I cannot use Special Characters

[DadL]

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
File: /home/wwwbark/public_html/Sources/Subs-Members.php
Line: 899

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.4, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.

Question: How do I upgrade my database?

[Sarge]

Hello again DadL, long time no see! How have you been?

In SMF Admin > Forum Maintenance, do you have "Convert the database and data to UTF-8" or do you have "Convert HTML-entities to UTF-8 characters"?

Can you download Subs-Members.php from the server, copy the lines 890-899 and paste them here? If you're not sure where the lines are, attach the file to your reply.

[DadL]

^{My smile is like this ->} 

Im good Sarge, thanks for asking.

Yeah I have "Convert the database and data to UTF-8" or do you have "Convert HTML-entities to UTF-8 characters" in SMF admin.

Pls. see the attachment.

Thank you

[Sarge]

Yeah I have "Convert the database and data to UTF-8" or do you have "Convert HTML-entities to UTF-8 characters" in SMF admin.

Which one? You can have one or the other, but not both. For example:

[DadL]

^{Lol! Sorry Sarge}    

[Sarge]

Can you check the smf_members table in your forum database from phpMyAdmin and post the collations here?

[DadL]

Here...

[DadL]

Where are you my friend

[Sarge]

Sorry for the delay. Are you still experiencing the problem? If yes, try this:

1) Get a backup your forum database. Very important!

2) Delete global_character_set from the smf_settings table.

3) Go to SMF Admin > Forum Maintenance and run "Convert the database and data to UTF-8".

Let me know how it goes.

[DadL]

Hi Sarge,

Yeah, Im still experiencing the same problem.
I follwed everything you said,

Here's the error message:
Error

SQL query:

DELETE FROM `smf_settings` WHERE `variable` = 'global_character_set' LIMIT 1

MySQL said: Documentation
#1146 - Table 'unsername_gllr1.smf_settings' doesn't exist



I also went through the links you have posted in other topics
and see those screenshots,
mine is different

[Sarge]

Are you sure you selected the forum database first?

[DadL]

You're really a genius Sarge!   

Thanks for asking!

Now its working.

Thank you and God Bless.