[@jbuesking Participant 10 years, 7 months ago]

Apparently having a few broken attachments lingering from a phpbb3 to Kunena migration several years ago is what is giving me a problem now migrating attachments to bbPress.

The error I’m seeing in my logs is:

[15-May-2014 22:32:08 UTC] PHP Warning:  copy(http://www.mydomain.com/media/kunena/attachments/phpbb3/Cabs%201.jpg) [<a href='function.copy'>function.copy</a>]: failed to open stream: HTTP request failed! HTTP/1.0 404 Not Found
 in /home/username/public_html/dev002/kunena-attachments-to-bbpress.php on line 45

I looked to see if there was a “Kunena fix for broken attachments” script but nothing popped up yet.

[@jbuesking Participant 10 years, 7 months ago]

I have finally found the time to start migrating my site over. The importer worked great.

Now it’s time to handle the issue with the attachments. Running the very young script returns nothing but “200”.

Has anyone succesfully migrated the attachments over yet? I would be willing to pay if there is a commercial script available.

Thanks

[@jbuesking Participant 11 years, 1 month ago]

I never was able to get it to work. I would like to switch a joomla site over eventually but until I can get away from kunena it’s not an option.

Has anyone successfully got this to work?

[@jbuesking Participant 11 years, 3 months ago]

Yes I have the latest version you updated. Thanks

I reset the forum and started from scratch. Ran the installer again and now it threw this error:

WordPress database error: [Table ‘ixxxxxxx_xxxxxxx.jos_kunena_topics’ doesn’t exist]
SELECT convert(kunena_messages.id USING “utf8”) AS id,convert(kunena_messages.catid USING “utf8”) AS catid,convert(kunena_messages.thread USING “utf8”) AS thread,convert(kunena_messages.ip USING “utf8”) AS ip,convert(kunena_messages.userid USING “utf8”) AS userid,convert(kunena_messages.subject USING “utf8”) AS subject,convert(kunena_messages_text.message USING “utf8”) AS message,convert(kunena_messages.time USING “utf8”) AS time FROM tvc4d_kunena_messages AS kunena_messages LEFT JOIN tvc4d_kunena_messages_text AS kunena_messages_text ON kunena_messages_text.mesid = kunena_messages.id LEFT JOIN jos_kunena_topics AS kunena_topics ON kunena_messages.thread = kunena_topics.id WHERE kunena_messages.parent != 0 LIMIT 0, 100

[@jbuesking Participant 11 years, 3 months ago]

*now

[@jbuesking Participant 11 years, 3 months ago]

Thanks for you reply.

I am not getting the following error:

WordPress database error: [Table 'insomnia_tccjoomla.tvc4d_user' doesn't exist]
SELECT convert(user.userid USING "utf8") AS userid,convert(user.password USING "utf8") AS password,convert(user.salt USING "utf8") AS salt,convert(user.username USING "utf8") AS username,convert(user.email USING "utf8") AS email,convert(user.homepage USING "utf8") AS homepage,convert(user.joindate USING "utf8") AS joindate,convert(user.aim USING "utf8") AS aim,convert(user.yahoo USING "utf8") AS yahoo,convert(user.icq USING "utf8") AS icq,convert(user.msn USING "utf8") AS msn,convert(user.skype USING "utf8") AS skype FROM tvc4d_user AS user LIMIT 0, 100

I believe the table it should be looking for is: tccjoomla.tvc4d_users not user

[@jbuesking Participant 11 years, 3 months ago]

Thanks for the reply.

I am using version 2.03 and your kunena2.php importer.

I’m tempted to upgrade to 3.0.1 and try your kunena3.php importer.

Thanks for your help!

[@jbuesking Participant 11 years, 3 months ago]

When I run the script with the convert users option checked it throws the following error:

WordPress database error: [Unknown column 'users.userid' in 'field list']
SELECT convert(users.userid USING "utf8") AS userid,convert(users.password USING "utf8") AS password,convert(users.username USING "utf8") AS username,convert(users.email USING "utf8") AS email,convert(users.registerDate USING "utf8") AS registerDate FROM tvc4d_users AS users LIMIT 0, 100

It appears to work if I don’t try to convert the users. I’ll dig into this later this evening but wanted to see if it’s something obvious?