Bug After upgrade 1.2.8 to 1.2.1.1 database error

[franzes80]

After upgrade database error.Please fix this error and help me thank you

Database error in 1211:

Invalid SQL:
;

MySQL Error :
Error Number :
Request Date : Sunday, November 2nd 2014 @ 01:16:22 PM
Error Date : Sunday, November 2nd 2014 @ 01:16:22 PM
Script : Gamesonic-Specialisti in news e console
Referrer :
IP Address : 191.183.148.190
Username : N/A
Classname : DBSEO_Database_MySQLi
MySQL Version :

 

[Fillip H.]

Please try setting $config['DBSEO']['debug'] = true; in config.php and wait for another such error message to be emailed to you, that should contain more information

 

[franzes80]

This is the error
Database error in* 1211:

Invalid SQL:
;

MySQL Error* *:
Error Number* :
Request Date* : Sunday, November 2nd 2014 @ 09:06:23 PM
Error Date* * : Sunday, November 2nd 2014 @ 09:06:23 PM
Script* * * * :*http://gamesonic.it/forum/mgc_cb_evo_ajax.php
Referrer* * * :*Gamesonic-Specialisti in news e console
IP Address* * : 89.21.213.172
Username* * * : N/A
Classname* * *: DBSEO_Database_MySQLi
MySQL Version :

Stack Trace:

#0 DBSEO_Database->halt() called in [path]/dbtech/dbseo/includes/class_db.php on line 845
#1 DBSEO_Database_MySQLi->db_connect() called in [path]/dbtech/dbseo/includes/class_db.php on line 169
#2 DBSEO_Database->connect() called in [path]/dbtech/dbseo/includes/class_core.php on line 220
#3 DBSEO::init() called in [path]/dbseo.php on line 50

 

[Fillip H.]

There should be a more complete error message in the next version

 

[franzes80]

The error continue in new version 1.30

 

[Fillip H.]

There's no longer any blank error messages in this new version. Please provide the full error message.

 

[franzes80]

This is the error on v 1.30
Database error in DragonByte SEO 1.3.0:

Invalid SQL:
;

MySQL Error* *:
Error Number* :
Request Date* : Thursday, November 6th 2014 @ 11:10:07 PM
Error Date* * : Thursday, November 6th 2014 @ 11:10:07 PM
Script* * * * :*http://gamesonic.it/forum/mgc_cb_evo_ajax.php
Referrer* * * :*Gamesonic-Specialisti in news e console
IP Address* * : 87.19.188.24
Username* * * : N/A
Classname* * *: DBSEO_Database_MySQLi
MySQL Version :

Stack Trace:

#0 DBSEO_Database->halt() called in [path]/dbtech/dbseo/includes/class_db.php on line 852
#1 DBSEO_Database_MySQLi->db_connect() called in [path]/dbtech/dbseo/includes/class_db.php on line 176
#2 DBSEO_Database->connect() called in [path]/dbtech/dbseo/includes/class_core.php on line 220
#3 DBSEO::init() called in [path]/dbseo.php on line 50

 

[Fillip H.]

This has already been resolved, please re-download the mod and re-upload /dbtech/dbseo/includes/class_db.php

 

[franzes80]

Re download and re-upload class_DB.PHP the error continue

Database error in DragonByte SEO 1.3.0:

Invalid SQL:

* * * * * * * * * * * * * * * * * * * * SELECT userid
* * * * * * * * * * * * * * * * * * * * FROM user
* * * * * * * * * * * * * * * * * * * * WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*p'(&[\#\da-z]*;|[^a-z\d])*$'
* * * * * * * * * * * * * * * * * * * * LIMIT 1;

MySQL Error* *: 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 '(&[\#\da-z]*;|[^a-z\d])*$'
* * * * * * * * * * * * * * * * * * * * LIMIT 1' at line 3
Error Number* : 1064
Request Date* : Friday, November 7th 2014 @ 08:24:00 PM
Error Date* * : Friday, November 7th 2014 @ 08:24:00 PM
Script* * * * :*Gamesonic-Specialisti in news e console'
Referrer* * * :
IP Address* * : 213.87.123.152
Username* * * : N/A
Classname* * *: DBSEO_Database_MySQLi
MySQL Version :

Stack Trace:

#0 DBSEO_Database->halt() called in [path]/dbtech/dbseo/includes/class_db.php on line 894
#1 DBSEO_Database_MySQLi->execute_query() called in [path]/dbtech/dbseo/includes/class_db.php on line 302
#2 DBSEO_Database->query_read_slave() called in [path]/dbtech/dbseo/includes/class_db.php on line 764
#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.]

I've uploaded a potential hotfix to /dbtech/dbseo/includes/filter.php that should resolve this

 

[franzes80]

Sorry The error continue tonight 100 e-mail error

Database error in DragonByte SEO 1.3.0:

