DragonflyCMS Projects > Storez > [fixed] SQL error when trying to copy an Item > Community Forums > Phoenix Netology
Forum Index > eCommerce > Storez

[fixed] SQL error when trying to copy an Item Reply to topic


ncludes/db/db.php

* CMS Warning line 75: On /rfe/admin.php?op=Storez While executing query "INSERT INTO cms_cart_products (prodID, prodCode, store_id, prodName, prodSInfo, prodInfo, prodXInfo, keywords, prodModel, prodInstant, prodBrand, prodCounter, prodCost, baseCost, optionCost, msrp_price, wholesale_price, shipcost, shipweight, shipping_ets, handlingcost, tax_class_id, promoActive, promoTitle, promoInfo, promoCost, promoStartDate, promoExpireDate, stockActive, stockQuantity, date, pthumb, product_availability, prodActive, prodGroup, prodDuration, cost_price, wholesaleGroup, prodFree, featured, prodLink, shiplength, shipheight, shipwidth, shipFree) VALUES (DEFAULT, '', '208', 'Testing', 'Store Test for verison 9.4.0', '', '', '', 'The Test Model', '0', '19', DEFAULT, '1200.00', '1200.00', DEFAULT, '0.00', '500.00', '0.00', '0.0000', '3', '0.00', '1', '0', '', '', '0.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '0', '2010-01-15 01:05:07', '', '1', '1', '0', '0', '0', '2', '0', '0', 'http://www.hopetoseeyousoon.com/Contact.html', '0.00', '0.00', '0.00, '0')" 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 '0')' at line 4 In: /homepages/12/d91017768/htdocs/LocalQuality_com/rfe/modules/Storez/admin/products.php on line: 1288

Initiated by Bugger (Original Entry) - Comments Here Please.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux infong 2.4 /5.0.91-log (client: 5.0.92)/5.2.17/9.3.3.0


Got it - near the end of line 1288, missing a single quote'$_POST[shipwidth]'

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

All times are Australia/Adelaide


Jump to: