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

SQL Error in Sitemap

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

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

Default SQL Error in Sitemap

I am receiving the following error when I visit http://www.flyclothing.com/fts_sitemap_cached.php

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 p.forsale = '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.
__________________
Jonathan
Flyclothing, LLC
PO Box 1490
Gilbert, AZ 85299-1571
P 480.422.7350
F 888.359.2568
www.flysportsgear.com?MMCF_xcartforum (X-Cart 4.5.2) FOR SALE
Reply With Quote
  #2  
Old 07-18-2006, 06:00 PM
 
balinor balinor is offline
 

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

Default

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

X-Man
  
Join Date: Apr 2003
Location: Firetanksoftware.com
Posts: 2,326
 

Default

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?
__________________
Groovico

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

http://www.firetanksoftware.com

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
Reply
   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 02:06 AM.

   

 
X-Cart forums © 2001-2020