Kunena 6.3.0 released

The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3

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

More
13 years 10 months ago #11 by JLW
Replied by JLW on topic Re: Post-Migration Issues: need to recalc hit-count and posts-count
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.

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #12 by JLW
Replied by JLW on topic Re: Post-Migration Issues: need to recalc hit-count and posts-count
I'm a novice at SQL but shouldn't that query have had some sort of update statement rather than insert?

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago - 13 years 10 months ago #13 by JLW
Replied by JLW on topic Re: Post-Migration Issues: need to recalc hit-count and posts-count
I have restored the db to the way it was before executing that query.

Here is the same view of the jos_fb_users table, but as it was *before* the query:
[img


Although we no longer see the duplicates that we saw after running that query, there are still problems:

The jos_comprofiler and jos_users tables are synched, with 1,567 records in each.

But the jos_fb_users table has 10,237 records, and sorting by userID shows that some users (including me, the super-admin) are in there three times: one time with the signature, one time with the karma, and one time with the correct number of posts! What do you make of this table:

[img


What sort of query can clean this up?



[BTW, editing the signature in the front end causes all three records to have the signatures modified, so the three records then match in that field. That's how my records (#62) ended up with matching signatures. But the karma & posts data remain distinct.]
Attachments:
Last edit: 13 years 10 months ago by JLW.

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #14 by xillibit
Replied by xillibit on topic Re: Post-Migration Issues: need to recalc hit-count and posts-count
Your table are no indexes is the reason why you have multiples similar items.

So, you need to re-do migration process a new time because now the tables contains broken datas.

Can-you create a clean install of kunena and compare the table indexes of this clean install and from imported datas ?
I don't provide support by PM, because this can be useful for someone else.

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #15 by JLW
Replied by JLW on topic Re: Post-Migration Issues: need to recalc hit-count and posts-count
1.
What would happen if I manually (or via writing a php script) pluck the highest non-null karma value, the highest non-null post-count, and the longest signature string from each group of records with matching userid, and copy these into one of the records, and then delete the other two? Then there'd be no multiple records and no lost data. Would that clean up this problem?

2.
I'd like to not lose the new members and new posts made since the migration. Is there a way to save the new stuff and add it back after re-dong the migration?

3.
If I uninstall Kunena and drop all the fb tables, then do I install the fresh Kunena before or after using phpMyAdmn to bring in the old Kunena 1.0.5 files that are in my backup of the Joomla 1.0 site?

(And suppose I'd better inspect those old files first, just to ensure that they were not messed up from going from 1.0.0 to 1.0.5 already.)

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #16 by xillibit
Replied by xillibit on topic Re: Post-Migration Issues: need to recalc hit-count and posts-count
1°) I don't see the purpose of this, this thing is a bit uselless.
2°) 3°) The solution that i see, is to do a clean install of kunena in your local machine and import with phpmyadmin your existing datas (use the functions export/import). I hope that you not too much users, so maybe you can remove the duplicate items, then you can re-inject this on new fresh kunena install.
I don't provide support by PM, because this can be useful for someone else.

Please Log in or Create an account to join the conversation.

More
13 years 9 months ago #17 by JLW
Replied by JLW on topic Re: Post-Migration Issues: need to recalc hit-count and posts-count
xillibit wrote:

Your table are no indexes is the reason why you have multiples similar items. So, you need to re-do migration process a new time because now the tables contains broken datas.


So far, I've been holding off doing this because I'm not sure I've understood your English.

If I backup the current tables, then uninstall the component, then drop the forum's tables, then do a clean reinstall which will create new tables, how will that help?

I mean, if I then use phpMyAdmin to Import the old tables, won't that reintroduce the problem you are trying to describe for me? (That indices are missing.)

I'm not worried about the duplicates, because I can write a php program to go find them all, and combine the good fields from each of the duplicates into a single record. (One record has the right karma-data, another has the right posts-count, and a third has the right signature.)

But how do I add the indices you are referring to? How do I import the data from the bad tables without reimporting the index problem?

Thanks for your attention.

Please Log in or Create an account to join the conversation.

More
13 years 9 months ago - 13 years 9 months ago #18 by JLW
Replied by JLW on topic Re: Post-Migration Issues: need to recalc hit-count and posts-count

xillibit wrote: Your table are no indexes is the reason why you have multiples similar items. So, you need to re-do migration process a new time because now the tables contains broken datas.
Can-you create a clean install of kunena and compare the table indexes of this clean install and from imported datas ?


Thanks for your help. OK, I tried this, but ran into a problem:
  1. First I used phpMyAdmin to backup all the jos_fb_... tables.
  2. Then I uninstalled Kunena.
  3. Next I used phpMyAdmin to drop all the jos_fb_... tables one at a time.
  4. Then I did a fresh install of Kunena.
  5. Finally I used phpMyAdmin to restore the jos_fb_... tables. But I got the following error message:
Code:
SQL query: -- -- Dumping data for table `jos_fb_categories` -- INSERT INTO `jos_fb_categories` (`id`, `parent`, `name`, `cat_emoticon`, `locked`, `alert_admin`, `moderated`, `moderators`, `pub_access`, `pub_recurse`, `admin_access`, `admin_recurse`, `ordering`, `future2`, `published`, `checked_out`, `checked_out_time`, `review`, `hits`, `description`, `headerdesc`, `class_sfx`, `id_last_msg`, `numTopics`, `numPosts`, `time_last_msg`, `image`) VALUES (503, 0, 'The Accordion Community', 0, 0, 0, 1, NULL, 0, 0, 0, 0, 1, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, ' ', '', '', 3073, 870, 2108, 1278575793, ''), (8, 503, 'The Repertoire Room & Master Class', 0, 0, 0, 1, NULL, 0, 0, 0, 1, 5, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 'From master class to beginner class. Discussions of accordion repertoire; share sources of interesting and useful sheet music; also tell us about your own original accordion music! Discussions of playing techniques, practice routines, teaching methods, [...] MySQL said: Documentation #1054 - Unknown column 'image' in 'field list'

What to try next? Should I be using some of the phpMyAdmin Export options rather than accepting the defaults when saving the data? Should I edit the SQL dump in some way before restoring it?

Thanks for your attention.
Last edit: 13 years 9 months ago by JLW.

Please Log in or Create an account to join the conversation.

More
13 years 9 months ago - 13 years 9 months ago #19 by JLW
Replied by JLW on topic Re: Post-Migration Issues: need to recalc hit-count and posts-count
I used phpMyAdmin to add a text field named 'image' to the categories table, and then reran the import:

This time the import went further, but it gave the following error when it got to the announcement table:
Code:
Error SQL query: -- -- Dumping data for table `jos_fb_announcement` -- INSERT INTO `jos_fb_announcement` ( `id` , `title` , `sdescription` , `description` , `created` , `published` , `ordering` , `showdate` ) VALUES ( 1, 'New Feature: 1-click log-in via your Facebook or Twitter profiles', 'New members, you can now register at Accordionist.org with one click, using your Facebook profile or your Twitter profile. \r\n\r\nExisting members, you can link your Accordionist.org and Facebook (or Twitter) profiles, and they will stay synchronized. (If you change your mind later, you can unlink them.)', '', '2010-06-10 12:24:00', 1, 0, 1 ) ; MySQL said: Documentation #1062 - Duplicate entry '1' for key 'PRIMARY'

So I then deleted the records from that table and reran the import. This time I get:
Code:
Error SQL query: -- -- Dumping data for table `jos_fb_announcement` -- INSERT INTO `jos_fb_announcement` ( `id` , `title` , `sdescription` , `description` , `created` , `published` , `ordering` , `showdate` ) VALUES ( 1, 'New Feature: 1-click log-in via your Facebook or Twitter profiles', 'New members, you can now register at Accordionist.org with one click, using your Facebook profile or your Twitter profile. \r\n\r\nExisting members, you can link your Accordionist.org and Facebook (or Twitter) profiles, and they will stay synchronized. (If you change your mind later, you can unlink them.)', '', '2010-06-10 12:24:00', 1, 0, 1 ) ; MySQL said: Documentation #1062 - Duplicate entry '1' for key 'PRIMARY'

OK, so I'll plow forward through each of these tables, deleting their records and re-importing?
Last edit: 13 years 9 months ago by JLW.

Please Log in or Create an account to join the conversation.

More
13 years 9 months ago #20 by JLW
Replied by JLW on topic Re: Post-Migration Issues: need to recalc hit-count and posts-count
I deleted all the rows in all the jos_fb... tables. Now when I import the old data I get the following error:
Code:
Error SQL query: INSERT INTO `jos_fb_sessions` (`userid`, `allowed`, `lasttime`, `readtopics`, `currvisit`) VALUES (21369, '4,6,7,8,11,503', 1246385496, '1297', 1277903501), (21354, '4,6,7,8,11,503', 1277053057, '2995,3025,1619,3018', 1277644507), (1261, 'na', 1225126738, '469', 0), (97, 'na', 1209671510, '', 0), (312, 'na', 1190080496, '', 0), (88, 'na', 0, '2446', 1275603626), (82, 'na', 1179821415, '2', 0), (135, '4,6,7,8,11,503', 1276793962, '3012', 1277060056), (313, 'na', 1179857095, '', 0), (68, 'na', 1179853455, '189,206,315,308', 0), (133, 'na', 1180280791, '268', 0), (320, 'na', 1180253526, '326', 0), (295, 'na', 1237916651, '1081,1103', 0), (115, 'na', 1258026887, '1665', 0), (139, 'na', 1213773317, '582,645,338,206,14', 0), (316, 'na', 1180199280, '', 0), (90, '4,6,7,8,11,503', 0, '', 1278524892), (317, 'na', 1180221684, '326', 0), (323, 'na', 1180284088, '', 0), (134, '4,6,7,8,11,503', 1278363953, '', 1278537998), (329, 'na', 1180913620, '', 0), (263, 'na', 1268913286, '2368', 0), (333, '[...] MySQL said: Documentation #1062 - Duplicate entry '5044' for key 'PRIMARY'

I'm sort of poking around in the dark here, but it appears that I have to massage the contents of the old tables first. What do I need to do to them? Sort each by primary key and ensure no duplicates? If so, is there a easy SQL statement I can make that would do this?

Thanks for your attention.

Please Log in or Create an account to join the conversation.

Time to create page: 0.584 seconds