×
Kunena 5.1.18 Released (30 Jun 2020)

The Kunena team has announce the arrival of Kunena 5.1.18 [K 5.1.18] which is now available for download as a native Joomla extension for J! 3.9.x. This version addresses most of the issues that were discovered in K 5.1 and issues discovered during the development stages of K 5.1.

Question phpbb3 to Kunena

More
10 years 5 months ago - 10 years 5 months ago #111 by Mark0100
Replied by Mark0100 on topic Re:phpbb3 to Kunena
Hi developers

my know how in PHP is not very good so I really need your help.

For an expert in PHP development must this very easy.

in the PDF-File in the attachment I wrote what I need to convert the Attachments from phpbb3 to Kunena.

Gruß Mark
Pickup-Wohnkabinen-Forum Kunena 4.0.7
Chevy-Forum Kunena 3.0.8
Attachments:
Last edit: 10 years 5 months ago by Mark0100.

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

More
10 years 5 months ago - 10 years 5 months ago #112 by Juraus
Replied by Juraus on topic Re:phpbb3 to Kunena
Help please!

I'm trying to convert (with go.php) but conversion stops here:
Importing data from phpBB
 
Connecting to Database... OK 
Populating Categories... OK OK 
Populating Messages Table... OK 
Populating Messages_Text Table...

Nothing happeded after "Populating Messages_Text Table..."??? What should I do :unsure:?


Resolved: It was about max_execution_time setting in php.ini.
Last edit: 10 years 5 months ago by Juraus.

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

More
10 years 5 months ago #113 by Juraus
Replied by Juraus on topic Re:phpbb3 to Kunena
Kymmy wrote:

I did find a way round the password issue. It's a long way round but it did work.

I first installed a test joomla with Jfusion linking into the phpbb3. Synced all the users using jfusion. Then on a fresh joomla install with kunena/fireboard (seperate DB from the test install I followed the go.php instructions in the phpbb3>>fireboard convertor. Once all the users/posts were transferred across I then used a simple php script to copy the passwords for each user from the jfusion/joomla DB to the relevant users in joomla/kunena DB (needed as the user ID's will not be the same.

The password copying script is available in this thread by the person who kindly made it for me
www.cableforum.co.uk/board/19/33659901-php-script.html

Yep it's a long way round but at least the jfusion usersync converts all of the passwords and as long as your secret key is the same in your joomla/jfusion and joomla/kunena installs the passwords will work.

Now what I would love is for the convertor to also copy across the users PM's

:kiss:


I check and tried script for passwords and i get:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

You said that

Yep, just added $db1_result = "";

Could you post modified script here on PM it to me , please.

And one more question... Which one is the database (on the password script) which have users syncronized with JFusion? Is it db1 or db2?

Regards,
Juraus

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

More
10 years 5 months ago #114 by Kymmy
Replied by Kymmy on topic Re:phpbb3 to Kunena
Here's a RAR file with the new code in place, I've marked the DB old and new and please remember that for this to work the Secret Key has to be the same as the old Joomla as it's salted into the password hashes. Please test this out on copies of the DB's first to make sure it works ;) ;)

www.hugzzz.com/passswap.rar

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

More
10 years 5 months ago #115 by Juraus
Replied by Juraus on topic Re:phpbb3 to Kunena
Kymmy wrote:

Here's a RAR file with the new code in place, I've marked the DB old and new and please remember that for this to work the Secret Key has to be the same as the old Joomla as it's salted into the password hashes. Please test this out on copies of the DB's first to make sure it works ;) ;)

www.hugzzz.com/passswap.rar


Thanks!!!:cheer: Just to be sure: is the olddatabase the database which have users syncronized with JFusion?

-Juraus

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

More
10 years 5 months ago #116 by Kymmy
Replied by Kymmy on topic Re:phpbb3 to Kunena
Sorry for the delayed reply, must set this thread to receive subscription emails..

The newdatabase should be the new joomla DB with the migrated kunena data, the old database is the joomla/jfusion/phpbb3 database. So it's copying the passwords from the old to the new..

Please, please, please try it first on copies of the db's

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

More
10 years 5 months ago #117 by Juraus
Replied by Juraus on topic Re:phpbb3 to Kunena
Thanks! I figured that out :)

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

More
10 years 5 months ago #118 by Kymmy
Replied by Kymmy on topic Re:phpbb3 to Kunena
Did it work??

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

More
10 years 5 months ago #119 by Juraus
Replied by Juraus on topic Re:phpbb3 to Kunena
Yes it did :cheer:

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

More
10 years 5 months ago #120 by Kymmy
Replied by Kymmy on topic Re:phpbb3 to Kunena
Good as it means that until an all-in-one solution comes along at least people now have a way of doing the forums/posts/users/smilies/emails and passwords :)

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.208 seconds