Xibo

Statement number: 52

Asked by Santosh

I am trying to install xibo in windows8. I am using xampp. When I try to install xibo server, the following error message shows while using existing database as well as when creating new database.

Loading from structure.sql ....................................................

An error occured populating the database.

MySQL Error:
Can't write; duplicate key in table '#sql-cb8_1b'

SQL executed:
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`)

Statement number: 52

Also I am not being able to find server key for xibo client. And I am not being able to register xibo client.
Thank you in Advance

Regards
Santosh

Question information

Language:
English Edit question
Status:
Solved
For:
Xibo Edit question
Assignee:
No assignee Edit question
Solved by:
Santosh
Solved:
Last query:
Last reply:
Revision history for this message
Alex Harrington (alexharrington) said : 		#1

You need to delete your database and then install Xibo again. It looks like
you had an installation which failed part way through. You set the server
key as part of the install process

Revision history for this message
Santosh (santosh-gautam47) said : 		#2

I have done that many times. I will try it again. '
Thank you
Regards

Revision history for this message
Santosh (santosh-gautam47) said : 		#3

Thank you sir for your quick response. I finally found out the solution. I just increased the max_execution_time in php.ini file from 30 to 300 and it worked.
Regards
Santosh