Post by Adi09 » Sat Aug 27, 2016 5:07 pm

Salut!
Am incercat sa fac niste forumulare in pagina cart care introduc in baza de date produsele.
Totul bine, dar primesc eroarea asta:

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
Cred că este o eroare la query-ul sql, dar nu îmi dau seama care este problema.
Sper că mă puteți ajuta! Mulțumesc!

Newbie

Posts

Joined
Sun Aug 21, 2016 6:41 pm

Post by inactiveaccount9912 » Mon Aug 29, 2016 3:03 pm

Code: Select all

TK 7500.00,TK 7500.00
Trebuie sa fie fara Tk sau daca ai nevoie de tk, punele intre ghilimele.

Expert Member

Posts

Joined
Fri May 14, 2010 2:36 am

Post by Adi09 » Mon Aug 29, 2016 9:42 pm

Asta era problema, mulțumesc mult!
Acum informațiile au fost introduse in baza de date, dar în orders list din admin cp apare 0.000 la price total și price unit. Am verificat tabelul prefix_order_product, iar acolo este introdus corect. Totuși, unde este problema?
Mulțumesc încă odată!

Newbie

Posts

Joined
Sun Aug 21, 2016 6:41 pm

Post by inactiveaccount9912 » Thu Sep 01, 2016 11:33 pm

Eu am zis varianta cu ghilimele, in caz ca ai tabelul modificat si asteapta varchar, altfel trbuie sa-i dai numar, fara TK.

Expert Member

Posts

Joined
Fri May 14, 2010 2:36 am
Who is online

Users browsing this forum: No registered users and 2 guests