PHP interesse |
|
Bij mijn webwinkel probeer ik een Ideal module in te bouwen. Echter blijf ik als ik de bestelling wil afrekenen de volgende melding krijgen:
1064 - 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 ' now(),'O:12:"shoppingcart":5:{s:8:"contents";a:1:{s:8:"62{0}257";a:2:{s:3:"qty"' at line 1
INSERT INTO mollieideal_payments (transaction_id, entrancecode, issuer_id, order_id, payment_status, date_last_check,cart_contents) values (0, 'b032c0ce203f79ad39fc73221216dbeb',0031,96,, now(),'O:12:"shoppingcart":5:{s:8:"contents";a:1:{s:8:"62{0}257";a:2:{s:3:"qty";s:1:"1";s:10:"attributes";a:1:{i:0;s:3:"257";}}}s:5:"total";d:343;s:6:"weight";d:0;s:6:"cartID";N;s:12:"content_type";s:8:"physical";}')
[TEP STOP] :cool:
1064 - 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 ' now(),'O :12:"shoppingcart":5:{s :8:"contents";a :1:{s :8:"62{0}257";a :2:{s :3:"qty"' at line 1 INSERT INTO mollieideal_payments (transaction_id, entrancecode, issuer_id, order_id, payment_status, date_last_check,cart_contents) values (0, 'b032c0ce203f79ad39fc73221216dbeb',0031,96,, now(),'O:12:"shoppingcart":5:{s:8:"contents";a:1:{s:8:"62{0}257";a:2:{s:3:"qty";s:1:"1";s:10:"attributes";a:1:{i:0;s:3:"257";}}}s:5:"total";d:343;s:6:"weight";d:0;s:6:"cartID";N;s:12:"content_type";s:8:"physical";}') [TEP STOP] :cool:
Dit is het stuk van de database:
#
# Tabel structuur voor tabel `mollieideal_payments`
#
CREATE TABLE `mollieideal_payments` (
`payment_id` int(11) NOT NULL auto_increment,
`transaction_id` varchar(16) NOT NULL default '0',
`entrancecode` varchar(40) NOT NULL default '',
`issuer_id` varchar(4) NOT NULL default '0',
`order_id` int(11) NOT NULL default '0',
`payment_status` int(5) NOT NULL default '0',
`date_last_check` datetime NOT NULL default '0000-00-00 00:00:00',
`cart_contents` text NOT NULL default '',
PRIMARY KEY (`payment_id`)
) TYPE=MyISAM;
# # Tabel structuur voor tabel `mollieideal_payments` # CREATE TABLE `mollieideal_payments` ( `payment_id` int(11) NOT NULL auto_increment, `transaction_id` varchar(16) NOT NULL default '0', `entrancecode` varchar(40) NOT NULL default '', `issuer_id` varchar(4) NOT NULL default '0', `order_id` int(11) NOT NULL default '0', `payment_status` int(5) NOT NULL default '0', `date_last_check` datetime NOT NULL default '0000-00-00 00:00:00', `cart_contents` text NOT NULL default '', PRIMARY KEY (`payment_id` )) TYPE=MyISAM;
Wie zou weten hoe dit is op te lossen?
|