Idea phpBB 3 to Kunena 3 Migration Script

Greetings - newbie here and I'm trying to migrate from phpbb 3.1.3 to Kunena on Joomla 3.3.6.

In running the script, I get the following Error code:

Error
SQL query:

DELIMITER $$ CREATE FUNCTION azlro.get_alias(

str VARCHAR( 256 )
) RETURNS VARCHAR( 256 ) DETERMINISTIC BEGIN DECLARE alias VARCHAR( 256 ) ;

SET alias = REPLACE( REPLACE( LCASE( REPLACE( CONVERT( TRIM( str ) USING ASCII ) , '?', '' ) ) , ' ', '-' ) , '&', 'and' ) ;

RETURN alias;

END ;

$$
MySQL said: Documentation

#1419 - You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Any help would be greatly appreciated!

Hi,

I would suggest you to:

1. download the dump of your phpBB3 database and restore that on your workstation.
2. Create a new Joomla installation or restore your existing joomla installation locally. Also, you will have to have the Kunena component installed first.
3. Downalod Toad for MySQL freeware.
4. Connect to your database server from Toad.
5. Run the script.
6. Restore your phpBB3 Kunena migrated forum to your actual webserver.

If you encounter any trouble during this, please let me know if I can help.

Good day.

Binod

I was able to, on my local machine, run the script and get my phpbb information moved over to the kunena tables.

However, when I try to import the Kunena tables to my 'real' web server's database, I get a similar error...

Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Please ask assistance with your web server's administrator or support personnel. Seems like you do not have permission to restore the database.

I've been struggling the last weeks with a forum migration to Kunena as done by your/Binod's script:

The issue is that the Search function on the forums doesn't work! In a very peculiar way: The only words that give results, are those used in new messages (so inserted through the Kunena frontend, not via script/mysql) --- zero results are found if searching for other words.

And when searching for those freshly-used words, the new messages using them consistently come up, while there are always a few (but not all) of the old/inserted messages found that match... For example, I find 9 results for the word 'not' out of thousands of messages; more targeted/meaningful words give me at most 10-12matches.

Any idea why? Reading through the script, I don't see where there is some sort of Search-index updated; and if I take a database dump before+after adding a message through Kunena (not through mysql) and check the differences, nothing significant shows up. I'm thoroughly flummoxed by now!

I have no idea why that is happening to you. Currently I am very occupied with my project MixERP, or I would have digged into it myself.

Moreover, if I were you, I would:

1. find how Kunena search feature works, how search queries are generated. Try to compare that against direct database query.
2. investigate if there is something wrong with existing MySQL installation.
3. give up everything and restore the database on a fresh new machine, just to make sure that there is nothing wrong with the current configuration.

Yes, the script doesn't do anything more than copying data from one database table to the other. Do let me know, if I can help you. Happy testing!