Question Cms disappeared - Please Help

[markoroots]

Fillip H..
Hi Fillip see maybe this could be really important.
We have found this error:



Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /home/users/roots756tt/www/dbtech/dbseo/includes/class_db.php on line 865

 

[markoroots]

Fillip H.
Because quite all errors arrive are generated from this ip.
And if you see on the voice "Reffer" is there always nothing wrote:

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])*[cÇc]%C3%A8(&[\#\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  : Tuesday, May 24th 2016 @ 04:46:32 PM
Error Date    : Tuesday, May 24th 2016 @ 04:46:32 PM
Script        : http://www.sigarettaelettronicaforum.com/tags/c%C3%A8.html
Referrer      :
IP Address    : 66.249.66.49
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version :

 

[markoroots]

That ip it seems to be a crawl of google.

 

[markoroots]

Also the tags are working, but it generate a database error each time some one search a tag that is not found in memory.
If you go here and you try to write a strange word you will see the error generated: Tag - Sigaretta Elettronica Forum

 

[markoroots]

Fillip H. it look that these errors are generated from that ip I send you the crawl of google
and also the ip of the crawl of bing.
Now I have re-enabled all the friendly urls (adn looks are all working, less that problem of the tags don't founded and users albums not reachable) and generated again the sitemap with dbseo, so that maybe the plugin must send it to google and bing the correct urls.
True?
Because the internal links are all working.

 

[markoroots]

So are the boots that creates these errors.
How can I instructed them crawls to index the right urls?
Maybe sending again the sitemap from the webmaster tools of google and of bing?
If yes where is located the principal sitemap url?

 

[Fillip H.]

If you re-generate the sitemap in your DBSEO CP, that should notify Google and Bing of the new URLs. After that, all you have to do is wait for it to update the index

 

[markoroots]

Ok great Fillip
I'm rebuilding counters and sitemap.
So have you seen the problems on the tags and on the albums? Sigaretta Elettronica Forum - Gallery Home

Tag - Sigaretta Elettronica Forum

 

[markoroots]

Fillip I'm seeing that also some normal tags aren't found from the google crawl, look here: vBulletin Database Error

 

[Fillip H.]

I'm not seeing any problems with the normally generated tags on the /tags/ page.

 

[markoroots]

Fillip H. Fillip the problem is that if you try to search a different word, for example "pia" or what else you want.. it generated a database error,
in fact all the errors that are coming (tons) are generated from the crawlers that don't found the url of tags they have in memory.
This show me that each time some one search a tag that isn't present stored in the database the system crash and generate an error.

 

[Fillip H.]

I'm not able to see this in action at the moment as your site's DNS is unreachable.

 

[markoroots]

Fillip H.
Hi Fillip, yes furthermore the server was down. Now is again online.

 

[markoroots]

Fillip H. I have also seen that the utf8 for the tags isn't working.
In all the links now are shown also Latin characters but in the tags as you can see in the attach not.
So maybe because the tags are using the utf8 of the vb that is setting in a wrong way...
maybe because seen that the errors was coming from the utf8 I have try to make many changes in the utf8 section of Vb and Dbseo.
In the Dbseo it look you have fixed, but maybe the tags are managed from Vb that a wrong setting for the utf8.
Can you please check one moment that I continue to receive tons of errors?
Thanks in advance Fillip.

 

[markoroots]

In fact if I search this tag: "comunità" (community)
it give me this error:

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])*[cÇc][oÒÓÔÕÖØòóôõöø]m([uÙÚÛÜùúûüµ]|u|Æ|æ)[nÑñ][iÌÍÎÏìíîï]t%C3%A0(&[\#\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 : Thursday, May 26th 2016 @ 05:49:18 PM
Error Date : Thursday, May 26th 2016 @ 05:49:18 PM
Script : vBulletin Database Error
Referrer : Tag - Sigaretta Elettronica Forum
IP Address : 93.58.31.180
Username : N/A
Classname : DBSEO_Database_MySQLi
MySQL Version :

a copy here:

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])*[cÇc][oÒÓÔÕÖØòóôõöø]m([uÙÚÛÜùúûüµ]|u|Æ|æ)[nÑñ][iÌÍÎÏìíîï]t%C3%A0(&[\#\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  : Thursday, May 26th 2016 @ 05:49:18 PM
Error Date    : Thursday, May 26th 2016 @ 05:49:18 PM
Script        : http://www.sigarettaelettronicaforum.com/tags/comunit%C3%A0.html
Referrer      : http://www.sigarettaelettronicaforum.com/tags/
IP Address    : 93.58.31.180
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version :

 

[Fillip H.]

I'm currently overworked so I don't have much time to dedicate to this, please be patient as I have not forgotten about this issue. It's not easy to solve, thank you for your patience and understanding.

 

[markoroots]

It's ok Fillip no problem, I will wait.

 

[Fillip H.]

I've tested the exact link you posted: Tag - Sigaretta Elettronica Forum and I don't receive a DB error any more when accessing it. I didn't make any changes to the files or anything, but I can't replicate the issue now.

Perhaps it was a cache issue?

 

[markoroots]

Hi Fillip, not is not a cache issue.
So I explain you what I have understand in this days.
If you go here Tag - Sigaretta Elettronica Forum
The problem is that many tags aren't founded and make go in crash the site.
I thought were only the search of tags the sistem don't found in the memory that was giving errors, but in the end I have understand that also those that are in the memory generate an error.
Searching the tag "e-liquid" you can see what happen:
vBulletin Database Error


and if I search the tag for example "sarà" it make a strange error.
The site crash with a database error
The link of the tag in the bar upside is correct and it seems that keep the utf8 because is visualized in this way:

http://www.sigarettaelettronicaforum.com/tags/sarà

But if I copy the link and I try to past it here like text in the post, it write me the link in this other way:

http://www.sigarettaelettronicaforum.com/tags/sar%C3%A0.html

And also the error you can see when the page go in crash is this:

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])*[s][a]r%C3%A0(&[\#\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  : Tuesday, May 31st 2016 @ 11:41:21 AM
Error Date    : Tuesday, May 31st 2016 @ 11:41:21 AM
Script        : http://www.sigarettaelettronicaforum.com/tags/sar%C3%A0.html
Referrer      : http://www.sigarettaelettronicaforum.com/tags/
IP Address    : 93.58.31.180
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version :

look the link inside.


Then I have also noted that all the thread with this symbol "%" in the title, the link aren't reachable and if I try to send a post with this symbol the thread crash the system and the page is also unreachable.

 

[markoroots]

Edited