Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error 1064 in mysql


arnaupuig100

Recommended Posts

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

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

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

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

$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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...