Question Post-Migration Issues: need to recalc hit-count and posts-count

xillibit wrote:

What is the exact version of fireboard from which you had migrated ?

I think I was at 1.0.0 beta.
(Disregard the version info from my original post. 0.5b -> 0.6+ ->... was my version of uddeIM, not simpleboard/fireboard.)

I used the com_converter to save the config in the database.

I downloaded and upgraded to 1.0.5.

(At some point _sb_ became _fb_; both sets of tables were still in the database; but that may have been an artifact from some previous migration. The still earlier phpBB tables were also there, but with different prefix.)

Then I tried using the migrator, which didn't work for me:

I had to manually change the prefix of all the tables from content_ to jos_ to get around a bug in the Joomla 1.5.17 install script that chokes if the table prefix is the same as the name of a component. (It queries for jos_jos_... tables instead of jos_content_... tables)

Even after renaming all the still-needed tables, migrator didn't work for some of my components. I ended up using mtwMigrator, which mostly did.

I was upgrading and migrating so many components, trying different things, that I'm now a bit fuzzy on what happened in the end. I think mtwMgrator worked on everything except kunena at first. Two possibilities about what happened next:

I think I ended up installing kunena on the new site, importing the fb tables directly to the new site, and then ran the mtwMigrator again selecting *only* kunena. Or perhaps the first Kunena install was on the old site and then I moved the tables and reran mtwMigrator.

Anyway, the result is close to whole...

For kunena the upgrade process is the following :

Copy the fireboard 1.0.5 tables jos_fb_* on your new site with joomla 1.5.x , then you have just to install kunena 1.5.11, the upgrade processus will be done automatically.

xillibit wrote:

Try this query and before don't forget to backup your database :

Code:

INSERT INTO jos_fb_users (userid, posts) SELECT m.userid, COUNT(m.userid) FROM jos_fb_messages AS m INNER JOIN jos_fb_users AS u ON u.userid = m.userid WHERE m.hold=0 and m.catid IN (SELECT id FROM jos_fb_categories WHERE published=1) GROUP BY m.userid ON DUPLICATE KEY UPDATE posts=VALUES(posts)

I backed up the db, then pasted the Query into phpMyAdmin. The result was strange:
Why only 642 rows?

So I went to see the result. See the attached image file. This is jos_fb_users sorted by number of posts. Notice that now each user is in there twice (and with different numbers of posts).

Also see the other attached file, which is the image of the forums tab of a member's CB profile in the front end. Notice how his many posts are all listed in the tab, but his number of posts in the header area is only 1.

The second image file is here:

xillibit wrote:

For kunena the upgrade process is the following :

Copy the fireboard 1.0.5 tables jos_fb_* on your new site with joomla 1.5.x , then you have just to install kunena 1.5.11, the upgrade processus will be done automatically.

Ah, that's was it! Thanks for refreshing my memory.

I'm a novice at SQL but shouldn't that query have had some sort of update statement rather than insert?