I want to make forms on cart page (name, address and number phone). I make that, but when I clicked on confim, it display :
Code: Select all
Fatal error: Uncaught exception 'Exception' with message 'Error: 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 ''Bushnell Full Metal Banner Dusk & Dawn Telescope','Bushnell',1,TK 7500.00,TK 75' at line 2<br />Error No: 1064<br />insert into ocbp_order_product(order_id,product_id,name,model,quantity,price,total) values(17,,'Bushnell Full Metal Banner Dusk & Dawn Telescope','Bushnell',1,TK 7500.00,TK 7500.00)' in /home/***/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/**/public_html/system/library/db.php(16): DB\MySQLi->query('insert into ocb...', Array) #1 /home/**/public_html/catalog/controller/checkout/cart.php(1068): DB->query('insert into ocb...') #2 [internal function]: ControllerCheckoutCart->insert() #3 /home/**/public_html/system/engine/action.php(51): call_user_func_array(Array, Array) #4 /home/**/public_html/catalog/controller/startup/router.php(25): Action->execute(Ob in /home/**x/public_html/system/library/db/mysqli.php on line 40