arnaupuig100 Posted January 3, 2008 Share Posted January 3, 2008 Once I have intstalled correctlly memeber_approvalV6 this error turns up and I don´t know how to solve it. 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 select customers_language_id from customers where customers_id = Can anyone help? Thanks Arnau Link to comment Share on other sites More sharing options...
Guest Posted January 3, 2008 Share Posted January 3, 2008 First of all put your backup in place as this new contrib is obviously playing havoc with your site, then try googling your error in its entirety. It's a great way of quickly finding the answer for your error. Link to comment Share on other sites More sharing options...
Teamjr Posted January 3, 2008 Share Posted January 3, 2008 Hello, Also could be that your server is running mysql 5, and the fix may be here, www.monikamathe.com/oscommerce/mysql5.txt JR Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 3, 2008 Share Posted January 3, 2008 Might be better to check the change you have made to the code as you have either got a duff contribution, unlikly, or you did not follow the installation instructions. Put some code in the wrong place?Ddidn't copy it exactly? The possibilities are endless. 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...
arnaupuig100 Posted January 3, 2008 Author Share Posted January 3, 2008 Might be better to check the change you have made to the code as you have either got a duff contribution, unlikly, or you did not follow the installation instructions. Put some code in the wrong place?Ddidn't copy it exactly? The possibilities are endless. --------------------------------------- 1- I have checked the installation, and it is correct. 2- I have tried to look for any help in google and the only page I find is a german one, in which a guy tells me to change ( $customer_language_id_qry = tep_db_query('select customers_language_id from ' . TABLE_CUSTOMERS . ' where customers_id = ' . $HTTP_GET_VARS['cID']); // Fehler beseitigt) but I don´t know either where to put it or if it´s really a fix.3- About the Mysql5 fix, I find it not to work with me. Can anyone else help me at least to understand the german quote? and if it´ll work and where to put it? Thanks Arnau Link to comment Share on other sites More sharing options...
satish Posted January 3, 2008 Share Posted January 3, 2008 $HTTP_GET_VARS['cID'] to $_GET['cID'] and chek. Register globals issues. Satish Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
arnaupuig100 Posted January 4, 2008 Author Share Posted January 4, 2008 $HTTP_GET_VARS['cID'] to $_GET['cID'] and chek.Register globals issues. Satish Where do I have to change this code, can you tell me the php page? Thanks Arnau Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.