Hi
I have had to do the same.

The 'best' way is to

1) Install the same version you have on the old host to the new host and then import the database.

2) Then upgrade the new host, which will then upgrade the database.

Technically the new version should update the database but if you are nervous or it doesn't work, do it in stages version 3 > 5. > 6.*

You will need php equal to or greater than 5.6 for b2evo 6.10.6 and above

If you have a conflict with the database version and b2evo version I have a list at http://rogerlovejoy.net/blog/b2evo/database-versions

And ensure you keep a copy of the originasl database :)

Have fun :)

@amoun wrote earlier:

Hi
I have had to do the same.
The 'best' way is to
1) Install the same version you have on the old host to the new host and then import the database.
2) Then upgrade the new host, which will then upgrade the database.
Technically the new version should update the database but if you are nervous or it doesn't work, do it in stages version 3 > 5. > 6.*
You will need php equal to or greater than 5.6 for b2evo 6.10.6 and above
If you have a conflict with the database version and b2evo version I have a list at http://rogerlovejoy.net/blog/b2evo/database-versions
And ensure you keep a copy of the originasl database :)
Have fun :)

Thanks for your advice. I did convert a few sites from 3 to 5 a few years back. That was working well. Problem right now is to "jump" from PHP5 to PHP5.6. and then to 7. I got the script admin to work, but not the front end, yet.

Enable php5.6 before 6.10.6 . . . . . is that working

While still on b2evo 5.12-stable I went from PHP 5 to 5.4. in the first step and the way posts are sorted is causing an error. Any idea how I can resolve this?

Additional information about this error:

MySQL error!

Expression #1 of ORDER BY clause is not in SELECT list, references column 'asian4y_b2e155.evo_items__item.post_datemodified' which is not in SELECT list; this is incompatible with DISTINCT(Errno=3065)

Your query: ItemList2::Query() Step 1: Get ID list

SELECT DISTINCT post_ID

  FROM evo_items__item

 INNER JOIN evo_postcats ON post_ID = postcat_post_ID

 INNER JOIN evo_categories ON postcat_cat_ID = cat_ID

 WHERE ( cat_blog_ID = 1 )

   AND (( post_ptyp_ID IS NULL

    OR post_ptyp_ID NOT IN (1000,1400,1500,1520,1530,1570,1600,3000,4000) ))

   AND ( (  ( post_status IN ( 'protected' ) )  ) )

 ORDER BY post_datemodified DESC, post_ID DESC

 LIMIT 5

1. Can you go back to php 5.12 and see if the posts sort themselves.

2. Otherwse check any changes in php that may effect the way DISTINCT works.

If no luck then the ORDER BY post_datemodified will need to be investigated as the error saysd it needs to be in the SELECT command, which it isn't.

I don't know enough about SQL to direct you, but I will look it up, but it will take a while, days maybe :(

Look at https://github.com/Piwigo/Piwigo/issues/376