Idea phpBB 3 to Kunena 3 Migration Script

Hello,

I used the script. had some issues and figured out so far everything.

BUT have problems with the attachments.
I have converted them all, I added the correct extensions like jpg or pdf

I copied them all into the required folder as written so in

/test/joomla_3_IG/media/kunena/attachments/migrated

I can see the files in the Backend in the file management.

But I cannot access them. I have set permissions to 777 so this is not the reason.

Error from Backend is
"You don't have permission to access /media/kunena/attachments/migrated/68_df5ebccae730d85437c45ac74da54226.jpg on this server."

any thoughts why this is?

I found the issue:

When you modify the attachments take care to the following
1. When you download the files with an FTP like FileZilla put the transfer method to BINARY
2. after modification of the files only copy the attachment files back to the media Kunena/migrated folder!!!! Not the Index.php or the .htaccess file!!!

One hint for everyone:
If you like to get the details from your attachments go to the Database of phpBB and Expotrt the attachment table. There you can easily identify the file extensions needed.

Thanks to this script.

Chris

Chris,

Sorry for the late reply. I have been very disturbed by a VPS service provider, paid for 12 months in upfront, them not delivering the service at all. I cancelled as per their ToS, they say that I am not eligible for refund. They want to take the whole 12 month payment, the service I got in return was not even a minute of the server. Since MixERP project is a non profit community, I feel very bad to loose the money as a result of an unethical business practice done by a company based in Washington.

On the happy note, I am glad to hear that you have sorted out the attachment issue. Good luck.

A strange discovery from the few words that return results:

I suspected the language files for quite a while, and thought "worst case I just rename those to English, and configure the site to be fully English (maybe even rename the dutch files to en-US, with fallback to en-UK) while it's not; and next update it will break but I'll re-overwrite them"... But that doesn't seem to be the problem.

Search on non-English words does give strange results: Search for "Olen" (a village, that I saw mentioned in a post) gave "watermolen" (=watermill) as result; search for "zee" (=sea) gave "zeer" (=very if adverb, or pain if noun) while there were matches enough about the sea... But this may be a typical problem? I haven't looked it up.

But, a possible lead to a breakthrough:
What I noticed was that all results came either from (1) self-written posts (i.e., through Kunena frontend, not through script), or (2) last posts in any topic. And indeed, I can find any post quite consistently (say 19 out of 20) if it's using my search term and it's the last in a topic. And if I post another message in the topic, then the now one-before-last post still gets found...

[So there is a ludicrous solution: Insert every topic with only its first message, then recount stats, then insert second message in each topic if it exists, recount, third message, recount, fourth, ... --- until the longest topics (54 and 56 posts) are fully inserted! Madness.]

OK, back to the grindstone. Maybe I have to turn off search, but that makes it almost useless.

Hi,

Can you provide me your database so I that I fully understand what the problem is? Since the scope of problem of this problem might be out of my domain, I cannot guarantee I will be able to solve this problem.

I am primarily a C++/C# developer, I have been just guessing and poking PHP with some success.

I would be free on the weekend to see your problem. So, if you're interested, send me an email at binodnp^outlook@com.

This topic has become very big and difficult to read. So, henceforward I would want to offer help in my own forum instead of here.

mixerp.org/forum

Please create a separate topic in MixERP forums under the category "phpBB to Kunena Migration Forum". See you there.

Dear Binod,

Thanks for such a kind offer. I'll give it another go or two this week first...

There's of course privacy issues in sending the actual database. So I'll see that I can replicate my problem with some fake data! I couldn't last time, because I hadn't put enough data in --- "hey this all works!" --- to notice only last messages in topics popped up.