Invalid SQL:
;

MySQL Error* *:
Error Number* :
Request Date* : Saturday, November 8th 2014 @ 04:36:33 AM
Error Date* * : Saturday, November 8th 2014 @ 04:36:33 AM
Script* * * * :*Linux
Referrer* * * :
IP Address* * : 220.181.108.102
Username* * * : N/A
Classname* * *: DBSEO_Database_MySQLi
MySQL Version :

Stack Trace:

#0 DBSEO_Database->halt() called in [path]/dbtech/dbseo/includes/class_db.php on line 852
#1 DBSEO_Database_MySQLi->db_connect() called in [path]/dbtech/dbseo/includes/class_db.php on line 176
#2 DBSEO_Database->connect() called in [path]/dbtech/dbseo/includes/class_core.php on line 220
#3 DBSEO::init() called in [path]/dbseo.php on line 50

 

[Fillip H.]

In either case, the issue is that DBSEO can't connect to the database. Try asking your host for assistance with increasing the MySQL connection limit, I recommend doubling it.

 

[franzes80]

MySQl database is unlimited

 

[Fillip H.]

I've made further improvements to the MySQLi database connection class which should hopefully print an actual error message, this will be available in tomorrow's update

 

[franzes80]

This is the error v 1.31
Database error in DragonByte SEO 1.3.1:

Can't connect to MySQL server on 'hostingmysql313.register.it' (113)

MySQL Error* *:
Error Number* :
Request Date* : Wednesday, November 12th 2014 @ 08:46:15 AM
Error Date* * : Wednesday, November 12th 2014 @ 08:46:15 AM
Script* * * * :*GameYob 3DS
Referrer* * * :
IP Address* * : 157.55.39.55
Username* * * : N/A
Classname* * *: DBSEO_Database_MySQLi
MySQL Version :

Stack Trace:

#0 DBSEO_Database->halt() called in [path]/dbtech/dbseo/includes/class_db.php on line 854
#1 DBSEO_Database_MySQLi->db_connect() called in [path]/dbtech/dbseo/includes/class_db.php on line 177
#2 DBSEO_Database->connect() called in [path]/dbtech/dbseo/includes/class_core.php on line 220
#3 DBSEO::init() called in [path]/dbseo.php on line 50

 

[Fillip H.]

We cannot give you the correct connection information, you will need to contact your host for assistance.

 

[franzes80]

OK solved error hosting.

This is another error
Database error in DragonByte SEO 1.3.1:

Invalid SQL:

* * * * * * * * * * * * * * * * * * * * SELECT userid
* * * * * * * * * * * * * * * * * * * * FROM user
* * * * * * * * * * * * * * * * * * * * WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*30(&[\#\da-z]*;|[^a-z\d])*otheros(&[\#\da-z]*;|[^a-z\d])*tools(&[\#\da-z]*;|[^a-z\d])**(&[\#\da-z]*;|[^a-z\d])*boot_gameos(&[\#\da-z]*;|[^a-z\d])*pkg(&[\#\da-z]*;|[^a-z\d])*boot_linux(&[\#\da-z]*;|[^a-z\d])*sh(&[\#\da-z]*;|[^a-z\d])*boot_otheros(&[\#\da-z]*;|[^a-z\d])*pkg(&[\#\da-z]*;|[^a-z\d])*boot_otheros(&[\#\da-z]*;|[^a-z\d])*pkg(&[\#\da-z]*;|[^a-z\d])*ecc.html(&[\#\da-z]*;|[^a-z\d])*$'
* * * * * * * * * * * * * * * * * * * * LIMIT 1;

MySQL Error* *: Got error 'repetition-operator operand invalid' from regexp
Error Number* : 1139
Request Date* : Thursday, November 13th 2014 @ 10:32:25 PM
Error Date* * : Thursday, November 13th 2014 @ 10:32:25 PM
Script* * * * :*DragonByte SEO Database Error
Referrer* * * :
IP Address* * : 66.249.69.92
Username* * * : N/A
Classname* * *: DBSEO_Database_MySQLi
MySQL Version :

Stack Trace:

#0 DBSEO_Database->halt() called in [path]/dbtech/dbseo/includes/class_db.php on line 896
#1 DBSEO_Database_MySQLi->execute_query() called in [path]/dbtech/dbseo/includes/class_db.php on line 303
#2 DBSEO_Database->query_read_slave() called in [path]/dbtech/dbseo/includes/class_db.php on line 765
#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 956
#7 DBSEO_Url::resolve() called in [path]/dbtech/dbseo/includes/url.php on line 579
#8 DBSEO_Url::lookup() called in [path]/dbseo.php on line 135

 

[Fillip H.]

I've added a hotfix for this to /dbtech/dbseo/includes/filter.php

 

[franzes80]

Solved problem on version 1.3.3 thank you