Question Cms disappeared - Please Help

[markoroots]

Also these pages aren't reachable:

http://www.sigarettaelettronicaforum.com/notizie-importanti/5122-sangalli-pd-modifica-limposta-del-consumo-nella-misura-pari-al-25%.html

http://www.sigarettaelettronicaforum.com/eliquids-e-mixing/8731-consiglio-liquido-60%vg-40%pg.html


http://www.sigarettaelettronicaforum.com/eliquids-e-mixing/8797-base-%-vg-pg-h2o.html


http://www.sigarettaelettronicaforum.com/eliquid-pronti-ed-aromi/8108-liquido-pronto-100%-vg.html

 

[Fillip H.]

Also is it impossible to let the system take and read this link for example:
View attachment 6879

It seems that this carachter "[" is not accepted.

That is not something we can control, sorry.

 

[markoroots]

I'm seeing the the links with specials symbols like "%" or "[" are not accepted as links.
But before they were working.
I have also to let you know that I have changed the codify of Italian Language in the "languages and phrases" option.
Before was ISOand I don't remember what... and then I changed with utf8.
I made this just when I moved the site on the new server.

 

[markoroots]

400 Bad Request

 

[markoroots]

Here this link is readed.
On my site not, now...

 

[markoroots]

Also for example now is arrived another blog error:

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  : Saturday, May 14th 2016 @ 09:08:57 PM
Error Date    : Saturday, May 14th 2016 @ 09:08:57 PM
Script        : http://www.sigarettaelettronicaforum.com/members/forrest/blog.html/
Referrer      :
IP Address    : 40.77.167.23
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version :

But the right link for the blog of this user for example should be:

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

 

[markoroots]

I don't know if this can help but I had also to disable the cms friendly urls, because if I enable it the cms page isn't loaded, but I would like to re active it.

 

[Fillip H.]

Can you try changing the Non-Latin Characters setting to Replace Non-Latin Characters and see if that helps?

 

[markoroots]

Fillip now it look to go better.
I'm not receiving utf8 errors (I mean with symbols corrupted)
The only thing I'm seeing that each time I go on the blog of each user, this for example:
Sigaretta Elettronica Forum - Markvaping68 - Prodotti

Arrive me this error:

Database error in vBulletin 2.0.32:

Invalid SQL:
SELECT blogcategoryid AS id FROM vb4_blog_category WHERE userid IN(0,2474) 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,2474) AND title) LIMIT 1;

MySQL Error   : Got error 'invalid UTF-8 string at offset 45' from regexp
Error Number  : 1139
Request Date  : Saturday, May 14th 2016 @ 10:52:53 PM
Error Date    : Saturday, May 14th 2016 @ 10:52:53 PM
Script        : http://www.sigarettaelettronicaforum.com/blogs/markvaping68/a/
Referrer      :
IP Address    : 93.58.31.180
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version :

Edited

 

[markoroots]

I have also setted to replace latins characters like you say and now the link is commuted in this way, is not the same bit is working (is a serch of the word "comunità" is means community)

Risultati Ricerca - Sigaretta Elettronica Forum

 

[markoroots]

Is there the name of this user "mister.mai"
but if I try to go on him page:

http://www.sigarettaelettronicaforum.com/members/mister.mai.html

you will see that the system will redirect to:

http://www.sigarettaelettronicaforum.com/members/mister-mai.html

and the page not appear.

 

[Fillip H.]

I would strongly recommend adding the [user_id] parameter to your member page URLs, for this exact reason.

 

[markoroots]

It's seem that when you search a word in the tags that the system haven't in memory go in error.
For example I have tried to search this word that doesnt mean anything "pri"
vBulletin Database Error
And it go in error...

 

[markoroots]

I would strongly recommend adding the [user_id] parameter to your member page URLs, for this exact reason.

Ok I'm doing it.

 

[markoroots]

I have setted this option: members/[user_id]-[user_name]/

 

[markoroots]

Now all members urls are working. Thanks Fillip.

 

[markoroots]

The problem that I still see is that the plugin send me an error for each time a tag is searched but is not contained in the memory.
If you try to search a tag that is different of those words proposed, the site crash.

 

[Fillip H.]

What's the error message sent when you search for a nonexistant tag?

 

[markoroots]

I receive this message:

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ÌÍÎÏìíîï][aÀÁÂÃÄÅàáâãäå](&[\#\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 @ 12:55:30 AM
Error Date    : Sunday, May 15th 2016 @ 12:55:30 AM
Script        : http://www.sigarettaelettronicaforum.com/tags/pia.html
Referrer      :
IP Address    : 68.180.229.241
Username      : N/A
Classname     : DBSEO_Database_MySQLi
MySQL Version :

 

[markoroots]

This is my email folder this morning.
If you see the errors arrives at all the hours all the night, also where don't should be anyone.