Xibo

mysql (installation)

Asked by doomer

i get an error with xibo 1.1.0

this is on 20.sql

MySQL Fout:
The query [INSERT INTO `pages` (`name`, `pagegroupID`) VALUES ('help', '2'), ('clock', 2)] failed to execute
MySQL error: Duplicate entry '28' for key 'PRIMARY'

SQL executed:
INSERT INTO `pages` (`name`, `pagegroupID`) VALUES ('help', '2'), ('clock', 2)

Statement number: 1

what can i do to fix it

Question information

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

Fresh install or upgrade?

Alex

Revision history for this message
doomer (doomer) said : 		#2

upgrade and fresh instaal on the win32 plaform

Revision history for this message
Best Alex Harrington (alexharrington) said : 		#3

https://bugs.launchpad.net/xibo/+bug/502749

You can either wait for 1.1.1 to be released or grab 9.sql from the branch attached to that bug and try again:
http://bazaar.launchpad.net/~dangarner/xibo/106-server/annotate/head%3A/server/install/database/9.sql

You'll need to start with an empty db or restore your pre-upgrade database to its original state.

Alex

Revision history for this message
doomer (doomer) said : 		#4

solved my problem