Error in Specials section of Admin

[nursers]

Hi everyone,

 

I've checked knowledge base and searched forum but haven't found an answer to this.

 

When I am in the admin utility and click on the Specials section, I get the following error:

 

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

 

select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20

 

[TEP STOP]

 

 

 

Any ideas?

 

Thanks in advance and happy holidays

[wheeloftime]

Hi everyone,

 

I've checked knowledge base and searched forum but haven't found an answer to this.

 

When I am in the admin utility and click on the Specials section, I get the following error:

 

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

 

select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20

 

[TEP STOP]

Any ideas?

 

Thanks in advance and happy holidays

 

I can't imagine you did a very thorough search as the board is filled with the same question over and over :-"

Take a look ie. here ;)

[nursers]

I can't imagine you did a very thorough search as the board is filled with the same question over and over :-"

Take a look ie. here ;)

 

 

Thank you for the reply. I did in fact search the first 15 pages of returns from a forum search plus a search of the knowledgebase on a number of search queries. I find it diffucult to find what I want when the search page returns the 'your queries has too few characters' etc etc most times.

 

Thanks again

 

David

[wheeloftime]

Thank you for the reply. I did in fact search the first 15 pages of returns from a forum search plus a search of the knowledgebase on a number of search queries. I find it diffucult to find what I want when the search page returns the 'your queries has too few characters' etc etc most times.

 

Thanks again

 

David

 

Hello David,

 

No big deal, it does need some time to get acquinted with the search indeed :D

If you try "near '-20, 20' at line 1" exactly as this with the quotes around you would have gotten the answer at the first place after your own question :P

With the 3 character limit things like +near +20 etc. don't work very well.

 

regards,

Howard

[nursers]

Thank you for the reply. I did in fact search the first 15 pages of returns from a forum search plus a search of the knowledgebase on a number of search queries. I find it diffucult to find what I want when the search page returns the 'your queries has too few characters' etc etc most times.

 

Thanks again

 

David

 

For anyone else's sake. I found the exact solution here:

 

http://www.oscommerce.com/community/bugs,1605

[nursers]

Hello David,

 

No big deal, it does need some time to get acquinted with the search indeed :D

If you try "near '-20, 20' at line 1" exactly as this with the quotes around you would have gotten the answer at the first place after your own question :P

With the 3 character limit things like +near +20 etc. don't work very well.

 

regards,

Howard

 

Thanks for the tip on wrapping searched in quotes Howard, will try that next time :)