Missing posts after changing Language file?

Started by SergeantAsh, August 26, 2010, 03:09:06 AM

Previous topic - Next topic
Print
Go Down Pages 1 2 3 All
User actions

SergeantAsh

#20
December 31, 2010, 05:27:47 AM
Quote from: LexArma on December 31, 2010, 02:19:14 AM
Any updates on this? Have you been able to sort things out? :)

No Lex unfortunately not - everything appears to look fine to Norv yet it doesn't to me and some of my members. Would it be worth me converting to UTF8, is that an advantage anyway?
Quote"Moderation has been called a virtue to limit the ambition of great men, and to console undistinguished people for their want of fortune and their lack of merit."

Aleksi "Lex" Kilpinen

#21
December 31, 2010, 05:31:29 AM
It's not really an advantage - more of a disadvantage on some perspectives, unless you really need support for utf-8 character sets.
You could ofcourse, make a duplicate install of your current forum - make sure to copy over the current database as well, and then play around with the copy - that you could safely convert as well if needed.

I would wager that this could possibly be because your posts and DB partly use UTF-8 already, but your forum tells the browsers it is in ISO and so the browsers fail to show the posts correctly - or something, I'm pretty much guessing here honestly.
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Aleksi "Lex" Kilpinen

#22
December 31, 2010, 05:32:59 AM
Actually - I just had a thought! How was your forum installed in the first place?
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

SergeantAsh

#23
December 31, 2010, 05:42:19 AM
Quote from: LexArma on December 31, 2010, 05:32:59 AM
Actually - I just had a thought! How was your forum installed in the first place?

I manually installed it but I started with 1.1 RC2 and upgraded to 2.0 RC3 - is it worth me altering the tables perhaps?
Quote"Moderation has been called a virtue to limit the ambition of great men, and to console undistinguished people for their want of fortune and their lack of merit."

Aleksi "Lex" Kilpinen

#24
December 31, 2010, 05:47:05 AM
Okay, if it was manually installed then my thought won't probably lead anywhere. I just thought, you could try (for laughs) to put your forum in maintanance mode for a while (just so that no one will cause further problems by mistake while testing), add the $db_character_set = 'utf8'; line to your settings.php and see if the nonfunctional posts now appear correctly or not.

I don't really know if this could do any good, but just a thought to further diagnose things.
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

SergeantAsh

#25
January 16, 2011, 12:32:43 PM
Quote from: LexArma on December 31, 2010, 05:47:05 AM
Okay, if it was manually installed then my thought won't probably lead anywhere. I just thought, you could try (for laughs) to put your forum in maintanance mode for a while (just so that no one will cause further problems by mistake while testing), add the $db_character_set = 'utf8'; line to your settings.php and see if the nonfunctional posts now appear correctly or not.

I don't really know if this could do any good, but just a thought to further diagnose things.

Very sorry for the late reply - I only just returned from holiday.

I have just tried this and miraculously EVERYTHING IS NOW WORKING as it should and symbols are appearing correctly. Should I leave the line in there or remove and await your next suggestion to permanently correct this?

Many thanks so far!
Quote"Moderation has been called a virtue to limit the ambition of great men, and to console undistinguished people for their want of fortune and their lack of merit."

Aleksi "Lex" Kilpinen

#26
January 16, 2011, 12:43:53 PM
Just leave the line there, but remember that you should now on use UTF8 language packs if not already :)
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

SergeantAsh

#27
January 16, 2011, 12:59:57 PM
Quote from: LexArma on January 16, 2011, 12:43:53 PM
Just leave the line there, but remember that you should now on use UTF8 language packs if not already :)

Thanks Lex, I'd prefer a more permanent fix though - would it be worth proceeding with the DB conversion to UTF8 via the admin panel?
Quote"Moderation has been called a virtue to limit the ambition of great men, and to console undistinguished people for their want of fortune and their lack of merit."

Aleksi "Lex" Kilpinen

#28
January 16, 2011, 01:07:27 PM
Quote from: SergeantAsh on January 16, 2011, 12:59:57 PM
Quote from: LexArma on January 16, 2011, 12:43:53 PM
Just leave the line there, but remember that you should now on use UTF8 language packs if not already :)

