Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

IN need of fast SQL assistance please


oscommerceking

Recommended Posts

Many errors after installing copy attributes and copy categories

 

 

1st error is that i lose my stylesheet when i click on products (this happened after i installed copy categories)

 

2nd error when i added the copy attributes contribution I get the following sql errors

 

 

#1

Discount Coupons

 

Customer id Customer Name IP Address Date Redeemed 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 '-20, 20' at line 1

 

select * from coupon_redeem_track where coupon_id = '1' limit -20, 20

 

[TEP STOP]

 

 

#2

Gift Voucher Release Queue

 

Customers Order-No. Voucher Value Date Purchased 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 '-20, 20' at line 1

 

select c.customers_firstname, c.customers_lastname, gv.unique_id, gv.date_created, gv.amount, gv.order_id from customers c, coupon_gv_queue gv where (gv.customer_id = c.customers_id and gv.release_flag = 'N') limit -20, 20

 

[TEP STOP]

 

 

#3

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 '-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]

 

 

 

 

 

 

PPPPPPPPlllllllleeeeeeeasssssssse help the shop is live and getting many visitors

 

 

Cheers and VERY MANY Thanks

 

 

Jon :blush:

Link to comment
Share on other sites

2nd error when i added the copy attributes contribution I get the following sql errors

 

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

Cause and fix see bug reports.
Link to comment
Share on other sites

Archived

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

×
×
  • Create New...