×
Kunena 5.2 Beta 1 Released (24 Sep 2020)

The Kunena team is thrilled to announce the first public beta release of Kunena 5.2, a native Joomla extension for Joomla 3.9. This is a development release and should be only be used for testing; this version is not recommended for live websites at this stage.

The purpose of this release is to encourage testing by downloading, installing and identifying any problems or shortcomings that people may discover. K 5.2.0 B1 is stable and we are aware that people will discover defects. We encourage you to use the forum to report defects, as soon as they are discovered, so that the development team can work through the problems before the release of K 5.1 as a stable product. Reporting defects does not mean that the problems can or will be fixed. The Kunena team is looking forward to hearing your feedback on how well we have achieved our design goals.

Question Error Migrating phpbb3

More
9 years 1 month ago #1 by DTP2
Error Migrating phpbb3 was created by DTP2
Before I start I see this in a red bar:

Error: Table 'gf.phpbb_acl_roles' doesn't exist SQL=SELECT u.user_id AS userid, ag.forum_id AS catid FROM phpbb_acl_roles AS ar INNER JOIN phpbb_acl_groups AS ag ON ar.role_id=ag.auth_role_id INNER JOIN phpbb_user_group AS ug ON ug.group_id=ag.group_id INNER JOIN phpbb_users AS u ON u.user_id=ug.user_id AND u.user_id > 0 AND u.user_type != 2 WHERE role_type='m_' LIMIT 0, 10000

After I click migrate everything looks to be fine until the migration of Import polls. Then I get this error in a white browser screen:

ERROR: KunenaImporterTablePolls::store failed - Duplicate entry '4806' for key 'PRIMARY' SQL=INSERT INTO `t2p7d_kunena_polls` (`id`,`title`,`threadid`,`polltimetolive`) VALUES ('4806','','4806','0000-00-00 00:00:00')

This is my configuration:

This message contains confidential information

Database collation check: The collation of your table fields are correct

Legacy mode: Disabled | Joomla! SEF: Enabled | Joomla! SEF rewrite: Disabled | FTP layer: Disabled |

This message contains confidential information
htaccess: Missing | PHP environment: Max execution time: 30 seconds | Max execution memory: 32M | Max file upload: 32M

This message contains confidential information

Joomla default template details : beez_20 | author: Angie Radtke | version: 1.7.0 | creationdate: 25 November 2009

Kunena default template details : Blue Eagle (default) | author: Kunena Team | version: 1.7.0 | creationdate: 2011-08-29

Kunena version detailled: Installed version: 1.7.0 | Build: 5135 | Version name: Tale | Kunena detailled configuration:

Warning: Spoiler!

Third-party components: None

Third-party SEF components: None

Plugins: System - Mootools Upgrade: Disabled | System - Mootools12: Disabled

Modules: Kunena Stats 1.7.0

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

More
9 years 1 month ago #2 by Matias
Replied by Matias on topic Re: Error Migrating phpbb3
phpBB version would be great addition, too. :)

Interesting that you don't have the table phpbb_acl_roles as I used latest vanilla phpBB3 version in my tests.

Can you ping me in Skype?

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

More
9 years 1 month ago #3 by DTP2
Replied by DTP2 on topic Re: Error Migrating phpbb3
My apologies. Tried to be as complete as possible, but there is always something extra. Forum is phpbb 3.0.9.

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

More
9 years 1 month ago - 9 years 1 month ago #4 by ron273
Replied by ron273 on topic Re: Error Migrating phpbb3
Matias,

Look at www.kunena.org/forum/191-kunena-migrator...=10&start=130#105834 for the answer to this problem. You hardcoded the default prefix phpbb_ into the component, but a lot of users use phpbb3_ or another prefix. This should be configurable in the component.

Also there are some other problems with the export_phpbb3.php file.

In line 383 and 384 of models/export_phpbb3.php you are using the joomla prefix #__ to point at a phpbb table. That seems incorrect. In my opinion it should be phpbb_ or even better a dynamic prefix, configurable in the component, as mentioned above.

Cheers,

Ronald
Last edit: 9 years 1 month ago by ron273.

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

More
8 years 4 months ago #5 by thomasjojo
Replied by thomasjojo on topic Error Migrating phpbb3
Hey
I see its 8 months, but I really can find how to import my users from phpbb to Kunena with the Kunenaimporter. everything else went good..

I get this message;


extuser: Invalid query:
TRUNCATE TABLE `#__kunenaimporter_users`
Table 'vmobikwm_autism.ain_kunenaimporter_users' doesn't exist SQL=TRUNCATE TABLE `ain_kunenaimporter_users`


So, do I have to change my joomla table names? to what ? my prefix is ain_ , the phpbb tables have prefix phpbb_

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

More
8 years 4 months ago #6 by Matias
Replied by Matias on topic Error Migrating phpbb3
Hmm.. Check if you have the table ain_kunenaimporter_users in your Joomla database.

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

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.106 seconds