Question Error Migrating phpbb3

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:

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

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!

[th]Kunena config settings:[/th]

board_title
board_offline	0
board_ofset	0.00
offline_message	<h2>The Forum is currently offline for maintenance.</h2> <div>Check back soon!</div>
enablerss	1
enablepdf	1
threads_per_page	25
messages_per_page	10
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
jmambot	0
disemoticons	0
template	default
showannouncement	1
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	255
regonly	0
changename	0
pubwrite	0
floodprotection	15
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatar	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	10
allowimageupload	0
allowimageregupload	1
imageheight	800
imagewidth	800
imagesize	150
allowfileupload	0
allowfileregupload	1
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	262
showranking	1
rankimages	1
avatar_src	fb
fb_profile	fb
pm_component	no
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_username	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
rules_infb	1
rules_cid	1
help_infb	1
help_cid	1
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
fbsessiontimeout	3600
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
fbdefaultpage	categories
default_sort	asc
alphauserpointsnumchars	0
sef	1
sefcats	0
sefutf8	0
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	ago
post_dateformat_hover	datetime
hide_ip	1
js_actstr_integration	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
integration_access	auto
integration_login	auto
integration_avatar	auto
integration_profile	auto
integration_private	auto
integration_activity	auto
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
onlineusers	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
activity_limit	0
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	0
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	1
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
email_visible_address
captcha_post_limit	0
recaptcha_publickey
recaptcha_privatekey
recaptcha_theme	white

Third-party components: None

Third-party SEF components: None

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

Modules: Kunena Stats 1.7.0

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?

My apologies. Tried to be as complete as possible, but there is always something extra. Forum is phpbb 3.0.9.

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

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_

Hmm.. Check if you have the table ain_kunenaimporter_users in your Joomla database.