Bug Database Error

[markoroots]

Hi,
I have installed few days ago the upgrade of the DBSeo to the 4.2.10 version
I don't know if depend from this but I'm receiving by email these database errors:

Database error in 1210:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP "^(&[\#\da-z]*;|[^a-z\d])*1922(&[\#\da-z]*;|[^a-z\d])*GP(&[\#\da-z]*;|[^a-z\d])*PAPS(&[\#\da-z]*;|[^a-z\d])*Style(&[\#\da-z]*;|[^a-z\d])*MOD(&[\#\da-z]*;|[^a-z\d])*V2(&[\#\da-z]*;|[^a-z\d])*(High(&[\#\da-z]*;|[^a-z\d])*quality(&[\#\da-z]*;|[^a-z\d])*Copper(&[\#\da-z]*;|[^a-z\d])*Contact(&[\#\da-z]*;|[^a-z\d])*Switch(&[\#\da-z]*;|[^a-z\d])*$"
LIMIT 1;

MySQL Error : Got error 'parentheses not balanced' from regexp
Error Number : 1139
Request Date : Sunday, October 26th 2014 @ 02:34:47 AM
Error Date : Sunday, October 26th 2014 @ 02:34:47 AM
Script : http://www.xxxxxxxxxxx.com/threads/1922-GP-PAPS-Style-MOD-V2-(High-quality-Copper-Contact-Switch
Referrer :
IP Address : 66.249.67.148
Username : N/A
Classname : DBSEO_Database
MySQL Version :

What to do?

 

[Fillip H.]

This looks like an old mod_rewrite vB Friendly URL conflicting with one of your member's URL formats.

If this is the case, you should add a .htaccess rewrite to redirect the old vB Friendly URLs back to their .php file equivalent, and place those rewrites above DBSEO's in your .htaccess file.

 

[markoroots]

Sorry Fillip H., but I really don't know what to do and how to fix.
Can you please give me an help?
The ftp access I gave you, is always the same.

 

[markoroots]

I see that are arriving also different kinds of errors messages in both forum I have installed the plugin after that I have made the upgrade to the last version.

I send you in PM these messages.

 

[Fillip H.]

I've made a change to the /dbtech/dbseo/includes/class_db.php found in v1.2.11 in order to increase the debug output required in order to discover the source of this issue.

Could you please follow these steps:
1. Download v1.2.11 from your Client Area
2. Either upgrade to v1.2.11 normally, or simply re-upload that one file
3. Make sure the "technicalemail" setting in config.php is filled out
4. Add $config['DBSEO']['debug'] = true; to your config.php file
5. Observe your email address for more database error notifications

Thank you

 

[markoroots]

Done.
I hope this will fix it.
I will let you know if new errors will be shown.
Many thanks.

 

[markoroots]

Today arrive.

Database error in 1211:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP "^(&[\#\da-z]*;|[^a-z\d])*1922(&[\#\da-z]*;|[^a-z\d])*GP(&[\#\da-z]*;|[^a-z\d])*PAPS(&[\#\da-z]*;|[^a-z\d])*Style(&[\#\da-z]*;|[^a-z\d])*MOD(&[\#\da-z]*;|[^a-z\d])*V2(&[\#\da-z]*;|[^a-z\d])*(High(&[\#\da-z]*;|[^a-z\d])*quality(&[\#\da-z]*;|[^a-z\d])*Copper(&[\#\da-z]*;|[^a-z\d])*Contact(&[\#\da-z]*;|[^a-z\d])*Switch(&[\#\da-z]*;|[^a-z\d])*$"
LIMIT 1;

MySQL Error : Got error 'parentheses not balanced' from regexp
Error Number : 1139
Request Date : Sunday, November 2nd 2014 @ 02:06:49 PM
Error Date : Sunday, November 2nd 2014 @ 02:06:49 PM
Script : http://www.myelfsite.com/threads/1922-GP-PAPS-Style-MOD-V2-(High-quality-Copper-Contact-Switch
Referrer :
IP Address : 66.249.78.93
Username : N/A
Classname : DBSEO_Database
MySQL Version :

Stack Trace:

#0 DBSEO_Database->halt() called in [path]/dbtech/dbseo/includes/class_db.php on line 359
#1 DBSEO_Database->execute_query() called in [path]/dbtech/dbseo/includes/class_db.php on line 295
#2 DBSEO_Database->query_read_slave() called in [path]/dbtech/dbseo/includes/class_db.php on line 757
#3 DBSEO_Database->generalQuery() called in [path]/dbtech/dbseo/includes/filter.php on line 744
#4 DBSEO_Filter::reverseUsername() called in [path]/dbtech/dbseo/includes/rewrite/avatar.php on line 27
#5 DBSEO_Rewrite_Avatar::resolveUrl() called in on line
#6 call_user_func() called in [path]/dbtech/dbseo/includes/url.php on line 954
#7 DBSEO_Url::resolve() called in [path]/dbtech/dbseo/includes/url.php on line 577
#8 DBSEO_Url::lookup() called in [path]/dbseo.php on line 135

 

[Fillip H.]

Try adding this rule above your DBSEO rules in the .htaccess:

RewriteRule ^threads/.* showthread.php [QSA]

 

[markoroots]

Now all work good.

Really thanks Fillip H..