Question php-fusion v6x -> Kunena 1.5 90% completed

After some days of mixing the code, i finally finished the thing with subjects.
And like you sed- there just needed a small changes.

Open convert_threads.php

edit line 75.
FROM: SELECT p.*, u.user_name, u.user_email, t.thread_views

TO: SELECT p.*, u.user_name, u.user_email, t.thread_views, t.thread_subject

and line 137.

FROM: '".prepTextForDB($rw)."', '".prepTextForDB($rw)."', '".$rw."',

TO: '".prepTextForDB($rw)."', '".prepTextForDB($rw)."', '".$rw."',


:woohoo: :woohoo: :woohoo: :woohoo: :woohoo: :woohoo: :woohoo:

Hi Laasics

Great!

Any idea how to fix the error, I'm getting...?


* Unable to run database query: 1054 - Table 'wiberg_altomhobby.jos_community_users' doesn't exist
* Unable to run database query: 1146 - Table 'wiberg_altomhobby.jos_community_fields_values' doesn't exist
* Unable to run database query: 1146 - Table 'wiberg_altomhobby.jos_fb_users' doesn't exist
* Unable to obtain row as associative array: 1146 - Table 'wiberg_altomhobby.jos_fb_users' doesn't exist

(See earlier post for the full description.)


I hope you can help - I don't know how else to migrate from my old site to my new...
I am more than willing to pay for your help, if that makes a difference...?


Rie

You are using kunena or fb ?

I'm asking,because this migrator i build for fb , but i think you are using kunena.
And that's why you have this error: ... doesn't exist

All you have to do is: in this migrator,open all files that are starting with "convert_"
and with search function,search for "fb" and replace them with "kunena" . = DONE

Remember to backup your database first

Ok, great! I'll try that.

Thank you SOOOOO much!!

Did it help ?

Hi again

Sorry for my late reply. The licence on the CP-server was renewed and there was an error with it, so I have not had access... But it's back, and I tried your solution.

Unfortunately I still get an error when trying to convert the users:

# Unable to run database query: 1054 - Unknown column 'userid' in 'where clause'
# Unable to run database query: 1146 - Table 'wiberg_altomhobby.jos_community_fields_values' doesn't exist
# Unable to run database query: 1054 - Unknown column 'userid' in 'field list' - INSERT INTO wiberg_altomhobby.jos_community_users ( userid, status, points, posted_on, avatar, thumb, invite, params, view, friendcount ) VALUES ( 1, '', 0, '0000-00-00 00:00:00', 'images/avatar/old/BIT[1].jpg', 'images/avatar/old/BIT[1].jpg', 0, 'notifyEmailSystem=1 privacyProfileView=20 privacyPhotoView=20 privacyFriendsView=20 privacyVideoView=1 notifyEmailMessage=1 notifyEmailApps=1 daylightsavingoffset=0 ', 0, 0 )
# Unable to run database query: 1146 - Table 'wiberg_altomhobby.jos_community_fields_values' doesn't exist

...etc, etc, etc...


Any idea what to do...?
(I am really happy that you have taken the time to help - I would be lost without your help...!)


Rie

It seems that users were created despite of the error message, so I tried converting the forum as well.

It kind of ...well... almost... ehm... didn't really work...

I can see a list of my forums/categories, but the categories are empty.
When I look at the list of recent topics, I can see them all. But when I click on a topic, the threads have no content. You can see which users posted when, but the text they wrote is gone...

Hi again

If it helps to have a look around, you can find it on www.findjobbet.dk/altomhobby ...


Rie

I think forum didn't convert well,because somewhere you forgot to edit from fb to kunena.



You are using fusion v6 or v7?
If v6,then create a new site and upgrade there from v6 to v7 (i'm using v7,not 7.1).
After that try to convert,just edit the code,like I did.

Hi again

I use v7... And I tried going through all the convert_ files again, but couldn't find anything missing.

However, for some reason I tried running your plugin again, this time choosing "delete and transfer forum messages" (or whatever it was called - the part that ONLY takes care of thread content).
And that worked!

Well... Kind of...
I have nothing in my "Recent posts" list, and looking at the index/categories, all posts are 41 years old... Haha! :laugh:
But the threads are fine, so I'll just have to see if I can figure out how to make it NOT say that they are 41 years old when looking at the index...

Anyway - I'm almost there.
Thank you SOOOOO much for your help!!


Rie