Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

This category is for K 1.7 issues only.
To get started please see K 1.6 & K 1.7 Installation Guide in our Documentation Wiki

Question Categories are missing

More
14 years 8 months ago #106309 by vrillian
Categories are missing was created 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
14 years 8 months ago - 14 years 8 months ago #106328 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: 14 years 8 months ago by xillibit.

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

More
14 years 8 months ago #106415 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
14 years 7 months ago #107360 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
14 years 7 months ago #107669 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
14 years 7 months ago #107957 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.

Time to create page: 0.328 seconds