SQL Error Websitename starting with number


#1

Hi,

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

Version: 2.8.3

When I use another string from this websitename, like “highway”, it works just fine.


(Matthieu Aubry) #2

Thanks for the report! I fixed it in : Searching for a number in Website Selector leads to SQL error · Issue #6537 · matomo-org/matomo · GitHub