Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 Sytax erro at line '-6, 6 at line 1


Aminpr

Recommended Posts

Hello

Im new in this.

 

I have the following problems...

 

 

Reviews

 

Products Rating Date Added Action

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

 

select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -6, 6

 

[TEP STOP]

 

 

Products Expected

 

Products Date Expected Action

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

 

select pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '1' order by p.products_date_available DESC limit -6, 6

 

 

Newsletter Manager

 

Newsletters Size Module Sent Status Action1064 - 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 '-6, 6' at line 1

 

select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -6, 6

 

 

Thanks

Link to comment
Share on other sites

Go to the downloads page using the menu above. Downlaod the latest update and look in it for the split_page_results.php fix. That should fix your problem.

 

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

Go to the downloads page using the menu above. Downlaod the latest update and look in it for the split_page_results.php fix. That should fix your problem.

 

Jack

 

 

Thank you

 

I when there and copy the file and replace the old one.

It still those the same.

 

Do I need a nother solution

Link to comment
Share on other sites

There is a file in the admin and one in the shop. Did you copy them boh, or at least the correct one?

 

Jack

 

 

This is the file that I downloaded osCommerce 2.2 Milestone 2 Update 060817

& this is the location where I found the split_page_results.php (fix)

oscommerce-2.2ms2-060817\catalog\includes\classes

 

I copy this file at the same location on my OSCommerce folder......

This update dosnt have a file with the name split_page_results.php on the Admin folder & it dosnt have a folder name Shop.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...