Advertisement:
« previous next »
Pages: [1] 2  All   Go Down

Author Topic: How do I prevent characters from becoming "?" forever?  (Read 6309 times)

Offline stylusss

  • Jr. Member
  • **
  • Posts: 337
How do I prevent characters from becoming "?" forever?
« on: August 15, 2012, 10:45:17 PM »
Certain characters never get translated properly, how do I prevent this from happening ever again?

I use English-utf8.

Please help me out, this has been bothering so much every since I started my forum years ago.
Logged
For top-notch server quality and expertise, visit CoreISP.net

Offline K@

  • Lead Support Specialist
  • SMF Master
  • *
  • Posts: 39,475
  • Gender: Male
  • Nothing (Or nothing you can see)
Re: How do I prevent characters from becoming "?" forever?
« Reply #1 on: August 16, 2012, 06:12:57 AM »
You use the utf-8 language files. But, did you actually convert the database to use that?
Logged

Offline ziycon

  • Support Specialist
  • SMF Hero
  • *
  • Posts: 1,873
  • Gender: Male
Re: How do I prevent characters from becoming "?" forever?
« Reply #2 on: August 16, 2012, 07:32:58 AM »
Make sure that your database is setup with the proper character encoding. Go into phpmyadmin and on the first page it should say 'Server charset:' next go into the database your using for SMF and click the Operations tab and look for 'Collation'. If you could post the two values we can take it from there.
Logged
Please don't PM me for support unless asked as they'll be ignored.
If you've removed the SMF copyright you won't get support.

ign.ie | SQLFace | APRAI | war.ie

Offline K@

  • Lead Support Specialist
  • SMF Master
  • *
  • Posts: 39,475
  • Gender: Male
  • Nothing (Or nothing you can see)
Re: How do I prevent characters from becoming "?" forever?
« Reply #3 on: August 16, 2012, 08:26:44 AM »
Good shout, Ziycon! I should've added that bit. :)
Logged

Offline stylusss

  • Jr. Member
  • **
  • Posts: 337
Re: How do I prevent characters from becoming "?" forever?
« Reply #4 on: August 16, 2012, 12:00:54 PM »
Quote from: ziycon on August 16, 2012, 07:32:58 AM
Make sure that your database is setup with the proper character encoding. Go into phpmyadmin and on the first page it should say 'Server charset:' next go into the database your using for SMF and click the Operations tab and look for 'Collation'. If you could post the two values we can take it from there.

It says Latin1_swedish_ci...

Also, when I go to convert the database using the forum maintenance, I get the following error:

Database Error: Column 'title' cannot be part of FULLTEXT index
File: /home/.../public_html/Sources/Admin.php
Line: 1343

and the line that corresponds to this is:

Code: [Select]
ALTER TABLE $table_info[Name]" . substr($updates_blob, 0, -1), __FILE__, __LINE__);
« Last Edit: September 23, 2012, 02:29:24 PM by stylusss »
Logged
For top-notch server quality and expertise, visit CoreISP.net

Offline stylusss

  • Jr. Member
  • **
  • Posts: 337
