Question Cms disappeared - Please Help

[markoroots]

These are the errors:

Database error in vBulletin 2.0.32:

Invalid SQL:

                    SELECT userid
                    FROM vb4_user
                    WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*[cÇc]l[aÀÁÂÃÄÅàáâãäå]80(&[\#\da-z]*;|[^a-z\d])*$'
                    LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 24' from regexp
Error Number  : 1139
Request Date  : Sunday, May 15th 2016 @ 08:49:11 AM
Error Date    : Sunday, May 15th 2016 @ 08:49:11 AM
Script        : http://www.sigarettaelettronicaforum.com/blogs/cla80/
Referrer      :
IP Address    : 157.55.39.249
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version : 





Database error in vBulletin 2.0.32:

Invalid SQL:
SELECT blogcategoryid AS id FROM vb4_blog_category WHERE userid IN(0,9452) AND title REGEXP "^(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*([uÙÚÛÜùúûüµ]|u|Æ|æ)[nÑñ][cÇc][aÀÁÂÃÄÅàáâãäå]t[eÈÉÊËèéêë]g[oÒÓÔÕÖØòóôõöø]r[iÌÍÎÏìíîï][zŽž][eÈÉÊËèéêë]d(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*$" ORDER BY LENGTH(userid IN(0,9452) AND title) LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 46' from regexp
Error Number  : 1139
Request Date  : Sunday, May 15th 2016 @ 08:40:49 AM
Error Date    : Sunday, May 15th 2016 @ 08:40:49 AM
Script        : http://www.sigarettaelettronicaforum.com/blogs/svapandoweb/uncategorized/
Referrer      :
IP Address    : 207.46.13.74
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version : 




Database error in vBulletin 2.0.32:

Invalid SQL:
SELECT blogcategoryid AS id FROM vb4_blog_category WHERE userid IN(0,7490) AND title REGEXP "^(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*[aÀÁÂÃÄÅàáâãäå](&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*$" ORDER BY LENGTH(userid IN(0,7490) AND title) LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 45' from regexp
Error Number  : 1139
Request Date  : Sunday, May 15th 2016 @ 08:30:07 AM
Error Date    : Sunday, May 15th 2016 @ 08:30:07 AM
Script        : http://www.sigarettaelettronicaforum.com/blogs/svapolibero/a/
Referrer      :
IP Address    : 66.249.66.49
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version : 


Database error in vBulletin 2.0.32:

Invalid SQL:

                    SELECT userid
                    FROM vb4_user
                    WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*bl[oÒÓÔÕÖØòóôõöø]g.html(&[\#\da-z]*;|[^a-z\d])*$'
                    LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 26' from regexp
Error Number  : 1139
Request Date  : Sunday, May 15th 2016 @ 07:49:00 AM
Error Date    : Sunday, May 15th 2016 @ 07:49:00 AM
Script        : http://www.sigarettaelettronicaforum.com/members/fabiohd68/blog.html/
Referrer      :
IP Address    : 157.55.39.249
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version :

If you see the blog links are different.
But should be the right one

http://www.sigarettaelettronicaforum.com/blogs/svapolibero/

And also:

Database error in vBulletin 2.0.32:

Invalid SQL:
SELECT tagtext AS id FROM vb4_tag WHERE tagtext REGEXP "^(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*[eÈÉÊËèéêë]v[iÌÍÎÏìíîï][cÇc](&[\#\da-z]*;|[^a-z\d])*vt[cÇc](&[\#\da-z]*;|[^a-z\d])*m[iÌÍÎÏìíîï][nÑñ][iÌÍÎÏìíîï](&[\#\da-z]*;|[^a-z\d])*[cÇc]([uÙÚÛÜùúûüµ]|u|Æ|æ)b[iÌÍÎÏìíîï][sŠš](&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*$" ORDER BY LENGTH(tagtext) LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 45' from regexp
Error Number  : 1139
Request Date  : Sunday, May 15th 2016 @ 07:26:27 AM
Error Date    : Sunday, May 15th 2016 @ 07:26:27 AM
Script        : http://www.sigarettaelettronicaforum.com/tags/evic-vtc-mini-cubis.html
Referrer      :
IP Address    : 66.249.66.49
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version : 





Database error in vBulletin 2.0.32:

Invalid SQL:
SELECT tagtext AS id FROM vb4_tag WHERE tagtext REGEXP "^(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*f[aÀÁÂÃÄÅàáâãäå][sŠš]h[iÌÍÎÏìíîï][oÒÓÔÕÖØòóôõöø][nÑñ][^a-z\d]*(and|&|&)[^a-z\d]*[nÑñ][eÈÉÊËèéêë]w(&[\#\da-z]*;|[^a-z\d])*[sŠš]m[oÒÓÔÕÖØòóôõöø]k[eÈÉÊËèéêë](&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*$" ORDER BY LENGTH(tagtext) LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 46' from regexp
Error Number  : 1139
Request Date  : Sunday, May 15th 2016 @ 07:24:43 AM
Error Date    : Sunday, May 15th 2016 @ 07:24:43 AM
Script        : http://www.sigarettaelettronicaforum.com/tags/fashion-and-new-smoke.html
Referrer      :
IP Address    : 66.249.66.49
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version : 




Database error in vBulletin 2.0.32:

Invalid SQL:
SELECT tagtext AS id FROM vb4_tag WHERE tagtext REGEXP "^(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*[eÈÉÊËèéêë]l[aÀÁÂÃÄÅàáâãäå][iÌÍÎÏìíîï]f(&[\#\da-z]*;|[^a-z\d])*[iÌÍÎÏìíîï]j([uÙÚÛÜùúûüµ]|u|Æ|æ)[sŠš]t(&[\#\da-z]*;|[^a-z\d])*[sŠš]t[aÀÁÂÃÄÅàáâãäå]rt(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*$" ORDER BY LENGTH(tagtext) LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 45' from regexp
Error Number  : 1139
Request Date  : Sunday, May 15th 2016 @ 07:19:55 AM
Error Date    : Sunday, May 15th 2016 @ 07:19:55 AM
Script        : http://www.sigarettaelettronicaforum.com/tags/elaif-ijust-start.html
Referrer      :
IP Address    : 66.249.66.49
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version : 






Database error in vBulletin 2.0.32:

Invalid SQL:
SELECT tagtext AS id FROM vb4_tag WHERE tagtext REGEXP "^(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*p[iÌÍÎÏìíîï]%C3%B9(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*$" ORDER BY LENGTH(tagtext) LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 46' from regexp
Error Number  : 1139
Request Date  : Sunday, May 15th 2016 @ 07:18:48 AM
Error Date    : Sunday, May 15th 2016 @ 07:18:48 AM
Script        : http://www.sigarettaelettronicaforum.com/tags/pi%C3%B9-page3.html
Referrer      :
IP Address    : 66.249.66.49
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version : 



Database error in vBulletin 2.0.32:

Invalid SQL:
SELECT tagtext AS id FROM vb4_tag WHERE tagtext REGEXP "^(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*v[aÀÁÂÃÄÅàáâãäå]p[oÒÓÔÕÖØòóôõöø]r[aÀÁÂÃÄÅàáâãäå]rtt[aÀÁÂÃÄÅàáâãäå]b[aÀÁÂÃÄÅàáâãäå][cÇc][cÇc][oÒÓÔÕÖØòóôõöø](&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*$" ORDER BY LENGTH(tagtext) LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 46' from regexp
Error Number  : 1139
Request Date  : Sunday, May 15th 2016 @ 07:16:59 AM
Error Date    : Sunday, May 15th 2016 @ 07:16:59 AM
Script        : http://www.sigarettaelettronicaforum.com/tags/vaporarttabacco.html
Referrer      :
IP Address    : 66.249.66.49
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version : 



Database error in vBulletin 2.0.32:

Invalid SQL:

                    SELECT userid
                    FROM vb4_user
                    WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*bl[oÒÓÔÕÖØòóôõöø]g.html(&[\#\da-z]*;|[^a-z\d])*$'
                    LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 26' from regexp
Error Number  : 1139
Request Date  : Sunday, May 15th 2016 @ 06:50:42 AM
Error Date    : Sunday, May 15th 2016 @ 06:50:42 AM
Script        : http://www.sigarettaelettronicaforum.com/members/cristian/blog.html/
Referrer      :
IP Address    : 157.55.39.159
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version : 



Database error in vBulletin 2.0.32:

Invalid SQL:
SELECT tagtext AS id FROM vb4_tag WHERE tagtext REGEXP "^(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*f([uÙÚÛÜùúûüµ]|u|Æ|æ)(&[\#\da-z]*;|[^a-z\d])*k[eÈÉÊËèéêë]r(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*$" ORDER BY LENGTH(tagtext) LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 47' from regexp
Error Number  : 1139
Request Date  : Sunday, May 15th 2016 @ 06:43:48 AM
Error Date    : Sunday, May 15th 2016 @ 06:43:48 AM
Script        : http://www.sigarettaelettronicaforum.com/tags/fu-ker.html
Referrer      :
IP Address    : 66.249.66.49
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version :

I'm going crazy...

 

[markoroots]

Know also that I have disabled the own blogs for the users, but let enabled only for the shops like this: Sigaretta Elettronica Forum - Svapolibero - Prodotti

 

[markoroots]

Also I was editing this post : Sigaretta Elettronica Forum
But when I click save it come on the home page showing me this link

http://www.sigarettaelettronicaforum.com/forum.php#post47128

I have seen a thing.
The friendly url of the upside thread is this:

http://www.sigarettaelettronicaforum.com/sistemi-a-mesh/9767-raccontiamo-come-a-andata-la-prima-volta-che-abbiamo-provato-a-rigenerare-un-genesis.html

But the title of the thread is: "Raccontiamo Come è Andata La Prima Volta Che Abbiamo Provato a Rigenerare Un Genesis"

So with the replace of the non latin characters this link should be:

http://www.sigarettaelettronicaforum.com/sistemi-a-mesh/9767-raccontiamo-come-e-andata-la-prima-volta-che-abbiamo-provato-a-rigenerare-un-genesis.html

But the system add the "a" instead of the "e".

 

[markoroots]

Do you think could help the rebuild index function in the maintenance section?

 

[markoroots]

Note also that the most of the errors received are from the same ip:
66.249.66.49

 

[Fillip H.]

The way thread titles are replaced is necessary for the system to function, unfortunately it would be too difficult to implement any changes to it as it would very likely break something else.

 

[markoroots]

I really don't know what else to do...
My email folders is like this from 20 days

and the site block each 20 minutes...
Now less of before but the problem is still there.

All beginning when I have updated the last version of dbseo, because the system begin to use really more usage of the resources of the previous hosting, so I had to change host and I move the site on a vps.
This vps use Mariadb that was previously setted in Innodb (note that) but in Innodb the site don't was working good so that the provider "Convert" the tables ad the database in utf8. I don't know if the codify conversion made some problems, but in each way the site continue to don't work like before.
So please Fillip try to help me in some way because I really don't know what else to do and you are the only person (really expert in this and that know better of anyone your application) that can fix this.

 

[Fillip H.]

You could try turning off rewrites for Tag URLs temporarily, that should stop the errors for the time being at least.

I am working on resolving it, but it isn't easy. Thank you for your patience and understanding.

 

[markoroots]

Patience how many you want I have. Really many thanks Fillip...
Only you can help me I'm desperate...

 

[Fillip H.]

If you PM me with FTP and AdminCP information I may be able to resolve it on-site, seems like the other avenue I had for getting this resolved has fallen through.

 

[markoroots]

Hi Fillip,
I have sent you the details.

Many thanks...

 

[markoroots]

Fillip H. Hi Fillip,
are there any news for me?
I have also disabled all the the friendly links of the forum like you told me and let enabled only for the threads because if not I loose all the rank of all the threads.
I have also disabled the tags but are continuing to arrive me errors about tags.
The site continue to go in block like you can see from the image in attach.

 

[Fillip H.]

Try re-enabling them and see if it works now

 

[markoroots]

Ok I'm trying.

 

[markoroots]

Just arrived the first one:

Database error in vBulletin 2.0.32:

Invalid SQL:

                    SELECT userid
                    FROM vb4_user
                    WHERE username REGEXP '^(&[\#\da-z]*;|[^a-z\d])*10(&[\#\da-z]*;|[^a-z\d])*r[eÈÉÊËèéêë]g[aÀÁÂÃÄÅàáâãäå]l[oÒÓÔÕÖØòóôõöø](&[\#\da-z]*;|[^a-z\d])*t([uÙÚÛÜùúûüµ]|u|Æ|æ)tt[eÈÉÊËèéêë](&[\#\da-z]*;|[^a-z\d])*[iÌÍÎÏìíîï]t[aÀÁÂÃÄÅàáâãäå]l[iÌÍÎÏìíîï][aÀÁÂÃÄÅàáâãäå][nÑñ][oÒÓÔÕÖØòóôõöø](&[\#\da-z]*;|[^a-z\d])*fl[aÀÁÂÃÄÅàáâãäå]v[oÒÓÔÕÖØòóôõöø]r(&[\#\da-z]*;|[^a-z\d])*l[iÌÍÎÏìíîï]q([uÙÚÛÜùúûüµ]|u|Æ|æ)[iÌÍÎÏìíîï]d[oÒÓÔÕÖØòóôõöø](&[\#\da-z]*;|[^a-z\d])*d[eÈÉÊËèéêë][aÀÁÂÃÄÅàáâãäå].html(&[\#\da-z]*;|[^a-z\d])*$'
                    LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 48' from regexp
Error Number  : 1139
Request Date  : Wednesday, May 18th 2016 @ 07:14:24 PM
Error Date    : Wednesday, May 18th 2016 @ 07:14:24 PM
Script        : http://www.sigarettaelettronicaforum.com/members/centrosvapo/10-regalo-tutte-italiano-flavor-liquido-dea.html/
Referrer      :
IP Address    : 157.55.39.10
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version :

 

[markoroots]

Would be really important for us forum to keep the latin characters because here in Italy really many words have these letters inside.

 

[Fillip H.]

What version of MySQL is this? I can't replicate any issues with the query in question locally.

 

[markoroots]

Fillip like I told you this server is using Mariadb not Mysql.
Who is using it says that is more better and in reality when it work is really more fast than Mysql.

 

[markoroots]

Now I have rebuild all the counter and deleted the caches of Vb and Dbseo.
I will let you know if others errors arrive.

 

[markoroots]

Now are arriving only errors about latin characters of the tags and the principal page of the blogs isn't reachable.