Xibo

Error upgrade 1.4.1> 1.6-rc (version database)

Asked by William Reichert

Hello! Sorry for the english, I'm Brazilian.

I'm trying to accomplish upgrade from version 1.4.1 to version 1.6-rc (for testing purposes only), but when accessing the configuration page returns error of different version of the database. I have the database in version 51 and 66 site.

What I did so far:

- Clone database: 1.4.1 on my server (Ubuntu 10.04) did clone database into a file called xibo.sql then copied this file to another server (ubuntu 4.12) and there poured at the base of this file data from 1.6-rc that runs on ubuntu 12:04.

- I copied the settings.php ubuntu 10:04 (Xibo 1.4.1) for ubuntu 12:04.

Went to start the settings on the web and informed me the error I mentioned earlier.

I made the wrong procedures? Could anyone help me?

Thank you.

Question information

Language:
English Edit question
Status:
Solved
For:
Xibo Edit question
Assignee:
No assignee Edit question
Solved by:
William Reichert
Solved:
Last query:
Last reply:

This question was reopened

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

Sounds like you're missing the upgrade.php file from the distribution?

Download a fresh copy of 1.6.0-rc1 and replace what you have already, then
copy in your settings.php and it should prompt you to perform the upgrade

Revision history for this message
William Reichert (reichertwill) said : 		#2

Thanks man, it worked!

Revision history for this message
William Reichert (reichertwill) said : 		#3

Thanks Alex Harrington, that solved my question.

Revision history for this message
William Reichert (reichertwill) said : 		#4

"52.sql ...

60.sql ......
There was an error in completing the database.

MySQL error:
The query [INSERT INTO `transition` (`TransitionID`, `Transition`, `code`, `HasDuration`, `HasDirection`, `AvailableAsIn`, `AvailableAsOut`) VALUES (1, 'Fade In', 'fadeIn', 1, 0, 0, 0), (2, 'fade out', 'fadeOut', 1, 0, 0, 0), (3 'Fly', 'fly', 1, 1, 0, 0)] failed to executeDuplicate entry '1 'for key' PRIMARY '

SQL executed:
INSERT INTO `transition` (`TransitionID`, `Transition`, `code`, `HasDuration`, `HasDirection`, `AvailableAsIn`, `AvailableAsOut`) VALUES (1, 'Fade In', 'fadeIn', 1, 0 , 0, 0), (2, 'fade out', 'fadeOut', 1, 0, 0, 0), (3 'Fly', 'fly', 1, 1, 0, 0) "

Revision history for this message
William Reichert (reichertwill) said : 		#5

When you find the database it is returning this error now:

"52.sql ...

60.sql ......
There was an error in completing the database.

MySQL error:
The query [INSERT INTO `transition` (`TransitionID`, `Transition`, `code`, `HasDuration`, `HasDirection`, `AvailableAsIn`, `AvailableAsOut`) VALUES (1, 'Fade In', 'fadeIn', 1, 0, 0, 0), (2, 'fade out', 'fadeOut', 1, 0, 0, 0), (3 'Fly', 'fly', 1, 1, 0, 0)] failed to executeDuplicate entry '1 'for key' PRIMARY '

SQL executed:
INSERT INTO `transition` (`TransitionID`, `Transition`, `code`, `HasDuration`, `HasDirection`, `AvailableAsIn`, `AvailableAsOut`) VALUES (1, 'Fade In', 'fadeIn', 1, 0 , 0, 0), (2, 'fade out', 'fadeOut', 1, 0, 0, 0), (3 'Fly', 'fly', 1, 1, 0, 0) "

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

Sounds like you have a partially upgraded database there. You need to start
with a fresh restore from your working server.

Revision history for this message
William Reichert (reichertwill) said : 		#7

Thanks, Alex. Is ok!