Bug dbseo errors

[nicklfire]

i am getting this error sent to my email, looks similar to the vbulletin error but says dragonbyte. I did upgrade dragonbyte to the latest version. I also made changes to htaccess for another mod but changed it back after i did not get the results i wanted.

I have no Custom Character Filter in the settings.


Database error in DragonByte SEO 1.3.6:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*3126(&[\#\da-z]*;|[^a-z\d])*New(&[\#\da-z]*;|[^a-z\d])*System(&[\#\da-z]*;|[^a-z\d])*Needed(&[\#\da-z]*;|[^a-z\d])*to(&[\#\da-z]*;|[^a-z\d])*Regulate(&[\#\da-z]*;|[^a-z\d])*Electric(&[\#\da-z]*;|[^a-z\d])*Cigarettes(&[\#\da-z]*;|[^a-z\d])*Reports(&[\#\da-z]*;|[^a-z\d])*DigitalSmoke(&[\#\da-z]*;|[^a-z\d])*org(&[\#\da-z]*;|[^a-z\d])*SBWire(&[\#\da-z]*;|[^a-z\d])*((&[\#\da-z]*;|[^a-z\d])*$'
LIMIT 1;

MySQL Error : Got error 'parentheses not balanced' from regexp
Error Number : 1139
Request Date : Wednesday, December 17th 2014 @ 12:40:49 AM
Error Date : Wednesday, December 17th 2014 @ 12:40:49 AM
Script : DragonByte SEO Database Error
Referrer :
IP Address : 66.249.79.61
Username : N/A
Classname : DBSEO_Database_MySQLi
MySQL Version :

 

[nicklfire]

seemed to just get another one:


Database error in DragonByte SEO 1.3.6:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*73(&[\#\da-z]*;|[^a-z\d])*Even(&[\#\da-z]*;|[^a-z\d])*Moderate(&[\#\da-z]*;|[^a-z\d])*Smoking(&[\#\da-z]*;|[^a-z\d])*Associated(&[\#\da-z]*;|[^a-z\d])*With(&[\#\da-z]*;|[^a-z\d])*Sudden(&[\#\da-z]*;|[^a-z\d])*Death(&[\#\da-z]*;|[^a-z\d])*Risk(&[\#\da-z]*;|[^a-z\d])*in(&[\#\da-z]*;|[^a-z\d])*Women(&[\#\da-z]*;|[^a-z\d])*Science(&[\#\da-z]*;|[^a-z\d])*Daily(&[\#\da-z]*;|[^a-z\d])*(pre(&[\#\da-z]*;|[^a-z\d])*$'
LIMIT 1;

MySQL Error : Got error 'parentheses not balanced' from regexp
Error Number : 1139
Request Date : Wednesday, December 17th 2014 @ 09:26:39 AM
Error Date : Wednesday, December 17th 2014 @ 09:26:39 AM
Script : DragonByte SEO Database Error
Referrer :
IP Address : 209.121.120.55
Username : N/A
Classname : DBSEO_Database_MySQLi
MySQL Version :

 

[Fillip H.]

I've added a potential hotfix for this issue, could you re-download the product and re-upload /dbtech/dbseo/includes/filter.php and let me know if this works for you?

 

[nicklfire]

i have uploaded the new filter.php, i'll wait and see if i get anymore email errors

What does the fix do, just refer the error back to homepage cause when i click on the same url giving me a error before it just sends me back to homepage.

 

[Fillip H.]

It escapes the parenthesis characters from the SQL query so there's no more DB errors (hopefully)