Nuke Business Resources

Bugger

#8 » Installer syntax error
Date Open:	Jan 11, 2008 at 01:13:00 Last Update: Jan 17, 2008 at 03:06:10	Bugger Off: Jan 11, 2008 at 10:32:44
Description:	includes/db/db.php * CMS Warning line 75: On /admin.php?op=modules&install=Storez While executing query "CREATE TABLE cms_cart_payments_options_paypal ( ppemail VARCHAR(255) NOT NULL, ipn TINYINT(1) DEFAULT 0 NOT NULL, currency TEXT NOT NULL, sandbox TINYINT(1) DEFAULT 0 NOT NULL pre_invoice VARCHAR(3)) TYPE=MyISAM DEFAULT CHARSET=utf8" the following error occured: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pre_invoice VARCHAR(3)) TYPE=MyISAM DEFAULT CHARSET=utf8' at line 6 In: /home/account/public_html/dragonfly/includes/classes/installer.php on line: 61
Request:	Bug
Application:	Module
Module:	storez
Solution:	Missing comma cpg_inst.php line 556 sandbox TINYINT(1) DEFAULT 0 NOT NULL,
Bugger From:	Alan
Debugger:	Phoenix
Group Access:	All Visitors
DiscussIt Forum:	Storez
DiscussIt Topic:	Installer syntax error
Status:	Done
Priority:	High

Topic Replies:

Phoenix
Jan 11, 2008
03:17:42

Many Thanks - damn, stupid comma missing in cpg_inst.php line 556
Should be

Code::

sandbox TINYINT(1) DEFAULT 0 NOT NULL,

Main download fixed

alan
Jan 11, 2008
11:54:52

Another error on install...

Quote::

INSERT INTO cms_cart_payments_options_paypal VALUES ('email@noworky.LOL', 1, 'USD', 0)
Column count doesn't match value count at row 1

Just trying to help get the bugs out ...

Phoenix
Jan 11, 2008
12:01:15

yep, I see what's wrong - line 559 now.

Code::

$installer->add_query('INSERT', 'cart_payments_options_paypal', "'email@noworky.LOL', 1, 'USD', 0, ''");

Just too many late nites Embarassed

alan
Jan 11, 2008
14:32:55 It installed fine... now on to testing.

145 buggers listed, 107 buggered off, 29 declined, 8 on hold.