07-19-2004, 10:35 AM
|
| |
|
|
Veteran |
|
Join Date: Oct 2003
Location: Connecticut, USA
Posts: 30,253
|
|
|
Quote:
|
Originally Posted by TonyD
Quote:
|
Originally Posted by longhorn180
After installation of 4.0, on the customer page I get this error at the top of the screen and am unsure what to do about it:
Code:
INVALID SQL: 1064 : You have an error in your SQL syntax near 'xcart_products.avail>0 and AND xcart_products_categories.categoryid IN (248) AN' at line 1
SQL QUERY FAILURE: SELECT xcart_products.productid, xcart_products.product, xcart_products.productcode, xcart_products.avail, MIN(xcart_pricing.price) AS price FROM xcart_products, xcart_categories, xcart_products_categories, xcart_pricing WHERE xcart_products.productid=xcart_products_categories.productid AND xcart_products_categories.categoryid=xcart_categories.categoryid AND xcart_products.productid=xcart_pricing.productid AND xcart_pricing.quantity=1 AND xcart_pricing.variantid = 0 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND (xcart_categories.membership='' OR xcart_categories.membership='') AND xcart_products.forsale='Y' xcart_products.avail>0 and AND xcart_products_categories.categoryid IN (248) AND xcart_products.views_stats>0 AND xcart_products.sales_stats > 0 GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 5
As I mentioned in an earlier post, I can't seem to correctly import data into the extra fields where I still can on my live store(3.4.14). Could this error have anything to do with that? And, am I the only one who got this error after installation?
I have since found from another thread that this SQL error is appearing when you check to disable products that are out of stock. When I unchecked it the error no longer appeared. I re-imported products, checked the box, and the error appears again, so that must be a bug. |
if you read up about 4 posts...this has already been addressed and the fix posted(in the same post).  |
This actually wasn't addressed yet, that was another SQL error. This one has to do with the 'Disabling products when they are out of stock" option. I really LOVE this option and look forward to a fix! 
__________________
Padraic Ryan
Ryan Design Studio
Professional E-Commerce Development
|
|
|