Gallery 4 fatal upgrade error
Submitted ΑndyF, Jul 28 2012 05:56 AM | Last updated Jul 30 2012 07:15 PM
A bit further on from a non fatal error, reported here a more serious one occurred.
To recap:
Board 3.2.2 to 3.3.4
Gallery 4.1.1 to 5.0.0. B1
Step 2/14
This Module: 5.0.0 Beta 1
To recap:
Board 3.2.2 to 3.3.4
Gallery 4.1.1 to 5.0.0. B1
Step 2/14
This Module: 5.0.0 Beta 1
mySQL query error: UPDATE ibf_gallery_albums_main SET album_type=1,album_category_id='' WHERE album_id=1
SQL error: Incorrect integer value: '' for column 'album_category_id' at row 1
SQL error code: 1366
Date: Saturday 28th July 2012 10:17:59 AM
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sat, 28 Jul 2012 10:17:59 +0000
Error: 1366 - Incorrect integer value: '' for column 'album_category_id' at row 1
IP Address: 127.0.0.1 - /_QA/322up/admin/upgrade/index.php?app=upgrade&workact=convertAlbumsTableStepTwo§ion=upgrade&do=appclass
| Status: | Fixed |
| Version: | 5.0.0 Beta 1 |
| Fixed In: | 5.0.0 Beta 1 |
2 Comments
Hrm. Well, I added an intval to prevent the error, but that doesn't solve the underlying problem. Basically, it's missing the category ID (if you didn't guess).
Edit: I think I know what is happening. Note to self: the settings haven't been imported yet, so most likely it's inserting the members albums category, then updating the setting (which doesn't exist). We probably need to manually insert this setting during the upgrade before trying to update it or set it when creating the members album category.
Updating Status to: Fixed
I've implemented a fix but it requires further testing.