Re: How do I prevent characters from becoming "?" forever?
« Reply #5 on: August 18, 2012, 03:06:10 PM »
Someone please assist me :(

When I use the character β, I get ?...
Logged
For top-notch server quality and expertise, visit CoreISP.net

Offline K@

  • Lead Support Specialist
  • SMF Master
  • *
  • Posts: 39,475
  • Gender: Male
  • Nothing (Or nothing you can see)
Re: How do I prevent characters from becoming "?" forever?
« Reply #6 on: August 18, 2012, 03:59:44 PM »
OK... Your Admin.php file must be modded, because the standard file only has 999 lines.

Can you attach the file to your next post, so we can take a gander at it?
Logged

Offline stylusss

  • Jr. Member
  • **
  • Posts: 337
Re: How do I prevent characters from becoming "?" forever?
« Reply #7 on: August 18, 2012, 04:47:44 PM »
Thank you, here it is:

Logged
For top-notch server quality and expertise, visit CoreISP.net

Offline K@

  • Lead Support Specialist
  • SMF Master
  • *
  • Posts: 39,475
  • Gender: Male
  • Nothing (Or nothing you can see)
Re: How do I prevent characters from becoming "?" forever?
« Reply #8 on: August 18, 2012, 05:14:00 PM »
Sorry. I got confused, there. I was looking at the SMF v2 file. :(

I just checked your file and that part's the same as mine.

The file's quite a bit bigger, though. So, I'd assume you have a mod, or something, which has edited it.

What mods do you have?
Logged

Offline stylusss

  • Jr. Member
  • **
  • Posts: 337
Re: How do I prevent characters from becoming "?" forever?
« Reply #9 on: August 19, 2012, 09:35:58 AM »
Quote from: K@ on August 18, 2012, 05:14:00 PM
Sorry. I got confused, there. I was looking at the SMF v2 file. :(

I just checked your file and that part's the same as mine.

The file's quite a bit bigger, though. So, I'd assume you have a mod, or something, which has edited it.

What mods do you have?

Over 500 maybe, too many custom ones to list, but according to the error, a mod has somehow converted something to be in FULLTEXT, and the conversion only works with non-FULLTEXT columns. I was wondering if anyone knew a way around that.
Logged
For top-notch server quality and expertise, visit CoreISP.net

Offline K@

  • Lead Support Specialist
  • SMF Master
  • *
  • Posts: 39,475
  • Gender: Male
  • Nothing (Or nothing you can see)
Re: How do I prevent characters from becoming "?" forever?
« Reply #10 on: August 19, 2012, 05:02:28 PM »
Hmm... Gissa clue, then.

What mods do you have?
Logged

Offline stylusss

  • Jr. Member
  • **
  • Posts: 337
Re: How do I prevent characters from becoming "?" forever?
« Reply #11 on: August 19, 2012, 11:47:49 PM »
Quote from: K@ on August 19, 2012, 05:02:28 PM
Hmm... Gissa clue, then.

What mods do you have?

Too long to list, K@.

Perhaps I should start a new thread and let people know of the actual error.

Thanks.
Logged
For top-notch server quality and expertise, visit CoreISP.net

Offline K@

  • Lead Support Specialist
  • SMF Master
  • *
  • Posts: 39,475
  • Gender: Male
  • Nothing (Or nothing you can see)
Re: How do I prevent characters from becoming "?" forever?
« Reply #12 on: August 20, 2012, 07:05:08 AM »
OK...

This is a kinda guesstimate, here, after a suggestion by another member.

Admin > Search > Search method

Try setting that to "Full text index" and click the "Remove fulltext index" link thingy.

Then, try the conversion again and rebuild the index after the conversion. As we don't know which table has the fulltext thing hassling us, that's a bit of a wild guess. But, I assume you backed-up, before attempting the conversion... So, if this causes anything goes "PHUT!", we'll be OK. (I doubt it will, though)
Logged

Offline stylusss

  • Jr. Member
  • **
  • Posts: 337
Re: How do I prevent characters from becoming "?" forever?
« Reply #13 on: August 20, 2012, 12:01:18 PM »
Quote from: K@ on August 20, 2012, 07:05:08 AM
OK...

This is a kinda guesstimate, here, after a suggestion by another member.

Admin > Search > Search method

Try setting that to "Full text index" and click the "Remove fulltext index" link thingy.

Then, try the conversion again and rebuild the index after the conversion. As we don't know which table has the fulltext thing hassling us, that's a bit of a wild guess. But, I assume you backed-up, before attempting the conversion... So, if this causes anything goes "PHUT!", we'll be OK. (I doubt it will, though)

It's currently not set to full index, so I should set it to full index, and then remove it?
Logged
For top-notch server quality and expertise, visit CoreISP.net

Offline K@

  • Lead Support Specialist
  • SMF Master
  • *
  • Posts: 39,475
  • Gender: Male
  • Nothing (Or nothing you can see)
Re: How do I prevent characters from becoming "?" forever?
« Reply #14 on: August 20, 2012, 04:37:51 PM »
Kinda. What I'd try, is setting it to "No index" and save that. Then, set it to "Full index" and save that.
Logged

Offline stylusss

  • Jr. Member
  • **
  • Posts: 337
Re: How do I prevent characters from becoming "?" forever?
« Reply #15 on: August 20, 2012, 09:39:48 PM »
Quote from: K@ on August 20, 2012, 04:37:51 PM
Kinda. What I'd try, is setting it to "No index" and save that. Then, set it to "Full index" and save that.

It was already indexed. I deleted the index and tried the conversion again. It still didn't work. :(
Logged
For top-notch server quality and expertise, visit CoreISP.net

Offline K@

  • Lead Support Specialist
  • SMF Master
  • *
  • Posts: 39,475
  • Gender: Male
  • Nothing (Or nothing you can see)
Re: How do I prevent characters from becoming "?" forever?
« Reply #16 on: August 21, 2012, 07:36:06 AM »
I'm at a loss, then.

Let me point the rest of the team, to this, to see if anyone has any more ideas...
Logged

Offline emanuele

  • Developer
  • SMF Super Hero
  • *
  • Posts: 12,154
  • Gender: Male
  • Because Orange is Orange
Re: How do I prevent characters from becoming "?" forever?
« Reply #17 on: August 21, 2012, 08:02:02 AM »
Quote from: stylusss on August 16, 2012, 12:00:54 PM
It says Latin1_swedish_ci...
Please go to to admin > forum maintenance
What is the last entry of the section "Forum Maintenance - General Maintenance"?
Is it "Convert the database and data to UTF-8" or "Convert HTML-entities to UTF-8 characters"?
Logged

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

Offline K@

  • Lead Support Specialist
  • SMF Master
  • *
  • Posts: 39,475
  • Gender: Male
  • Nothing (Or nothing you can see)
Re: How do I prevent characters from becoming "?" forever?
« Reply #18 on: August 21, 2012, 08:06:09 AM »
Ta, Manny! :)
Logged

Offline stylusss

  • Jr. Member
  • **
  • Posts: 337
Re: How do I prevent characters from becoming "?" forever?
« Reply #19 on: August 21, 2012, 12:13:55 PM »
It is:

Quote
Convert the database and data to UTF-8

:S
Logged
For top-notch server quality and expertise, visit CoreISP.net
Pages: [1] 2  All   Go Up
« previous next »