×
Kunena 5.1.9 Released (Today)

The Kunena team has announce the arrival of Kunena 5.1.9 [K 5.1.9] which is now available for download as a native Joomla extension for J! 3.9.x. This version addresses most of the issues that were discovered in K 5.1 and issues discovered during the development stages of K 5.1. This is a maintenance release.

Question Error 1054 Unknown column 'id'

More
2 years 6 months ago #1 by Chelsea FC
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.

Please Log in or Create an account to join the conversation.

More
2 years 6 months ago #2 by 810
Replied by 810 on topic Error 1054 Unknown column 'id'
Looks like you miss the sql table.


Please add this code on your database, and change the yourprefix with your own prefix:
CREATE TABLE IF NOT EXISTS `yourprefix_kunena_configuration` (
	`id` int(11) NOT NULL default '0',
	`params` text NULL,
	PRIMARY KEY (id) ) DEFAULT CHARACTER SET utf8;
The following user(s) said Thank You: Chelsea FC

Please Log in or Create an account to join the conversation.

More
2 years 6 months ago #3 by Chelsea FC
Thank you,

which database? As a new Table? inside _kunena_configuration?

Thanks.

Please Log in or Create an account to join the conversation.

More
2 years 6 months ago #4 by 810
Replied by 810 on topic Error 1054 Unknown column 'id'
into the joomla database, where you have all the website tables.

You need to copy the code into the sql tab and run it.
The following user(s) said Thank You: Chelsea FC

Please Log in or Create an account to join the conversation.

More
2 years 6 months ago - 2 years 6 months ago #5 by Chelsea FC
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.
Last edit: 2 years 6 months ago by Chelsea FC.

Please Log in or Create an account to join the conversation.

More
2 years 6 months ago #6 by 810
Replied by 810 on topic Error 1054 Unknown column 'id'
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.

Please Log in or Create an account to join the conversation.

More
2 years 6 months ago #7 by Chelsea FC
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.

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.100 seconds