Kunena 7.0.2 Released

The Kunena team has announce the arrival of Kunena 7.0.2 [K 7.0.2] in stable which is now available for download as a native Joomla extension for J! 5.3.x/5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

Question Modified version of the conversion script - Get more data from phpBB3 to Kunena

More
14 years 11 months ago - 14 years 11 months ago #91872 by frold
Modified version of the conversion script - Get more data from phpBB3 to Kunena was created by frold
Hey,

I did create this snippet you might wanna use to get more data from phpBB3 to Kunena the the converter script does?

Modify it for you needs. Backup before use. Use eg phpMyAdmin to run the sql.
Code:
# Move gender from phpBB3 to Kunena profile UPDATE jos_kunena_users JOIN phpbb_users ON (jos_kunena_users.userid = phpbb_users.user_id +61) SET jos_kunena_users.gender = phpbb_users.user_gender # Move location from phpBB3 to Kunena profile UPDATE jos_kunena_users JOIN phpbb_users ON (jos_kunena_users.userid = phpbb_users.user_id +61) SET jos_kunena_users.location = phpbb_users.user_from # Move Birthday from phpBB3 to Kunena profile UPDATE jos_kunena_users JOIN phpbb_users ON (jos_kunena_users.userid = phpbb_users.user_id +61) SET jos_kunena_users.birthdate = phpbb_users.user_birthday # Move icq, aim, yim, msnm from phpBB to Kunena Profile UPDATE jos_kunena_users JOIN phpbb_users ON (jos_kunena_users.userid = phpbb_users.user_id +61) SET jos_kunena_users.ICQ = phpbb_users.user_icq UPDATE jos_kunena_users JOIN phpbb_users ON (jos_kunena_users.userid = phpbb_users.user_id +61) SET jos_kunena_users.AIM = phpbb_users.user_aim UPDATE jos_kunena_users JOIN phpbb_users ON (jos_kunena_users.userid = phpbb_users.user_id +61) SET jos_kunena_users.YIM = phpbb_users.user_yim UPDATE jos_kunena_users JOIN phpbb_users ON (jos_kunena_users.userid = phpbb_users.user_id +61) SET jos_kunena_users.MSN = phpbb_users.user_msnm # Move website from phpBB to Kunena Profile (do it twice for website name and link) UPDATE jos_kunena_users JOIN phpbb_users ON (jos_kunena_users.userid = phpbb_users.user_id +61) SET jos_kunena_users.websitename = phpbb_users.user_website UPDATE jos_kunena_users JOIN phpbb_users ON (jos_kunena_users.userid = phpbb_users.user_id +61) SET jos_kunena_users.websiteurl = phpbb_users.user_website #Move interest from phpBB to Kunena Profile UPDATE jos_kunena_users JOIN phpbb_users ON (jos_kunena_users.userid = phpbb_users.user_id +61) SET jos_kunena_users.personalText = phpbb_users.user_interests
Last edit: 14 years 11 months ago by frold.
The following user(s) said Thank You: hkymre

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

More
14 years 11 months ago #92002 by frold
Replied by frold on topic Re: Modified version of the conversion-fil - Get more data from phpBB3 to Kunena
I have updated the convertion script found here:

Feel free to test it

I was not able to get the birthday from phpBB3 --> Kunena

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

More
14 years 11 months ago #92358 by frold
Replied by frold on topic Re: Modified version of the conversion script - Get more data from phpBB3 to Kunena
Anyone tested it and would it work for you?

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

More
14 years 10 months ago - 14 years 10 months ago #93447 by gatuko
Replied by gatuko on topic Re: Modified version of the conversion-fil - Get more data from phpBB3 to Kunena

frold wrote: Anyone tested it and would it work for you?



Hi Frold

I want to convert a PHPBB3 3.08 (99000 messages - 700 users - 9000 topics ) to Kunena 1.6.3 on Joomla 1.5 ( last versions )

All are test versions that i have instaled to test it...

I just test it and I get a memory error
Code:
Importing data from phpBB Connecting to Database... OK Populating Categories... OK OK Populating Messages Table... OK Populating Messages_Text Table... Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 524288 bytes) in /home/xxxxx.../xxxx.../xxxx.../converter/go.php on line 142

I look fireboard and the part that migrate OK... are in forum OK...


Thanks all from Spain...
Last edit: 14 years 10 months ago by gatuko.

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

More
14 years 10 months ago - 14 years 10 months ago #93448 by gatuko
Replied by gatuko on topic Re: Modified version of the conversion-fil - Get more data from phpBB3 to Kunena

gatuko wrote:

frold wrote: Anyone tested it and would it work for you?



Hi Frold

I want to convert a PHPBB3 3.08 (99000 messages - 700 users - 9000 topics ) to Kunena 1.6.3 on Joomla 1.5 ( last versions )

All are test versions that i have instaled to test it...

I just test it and I get a memory error
Code:
Importing data from phpBB Connecting to Database... OK Populating Categories... OK OK Populating Messages Table... OK Populating Messages_Text Table... Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 524288 bytes) in /home/xxxxx.../xxxx.../xxxx.../converter/go.php on line 142

I look fireboard and the part that migrate OK... are in forum OK...


Thanks all from Spain...


I test this version of converter too:
docs.kunena.org/index.php/PHPBB3_to_Kunena

And get the same error... :(
Last edit: 14 years 10 months ago by gatuko.

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

More
14 years 10 months ago #94137 by stalkerMPRo
Replied by stalkerMPRo on topic Re: Modified version of the conversion-fil - Get more data from phpBB3 to Kunena

gatuko wrote:

gatuko wrote:

frold wrote: Anyone tested it and would it work for you?



Hi Frold

I want to convert a PHPBB3 3.08 (99000 messages - 700 users - 9000 topics ) to Kunena 1.6.3 on Joomla 1.5 ( last versions )

All are test versions that i have instaled to test it...

I just test it and I get a memory error
Code:
Importing data from phpBB Connecting to Database... OK Populating Categories... OK OK Populating Messages Table... OK Populating Messages_Text Table... Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 524288 bytes) in /home/xxxxx.../xxxx.../xxxx.../converter/go.php on line 142

I look fireboard and the part that migrate OK... are in forum OK...


Thanks all from Spain...


I test this version of converter too:
docs.kunena.org/index.php/PHPBB3_to_Kunena

And get the same error... :(


Do this on localhost! most hosts limits memory usage. i have done this on local XAMPP(u may use denver if u want)

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

Time to create page: 0.510 seconds