Guest Posted May 17, 2007 Posted May 17, 2007 Hi, I have tried to install the script and it went perfectly fine.But there are some matters that I need to clarify or need to ask: 1.In the admin area,when I tried to click one of the links,like Banners it displays: Affiliate Banner Manager Banners Product ID Statistics 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 affiliate_banners order by affiliate_banners_title, affiliate_banners_group limit -20, 20 [TEP STOP] Quesion : May I know how to resolve this,please.Thanks! 2.On the main page using Contact Us link,I have tried to test and send an email and contact my own site but,I never received any emails from my test contact.Done this so many times,for the past couple of days,though at first it will be delayed but til now no email/mail received.May I know how to resolve this,please.Thanks! 3.My script (OsCommerce) I bought is already have a built-in affiliate,think OsAffiliate,everything is fine and even tried it and it's very good but one problem I have encounter or missing,May I know how to build an affiliate link ...like www.mydomain.com/affiliate_id?ref=xxxx.I have check each link on the affiliate area and I couldn't find it.How can an affiliate introduced the site then,there's a banner link where the affililate can introduce to others.But some customers doesn't like banners,they like affiliate link itself.May I know how to build it?Thanks in advance. Hope to hear from you Pros. More power and more success.
sridhar Posted May 17, 2007 Posted May 17, 2007 Hi, I have tried to install the script and it went perfectly fine.But there are some matters that I need to clarify or need to ask: 1.In the admin area,when I tried to click one of the links,like Banners it displays: Affiliate Banner Manager Banners Product ID Statistics 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 affiliate_banners order by affiliate_banners_title, affiliate_banners_group limit -20, 20 [TEP STOP] Quesion : May I know how to resolve this,please.Thanks! 2.On the main page using Contact Us link,I have tried to test and send an email and contact my own site but,I never received any emails from my test contact.Done this so many times,for the past couple of days,though at first it will be delayed but til now no email/mail received.May I know how to resolve this,please.Thanks! 3.My script (OsCommerce) I bought is already have a built-in affiliate,think OsAffiliate,everything is fine and even tried it and it's very good but one problem I have encounter or missing,May I know how to build an affiliate link ...like www.mydomain.com/affiliate_id?ref=xxxx.I have check each link on the affiliate area and I couldn't find it.How can an affiliate introduced the site then,there's a banner link where the affililate can introduce to others.But some customers doesn't like banners,they like affiliate link itself.May I know how to build it?Thanks in advance. Hope to hear from you Pros. More power and more success. For the first problem no need to take negative value, you can put one condition for that ,ie. if any negative value comes there it starts from 0 to 20, this will remove your error. For the second problem, In which server your site is there means linux or window, if your site is in windows set the mail options from admin as "SMTP"(goto admin/configuration.php?gId=11(email options)), if your site in linux set the mail options from admin as "Send mail". check it once, This will definately remove your problem.
Guest Posted May 17, 2007 Posted May 17, 2007 For the first problem no need to take negative value, you can put one condition for that ,ie. if any negative value comes there it starts from 0 to 20, this will remove your error. For the second problem, In which server your site is there means linux or window, if your site is in windows set the mail options from admin as "SMTP"(goto admin/configuration.php?gId=11(email options)), if your site in linux set the mail options from admin as "Send mail". check it once, This will definately remove your problem. Thank you,but will you able to tell me where can I find or where can set this values on the admin area or in cpanel (exact location,please.) Another thing,I am hosted on linux and it is already set on Send Mail but I wasn't able to received emails so I try to set it SMTP,try an still fail.Anyway,will set back to Send Mail and try it again,hope it is ok now. Thanks for the reply.God bless.
Guest Posted May 17, 2007 Posted May 17, 2007 you should check if your store uses the latest osc code http://www.oscommerce.com/solutions/downloads The particular bug is documented here (fix at the end of page). http://www.oscommerce.com/community/bugs,1605
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.