Urgent Help Please!!!! CCGV installation

[zp04]

Hi

 

I finished the installation, but at the admin -Vouchers & Coupons - Coupon Admin section, i received a error message:

 

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 coupon_active, coupon_id, coupon_code, coupon_amount, coupon_minimum_order, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_p

roducts, restrict_to_categories, date_created,date_modified from coupons where coupon_active='Y' and coupon_type != 'G' limit -20, 20

 

Other section are fine.

 

And also, we i login as a customer at www.myweb/oscommerce/shopping_cart page, there was a error too:

 

1146 - Table 'ausight_com_au_-_oscommerce.TABLE_COUPON_GV_CUSTOMER' doesn't exist

 

select amount from TABLE_COUPON_GV_CUSTOMER where customer_id = '2'

 

 

Any help will be very much appreciated!!!

 

ZP

[zp04]

Hi

 

I finished the installation, but at the admin -Vouchers & Coupons - Coupon Admin section, i received a error message:

 

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 coupon_active, coupon_id, coupon_code, coupon_amount, coupon_minimum_order, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_p

roducts, restrict_to_categories, date_created,date_modified from coupons where coupon_active='Y' and coupon_type != 'G' limit -20, 20

 

Other section are fine.

 

And also, we i login as a customer at www.myweb/oscommerce/shopping_cart page, there was a error too:

 

1146 - Table 'ausight_com_au_-_oscommerce.TABLE_COUPON_GV_CUSTOMER' doesn't exist

 

select amount from TABLE_COUPON_GV_CUSTOMER where customer_id = '2'

Any help will be very much appreciated!!!

 

ZP

 

 

anyone can help me?

[♥Vger]

First of all you need to install CCGV correctly. One of the errors indicates that you haven't installed the sql file into your database - this is not an optional extra.

 

The 1064 error is caused by using the old version of osCommerce (pre November 2005). The updated version contains essential bug fixes and security patches. Go to downloads at www.oscommerce.com, download the updated version, and use the html file to update your present website manually.

 

Vger