hts-direct Posted February 2, 2009 Share Posted February 2, 2009 Hi - Hope someone can help me here. I installed the Individual shipping price by zone contribution today http://addons.oscommerce.com/info/4468 Everything seems to be ok afer I found a fix for some errors, apart from I'm getting a database error now when updating products in admin as follows: 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 ')' at line 1 INSERT INTO indvshipzones (product_id, zone_code, price) VALUES (407, 'AL', ) [TEP STOP] has anyone experienced this error or could give advice of a possible fix? Thanks, Ashley Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted February 2, 2009 Share Posted February 2, 2009 Would think it should read INSERT INTO indvshipzones (product_id, zone_code, price) VALUES (407, 'AL', '0.00') It is trying to insert 3 fields and only providing the values for 2. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.