[@marshallarts Participant 10 years, 12 months ago]

Hi Stephen – I wanted to come back and update this thread with a SOLVED notice – At the end of the day the solution was simple – don’t upgrade to Kunena 1.6 – upgrade to Kunena 1.7.2 instead!! I spent weeks looking for solutions but the fix took only a few minutes when I made the decision to skip multiple versions. bbpress is working with 7500 old posts seeding the new forum

Anyway for anyone else following who has the same issues – upgrade to a later version that is still capable of working with Joomla 1.5.

A huge thank you to Stephen for taking the time to work with me on getting this migration happening

Cheers

Paul

[@marshallarts Participant 11 years ago]

Hi Stephen,

thank you for this and the time you are taking to help – I’ve read your previous very carefully.

Maybe I misunderstood something – The queries you suggest are all in the new form – e.g. jos_kunena_categories.id whereas my database is jos_fb_categories.id from Kunena 1.5.x- I checked on a test install of a newer version of Kunena and table names and fields have changed so I think the jos_fb_ tables/fields are all wrong for the migrator.

I do have backups and am willing to have a go but the queries are jos_kunena format not jos_fb – so much is unfamiliar and ergo scary!

Thanks Stephen and sorry for being a pain, I really do want to get this out of your way and me out of your hair 🙂

Paul

[@marshallarts Participant 11 years ago]

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

[@marshallarts Participant 11 years ago]

So, progress…

I worked out that the Kunena1 migrator was within bbpress – duh! My Kunena database had the jos_fb_ preface instead of the jos_kunena_ preface – I manually changed those-

I have now managed to import the replies however despite running the repair option, the forums and topics were not imported – It seems to have appended an extre Re: in front of each (so they read Re:Re:Topic). It’s possible that the kunena version I have might have used a slightly different table naming convention or somethung

I’m reading around as much as I can so I’m not posting too many silly questions here but your help is appreciated.

Thanks

Paul

[@marshallarts Participant 11 years ago]

Hi Stephen,all

I’m working to recover 10,000 posts from my old forum that was on an old Joomla 1.5.22 site – Kunena V1.5.66 – The site was the victim of an attempted hack in 2010 that achieved nothing apart from screwing up 3000 registrations and killing the site it never recovered, it was a real blow to the community – I have restarted the site again on WP (.org not .com) in a development domain before switching to the main hosting and have selected to use BBpress for the new forum – I had given up the ghost on the old content until I saw this thread, now I’m all excited because the meat of the old site was on the old forum!!

Apologies for being a real numpty but is there an installation instruction? I can’t figure out where I place the kunena1.php file to start attempting the migration – I have tried in the root of the joomla domain but it 404’s.

Many thanks for your help and potentially brightening my day!!

Paul