OSC Affiliate Help

[Annabellee]

I keep getting the following errors when installing OSC Affliate.

 

When I click Affiliates in the Admin, I get:

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 affiliate_affiliate order by affiliate_id DESC limit -20, 20

 

When I select Payment, I get:

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 p.* , s.affiliate_payment_status_name from affiliate_payment p , affiliate_payment_status s where p.affiliate_payment_status = s.affiliate_payment_status_id and s.affiliate_language_id = '1' order by p.affiliate_payment_id DESC limit -20, 20

 

When I select Banners, I get:

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 affiliate_banners order by affiliate_banners_title, affiliate_banners_group limit -20, 20

 

And when I select Newsletter, I get

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

 

Anybody have any idea what I've done wrong?

 

Amanda

[Emmett]

I keep getting the following errors when installing OSC Affliate.

Anybody have any idea what I've done wrong?

 

Amanda

 

I believe you did the SQL import wrong.

I recently installed oscaffiliate by following the install guide and the installation went flawless.

After a couple of days of cosmetic edits to make it conform to my site looks, I finally went to admin and again everything is working flawlessly.

 

My suggestion is to go to your osc database and delete all affiliate tables and re-import the affiliate SQL file.

Use phpmyadmin to do it. (click import, click browse, locate file, click go)

The only other area to look closely at would be the oscommerce files that were edited with affiliate code by you.

Double check that you have all the affiliate_whatever_filename.php files installed.

All this assumes you have oscommerce version 2.2 milestone 2 and oscaffiliate version 2.6.

 

- Emmett