surajk42 Posted July 10, 2005 Share Posted July 10, 2005 I installed Deals/Coupons Manager contribution. Everything is installed perfectly and still i am getting an error. http://www.oscommerce.com/community/contributions,2223 But i am getting this error. 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 deals_coupons order by deals_coupons_id limit -20, 20 [TEP STOP] Anyone knows how to fix it? Link to comment Share on other sites More sharing options...
OceanRanch Posted July 10, 2005 Share Posted July 10, 2005 A known problem with new versions of mysql. http://www.oscommerce.com/community/bugs,1605 Make changes to both split_pages_results.php (admin and catalog) HTH Tom Link to comment Share on other sites More sharing options...
surajk42 Posted July 11, 2005 Author Share Posted July 11, 2005 Thanks OceanRanch for your fast reply. It is working now. I have another question and wondering if u know the answer to it. I installed the support ticket contribution and everything running great. But when i send reply emails to customers, the link to view the replies is not clickable. I have been going through all files to see how to change it but i am not getting lucky. I would appreciate if you could help me. Surajk42 Link to comment Share on other sites More sharing options...
OceanRanch Posted July 11, 2005 Share Posted July 11, 2005 Sorry, no input on that contribution. I recommend you post it in the contribution section of the forum and I'm sure you'll get some help if you name it properly. Tom Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.