11-17-2004, 05:14 AM
|
| |
|
|
Advanced Member |
|
Join Date: Aug 2004
Location: California
Posts: 32
|
|
|
Quote:
|
Originally Posted by Courage
4.0.6 -> 4.0.7 update easy, but..
now when i'm trying to modify any product i get
Quote:
Site : https://www.222222222
Script : /provider/product_modify.php
Logged as : xxxxxx
SQL query : SELECT xcart_products.*, xcart_products.avail-0 AS avail, min(xcart_pricing.price) AS price, IF(.variantid IS NOT NULL,'Y','') as is_variant FROM xcart_products, xcart_pricing LEFT JOIN ON .productid = xcart_products.productid WHERE xcart_products.productid='14775' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.variantid = 0 AND (xcart_pricing.membership = '' OR xcart_pricing.membership = '') GROUP BY xcart_products.productid
Error code : 1064
Description :
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 'IS NOT NULL,'Y','') as is_variant FROM xcart_products, xcart_pr
|
|
This might help: http://forum.x-cart.com/viewtopic.php?t=14404&highlight=xcartproducts
__________________
Tyson McPherson
X-Cart version 4.1.8
PHP 4.3.9
MySQL server 4.1.12-log
MySQL client 4.1.12
Web server Apache/2.0.52 (Red Hat)
Operation system Red Hat 3.4.6-2
|
|
|