Advertisement:

Author Topic: question mark appearing instead of commas and apostraphe  (Read 664 times)

Offline chelseaphil

  • Jr. Member
  • **
  • Posts: 176
question mark appearing instead of commas and apostraphe
« on: September 21, 2018, 04:26:23 AM »
About a week ago I noticed that commas, $ sign, %, and apostrophes were being replaced with a ? mark. It is on all browsers. Anyone any idea how to fix it? Thanks Using 1.1.21

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 8,248
  • 'Tis the gift to be simple (duh)
Re: question mark appearing instead of commas and apostraphe
« Reply #1 on: September 21, 2018, 12:08:50 PM »

- Convert your database to utf-8.

- Upgrade to current version.


Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,341
  • Gender: Male
    • Macedonian electronics forum
Re: question mark appearing instead of commas and apostraphe
« Reply #2 on: September 21, 2018, 11:38:49 PM »
There is no UTF-8 converter tool for 1.1.x as far as I'm aware. Yes, you could do it manually though.

And yes, definitely upgrade. Support for the 1.1.x branch has been suspended, it's been deemed EOL (End Of Life).
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 8,248
  • 'Tis the gift to be simple (duh)
Re: question mark appearing instead of commas and apostraphe
« Reply #3 on: September 22, 2018, 12:37:06 AM »
Don't have a 1.1 install, but you can change collation in phpmyadmin (one table at a time), didn't work last time I tried it.  Best bet is to upgrade, then run 2.0 utf8 conversion.


Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,341
  • Gender: Male
    • Macedonian electronics forum
Re: question mark appearing instead of commas and apostraphe
« Reply #4 on: September 22, 2018, 12:39:49 AM »
Well, that's what I meant when writing "manually" ;).
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Offline chelseaphil

  • Jr. Member
  • **
  • Posts: 176
Re: question mark appearing instead of commas and apostraphe
« Reply #5 on: September 22, 2018, 03:07:08 AM »
I have been intending upgrading for sometime. But it is a big forum and popular with over a million page views per month. So would need closing for 24hours. Seems that is the way to go. Thanks folks.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,098
  • Gender: Male
    • Kindred-999 on GitHub
Re: question mark appearing instead of commas and apostraphe
« Reply #6 on: September 22, 2018, 09:06:04 AM »
why 24 hours?

The only time it took me that long to upgrade was on a site that had well over 2 million posts
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,341
  • Gender: Male
    • Macedonian electronics forum
Re: question mark appearing instead of commas and apostraphe
« Reply #7 on: September 23, 2018, 07:27:22 PM »
@chelseaphil: If you suspect there will be problems during the upgrade procedure, you can do the upgrade in a separate subdirectory or a separate subdomain linked to a directory in your webspace and try to do the upgrade from there ;). If everything goes as expected, great, you can apply the same to your main forum ;). If not, you can always ask here for help and get everything sorted until you get the upgrade procedure just right and apply that on your production forum ;).
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."