| Author |
 Topic Search  Topic Options
|
iSec 
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Character encoding issue after upgrading to 10.11
Posted: 15 April 2012 at 7:37am |
|
I have applied the latest update to my forum but I'm having a weird issue, where non-latin characters are not displayed correctly. The charset is set to 'UTF-8' but it's still messed up. What am i missing?
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 4:49pm |
Are you using a custom header?
If so this maybe over riding the character encoding that you set in your forum.
|
|
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 5:08pm |
Bruce, no I don't use a custom header. Also, it seems to be affecting the forum_posts.asp page alone, the topic page titles are ok, if that makes any difference. Please take a look here if you get a chance,
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 5:14pm |
Could be a database issue.
Have you changed the collation in the database or restored the database from another server?
If the
collation has changed in the database the only fix maybe to roll back the database to before the upgrade and try again, but make sure that the database has the correct encoding (collation) before upgrading.
|
|
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 5:16pm |
No all I did was upload the new forum and went through the upgrade wizard to upgrade from 10.x... I still have the old version of the forum and it's not affected. Here it is. |
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 5:19pm |
|
Have you looked at the data directly in the database, has it changed in tblThread -> Message?
|
|
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 5:26pm |
I just looked, and they do seem to be the same in the db. Why is it affecting one forum version and not the other though? I have not made any changes to the database:
Also here is the current collation type:
Bruce, when you say roll back the database, does that mean use a backup copy? Or is there another way?
Edited by iSec - 15 April 2012 at 5:41pm
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 6:29pm |
Ok, this is weird... I fixed it by doing the following:
- Uploaded a fresh a copy of the forum
- Instead of going through the database wizard which automatically launches itself when attempting to access the newly uploaded forum copy, I copied the content of the 'database_settings.asp' file from the previous copy to the new copy, not just the database connection settings, but everything in that file. The issue is magically resolved!
I wonder why this happens, the database connection parameters were already there, but the issue doesn't go away until you have copied the content of the entire file from the previous copy. |
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
