Page 1 of 1

Problem with installing 1.5.3 and 1.5.4 versions

Posted: Mon Jun 12, 2017 4:26 pm
by captquirk
It seems the database has not been updating correctly when running update_rollup.php in the 1.5.3 and 1.5.4 versions (including PDO versions).
You can check if you are affected by looking at the Settings tab in Sphider. If this indicates 1.5.2 and you know you have upgraded to 1.5.3 or 1.5.4, you are affected.

For 1.5.3 users, this is not a big deal. For 1.5.4, it is a big deal, as a column is now missing in the settings table. The Downloads page of the Worldspaceflight forum has a fixed version of update_rollup.php, but you can fix the problem yourself.

Edit update_rollup.php. Towards the bottom you will see a series of lines with "case nn:". For 1.5.3 versions, remove the line "break;" in the "case 5:". For 1.5.4 versions, remove the line "break;" from BOTH "case 5:" and "case 6:".

Re-run update_rollup.php. Check the settings tab to ensure it now says 1.5.4.

**************************************************************
SPECIFICS
Edit update_rollup.php and re-run; Edits are as follows -
For Sphider 1.5.3:
switch ($state) {
case 1:
update141();
case 2:
update142();
case 3:
update150();
case 4:
update151();
case 5:
update152();
break; REMOVE THIS LINE
case 6:
update153();
break;
case 99;


For Sphider 1.5.3 PDO:
switch ($state) {
case 1:
update141();
case 2:
update142();
case 3:
update150();
case 4:
update1511();
case 5:
update1521();
break; REMOVE THIS LINE
case 6:
update1531();
break;
case 99;


For Sphider 1.5.4:
switch ($state) {
case 1:
update141();
case 2:
update142();
case 3:
update150();
case 4:
update151();
case 5:
update152();
break; REMOVE THIS LINE
case 6:
update153();
break; REMOVE THIS LINE
case 7:
update154();
break;
case 99;


For Sphider 1.5.4 PDO:
switch ($state) {
case 1:
update141();
case 2:
update142();
case 3:
update150();
case 4:
update1511();
case 5:
update1521();
break; REMOVE THIS LINE
case 6:
update1531();
break; REMOVE THIS LINE
case 7:
update1541();
break;
case 99;

Re: Problem with installing 1.5.3 and 1.5.4 versions

Posted: Thu Aug 24, 2017 8:39 am
by Griffie
Thankyou captquirk, I got 1.5.4 installed now!