error login

Started by danil0, Apr 09 2011, 19:36

You cannot reply to this topic
Go to first unread post

3 replies to this topic

#1 danil0

Community Member
72 posts

Real Name:Daniel
Gender:Male
Location:Greece Athens

@Mention

Posted 09 April 2011, 19:36

Hello suddenly, after 2-3 years of normal use, I cannot login with my customer test account I have for testing reasons... I m getting this error message:

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 '?products_id=100,186)' at line 1

select p.products_id, find_in_set('0', products_hide_from_groups) as hide_or_not, find_in_set('0', categories_hide_from_groups) as in_hidden_category from products p left join products_to_categories p2c using(products_id) left join categories c using(categories_id) where p.products_id in (88,46,100,39?products_id=100,186)

[TEP STOP]

This is a big problem because I guess that many customers probably cannot login either...
Can anyone help me?

Back to top

#2 DunWeb

Community Sponsor
10,464 posts

Real Name:Chris Dunn
Gender:Male
Location:Tecumseh, Ontario, Canada N8N 1X8

@Mention

Posted 09 April 2011, 19:41

Daniel,

My guess would be that your hosting provider updated your version of MYSQL and now your site needs to be updated. I would check with them to verify any changes.

Otherwise, check your site for hacker activity.

Chris

:|: Was this post helpful ? Click the LIKE THIS button :|:

:|: Click Here to learn how I can help you with custom coding, add ons, security and templates :|:

:|: Need an Area Calculator, Pre-Paid Account, Virtual Pin, Auction or Layaway Add on ? Click Here :|:

Back to top

#3 danil0

Community Member
72 posts

Real Name:Daniel
Gender:Male
Location:Greece Athens

@Mention

Posted 11 April 2011, 16:56

DunWeb, on 09 April 2011, 19:41, said:

Daniel,

My guess would be that your hosting provider updated your version of MYSQL and now your site needs to be updated. I would check with them to verify any changes.

Otherwise, check your site for hacker activity.

Chris

Chris thank you for your answer...
I asked my provider here his answer:

[i]Hello,
Thank you for your inquiry.
We haven't touched MYSQL. 

Regards,
Norman
Netfirms Support Team.[/i]

...I don't thing that I have been hacked ... is there any way to check this out?
I checked with other test accounts and its working well ... but with this account I het this error...

Any other ideas?

Back to top

#4 danil0

Community Member
72 posts

Real Name:Daniel
Gender:Male
Location:Greece Athens

@Mention

Posted 13 April 2011, 20:01

danil0, on 11 April 2011, 16:56, said:

Chris thank you for your answer...
I asked my provider here his answer:

[i]Hello,
Thank you for your inquiry.
We haven't touched MYSQL. 

Regards,
Norman
Netfirms Support Team.[/i]

...I don't thing that I have been hacked ... is there any way to check this out?
I checked with other test accounts and its working well ... but with this account I het this error...

Any other ideas?

...so there is no other ideas?

Back to top

Back to Installation and Configuration · Next Unread Topic →