ZenCart and Ultimate SEO URL’s
If you are reading this you’ve probably seen this message:
Incorrect integer value: ” for column ‘configuration_group_id’ at row 1 in:
[INSERT INTO `configuration_group` VALUES ('', 'SEO URLs', 'Options for Ultimate SEO URLs by Chemo', '39', '1')]
I had this problem myself. And now I can tell you that there are at least three ways to solve this annoying problem.
Solution 1
pay some money to a to someone for fixing this and go to the pub (if you still have some money left).
Solution 2
buy a SEO module that works and go to the pub (if you still have some money left).
Solution 3
- open includes/classes/seo.install.php with your favourite editor.
- find function install_settings()
- Change line $insert_group = “INSERT INTO `”.TABLE_CONFIGURATION_GROUP.”` VALUES (”, ‘SEO URLs’, ‘Options for Ultimate SEO URLs by Chemo’, ‘”.$next_sort.”‘, ’1′)”; to “INSERT INTO `”.TABLE_CONFIGURATION_GROUP.”` VALUES (‘”.$next_sort.”‘, ‘SEO URLs’, ‘Options for Ultimate SEO URLs by Chemo’, ‘”.$next_sort.”‘, ’1′)”;
- save the file
- open your Zen Cart again
It should work now. If it does, go to the pub.
If it’s not(very likely) and if you are still getting “Incorrect integer value” errors, find a function SEO_URL_INSTALLER right at the top of the file and change all lines that have something like this: “INSERT INTO `”.TABLE_CONFIGURATION.”` VALUES (”, to something like this: “INSERT INTO `”.TABLE_CONFIGURATION.”` VALUES (LAST_INSERT_ID()+”.$x.”,
It should work now. If it does, go to the pub(you’ve saved some money today). If not, write a comment with as much detail as possible and come back later – you might find my reply on how to fix it 
April 7th, 2010 at 3:00 am
Great post!
It didn’t completely solve the problem for me – after THAT line of code was fixed, there were about 20 inserts in the SEO_URL_INSTALLER function. Rather than try to enter a value, I changed it to … VALUES (null, ‘Enable SEO URLs?’…. (replaced the empty quotes for a null). That did the trick, since it’s an auto-increment column, it auto-assigned the next integer.
Thanks!