ZenCart and Ultimate SEO URL’s
May 20th, 2009 currentlyOfflineIf 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 
