Exclusive eBooks, Software Solutions, Quality Guaranteed
 
Web NukeBiz
Welcome to NukeBiz · Members
Amazon
show cart or checkout0 items
Cart Value: 0.00

Forums » DragonflyCMS Projects » Storez » [fixed] SQL error when trying to copy an Item
[fixed] SQL error when trying to copy an Item
A comprehensive shopping cart solution.
Topic initiation via Bugger.

Post new topic    Reply to topic    Printer Friendly Page     Forum Index »  eCommerce » Storez

View previous topic :: View next topic  
Author Message
RickC
Manager
Manager

Offline Offline
Joined: Nov 09, 2006
Posts: 53
Location: Sharps Chapel, TN
PostPosted: Fri Jan 15, 2010 8:37 am
Post subject: [fixed] SQL error when trying to copy an Item

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.


RickC's 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
Back to top
View user's profile Visit poster's website
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Sat Jan 23, 2010 8:20 pm
Post subject: Re: SQL error when trying to copy an Item

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


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
Display posts from previous:   
Post new topic    Reply to topic    Printer Friendly Page    Forum Index »  eCommerce » Storez
Page 1 of 1
All times are GMT + 9.5 Hours



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum