Hey Tim,

To be frank with you, I never use this SP Upgrade extension for migration old data to new site before, but you can try this migration method and see how it goes?

https://stackideas.com/docs/easyblog/administrators/migrations/migrating-easyblog-to-different-site

What this method does is just export all of the Easyblog table from your old database then import into your new database, so all the blog id will remain the same.

Perhaps you can try setup one of the staging site so you can try migrate it from there and it will not affect on your live site.

Hey Tim,

To be frank with you, I never use this SP Upgrade extension for migration old data to new site before, but you can try this migration method and see how it goes?

https://stackideas.com/docs/easyblog/administrators/migrations/migrating-easyblog-to-different-site

What this method does is just export all of the Easyblog table from your old database then import into your new database, so all the blog id will remain the same.

Perhaps you can try setup one of the staging site so you can try migrate it from there and it will not affect on your live site.

There was no problem with the initial migration & SPUpgrade allows you to migrate select items from the table. The problem that occurred is how the new version of EasyBlog works with drafts I guess, because the drafts were given the ID number of the new Blog Post I did in the Old J1.5 version so it won't migrate over because that ID number is taken already.

Hey Tim,

Hm, I can't recall how older Easyblog version work in previously for the draft section.

But in Easyblog 5.x onward, when you start a new post before publish on the site, system will generate a new blog ID and revision id for this.

If the user decide to save it as draft, that blog ID will belong to this draft and the revision id as well.

If the user edit the existing draft and press save again, it will store a new revision ID.

What this revision id does is, it will record all the changes of this blog post you made, if the user want to revert back to previous changes, he can choose back to previous revision id.

Perhaps you can setup one of the staging site before you migrate anything, so we can better have a check on your old data?

OK, What you describe is reflected by how the old data was migrated into the new site. So I think I can remedy my issue if I delete (totally delete) the draft blog post that is occupying the ID# that I need for my migration. I am assuming that if I totally delete it (meaning I delete it and clear trash) that that ID# will be free once more.. Please let me know if I am correct on this. After I delete this, then migrate the added blog post from the old site will this work? The other option is to export the particular blog post data from the old site database and import into the new site database? This is the last issue I have to deal with before I make my new site live, so I am anxious to complete this task.

Hey Tim,

First I need to double confirm with you those draft blog post also listed on your backend > blog listing page?

If i recall correctly, it should store into this draft table -> #__easyblog_draft , can you check your old database and see whether you have this table?

If those draft blog post store in this #__easyblog_draft table, then it shouldn't affect with your current post table ID which is #__easyblog_post .

Perhaps you can provide us with your following details at http://stackideas.com/dashboard/site so I can better have a check your old data?
- Joomla backend access
- Database access

Hey Tim,

First I need to double confirm with you those draft blog post also listed on your backend > blog listing page?

The drafts are listed in the backend.

If i recall correctly, it should store into this draft table -> #__easyblog_draft , can you check your old database and see whether you have this table?

Yes, I have this table in the old database.

If those draft blog post store in this #__easyblog_draft table, then it shouldn't affect with your current post table ID which is #__easyblog_post .

I am not sure I totally understand, but since you understand better what you are trying to tell me, I think you will find what you want to know when you access the account.

Perhaps you can provide us with your following details at http://stackideas.com/dashboard/site so I can better have a check your old data?
- Joomla backend access
- Database access

I have added all the info for all access that I think you will need to my dashboard as you suggested.

I want to add that I noticed something in the new site regarding the drafts. Although drafts show up in my database I do not see the drafts listed if I go to write a post and want to see my drafts list.... It shows no drafts.

Thanks

Oh yes, I want to add that the new post on the old site that I am trying to bring to the new site has the ID# of 174 in the old database. If worse comes to worse, I can delete all drafts & revisions in the new site & just recreate them as needed as I will have to drafts from the old site as reference.

Thanks

It seems like Easyblog 3.x do not have a draft view from backend, but you can access it through your site frontend (have to login as this user Tim Firkowski), you can take a look of my screenshot here how to access draft listing page : http://take.ms/tv7uK

Oh yes, I want to add that the new post on the old site that I am trying to bring to the new site has the ID# of 174 in the old database. If worse comes to worse, I can delete all drafts & revisions in the new site & just recreate them as needed as I will have to drafts from the old site as reference.

Hm, I would suggest that if you would like to add new blog post from your old site, you shouldn't do that migration first because in Easyblog 5.x structure is totally different.

This is what my suggestion :

1. you can create all the new blog post from your old site first
2. If you already migrated those old data into your new site, i would suggested that uninstall Easyblog from your new site and remove all the #__easyblog_xx table from your new database.
3. Export all the #__easyblog_xx table to .sql dump file from your old database
4. Import that .sql dump file into your new database
5. Make sure all the table prefix match with your new database table prefix
6. Once import completed, then only install Easyblog latest version, so it will perform all the maintenance script during installation.

Okay, i have another question, may i know those draft post you would like to publish on the site? Because if I recall correctly, for those draft post will not bring over to Easyblog 5.x.

Ok, I think that is all too complex a process to move over just the one blog post that I had added to the old site. I think I will just rewrite the added blog post from the old site into the new site. As far as the drafts go, I will just write new ones in the new site as I am ready. Mark has also done some Mods for me & I don't want to go through making all those changes again.... Reference: https://stackideas.com/forums/easyblog-issues-after-migration-to-j3-x-site

Okay, i have another question, may i know those draft post you would like to publish on the site? Because if I recall correctly, for those draft post will not bring over to Easyblog 5.x.

The drafts did transfer over to Easyblog 5 when I did the migration, but you can not see them from the admin backend. They only show up in the SQL table & they show up in the easyblog_post table.

Hey there,

I am really sorry for the delay of this reply as it is a weekend for us here.

I believe Mark what he did for you in previous ticket is just added those custom css in this file -> JoomlaFolder/templates/rt_juxta/css/joomla.css , what you need to do is backup this file so you can apply back this file after you re-do the migration later.

The drafts did transfer over to Easyblog 5 when I did the migration, but you can not see them from the admin backend. They only show up in the SQL table & they show up in the easyblog_post table.

It seems like we didn't cater this for draft from the 3.x Easyblog version, if you would like to access those old draft post from your new site, i can update those 41 draft post to published, so you can see those post on the blog listing page from backend.

I have completed deleting the "old" drafts from the database and will start from scratch on those when needed. I recreated the one post I had made on the old site & everything is find in that area.

Thanks for the help

You are most welcome. Glad to hear that your issue has been resolved now.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.