Advertisement:

Author Topic: date display wrong - SMF 2.0.6 mysql 5.6.11  (Read 11858 times)

Offline Barlos

  • Semi-Newbie
  • *
  • Posts: 21
date display wrong - SMF 2.0.6 mysql 5.6.11
« on: November 14, 2013, 04:59:34 AM »
Hello,

I install SMF 2.0.6 on mysql 5.6.11. The date display � instead of ,.

SMF 2.0.6 with mysql 5.1 was ok, which was my previous environment.

I am running XAMPP 1.8.3 on a Win 7 PC.
Apache 2.4.4
MySQL 5.6.11
PHP 5.5.3

Please help.
« Last Edit: November 15, 2013, 04:22:54 AM by Barlos »

Offline Burke ♞ Knight

  • SMF Hero
  • ******
  • Posts: 3,534
Re: date display wrong - SMF 2.0.6 mysql 5.6.11
« Reply #1 on: November 14, 2013, 05:11:15 AM »
Maybe not a SMF bug, but a mysql 5.6.11 bug?

Offline emanuele

  • SMF Super Hero
  • *******
  • Posts: 14,156
  • Gender: Male
  • THERE'S JUST ME
Re: date display wrong - SMF 2.0.6 mysql 5.6.11
« Reply #2 on: November 14, 2013, 07:01:20 AM »
mmm... as far as I remember a comma is not a special char of any type.

Did you select UTF8 while installing?
Is this the only "artifact" or there are others?
Did you change the time format somewhere?
As a guest do you see it broken?


Take a peek at what I'm doing! ;D



Hai bisogno di supporto in Italiano?

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 Barlos

  • Semi-Newbie
  • *
  • Posts: 21
Re: date display wrong - SMF 2.0.6 mysql 5.6.11
« Reply #3 on: November 15, 2013, 04:24:44 AM »
Yes, I did select UTF-8 during the installing.

When creating a database, I selected <UTF8_bin> with phpmyadmin.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 69,458
    • StoryBB/StoryBB on GitHub
Re: date display wrong - SMF 2.0.6 mysql 5.6.11
« Reply #4 on: November 15, 2013, 07:45:21 AM »
What about the other questions asked?
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline emanuele

  • SMF Super Hero
  • *******
  • Posts: 14,156
  • Gender: Male
  • THERE'S JUST ME
Re: date display wrong - SMF 2.0.6 mysql 5.6.11
« Reply #5 on: November 15, 2013, 07:55:54 AM »
mmm... UTF8_bin? For the collation?
I think it is generally better to use general_ci to use with SMF (at least because I seem to remember bin is case sensitive, while SMF assumes mysql to be case insensitive, but I may be wrong).
Well, anyway that should be a detail (in theory and if the few I understand about collation and charset is not *so* wrong).

Yep, answer to the other questions was more important. :)


Take a peek at what I'm doing! ;D



Hai bisogno di supporto in Italiano?

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 Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 69,458
    • StoryBB/StoryBB on GitHub
Re: date display wrong - SMF 2.0.6 mysql 5.6.11
« Reply #6 on: November 15, 2013, 08:09:14 AM »
You're right about the collation, though AFAIR the installer should be indicating a _ci collation itself ;)
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Barlos

  • Semi-Newbie
  • *
  • Posts: 21
Re: date display wrong - SMF 2.0.6 mysql 5.6.11
« Reply #7 on: November 18, 2013, 02:28:40 AM »
I installed another SMF 2.0.6 on the same PC environment. The issue still persisted.

When I was creating a database with phpmyadmin, I use <collation> this time, which is the default value.

The default time format is : %B %d, %Y, %I:%M:%S %p

All posts' data now display like this :  ?��???11�?2013�?09:52:55 pm

I would suspect it more like a mysql's issue.

Best Regards

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 69,458
    • StoryBB/StoryBB on GitHub
Re: date display wrong - SMF 2.0.6 mysql 5.6.11
« Reply #8 on: December 25, 2013, 11:08:27 PM »
So, what language pack was being used?
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 69,458
    • StoryBB/StoryBB on GitHub
Re: date display wrong - SMF 2.0.6 mysql 5.6.11
« Reply #9 on: January 23, 2014, 04:49:26 PM »
Bump. If no response within 7 days I'll consider it closed.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 69,458
    • StoryBB/StoryBB on GitHub
Re: date display wrong - SMF 2.0.6 mysql 5.6.11
« Reply #10 on: January 31, 2014, 12:19:56 AM »
Closed.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.