migration with sql
By verwaerde on Monday, 31 August 2015
Posted in Installation Issues
Likes 0
Views 867
Votes 0
hello,
I'm developping a new site on my localhost. I've integrated EasyBlog latest version. As the live site is running a old version of EsayBlog (3.x) I've taken the data from the old database and inserted in the new one thanks to SQL queries. Everything is ok as for the tables content, mainly categories and posts, but I cannot get the posts to be displayed because their category is empty. BUT the category_id fiels is correct and the category ids are ok too.
So what else is to be done ?
thanks for help
best regards to you
If you migrated everything completely in your new site, perhaps you can try run this maintenance script from backend > Easyblog > maintenance > database > click Run

After run completely then go back to backend > Easyblog > maintenance > script > select all > click execute script button

If still doesn't, perhaps you try upload your current local site to live site so we can directly access and check on this issue.
Arlex Wong
·
Wednesday, 02 September 2015 03:08
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Verwaerde,

I am really sorry for the delay of this reply as it is actually a public day off for us here. Ideally, your migration steps should be this:

1. Do not install EasyBlog 5 on your new site yet.
2. Export from the old database
3. Import into the new database
4. Install EasyBlog 5.
Mark
·
Tuesday, 01 September 2015 00:43
·
0 Likes
·
0 Votes
·
0 Comments
·
hello,
thanks for your reply, but proceeding like you suggested did not do anything.
If I write a new post it is displayed in the latest blogs module. But the old posts imported in the "easyblog_post" table do not show up. Although all the table fields are filled like they should.
If I add a new post directly in the "easyblog_post" table, it does not work either.
This behaviour looks kinda strange for me.
I guess you can help.
thanks
regards
verwaerde
·
Wednesday, 02 September 2015 02:45
·
0 Likes
·
0 Votes
·
0 Comments
·
Great, that did it !!
Thanks a lot for your support, fast and efficient.
best regards
verwaerde
·
Wednesday, 02 September 2015 04:39
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

You are most welcome. Glad that your issue has been resolved now.
Ezrul Fazwan
·
Wednesday, 02 September 2015 12:44
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post