Advertisement:

Author Topic: date display wrong - SMF 2.0.6 mysql 5.6.11  (Read 11221 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: 68,041
    • Arantor 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?
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.

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: 68,041
    • Arantor 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 ;)
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.

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: 68,041
    • Arantor 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?
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 68,041
    • Arantor 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.
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 68,041
    • Arantor 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.
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.