DragonflyCMS Projects > Storez > [fixed] Error on install - cpg_inst.php > Community Forums > Phoenix Netology

[fixed] Error on install - cpg_inst.php Reply to topic

alan Offline Joined: Oct 14, 2007 Posts: 31 0 👍 / 0 👎	Fri Jan 11, 2008 4:43 pm Hello. I tried to install the new upgrade and got this error on install. This was a new site and db solely for the purpose of testing this module. It is a php5 and mysql 5 using DF 9.1.2.1 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 Just wanted to make you aware of this. I will test it further but for now, I can't go any further, yet. Please enter your server specs in your user profile! 😢
Phoenix Offline Joined: Mar 18, 2004 Posts: 1543 Location: Netosphere 0 👍 / 0 👎	Fri Jan 11, 2008 6:47 pm Many Thanks - damn, stupid comma missing in cpg_inst.php line 556 Should be `sandbox TINYINT(1) DEFAULT 0 NOT NULL,` Main download fixed Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
alan Offline Joined: Oct 14, 2007 Posts: 31 0 👍 / 0 👎	Sat Jan 12, 2008 3:24 am Another error on install... 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 ... Please enter your server specs in your user profile! 😢
Phoenix Offline Joined: Mar 18, 2004 Posts: 1543 Location: Netosphere 0 👍 / 0 👎	Sat Jan 12, 2008 3:31 am yep, I see what's wrong - line 559 now.`$installer->add_query('INSERT', 'cart_payments_options_paypal', "'email@noworky.LOL', 1, 'USD', 0, ''");`Just too many late nites Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
alan Offline Joined: Oct 14, 2007 Posts: 31 0 👍 / 0 👎	Sat Jan 12, 2008 6:02 am It installed fine... now on to testing. Dragonfly9 continues with php7.1+ ! https://dragonfly9php7support.com Please enter your server specs in your user profile! 😢
All times are Australia/Adelaide Post new topic Reply to topic Forum Index > eCommerce > Storez Page 1 of 1