Updating to 2.0.2 loses all posts text

[Migrated From Jforum.net]

I just updared to 2.0.2 from some very old release. I am no longer sure what the release was.

Anyway, the rc5 to 2.0 mysql sql did not run cleanly, so I know I was out of sync.

After some work, I am back to working, but previous posts show no text. In fact they show little of anything. I presume that this is because the post_text field from jforum_posts has since been moved into jforum_posts_text table.

Can you please confirm this? If so, can you possibly tell me what other terrible things I have likely screwed up in this update? Or was the post text move the biggest thing?

Thanks, tim.
[originally posted on jforum.net by time]

[Migrated From Jforum.net]

I quickly wrote a Java program to convert the db to move posts text and subjects to the new table, and now all appears to be back to normal.

I would still appreciate some confirmation that I have covered all the needed changes. I applied the "rc5 to 2.0" sql script as best as I could. I created any missing tables. And I copied the post text and subjects to the new table.

[originally posted on jforum.net by time]

[Migrated From Jforum.net]

RC5 already have the jforum_posts_text table. It was an update from RC4. As you can see at https://jforum-tools.dev.java.net/source/browse/jforum-tools/scripts/rc5/mysql_rc4_to_rc5.sql?rev=1.1&view=auto&content-type=text/vnd.viewcvs-markup, the migration script RC4 to RC5 does the migration of fields.

Rafael
[originally posted on jforum.net by Rafael Steil]