1064 - You have an error in your SQL syntax; ...

[mondobongo3]

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 '' at line 1

 

select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit

 

[TEP STOP]

 

Where to edit and what?

Thank you.

 

EDIT: I CAN NOT ACCESS MY SITE SINCE THAT ERROR :'(

[Collines]

Depends.....which file was being opened when you got the error.

[MrPhil]

That would appear to be coming from includes/boxes/whats_new.php. The problem is that for some reason, MAX_RANDOM_SELECT_NEW has become undefined, or defined as empty. It should be defined in the "configuration" table under the heading "Selection of Random New Products". The default value is 10. Go into phpMyAdmin and browse the configuration table under that "configuration_title". What is the value? What happened that it's not correct?

[TracyS]

I am having a new 1064 error that wasn't happening a couple weeks ago. I have no idea what caused it to suddenly appear - the info is here: Other 1064 Error Forum Post and on the Master Products Forum.

 

I didn't want to keep repeating it all over the forums - but I'm getting desperate for help as our top selling product is currently not purchasable online with this error. Please let me know if you have any ideas on what to change. Thank you.

[TracyS]

Have you tried any of the fixes on this forum section? Click here

 

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 '' at line 1

 

select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit

 

[TEP STOP]

 

Where to edit and what?

Thank you.

 

EDIT: I CAN NOT ACCESS MY SITE SINCE THAT ERROR :'(

[mondobongo3]

That would appear to be coming from includes/boxes/whats_new.php. The problem is that for some reason, MAX_RANDOM_SELECT_NEW has become undefined, or defined as empty. It should be defined in the "configuration" table under the heading "Selection of Random New Products". The default value is 10. Go into phpMyAdmin and browse the configuration table under that "configuration_title". What is the value? What happened that it's not correct?

Indeed, this was the problem ! In Admin was no value there. It was blank.

Thanks. I was a little scared :wacko:

[TracyS]

Glad that fix helped you! Hopefully someone will know how to fix my issue :blush:

 

Indeed, this was the problem ! In Admin was no value there. It was blank.

Thanks. I was a little scared :wacko: