Question DB errors with forum titles having * in them

Status
Not open for further replies.

subaruclub

Customer
Hi,

Just installed the product yesterday (v 1.3.1) and I am getting emails with this error:

Database error in DragonByte SEO 1.3.1:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*113071(&[\#\da-z]*;|[^a-z\d])*\*w[eИЙКЛийкл](&[\#\da-z]*;|[^a-z\d])*b[aАБВГДЕабвгде][cЗc]k(&[\#\da-z]*;|[^a-z\d])*j[aАБВГДЕабвгде]p[aАБВГДЕабвгде][nСс](&[\#\da-z]*;|[^a-z\d])*f[iМНОПмноп][nСс][aАБВГДЕабвгде]ll[yџЭэя].html(&[\#\da-z]*;|[^a-z\d])*$'
LIMIT 1;

MySQL Error : Got error 'repetition-operator operand invalid' from regexp
Error Number : 1139
Request Date : Saturday, November 22nd 2014 @ 07:01:18 PM
Error Date : Saturday, November 22nd 2014 @ 07:01:18 PM
Script : DragonByte SEO Database Error
Referrer :
IP Address : 66.249.79.72
Username : N/A
Classname : DBSEO_Database_MySQLi
MySQL Version :




I did read where changing my .htaccess should fix the issue, but it is not.

Can you double check that I have things done correctly?



Here is my .htaccess:


<IfModule mod_rewrite.c>

RewriteEngine On
RewriteCond %{SERVER_PORT} 80
RewriteRule ^(.*)$ https://www.toronto-subaru-club.com/\forums\/$1 [R=301,L]

RewriteEngine on

# Set to vbulletin directory
RewriteBase /forums/

# Retrieve gamedata requests and send to new dbtech locations
RewriteRule ^arcade/gamedata/(.*) dbtech/vbarcade/media/$1 [L]

# Retrieve crossdomain requests and send to new dbtech location
RewriteRule ^crossdomain\.xml dbtech/vbarcade/crossdomain.xml [L]

# Send hardcoded legacy scores to arcade instead
RewriteCond %{REQUEST_URI} newscore\.php [OR]
RewriteCond %{REQUEST_URI} viewgame\.php
RewriteRule .* arcade.php?sendscore=legacy [L,QSA]

# Send hardcoded legacy scores to arcade instead
RewriteCond %{QUERY_STRING} func=storeScore [OR]
RewriteCond %{QUERY_STRING} autocom=arcade [OR]
RewriteCond %{QUERY_STRING} act=arcadelib [OR]
RewriteCond %{QUERY_STRING} act=Arcade
RewriteRule .* arcade.php [L,QSA]

# Reroute v3arcade liveinstaller
RewriteCond %{QUERY_STRING} do=liveinstall
RewriteCond %{REQUEST_URI} v3arcade_admin\.php

# If you renamed your admincp directory, change it here
RewriteRule .* %{DOCUMENT_ROOT}/admincp/arcade_admin.php?%{QUERY_STRING}&do=review&import=browse&system=v3a [L,R=301]
</IfModule>
RewriteEngine Off

RewriteEngine On

RewriteRule ^classifieds/([^/]*)/ ./ozzmodz_classifieds.php?do=main&catid=$1 [L,NC]
RewriteRule ^sale/([^/]*)/ ./ozzmodz_classifieds.php?do=viewitem&itemid=$1 [L,NC]
RewriteRule ^wanted/([^/]*)/ ./ozzmodz_classifieds.php?do=viewitem&itemid=$1 [L,NC]
RewriteRule ^trade/([^/]*)/ ./ozzmodz_classifieds.php?do=viewitem&itemid=$1 [L,NC]
RewriteRule ^offer/([^/]*)/ ./ozzmodz_classifieds.php?do=viewitem&itemid=$1 [L,NC]
RewriteRule ^seller/([^/]*)/ ./ozzmodz_classifieds.php?do=seller&sellerid=$1 [L,NC]


RewriteEngine On

# If you are having problem with "None Could Be Negotiated" errors in Apache, uncomment this to turn off MultiViews
# Options -MultiViews

RewriteRule ^threads/.* showthread.php [QSA]
RewriteRule ^forums/.* forumdisplay.php [QSA]
RewriteRule ^members/.* member.php [QSA]
RewriteRule ^blogs/.* blog.php [QSA]
RewriteRule ^entries/.* entry.php [QSA]

RewriteCond %{REQUEST_URI} !(admincp/|dbseocp/|modcp/|cron|mobiquo|forumrunner|api\.php|reviewpost/|classifieds/|photopost/)
RewriteRule ^((archive/)?(.*\.php(/.*)?))$ dbseo.php [L,QSA]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !/(admincp|dbseocp|modcp|clientscript|cpstyles|images|reviewpost|classifieds|photopost)/
RewriteRule ^(.+)$ dbseo.php [L,QSA]

D.
 
Can you try upgrading to v1.3.2 and let me know if that resolves it for you? I made a few changes in that version that I believe should resolve this.
 
Can you try upgrading to v1.3.2 and let me know if that resolves it for you? I made a few changes in that version that I believe should resolve this.

I am downloading and installing now.

Do I need to make any setting changes with the new version?

Is my .htaccess okay as is?

D.
 
Re-installed the "new" 3.2.1

Still getting these errors:

Database error in DragonByte SEO 1.3.2:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*135247(&[\#\da-z]*;|[^a-z\d])*h[eИЙКЛийкл][aАБВГДЕабвгде]d[sЉљ](&[\#\da-z]*;|[^a-z\d])*([uЩЪЫЬщъыьµ]|u|Ж|ж)p(&[\#\da-z]*;|[^a-z\d])*\*(&[\#\da-z]*;|[^a-z\d])*[iМНОПмноп][nСс][sЉљ]([uЩЪЫЬщъыьµ]|u|Ж|ж)r[aАБВГДЕабвгде][nСс][cЗc][eИЙКЛийкл](&[\#\da-z]*;|[^a-z\d])*[sЉљ][cЗc][aАБВГДЕабвгде]m.html(&[\#\da-z]*;|[^a-z\d])*$'
LIMIT 1;

MySQL Error : Got error 'repetition-operator operand invalid' from regexp
Error Number : 1139
Request Date : Sunday, November 23rd 2014 @ 02:18:02 AM
Error Date : Sunday, November 23rd 2014 @ 02:18:02 AM
Script : DragonByte SEO Database Error
Referrer :
IP Address : 76.68.22.136
Username : N/A
Classname : DBSEO_Database_MySQLi
MySQL Version :


Is there a way I can run a SQL script to delete all instances of "*" in thread titles so that the error doesn't come back?

From what I can tell it is a remnant of when we used to have censorship turned on and it replaced "bad words" with a * for the letters.




D.
 
Here are some unique ones that I got over-night


Database error in DragonByte SEO 1.3.2:

Invalid SQL:

SELECT *
FROM thread
WHERE threadid IN (192167,192167,192261,192261,122705,122705,192220,192220,192270,192270,183072,183072,143126,143126,192299,192299,187637,187637,191360,191360,179657,179657,189729,189729,150959,150959,188069,188069,188757,188757,192223,192223,192133,192133,173599,173599,141312,141312,192213,192213,192176,192176,192226,192226,140891,140891,116440,116440,156713,156713,192233,192233,192280,192280,192208,192208,191625,191625,136738,136738,189567,189567,192292,192292,192087,192087,192300,192300,192297,192297,192252,192252,191323,191323,192089,192089,192216,192216,192115,192115,192291,192291,192095,192095,192296,192296,192232,192232,192255,192255,192197,192197,192241,192241,191186,191186,192267,192267,192085,192085,167736,167736,191668,191668,192221,192221,181383,181383,192236,192236,184343,184343,192211,192211,190491,190491);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, November 23rd 2014 @ 10:10:58 AM
Error Date : Sunday, November 23rd 2014 @ 10:10:58 AM
Script : Toronto Subaru Club
Referrer : https://www.toronto-subaru-club.com...-turbo-and-built/192281-pipe-length-size.html
IP Address : 207.219.69.168
Username : N/A
Classname : DBSEO_Database_MySQLi
MySQL Version :



Database error in DragonByte SEO 1.3.2:

User subaru_tsc already has more than 'max_user_connections' active connections

MySQL Error :
Error Number :
Request Date : Sunday, November 23rd 2014 @ 10:10:36 AM
Error Date : Sunday, November 23rd 2014 @ 10:10:36 AM
Script : license can be taken for 10 years
Referrer :
IP Address : 157.55.39.146
Username : N/A
Classname : DBSEO_Database_MySQLi
MySQL Version :
 
Still seeing these errors.

This is the latest:

Database error in DragonByte SEO 1.3.2:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*92414(&[\#\da-z]*;|[^a-z\d])*fifa\*\*head(&[\#\da-z]*;|[^a-z\d])*butt(&[\#\da-z]*;|[^a-z\d])*chest\*\*fifa(&[\#\da-z]*;|[^a-z\d])*9.html(&[\#\da-z]*;|[^a-z\d])*$'
LIMIT 1;

MySQL Error : Got error 'repetition-operator operand invalid' from regexp
Error Number : 1139
Request Date : Monday, November 24th 2014 @ 04:38:38 PM
Error Date : Monday, November 24th 2014 @ 04:38:38 PM
Script : DragonByte SEO Database Error
Referrer :
IP Address : 66.249.79.88
Username : N/A
Classname : DBSEO_Database_MySQLi
MySQL Version :


This is the CURRENT URL of the thread:

https://www.toronto-subaru-club.com...scussion/92414-fifa-head-butt-chest-fifa.html

I think, as you pointed out, that this is a remnant of when I used to have VB doing the rewrite URLS then moved to your product.

Do I need to add another QSA rule in my .htaccess? I have this now:

RewriteRule ^threads/.* showthread.php [QSA]
RewriteRule ^forums/.* forumdisplay.php [QSA]
RewriteRule ^members/.* member.php [QSA]
RewriteRule ^blogs/.* blog.php [QSA]
RewriteRule ^entries/.* entry.php [QSA]



D.
 
MySQL Error : MySQL server has gone away
MySQL :: MySQL 5.0 Reference Manual :: B.5.2.9 MySQL server has gone away
User subaru_tsc already has more than 'max_user_connections' active connections
You'll need to increase the max_user_connections variable in the MySQL config.
MySQL Error : Got error 'repetition-operator operand invalid' from regexp
I'm adding additional code that should resolve this to tonight's update :)
 
MySQL :: MySQL 5.0 Reference Manual :: B.5.2.9 MySQL server has gone away
You'll need to increase the max_user_connections variable in the MySQL config.
I'm adding additional code that should resolve this to tonight's update :)

New version applied....

Still getting the errors:


Database error in DragonByte SEO 1.3.3:

Invalid SQL:

SELECT userid
FROM user
WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*144884(&[\#\da-z]*;|[^a-z\d])*f\*\*\*\*(&[\#\da-z]*;|[^a-z\d])*ice(&[\#\da-z]*;|[^a-z\d])*chunks.html(&[\#\da-z]*;|[^a-z\d])*$'
LIMIT 1;

MySQL Error : Got error 'repetition-operator operand invalid' from regexp
Error Number : 1139
Request Date : Tuesday, November 25th 2014 @ 05:20:30 PM
Error Date : Tuesday, November 25th 2014 @ 05:20:30 PM
Script : DragonByte SEO Database Error
Referrer :
IP Address : 66.249.79.80
Username : N/A
Classname : DBSEO_Database_MySQLi
MySQL Version :
 
Could you PM me with FTP and AdminCP information so I could look into this further?
 
My Issue is resolved.

I was interpreting the error incorrectly and it was caused by improperly removed users.

This I would assume is unique to my site and therefore should not be considered a bug of the software.

Deleting the offending threads has made all errors stop.

Thank you.

D.
 
Status
Not open for further replies.

Legacy DragonByte SEO

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
7,169
Customer rating
5.00 star(s) 1 ratings
Back
Top