Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Searching for a number in Website Selector leads to SQL error #6537

Closed
mattab opened this issue Oct 28, 2014 · 0 comments
Closed

Searching for a number in Website Selector leads to SQL error #6537

mattab opened this issue Oct 28, 2014 · 0 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone
Backlog (Help wan...

Comments

@mattab
Copy link
Member

mattab commented Oct 28, 2014

Reported in forum post

I'm using some Websitenames starting with a number (ie: 06highway) . As soon as I try to search by entering 06, it get this error:

SQLSTATE[42000]: Syntax error or access violation: 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 'ORs s.idsite = '50' ) AND idsite in (1 , 2 , 3 , 4 , 5 , 6 ' at line 6
@mattab mattab added the Bug For errors / faults / flaws / inconsistencies etc. label Oct 28, 2014
@mattab mattab closed this as completed in 5494274 Oct 28, 2014
@mattab mattab modified the milestone: Short term Sep 23, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Milestone
Backlog (Help wanted)
Development

No branches or pull requests
1 participant
@mattab