×
Kunena 5.1.18 Released (30 Jun 2020)

The Kunena team has announce the arrival of Kunena 5.1.18 [K 5.1.18] 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.

Question getting error after migrating to kuenana 3.0 from 2.0 when a user changes status

More
5 years 3 weeks ago #1 by webdeveloper
Hi

Getting the sql query error below after migration joomla 1.5 to 3.5 and updating kuenena from 2.0 to 3.0

Can any one plz suggest a solution


Unknown column 'status' in 'field list' SQL=UPDATE `fgx_kunena_users` SET `view`='',`moderator`='0',`ordering`='0',`posts`='0',`karma`='0',`karma_time`='0',`group_id`='1',`uhits`='0',`gender`='0',`birthdate`='0001-01-01',`rank`='0',`hideEmail`='1',`showOnline`='1',`thankyou`='0',`status`='0' WHERE `userid`='994'

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

More
5 years 3 weeks ago #2 by sozzled
If you want professional help with this kind of problem, there are people who can help you.

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

More
5 years 3 weeks ago #3 by 810
The field Status is new in Kunena 4.0

Did you install Kunena 4.0 before.

Just install the new version, it will be good when you install the lasted version.

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

More
5 years 2 weeks ago #4 by webdeveloper
Hi thanks for response...I did install kuenana 4 before proceeding with the update...Is there anything in database table that I can do it stop it from giving this query error...Please suggest...Thanks

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

More
5 years 2 weeks ago #5 by 810
try this on your database:

Replace #_ with your prefix
ALTER TABLE `#__kunena_topics` ADD KEY `last_post_id` (`last_post_id`);
ALTER TABLE `#__kunena_attachments` ADD `protected` TINYINT( 4 ) NOT NULL DEFAULT '0' AFTER `userid`;
ALTER TABLE `#__kunena_attachments` ADD `filename_real` VARCHAR( 255 ) NOT NULL DEFAULT '' COMMENT 'Filename for downloads.';
ALTER TABLE `#__kunena_attachments` ADD `caption` VARCHAR( 255 ) NOT NULL DEFAULT 'Caption text.';
UPDATE `#__kunena_attachments` SET `filename_real`=`filename` WHERE `filename_real`='';
ALTER TABLE `#__kunena_attachments` ADD INDEX `filename_real` (`filename_real`);
ALTER TABLE `#__kunena_user_categories` ADD `allreadtime_new` INT NOT NULL DEFAULT '0' AFTER `allreadtime`;
UPDATE `#__kunena_user_categories` SET `allreadtime_new`=if(UNIX_TIMESTAMP(`allreadtime`), UNIX_TIMESTAMP(`allreadtime`), `allreadtime`);
ALTER TABLE `#__kunena_user_categories` DROP `allreadtime` ;
ALTER TABLE `#__kunena_user_categories` CHANGE `allreadtime_new` `allreadtime` INT(11) NOT NULL DEFAULT '0';
UPDATE #__kunena_user_categories AS c INNER JOIN #__kunena_sessions AS s ON c.user_id=s.userid SET c.allreadtime=s.lasttime WHERE c.category_id=0 AND c.allreadtime<s.lasttime;
ALTER TABLE `#__kunena_users` ADD `canSubscribe` tinyint(1) NOT NULL DEFAULT '1' AFTER `showOnline`;
ALTER TABLE `#__kunena_users` ADD `userListtime` int(11) NOT NULL DEFAULT '-2' AFTER `canSubscribe`;
ALTER TABLE `#__kunena_categories` ADD COLUMN `icon` varchar(20) NOT NULL	DEFAULT '' AFTER `alias`;
ALTER TABLE `#__kunena_categories` ADD COLUMN `iconset` varchar(255) NOT NULL	DEFAULT '' AFTER `topic_ordering`;

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

More
5 years 2 weeks ago #6 by webdeveloper
I updated it and it showed 26 rows affected but when I try to login and do announcements in kunena I got the same error:

Unknown column 'status' in 'field list' SQL=UPDATE `fgx_kunena_users` SET `view`='',`moderator`='0',`ordering`='0',`posts`='0',`karma`='0',`karma_time`='0',`group_id`='1',`uhits`='0',`gender`='0',`birthdate`='0001-01-01',`rank`='0',`hideEmail`='1',`showOnline`='1',`thankyou`='0',`canSubscribe`='1',`userListtime`='-2',`status`='3' WHERE `userid`='994'

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

More
5 years 2 weeks ago #7 by 810
you need to install k4.0.1 first

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.127 seconds