"Table 'JobSets' doesn't exist" when upgrading from 5.6.1.2 to 5.6.2.x
Permalink
I am running a C5 5.6.1.2 with the Internationalization add-on and some others.
All add-ons are up to date.
When I try to update to 5.6.2.1 or 5.6.2, the update process crashes with the following database error:
all pages, both in the back-end and in the front-end, break with the same error.
I can access /index.php/tools/required/upgrade and can choose to upgrade there, but the process again fails with the same error.
To revert back to normal, I have to remove the "DIRNAME_APP_UPDATED" constant from config/site.php.
What do I need to do to upgrade to 5.6.2.1? Could this be an add-on problem? But the fact that the problem occurs with a core table (right?) doesn't support that assumption.
I could upgrade the database manually, but I can't seem to see how from the manual updating instructions (http://www.concrete5.org/documentation/how-tos/developers/manually-upgrade-concrete5/). If somebody could tell me how to do this I'd be grateful.
All add-ons are up to date.
When I try to update to 5.6.2.1 or 5.6.2, the update process crashes with the following database error:
mysqlt error: [1146: Table 'databasename.JobSets' doesn't exist] in EXECUTE("select jsID, pkgID, jsName, jDateLastRun, isScheduled, scheduledInterval, scheduledValue from JobSets order by jsName asc")
all pages, both in the back-end and in the front-end, break with the same error.
I can access /index.php/tools/required/upgrade and can choose to upgrade there, but the process again fails with the same error.
To revert back to normal, I have to remove the "DIRNAME_APP_UPDATED" constant from config/site.php.
What do I need to do to upgrade to 5.6.2.1? Could this be an add-on problem? But the fact that the problem occurs with a core table (right?) doesn't support that assumption.
I could upgrade the database manually, but I can't seem to see how from the manual updating instructions (http://www.concrete5.org/documentation/how-tos/developers/manually-upgrade-concrete5/). If somebody could tell me how to do this I'd be grateful.
It never hurts to re-run the upgrade script. If you look in the INSTALL file with the upgrade zip, it will give instructions for manually running the upgrade file.
To summarise, you can your browser at
http://yoursite.com/index.php/tools/required/upgrade...
There is also an option to force it to repeat
http://yoursite.com/index.php/tools/required/upgrade?force=1...
To summarise, you can your browser at
http://yoursite.com/index.php/tools/required/upgrade...
There is also an option to force it to repeat
http://yoursite.com/index.php/tools/required/upgrade?force=1...
Thanks, but no luck with neither 5.6.2 nor 5.6.2.1.
Whenever I run the upgrade script, it upgrades (= changes the DIRNAME_APP_UPDATED constant in the config file) and then every request fails with the fatal error mentioned above. Forcing the updater script has the same result.
Whenever I run the upgrade script, it upgrades (= changes the DIRNAME_APP_UPDATED constant in the config file) and then every request fails with the fatal error mentioned above. Forcing the updater script has the same result.
No luck - I thought for a moment it worked, but that was just the cache deceiving me.
It appears that the mySQL database is never updated - the jobgroups table seems to be new to 5.6.2. The problem occurs with 5.6.2 as well as 5.6.2.1.
Do you know where in the update package the mySQL upgrade script is stored? I should be able to run that manually once I find it.
It appears that the mySQL database is never updated - the jobgroups table seems to be new to 5.6.2. The problem occurs with 5.6.2 as well as 5.6.2.1.
Do you know where in the update package the mySQL upgrade script is stored? I should be able to run that manually once I find it.
You could try the dashboard page to rebuild/refresh core tables
/dashboard/system/backup_restore/database/
/dashboard/system/backup_restore/database/
OMG this fixed issue I was having with errors at bottom of pages after upgrade- thank you!! (went to "http://yoursitehere.com/index.php/tools/required/upgrade" and just upgraded and all fixed- YAY!
I managed to solve the problem my installing an empty 5.6.2.1 in another location, and copy&pasting the SQL for the missing JobGroups table from there. Now everything appears to be working fine.
There were some bugs in this area for 5.6.2.