Smart Quotes

[iorkara]

I have noticed that my SMF does not support Smart Quotes. Is it possible to change this?

Thank you.

[Kindred]

Well, so called smart quotes are anything but...   They are the most annoying thing that microsquish ever started using... And they look terrible.


That being said, convert to UTF8 and your site will handle them

[iorkara]

It is annoying. So many of my users have been having problems when they copy something from one site and try to paste into the forum. The text just get's cut off.

So, first off. I guess I need to backup. To do this. I goto: Maintenance >   Forum Maintenance... > Database.

Under Backup Database, I have all these checked: Save the table structure. Save the table data (the important stuff). Compress the file with gzip. Then click download.

Then, to switch to UTF8. I need to follow these steps: Maintenance > Convert the database and data to UTF-8. Then click Run Task Now. Then I should be all good?

[Chalky]

You should always use the backup tools provided by your host, if you have access to them.  They are more reliable than the one built into SMF  http://wiki.simplemachines.org/smf/Backup

[Illori]

http://wiki.simplemachines.org/smf/Why_do_I_have_partially_blank_or_missing_text_in_posts

[iorkara]

G'day all, thank you all for the great tips n' all.

I did ran into an error:

Database Error

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

[Ninja ZX-10RR]

You didn't mention if you actually ran upgrade.php though...

[Illori]

You didn't mention if you actually ran upgrade.php though...

there are no database changes since 2.0, there should be more to that error message to tell us what the issue is.

[Ninja ZX-10RR]

I know, but it's strange that SMF tells him to run it if there are no changes... Trying to run it though would not hurt, even if I don't think it would solve ita anyway...

[Kindred]

It's a misprint in the error message...   The database IS set to a previous version.
How erver, the end bit of the error message is incorrect in this case, since that previous version in the database does not actually matter, since there have been no database changes.

What matters...   And what has no been included in his post... Is the FIRST part of the error message that indicates what ACTUALLY errored...

[iorkara]

G'day all,

Apologise for not including the first part. Here it is:

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'ifnull'
File: forum/Sources/Subs-Portal.php
Line: 1251

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

[Kindred]

ah well...   that is much clearer now...    the problem is exactly what it says...   your database has apparently been created with different collations.