- Posts: 3
- Thank you received: 0
Kunena 6.2.5 & module Kunena Latest 6.0.7 released
The Kunena team has announce the arrival of Kunena 6.2.5 [K 6.2.5] which is now available for download as a native Joomla extension for J! 4.3.x/4.4.x/5.0.x. This version addresses most of the issues that were discovered in K 6.1 / K 6.2 and issues discovered during the last development stages of K 6.2
Question getting error after migrating to kuenana 3.0 from 2.0 when a user changes status
- webdeveloper
- Topic Author
- Offline
- New Member
Less
More
8 years 9 months ago #1
by webdeveloper
getting error after migrating to kuenana 3.0 from 2.0 when a user changes status was created 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'
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.
8 years 9 months ago #2
by sozzled
Blue Eagle vs. Crypsis reference guide
Read my blog and
Replied by sozzled on topic getting error after migrating to kuenana 3.0 from 2.0 when a user changes status
If you want professional help with this kind of problem, there are people who can help you.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
8 years 9 months ago #3
by 810
Replied by 810 on topic getting error after migrating to kuenana 3.0 from 2.0 when a user changes status
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.
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.
- webdeveloper
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
8 years 9 months ago #4
by webdeveloper
Replied by webdeveloper on topic getting error after migrating to kuenana 3.0 from 2.0 when a user changes status
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.
8 years 9 months ago #5
by 810
Replied by 810 on topic getting error after migrating to kuenana 3.0 from 2.0 when a user changes status
try this on your database:
Replace #_ with your prefix
Replace #_ with your prefix
Code:
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.
- webdeveloper
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
8 years 9 months ago #6
by webdeveloper
Replied by webdeveloper on topic getting error after migrating to kuenana 3.0 from 2.0 when a user changes status
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'
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.
8 years 9 months ago #7
by 810
Replied by 810 on topic getting error after migrating to kuenana 3.0 from 2.0 when a user changes status
you need to install k4.0.1 first
Please Log in or Create an account to join the conversation.
Time to create page: 0.450 seconds