1064 - You have an error in your SQL syntax

[Guest]

I get the following messages in several areas of the Admin area. They relate to either New Letters, Product Expected, Customer Totals, et cetera.

 

All of these areas have no entries in them in the database. Seems like it's giving an error because there's nothing in those areas, but it also doesn't give me the option TO create say a News Letter.

 

Newsletter Manager

 

Newsletters Size Module Sent Status 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 '-5, 5' 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 -5, 5

 

 

 

Best Products Purchased

 

No. Products Purchased

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

 

select p.products_id, p.products_ordered, pd.products_name from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '1' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name limit -5, 5

 

(NO products have been sold as of yet so this is of course devoid of any entries as a result)

 

Best Customer Orders-Total

 

No. Customers Total Purchased

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

 

select c.customers_firstname, c.customers_lastname, sum(op.products_quantity * op.final_price) as ordersum from customers c, orders_products op, orders o where c.customers_id = o.customers_id and o.orders_id = op.orders_id group by c.customers_firstname, c.customers_lastname order by ordersum DESC limit -5, 5

 

 

Orders

 

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

 

select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -5, 5

 

 

 

The recurring theme is there are no entries for these things. I expected that, but what I'm not understanding is why it doesn't show something like '0 Entries' or whatever, nor why it won't let me create a news letter campaign. I don't know how to add token entries to each section in order to quit getting the errors and thus allowing oscommerce to show the information for that section with it's tools.

 

Also, this is the following information for the site. (I get that LIMIT -5, 5 error on a lot of other things as well.)

 

 

Database: MySQL 4.1.10a-Debian_2ubuntu0.1-log

HTTP Server: Apache/2.0.53 (Ubuntu) mod_ssl/2.0.53 OpenSSL/0.9.7e

PHP Version: 4.3.10-10ubuntu4.1 (Zend: 1.3.0)

osCommerce Version: osCommerce 2.2-MS2

[Jan Zonjee]

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

See Christian Lescuyer's blog

[Guest]

See Christian Lescuyer's blog

<{POST_SNAPBACK}>

 

 

Awesome. Thank you. Didn't see other topisc regarding that, so again, thanks. All fixed :)