Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MySQL Errors


yatahaze

Recommended Posts

I'm getting a couple errors on a few pages and I can't figure out how to fix them. I have a feeling its because I'm using a newer version of MySQL than I used to, but I don't know anything about it.

 

When I open the Newsletter link in the admin section I get this:

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 newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -20, 20

 

[TEP STOP]

 

When I try to approve a user (with an addon contribution) I get this:

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 c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id where member_level = '0' order by c.customers_lastname, c.customers_firstname limit -20, 20

 

[TEP STOP]

 

 

How do I solve this?

Link to comment
Share on other sites

I'm getting a couple errors on a few pages and I can't figure out how to fix them. I have a feeling its because I'm using a newer version of MySQL than I used to, but I don't know anything about it.

 

When I open the Newsletter link in the admin section I get this:

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 newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -20, 20

 

[TEP STOP]

 

When I try to approve a user (with an addon contribution) I get this:

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 c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id where member_level = '0' order by c.customers_lastname, c.customers_firstname limit -20, 20

 

[TEP STOP]

How do I solve this?

 

 

Read this http://www.oscommerce.com/forums/index.php?showtopic=144095

 

Charles

A kite flies highest AGAINST the wind !

 

"Life should NOT be a journey to the grave with the intention of arriving safely in an attractive and well preserved body, but rather to skid in sideways, a lover in one hand, martini in the other, body thoroughly used up, totally worn out and screaming ~ WOO HOO!! What a ride!"

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...