This is the error
An error occurred populating the database. Statement number: 57. Error Message = [SQLSTATE[HY000]: General error: 1005 Can’t create table ‘kourosize_it.#sql-5551_33c91b6’ (errno: 121)]. File = [Array]. SQL = [ALTER TABLE blacklist ADD CONSTRAINT blacklist_ibfk_1 FOREIGN KEY (MediaID) REFERENCES media (mediaID), ADD CONSTRAINT blacklist_ibfk_2 FOREIGN KEY (DisplayID) REFERENCES display (displayid)].
Are you definitely installing into an empty database?
si un database vuoto
Well, its failing here: https://github.com/xibosignage/xibo-cms/blob/master/install/master/structure.sql#L670
I can’t see any reason why that wouldn’t work - unless the install moved past this point before and the constraint already exists.
You could try commenting 670-672 with a -- at the start of each line and see if the installation progresses further
Ciao Dan, il sito www.kourosize.it è stato creato lo scorso anno, ho installato XIBO e tutto ha funzionato bene. La scorsa settimana un malware ha danneggiato il sito. Ho disinstallato XIBO e installato la nuova versione con un database MySQL presente ma completamente vuoto. L’errore che mi risulta è quello del primo annuncio. Non sono esperto in programmazione per cui non so proprio come proseguire. Sono disperato.
I’ve really provided as much help as I can without shell access to your server - I’d be happy to do that but it would need to be on a paid basis. Please feel free to email us - support@springsignage.com.
Alternatively if you can comment out the lines I indicated before in the file - it may be that the upgrade functions correctly.
Grazie di tutto Dan. Sto meditando di aprire un nuovo sito.
I’m sure it can be made to work - as I said before if you wanted us to look at it then please get in touch.
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.