Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Admin Issues with osCAffiliate v2.6


Recommended Posts



I osCAffiliate v2.6 and the bug fix associated with it. I keep getting the following basic error in several of the Admin options for this contribution. Here is an example of one of the error messages:




Page: /affiliate_affiliates.php?listing=id-desc



Affiliates Search:

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






I can't find limit mentioned anywhere in the source files. I just installed this and we do not currently have any affiliates. So perhaps it is upset since there are no affiliate entries in the database yet?


We are running MySQL client version: 4.1.15


Any help would be appreciated.



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...