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

This category is for K 1.7 issues only.

Question Categories are missing

More
12 years 6 months ago #1 by vrillian
I had Kunena 1.6. and now i installed 1.7. Everything is ok, but categories are missing.

I see categories in forum, thats not a problem. But there are no categories in adminpanel. And there is this error message:

Warning: Invalid argument supplied for foreach() in /xxx/xxx/administrator/components/com_kunena/admin.kunena.php on line 1050


I can't create new category (example category: Sivuston artikkelit).

TableKunenaCategory::store failed - Unknown column 'accesstype' in 'field list' SQL=INSERT INTO `jos_kunena_categories` (`id`,`parent`,`name`,`locked`,`moderated`,`accesstype`,`access`,`pub_access`,`pub_recurse`,`admin_access`,`admin_recurse`,`ordering`,`review`,`allow_anonymous`,`post_anonymous`,`description`,`headerdesc`,`class_sfx`,`allow_polls`) VALUES ('','1','Sivuston artikkelit','0','0','none','2','2','1','8','1','9999','0','0','0','','','','0')


I'm confused, because last time upgrade worked fine :(

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

More
12 years 6 months ago - 12 years 6 months ago #2 by xillibit
Replied by xillibit on topic Re: Categories are missing
Hello,

Your kunena categories table seems to be broken, the structure of the table is, before use that please make a backup :
Code:
CREATE TABLE IF NOT EXISTS `lm9w8_kunena_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent` int(11) DEFAULT '0', `name` tinytext, `cat_emoticon` tinyint(4) NOT NULL DEFAULT '0', `locked` tinyint(4) NOT NULL DEFAULT '0', `alert_admin` tinyint(4) NOT NULL DEFAULT '0', `moderated` tinyint(4) NOT NULL DEFAULT '1', `moderators` varchar(15) DEFAULT NULL, `accesstype` varchar(20) NOT NULL DEFAULT 'none', `access` int(11) NOT NULL DEFAULT '0', `pub_access` tinyint(4) DEFAULT '1', `pub_recurse` tinyint(4) DEFAULT '1', `admin_access` tinyint(4) DEFAULT '0', `admin_recurse` tinyint(4) DEFAULT '1', `ordering` smallint(6) NOT NULL DEFAULT '0', `future2` int(11) DEFAULT '0', `published` tinyint(4) NOT NULL DEFAULT '0', `checked_out` tinyint(4) NOT NULL DEFAULT '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `review` tinyint(4) NOT NULL DEFAULT '0', `allow_anonymous` tinyint(4) NOT NULL DEFAULT '0', `post_anonymous` tinyint(4) NOT NULL DEFAULT '0', `hits` int(11) NOT NULL DEFAULT '0', `description` text NOT NULL, `headerdesc` text NOT NULL, `class_sfx` varchar(20) NOT NULL, `allow_polls` tinyint(4) NOT NULL DEFAULT '0', `id_last_msg` int(10) NOT NULL DEFAULT '0', `numTopics` mediumint(8) NOT NULL DEFAULT '0', `numPosts` mediumint(8) NOT NULL DEFAULT '0', `time_last_msg` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `parent` (`parent`), KEY `published_pubaccess_id` (`published`,`pub_access`,`id`), KEY `msg_id` (`id_last_msg`), KEY `category_access` (`accesstype`,`access`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I don't provide support by PM, because this can be useful for someone else.
Last edit: 12 years 6 months ago by xillibit.

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

More
12 years 6 months ago #3 by Matias
Replied by Matias on topic Re: Categories are missing
This will show what's wrong:
administrator/index.php?option=com_kunena&view=install&layout=schema (output the first box here)

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

More
12 years 6 months ago #4 by mcgski
Replied by mcgski on topic Re: Categories are missing
I'm having the same problem. Ran what you suggested and got the following:
Code:
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE schema> <schema type="diff"> <table name="kunena_polls_users" action="alter"> <field name="lasttime" type="timestamp" null="0" extra="on update CURRENT_TIMESTAMP" action="alter" after="votes"/> </table> <table name="kunena_thankyou" action="alter"> <field name="time" type="timestamp" null="0" action="alter" after="targetuserid"/> </table> </schema>

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

More
12 years 6 months ago #5 by Matias
Replied by Matias on topic Re: Categories are missing
There's nothing wrong in your database, so the issue is elsewhere. Please enable debug mode and explain what you do and what you see.

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

More
12 years 6 months ago #6 by mcgski
Replied by mcgski on topic Re: Categories are missing
Do you need me to start over or can I just enable debug mode now?

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

More
12 years 6 months ago #7 by xillibit
Replied by xillibit on topic Re: Categories are missing
Just enable debug mode for now

I don't provide support by PM, because this can be useful for someone else.

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

More
12 years 6 months ago #8 by mcgski
Replied by mcgski on topic Re: Categories are missing
OK. How do I enable debug mode when there is no admin components installed? I've been trying to upgrade from 1.5.23 to any version in the 1.6/1.7 range. Apparently the JUpgrade won't do this properly.

I now have an instance of 1.7 but no components on the admin side.

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

More
12 years 6 months ago #9 by xillibit
Replied by xillibit on topic Re: Categories are missing
Enable debug mode in Joomla! configuration panel, don't use for now Jupgrade for migrate Kunena because there are issues and will be fixed with next version

I don't provide support by PM, because this can be useful for someone else.

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

More
12 years 5 months ago - 12 years 5 months ago #10 by Matias
Replied by Matias on topic Re: Categories are missing
Try with JUpgrade 1.2.2
Last edit: 12 years 5 months ago by Matias.

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

Time to create page: 0.373 seconds