Advertisement:

Author Topic: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10  (Read 10144 times)

Offline adsl74

  • Semi-Newbie
  • *
  • Posts: 15
upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« on: March 20, 2013, 04:03:21 AM »
hi
 i have trubles, my hoster upgrade soft in server  "PHP 5.1 -> 5.4.10     and mysql 5.1.66 -> 5.6.10" and after this is upgrading sorting section of the forum is broken,

in admin panel sorting is good,  but in  main page sorting is broken.

type table engine smf_boards not changed  and set "MyISAM".

sorry for my english.

Offline Ricky.

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 4,057
    • Indian Linux Forums
Re: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« Reply #1 on: March 20, 2013, 04:49:34 AM »
What exactly you mean by problem in sorting ?
What issue you are facing in it ?

Offline adsl74

  • Semi-Newbie
  • *
  • Posts: 15
Re: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« Reply #2 on: March 20, 2013, 05:01:13 AM »
sequence section of the forum is not the same to the order section of the forum in the admin panel


Offline Ricky.

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 4,057
    • Indian Linux Forums
Re: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« Reply #3 on: March 20, 2013, 01:46:05 PM »
I believe more in seeing ..
Can mind sharing some screenshot ?

Offline adsl74

  • Semi-Newbie
  • *
  • Posts: 15
Re: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« Reply #4 on: March 20, 2013, 02:11:15 PM »
http://images.l-type.net/images/64822ad_screen.jpg [nofollow]   it is  sequence section in admin panel

http://images.l-type.net/images/89038board_page.jpg [nofollow]  this is sequence section in main page .

sorry i`am  must hide forum text but in text, all ok.

Offline Ricky.

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 4,057
    • Indian Linux Forums
Re: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« Reply #5 on: March 20, 2013, 03:13:30 PM »
Seriously, I can't make anything out of it, may you should go to language specific board.

Offline adsl74

  • Semi-Newbie
  • *
  • Posts: 15
Re: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« Reply #6 on: March 20, 2013, 03:19:09 PM »
sorry for my terrible english :(

close this topic if you can, please.

Offline Ricky.

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 4,057
    • Indian Linux Forums
Re: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« Reply #7 on: March 20, 2013, 04:41:29 PM »
May be someone can else understand and help you, I am not able to get what kind of sorting not working, and from your screenshot , I got more confused.

Offline lc62003

  • Jr. Member
  • **
  • Posts: 207
Re: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« Reply #8 on: March 20, 2013, 09:46:59 PM »
You said the engine was MyISAM.  However I have to wonder if this will help you:

http://www.simplemachines.org/community/index.php?topic=293441.msg1935333#msg1935333


Scroll down to the Intermediate Improvements section, number 1 (converting tables to Innodb). 

There is a board order fix for the conversion using this MySQL:

Code: [Select]
ALTER TABLE `smf_boards` ADD UNIQUE KEY (`id_board`), DROP PRIMARY KEY, ADD PRIMARY KEY ( `board_order`, `id_board` ), ENGINE=InnoDB;
That works if you do convert.  I converted, performed that task, and have no problems.  ;)

Offline butch2k

  • Full Member
  • ***
  • Posts: 416
  • Gender: Male
    • @butch2k on Twitter
    • Planète Roliste
Re: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« Reply #9 on: March 21, 2013, 04:06:52 AM »
If you did not export with MySQL engine settings precised for each table, MySQL 5.6 will recreate them using the InnoDB engine (1 file per table) which is the default engine in this version. The solution above will correct the sorting order issue.

Note that PHP 5.4 might cause some other issues as well.

Offline inter

  • Jr. Member
  • **
  • Posts: 290
  • Gender: Male
    • interlab on GitHub
Re: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« Reply #10 on: March 21, 2013, 05:23:38 AM »
I have the same problem
I think this topic should be moved to the forum errors and this error will face all who will have a new version of the database mysql 5.6
the error is in the wrong sort of categories
Thanks

You use this decision at own risk (possibly to eat more correct decision):
File:  ./Sources/Subs-BoardIndex.php
Line: 66
Find:

Code: [Select]
AND b.child_level BETWEEN ' . $boardIndexOptions['base_level'] . ' AND ' . ($boardIndexOptions['base_level'] + 1)),
Replace:
Code: [Select]
AND b.child_level BETWEEN ' . $boardIndexOptions['base_level'] . ' AND ' . ($boardIndexOptions['base_level'] + 1)) . ($boardIndexOptions['include_categories'] ? '
                ORDER BY c.cat_order ASC' : ''),


File:  ./Sources/Subs-MessageIndex.php
Line: 55
Find:

Code: [Select]
AND ', $where)),
Replace:
Code: [Select]
AND ', $where) . '
                ORDER BY c.cat_order ASC'),
« Last Edit: March 21, 2013, 06:14:51 AM by Inter »
Sorry for my English

Offline adsl74

  • Semi-Newbie
  • *
  • Posts: 15
Re: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« Reply #11 on: March 21, 2013, 05:51:55 AM »
oh !!  it is works really !

thank you very much! you make my day.

Offline Study Force

  • SMF Hero
  • ******
  • Posts: 3,585
    • StudyForcePS on Facebook
    • @studyforceps on Twitter
Re: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« Reply #12 on: July 18, 2013, 08:50:36 PM »
I have the same problem
I think this topic should be moved to the forum errors and this error will face all who will have a new version of the database mysql 5.6
the error is in the wrong sort of categories
Thanks

You use this decision at own risk (possibly to eat more correct decision):
File:  ./Sources/Subs-BoardIndex.php
Line: 66
Find:

Code: [Select]
AND b.child_level BETWEEN ' . $boardIndexOptions['base_level'] . ' AND ' . ($boardIndexOptions['base_level'] + 1)),
Replace:
Code: [Select]
AND b.child_level BETWEEN ' . $boardIndexOptions['base_level'] . ' AND ' . ($boardIndexOptions['base_level'] + 1)) . ($boardIndexOptions['include_categories'] ? '
                ORDER BY c.cat_order ASC' : ''),


File:  ./Sources/Subs-MessageIndex.php
Line: 55
Find:

Code: [Select]
AND ', $where)),
Replace:
Code: [Select]
AND ', $where) . '
                ORDER BY c.cat_order ASC'),

Solved my problem ;)

Offline tomreyn

  • Semi-Newbie
  • *
  • Posts: 44
Re: upgrade PHP 5.1 -> 5.4.10 and mysql 5.1.66 -> 5.6.10
« Reply #13 on: March 20, 2014, 02:45:36 PM »
And mine. This topic has been dormant for a year, I'm posting anyways since this should probably go into the next patch release.