Question Cms disappeared - Please Help

[markoroots]

And also we have noted that each time we go to see in the "Notifications" the section "Quote" it slow down all the forum and it needed 20 second to load the page.

Then I have seen that each time I search a tag (not only with latin characters) it haven't in memory, generate a database error.
You can try here: Tag - Sigaretta Elettronica Forum

 

[markoroots]

Now the system is reading the latins symbols as you can see here: Test: Novita Perche

But this category (in the home page) that contain a latin character is not redirected in the right way

http://www.sigarettaelettronicaforum.com/ultime-novità.html

If I change the title removing the "à" it work.

For the rest the most of the errors that are arriving are generated from tags not found.

 

[markoroots]

Also I have seen that are arriving blog database errors like this:

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  : Thursday, May 19th 2016 @ 01:20:20 PM
Error Date    : Thursday, May 19th 2016 @ 01:20:20 PM
Script        : http://www.sigarettaelettronicaforum.com/members/fabiohd68/blog.html/
Referrer      :
IP Address    : 207.46.13.111
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version :

But if you delete the "/" sign at the end of the link, the link work.

http://www.sigarettaelettronicaforum.com/members/fabiohd68/blog.html

Is this Sigaretta Elettronica Forum


Instead with the final slash go in crash.

 

[markoroots]

Also the albums links are giving others errors like this:

Database error in vBulletin 2.0.32:

Invalid SQL:
SELECT albumid AS id FROM vb4_album WHERE userid = "8889"  AND title REGEXP "^(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*b[aÀÁÂÃÄÅàáâãäå]tt[eÈÉÊËèéêë]r[yŸÝýÿ](&[\#\da-z]*;|[^a-z\d])*[eÈÉÊËèéêë](&[\#\da-z]*;|[^a-z\d])*b[aÀÁÂÃÄÅàáâãäå]tt[eÈÉÊËèéêë]r[yŸÝýÿ](&[\#\da-z]*;|[^a-z\d])*b[oÒÓÔÕÖØòóôõöø]x(&[\#\da-z]*;|[^a-z\d])*(&[\#\da-z]*;|[^a-z\d])*$" ORDER BY LENGTH(userid = "8889"  AND title) LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 46' from regexp
Error Number  : 1139
Request Date  : Thursday, May 19th 2016 @ 02:53:47 PM
Error Date    : Thursday, May 19th 2016 @ 02:53:47 PM
Script        : http://www.sigarettaelettronicaforum.com/members/rafs/albums/battery-e-battery-box/2682-innokin-itaste-mvp-3-0-pro/
Referrer      :
IP Address    : 66.249.66.49
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version :

 

[markoroots]

Know also that now to stop these errors I had to disable again the members and the blogs urls of the Dbseo.

 

[Fillip H.]

Okay, fine, what version of MariaDB are you running?

 

[markoroots]

The Db use this version: 10.0.25-MariaDB-1~trusty

 

[Fillip H.]

Can you please try upgrading to MariaDB 10.1 and see if this resolves the issue?

 

[markoroots]

Yes Fillip.
I do this and let you know.

 

[markoroots]

Fillip H.
Fillip them told me:
Hallo,

I am in doubt that a update will help.

We never tested Keyhelp with MariaDB 10.1 so I cannot guarntee thta it will work

regards

 

[markoroots]

Think also if can be of help that the person that is using Mariadb many days ago told me this:
Converting from MySQL to MariaDB just works.
Once converted you can change table types etc.


Consider also that before the db was setted in utf8 and the tables Latin-Swedish
Now is all utf8
I don't know if maybe setting again those table in Latin-Swedish can help or not.

 

[markoroots]

Please look also here:

Database error in vBulletin 2.0.32:

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

MySQL Error   : Got error 'invalid UTF-8 string at offset 45' from regexp
Error Number  : 1139
Request Date  : Friday, May 20th 2016 @ 12:29:27 PM
Error Date    : Friday, May 20th 2016 @ 12:29:27 PM
Script        : http://www.sigarettaelettronicaforum.com/groups/amici-dell-emilia-romagna/members/
Referrer      : http://www.sigarettaelettronicaforum.com/groups/categories/svapo-in-italia/
IP Address    : 5.168.12.174
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version :

It says Database error in vBulletin 2.0.32
But I'm using the last version of vb.

 

[Fillip H.]

I'm not experiencing any issues running these queries locally on MariaDB 10.1 which is why I requested the update to see if it works for you

 

[markoroots]

Hi Fillip, please can you give a look to these 2 thread that are about this problem I think.
Can I switch to MariaDB with vb3.8? - vBulletin.org Forum
About Databases and other wondrous things (MariaDB) - vBulletin.org Forum

 

[markoroots]

Fillip H. Fillip the situation is still like this:


Have you read these threads?
I see 2 things there, one that they says that maybe Oracle isn't good, but I didn't understand good this.
And also that they convert the db in Aria to let it work.
Can you please try to check these threads so that maybe we can found a way to fix these issues?

 

[markoroots]

Also if it is useful and it could help you can set for a while your email address to receive these errors like this you can better see and monitor what is succeeding.

 

[Fillip H.]

Sorry, I'm confused. Have you upgraded to MariaDB 10.1 yet?

 

[markoroots]

Not still not. I was waiting your instructions.

 

[markoroots]

Ahh sorry I didn't understand good your previous post.
Ok I will ask to upgrade Mariadb.
I will let you know when ready.

 

[markoroots]

Fillip H.
Hi Fillip, Mariadb is been updated but nothing change.
The errors continue to arrive.
If you see it seems are all errors generated from a wring codify, and look that the problem is the codifying of the utf8.
Have you check those 2 threads the I send you in my last post?
It seems that the persons that are using it say that the db must be converted in "Aria", could be this the problem?