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

Before upgrading - Found a SQL issue
 
Reply
   X-Cart forums > Considering X-Cart > Considering using X-Cart for my project
 
Thread Tools Search this Thread
  #1  
Old 07-24-2018, 08:09 PM
 
confusedK confusedK is offline
    
Join Date: Jul 2018
Posts: 0
 

Default Before upgrading - Found a SQL issue

I had a client reach out to me to do an update to their XCart. When I logged into their Admin area, I didn't see anything out of line. Then I went to their website and saw INVALID SQL messages at the very top of their page, above the start of the site.

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 'OPTION SQL_BIG_SELECTS=1' at line 1
SQL QUERY FAILURE:SET OPTION SQL_BIG_SELECTS=1
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 'OPTION SQL_BIG_SELECTS=1' at line 1
SQL QUERY FAILURE:SET OPTION SQL_BIG_SELECTS=1


Before I do anything to their site, I want to make sure this is resolved because I do not want the client to think I broke the site even more during the update.

Does anybody know what this message means, or how to resolve it?
I found "db_query("SET OPTION SQL_BIG_SELECTS=1");" in both the search.php and func.product.php files, so I think there needs to be an adjustment her, or in the actual MySQL?

Thoughts?
Reply With Quote
  #2  
Old 07-25-2018, 06:29 PM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 13,259
 

Default Re: Before upgrading - Found a SQL issue

https://forum.x-cart.com/showthread.php?t=72333
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
Reply
   X-Cart forums > Considering X-Cart > Considering using X-Cart for my project


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 11:15 PM.

   

 
X-Cart forums © 2001-2018