Thanks Lex, I'd prefer a more permanent fix though - would it be worth proceeding with the DB conversion to UTF8 via the admin panel?
That is a permanent fix, and if you check, you will probably notice that with the line in there you don't have the option to do the DB conversion anymore, as if everything is working correctly with that line in settings.php - you don't need (really shouldn't actually) do the conversion anymore.
If you would convert a virgin install to UTF8, it would convert the DB tables, their contents, and add that line to settings.php :)
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

SergeantAsh

#29
January 16, 2011, 01:09:08 PM
Ok fair enough, thanks very much for your help! I hope that future versions look out perhaps for this oddity?
Quote"Moderation has been called a virtue to limit the ambition of great men, and to console undistinguished people for their want of fortune and their lack of merit."

SergeantAsh

#30
February 02, 2011, 01:24:46 PM
Bit of an update, having inserted this line into my settings.php, my members are complaining that they're once again no longer able to see the pound (GBP £) symbol, I've got a link to their thread that I'll PM to the SMF experts that responded above - please ask if you'd also like a copy of the thread.
Quote"Moderation has been called a virtue to limit the ambition of great men, and to console undistinguished people for their want of fortune and their lack of merit."

Aleksi "Lex" Kilpinen

#31
February 02, 2011, 03:07:38 PM
You are probably still using an ISO language pack, since your source indicates var smf_charset = "ISO-8859-1";
Perhaps, if you uploaded an UTF-8 language pack, and switched to use that, it would work out OK - I'm not really an expert on different charsets and their differences though, so I'm not completely sure about this. You shouldn't lose anything if you try though ;)
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Illori

#32
February 02, 2011, 03:11:23 PM
if you can find the post in your database you can check to make sure it is showing up correctly there and not corrupted in some way. I am not an expert on this step though.

SergeantAsh

#33
February 05, 2011, 12:27:15 PM
Thanks guys, I have changed my language pack to a UTF8 version and it now appears to be working fine - could you take a look at the page PM'd to you to see if it looks right for you too?
Quote"Moderation has been called a virtue to limit the ambition of great men, and to console undistinguished people for their want of fortune and their lack of merit."

Aleksi "Lex" Kilpinen

#34
February 05, 2011, 12:29:35 PM
msg523052 Seems fine :) So I guess we solved it ;)
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

SergeantAsh

#35
February 06, 2011, 03:46:09 PM
All looks good to me, thanks guys, good work!!
Quote"Moderation has been called a virtue to limit the ambition of great men, and to console undistinguished people for their want of fortune and their lack of merit."

SergeantAsh

#36
February 19, 2011, 02:08:22 PM
Guys...more problems - since making these changes things have gone from bad to worse - modifications aren't working because they don't support UTF8, login cookie problems have occurred, and on top of that I'm getting tens of thousands of errors being logged in my logs...

Mainly this one...

--------------------

Database Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

SELECT passwd, id_member, id_group, lngfile, is_activated, email_address, additional_groups, member_name, password_salt,
openid_uri, passwd_flood
FROM cc_smf_members
WHERE member_name = 'Bad Kidâ?¢'
LIMIT 1

--------------------

How can I properly migrate to UTF8 or is there a better alternative? Does RC4 resolve any of this?
Quote"Moderation has been called a virtue to limit the ambition of great men, and to console undistinguished people for their want of fortune and their lack of merit."

Arantor

#37
February 19, 2011, 02:17:44 PM
QuotePerhaps, if you uploaded an UTF-8 language pack, and switched to use that, it would work out OK - I'm not really an expert on different charsets and their differences though

No it wouldn't.

The proper way to migrate to UTF-8 is to use Admin > Maintenance > Database > Convert to UTF-8

Aleksi "Lex" Kilpinen

#38
February 19, 2011, 02:21:24 PM
I know that, but was thinkinng that these problems came to be by an upgrade losing the already existing UTF8 setup, since that happened to many others, and then doing the conversion again would not have probably been a good idea.
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Arantor

#39
February 19, 2011, 02:30:28 PM
From what I've seen the majority of issues seem to be because people upload UTF-8 language packs and don't actually convert the forum at the same time.
Print
Go Up Pages 1 2 3 All
User actions
Advertisement: