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

Downloaded V6 database to compare it with V7.
Found out that in V6, fusion_posts there is post_subject field , but in V7 there isn't.
For this migrator you coded that subjects are token from fusion_posts - post_subject field, but for v7 subject need to be taken from fusion_threads - thread_subject field. ( i think )

Hi

I was so happy to find this! It was exactly what I needed!

But I'm getting an error when trying to get the users to the new site:

* 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



I tried creating the first table: 'wiberg_altomhobby.jos_community_users' and put in a field, just to see what would happen. I now get this error:

* 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: 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


As far as I can tell, it is a problem with a query - the structure seems to have changed from php4 to php5. ( bugs.mysql.com/bug.php?id=13551 )

But I am completely lost...!!
Can anyone please help...?


Rie

By the way, the tables mentioned don't seem to exist in neither the old PHP Fusion db nor in the new Joomla db...?

If it helps, I'm going from MySQL serverversion 4.1.22 and clientversion 4.1.22 to serverversion 5.1.51 and clientversion 4.1.22...

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