Kunena 7.0.4 Released

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

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

More
15 years 9 months ago - 15 years 9 months ago #51750 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: 15 years 9 months ago by JLW.

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

More
15 years 9 months ago #51757 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.

More
15 years 9 months ago #52189 by Matias
Replied by Matias on topic Re: Post-Migration Issues: need to recalc hit-count and posts-count
Use INSERT ... ON DUPLICATE KEY UPDATE Syntax:

dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

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

Time to create page: 0.238 seconds