Exclusive eBooks, Software Solutions, Quality Guaranteed
Web NukeBiz
Welcome to NukeBiz · Members
of 6

 #65 » Update Install error v9.3.0
 Date Open: Oct 05, 2008 at 00:00:31    Last Update: Oct 05, 2008 at 00:15:13 Bugger Off: Oct 05, 2008 at 00:15:13 
 Description: CMS Warning line 75: On /rfe/admin.php?op=modules&upgrade=22 While executing query "ALTER TABLE cms_cart_preorders_items ADD prodFree TINYINT(1) NOT NULL DEFAULT '0'" the following error occured: Table 'db233570098.cms_cart_preorders_items' doesn't exist In: /homepages/12/d91017768/htdocs/LocalQuality_com/rfe/includes/classes/installer.php on line: 98
 Request: Bug
 Application: Module
 Module: storez
 Solution: Line 1042 of cpg_inst.php should be

$installer->add_query('ADD', 'cart_preorders_cartitems', "prodFree TINYINT(1) DEFAULT '0' NOT NULL");

Main download now updated.
 Bugger From: RickC
 Debugger: Phoenix
 Group Access: All Visitors
 DiscussIt Forum: Storez
 DiscussIt Topic: Update Install error v9.3.0
 Status: Done
 Priority: High
 Topic Replies:
 Oct 05, 2008
Line 1042 of cpg_inst.php should be
$installer->add_query('ADD', 'cart_preorders_cartitems', "prodFree TINYINT(1) DEFAULT '0' NOT NULL");

The main Download is now fixed.

Normally I added extra fields only via the installer - this time I added some manually and then adjusted the installer (incorrectly) - won't happen again Embarassed
 Oct 05, 2008
No dice. Still getting the error. I checked the cpg_inst.php file as well, and that line is correct. Still not working for me.
 Oct 05, 2008
No, you may be getting "an" error but you cannot be getting the same error.

Activate your debug options to see what the real issue is.
150 buggers listed, 109 buggered off, 31 declined, 8 on hold.