Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

SQL Error in Sitemap

   X-Cart forums > X-Cart 4 > Third Party Add-Ons for X-Cart 4
Thread Tools
Old 07-18-2006, 12:54 PM
  flyclothing's Avatar 
flyclothing flyclothing is offline

Join Date: Aug 2004
Location: Gilbert, AZ
Posts: 357

Default SQL Error in Sitemap

I am receiving the following error when I visit

INVALID SQL: 1064 : 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 '-1' at line 1
SQL QUERY FAILURE: SELECT DISTINCT(p.productid), p.descr, p.product FROM xcart_products AS p, xcart_categories AS c, xcart_products_categories AS pc WHERE pc.productid = p.productid AND pc.categoryid = c.categoryid AND = 'Y' AND (c.membership = '' OR c.membership ='') AND pc.categoryid = '22' ORDER BY orderby ASC LIMIT -1

The error just repeats with the pc.categoryid changing each time.

I repaired the databases, but nothing worked. I am not sure when it started to occur either, so I can't pinpoint any changes to the site caused the error.

Has anyone had similar issues and found a solution? Any help is gladly appreciated! Thank you.
Flyclothing, LLC
PO Box 1490
Gilbert, AZ 85299-1571
P 480.422.7350
F 888.359.2568 (X-Cart 4.5.2) FOR SALE
Reply With Quote
Old 07-18-2006, 06:00 PM
balinor balinor is offline

Join Date: Oct 2003
Location: Connecticut, USA
Posts: 30,253


Moving to Third Party Mods
Padraic Ryan
Ryan Design Studio
Professional E-Commerce Development
Reply With Quote
Old 08-06-2006, 04:32 PM
  groovico's Avatar 
groovico groovico is offline

Join Date: Apr 2003
Posts: 2,326


Your signature suggests either x-cart 4.1. or x-cart 4.0.14, do you have the correct version of the firetanksoftware advanced x-cart sitemap installed for your version?

Used by X-carters the world over:
Marketing Manager Pro Bundle For X-cart
Featured Product Manager for X-cart
Feed manager pro for X-cart

Celebrating 7 Years of providing quality X-cart Add ons and X-cart Mods for x-cart 3.X to X-cart 4.4.X
Reply With Quote
   X-Cart forums > X-Cart 4 > Third Party Add-Ons for X-Cart 4

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT -8. The time now is 09:06 AM.


X-Cart forums © 2001-2020