bbPress.org

Hi Stephen – many thanks for your lengthy and considered reply. You are right that a lot of the php MySQL is over my head

I believe that the issue is that between 1.5.9 and 1.6 of kunena, the layout of the database changed in more ways than renaming the tables and therefore my old-style database won’t work. My information is in the jos_fb_ format

I have tried updating Kunena to a 1.6.x version however I’m hitting other problems with that –

Uncaught Exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci’ at line 9 SQL=CREATE TABLE jos_kunena_version ( id int(11) NOT NULL AUTO_INCREMENT, version varchar(20) NOT NULL, versiondate date NOT NULL, installdate date NOT NULL, build varchar(20) NOT NULL, versionname varchar(40) DEFAULT NULL, PRIMARY KEY (id) ) TYPE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci.

I believe I need to change TYPE to ENGINE and have found one set of instructions for that, but they do not work so I’m backed into a different corner.

I put up a post on the kunena forum asking for help, even if I have to pay a few bucks for that – but really I only need the old database content to be transferred into the new database in the correct format, the rest of the site is to be scrapped – is it possible that the database tweaks can be done independently from upgrading the kunena installation? or can I tweak the importer to work with the jos_fb_ version – I don’t have the skills to do that but I suspect it’s a major job and probably unfeasible.

Your importer clearly works as intended and thank you for making it available, the problem I believe is most likely to be upstream but I won’t know until I can sort that bit out. Unless there is a way to make the database transfer (I can pay a wee bit) I’m not quite sure where to go next.

Many thanks

Paul