Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 Syntax Error


Guest

Recommended Posts

Hi

 

I have installed a new OsCommerce site and have the folowing problem ....

 

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

 

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9

 

[TEP STOP]

 

I have looked online and in these forums, but cant find a fix for it.

 

The above error message appears when loading up the Specials page.

 

I have made adjustments to the split_page_results.php file, but the error still remains

 

Can anyone solve this for me?

 

Thanks

Darren

Link to comment
Share on other sites

It appears you've installed an older version that has a problem in the code. Be sure you have installed the latest version. Ccheck my signature to see how to do that.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

I have the same issue with my template I just installed. The template was supposed to be completely compatible with newest 2.x version and that is what I have installed. I cannot find how to fix this issue either. Some guidance on how to fix this would be appreciated.

 

Thanks,

 

Kevin

Link to comment
Share on other sites

The patches file in my signature block should help.

 

http://svn.oscommerce.com/jira/browse/OSC-...rator=printable

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

I thought the limit -20, 20 might be similar.

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

That worked perfect for my site. Thanks. I only had to use half the fix since the I didn't find this line in my split_page_results.php

 

 

Line 38 in catalog/admin/includes/classes/split_page_results.php must be changed from:

 

$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

 

 

I tried using only the first half of the fix since it was part of my templates makeup and it worked out perfect.

 

Thank you again for that quick fix and that is a great link you have in your sig for those types of issues.

 

Kevin

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...