Hi, an error has popped up when a user registers on the website with facebook login.
Error: 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 'INT) suffix FROM jool_users WHERE `username` ~ '^g.smith[0-9]+$' ORDER BY `suf' at line 1 SQL=SELECT CAST(REPLACE(username, 'g.smith', '') AS INT) suffix FROM jool_users WHERE `username` ~ '^g.smith[0-9]+$' ORDER BY `suffix` DESC LIMIT 1
You may not be able to visit this page because of:
1. an out-of-date bookmark/favourite
2. a search engine that has an out-of-date listing for this site
3. a mistyped address
4. you have no access to this page
5. The requested resource was not found.
6. An error has occurred while processing your request.
When they visit a discussion page their name shows as ()Guest until the page is refreshed.
Please advise.
Error: 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 'INT) suffix FROM jool_users WHERE `username` ~ '^g.smith[0-9]+$' ORDER BY `suf' at line 1 SQL=SELECT CAST(REPLACE(username, 'g.smith', '') AS INT) suffix FROM jool_users WHERE `username` ~ '^g.smith[0-9]+$' ORDER BY `suffix` DESC LIMIT 1
You may not be able to visit this page because of:
1. an out-of-date bookmark/favourite
2. a search engine that has an out-of-date listing for this site
3. a mistyped address
4. you have no access to this page
5. The requested resource was not found.
6. An error has occurred while processing your request.
When they visit a discussion page their name shows as ()Guest until the page is refreshed.
Please advise.