db charset problem unstable reads from the DB

This is an open forum for any mojoPortal topics that don't fall into the other categories.

This thread is closed to new posts. You must sign in to post in the forums.
12/8/2011 5:15:51 AM
Gravatar
Total Posts 87

db charset problem unstable reads from the DB

Hi,

Have strange problem, today my site started to show ???? (instead of ciryllic) in arbitrary places - as i can see there is some charset problem. But strange is that question marks appear on diffeerent parts of the site, on each page refresh some modules can show correctly some modules will show question marks. Looks like at some random time read to DB returns incorrectly encoded data. 

I use mojo version 2.3.7.0 MySQL. Everything worked fine untill today. Even more strange thing - i have one other instance of mojoportal on same provider and as i see  - on same shared serever, they use same localhost mysql DB - and it works correclty.

Any ideas what to check?

12/8/2011 5:20:49 AM
Gravatar
Total Posts 87

Re: db charset problem unstable reads from the DB

Hi again,

while writing this question i came up with idea to change webconfig to force websites recompilation, and it seem to help... still very strange and if someone have explanation to this please share, may be some configuration problem? or my provider has some strange settings on the server?.

At the same time provider says that they restarted Mysql server. so i do not know what solved the issue....

Regards,

Victor

12/8/2011 5:41:03 AM
Gravatar
Total Posts 18439

Re: db charset problem unstable reads from the DB

Hi,

I have no idea why it would change if it was working correctly before, but I would make sure your conneciton string has:

Charset=utf8;

in it.

Hope that helps,

Joe

12/21/2011 5:30:14 AM
Gravatar
Total Posts 87

Re: db charset problem unstable reads from the DB

Jus to update the status of this issue, it come out that it is some technical problems on hosting server's disk subsystem, some disk operations worked incorrectly in some "read only" mode. Do not know what they mean by saing me this. But as short quick solution refreshing web.config helps for a while then whole server fall (MySql server first in this). Seem provider fixed something. So main idea it was not mojoportal problem.

Regards,

Victor

You must sign in to post in the forums. This thread is closed to new posts.