Question Error 1054 Unknown column 'id'

Hi Kunena Team,

i got a Problem with my Kunena.

First i updated Joomla from 1.5 to 3.6 with SP Upgrade 4.0.6.

Than install the new Kunena on new Site with new Joomla, Transfered User and all Stuf from old Joomla.

Than Transfered Old Kunena User, Posts, Topic etc. to new Kunena.

When i go to components ---> Kunena than comes a Error:

1054 Unknown column 'id' in 'where clause' SQL=SELECT * FROM #__kunena_configuration WHERE id=1

Any idea how to solve this Problem? Please help.

Thank you.

Looks like you miss the sql table.


Please add this code on your database, and change the yourprefix with your own prefix:

Thank you,

which database? As a new Table? inside _kunena_configuration?

Thanks.

into the joomla database, where you have all the website tables.

You need to copy the code into the sql tab and run it.

Thanks.

So i go to phpMyAdmin.

inside the Database.

At the header i click on the Tab "SQL".

i see a empty field. so copy and paste

CREATE TABLE IF NOT EXISTS `tg09a_kunena_configuration` (
`id` int(11) NOT NULL default '0',
`params` text NULL,
PRIMARY KEY (id) ) DEFAULT CHARACTER SET utf8;

Than click on ok.

than i see green field with text in german: MySQL lieferte ein leeres Resultat zurück, means like MySQL gave back an empty result

i go back to joomla backend, reload the site and go to Components --> Kunena Forum = nothin happen. same problem with the error text.

I suggest to create a full backup. data + databse

Then remove all kunena tables, then export the kunena tables from your J1.5

Then import it into you new database, check the tables if they have the correct prefix. Then install kunena package by the joomla installer.

Here I have a small update: I could fix the problem changing the name of a column that was wrong, it had the old prefix copied from the old database.
Unfortunately, I have another problem: After migrating the categories to the new kunena 4, the categories list is empty, although the database has exactly the same content as the old database (frontend and backend). Is there a solution for this problem?
Oddly, the thrash bin in the new version has the same content than the old thrash bin, which I have not deleted.