Kunena 7.0.6 & Kunena 6.4.12 – Security Updates Released

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

The Kunena team is also pleased to announce the twelfth version of Kunena 6.4, a native Joomla extension for Joomla! 5.0, 5.1, 5.2, 5.3, 5.4 and 6.0.

Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.

Solved Upgrade from 1.7.2 to 2.0.1 breaks in last step

nyabynghi
Topic Author
Offline
Junior Member

13 years 11 months ago - 13 years 11 months ago #128712 by nyabynghi

Upgrade from 1.7.2 to 2.0.1 breaks in last step was created by nyabynghi

Hello,

Like a previous poster I am also having issues with the upgrade in the last step. Every one of the processes seem to go through ok with the exception of upgrading menu item. That fails.

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE schema>
<schema type="diff">
<table name="kunena_categories" action="alter">
<field name="admin_access" type="int(11)" null="0" default="0" action="alter" after="pub_recurse"/>
</table>
<table name="kunena_user_read" action="alter">
<field name="time" type="int(11)" null="0" action="alter" after="message_id"/>
</table>
<table name="kunenadiscuss" action="unknown"/>
</schema>

and

Full Schema

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE schema>
<schema>
<table name="kunena_aliases">
<field primary_key="yes" name="alias" type="varchar(255)" null="0"/>
<field name="type" type="varchar(10)" null="0"/>
<field name="item" type="varchar(32)" null="0"/>
<field name="state" type="tinyint(4)" null="0" default="0"/>
<key name="alias" unique="1" columns="alias"/>
<key name="state" columns="state"/>
<key name="item" columns="item"/>
<key name="type" columns="type"/>
</table>
<table name="kunena_announcement">
<field primary_key="yes" name="id" type="int(3)" null="0" extra="auto_increment"/>
<field name="title" type="tinytext" null="0"/>
<field name="created_by" type="int(11)" null="0" default="0"/>
<field name="sdescription" type="text" null="0"/>
<field name="description" type="text" null="0"/>
<field name="created" type="datetime" null="0" default="0000-00-00 00:00:00"/>
<field name="published" type="tinyint(1)" null="0" default="0"/>
<field name="ordering" type="tinyint(4)" null="0" default="0"/>
<field name="showdate" type="tinyint(1)" null="0" default="1"/>
<key name="PRIMARY" unique="1" columns="id"/>
</table>
<table name="kunena_attachments">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="mesid" type="int(11)" null="0" default="0"/>
<field name="userid" type="int(11)" null="0" default="0"/>
<field name="hash" type="char(32)" null="1"/>
<field name="size" type="int(11)" null="1"/>
<field name="folder" type="varchar(255)" null="0"/>
<field name="filetype" type="varchar(20)" null="0"/>
<field name="filename" type="varchar(255)" null="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="mesid" columns="mesid"/>
<key name="userid" columns="userid"/>
<key name="hash" columns="hash"/>
<key name="filename" columns="filename"/>
</table>
<table name="kunena_categories">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="parent_id" type="int(11)" null="1" default="0"/>
<field name="name" type="tinytext" null="1"/>
<field name="alias" type="varchar(255)" null="0"/>
<field name="icon_id" type="tinyint(4)" null="0" default="0"/>
<field name="locked" type="tinyint(4)" null="0" default="0"/>
<field name="accesstype" type="varchar(20)" null="0" default="joomla.level"/>
<field name="access" type="int(11)" null="0" default="0"/>
<field name="pub_access" type="int(11)" null="0" default="1"/>
<field name="pub_recurse" type="tinyint(4)" null="1" default="1"/>
<field name="admin_access" type="int(11)" null="0" default="1"/>
<field name="admin_recurse" type="tinyint(4)" null="1" default="1"/>
<field name="ordering" type="smallint(6)" null="0" default="0"/>
<field name="published" type="tinyint(4)" null="0" default="0"/>
<field name="channels" type="text" null="1"/>
<field name="checked_out" type="tinyint(4)" null="0" default="0"/>
<field name="checked_out_time" type="datetime" null="0" default="0000-00-00 00:00:00"/>
<field name="review" type="tinyint(4)" null="0" default="0"/>
<field name="allow_anonymous" type="tinyint(4)" null="0" default="0"/>
<field name="post_anonymous" type="tinyint(4)" null="0" default="0"/>
<field name="hits" type="int(11)" null="0" default="0"/>
<field name="description" type="text" null="0"/>
<field name="headerdesc" type="text" null="0"/>
<field name="class_sfx" type="varchar(20)" null="0"/>
<field name="allow_polls" type="tinyint(4)" null="0" default="0"/>
<field name="topic_ordering" type="varchar(16)" null="0" default="lastpost"/>
<field name="numTopics" type="mediumint(

" null="0" default="0"/>
<field name="numPosts" type="mediumint(

" null="0" default="0"/>
<field name="last_topic_id" type="int(11)" null="0" default="0"/>
<field name="last_post_id" type="int(11)" null="0" default="0"/>
<field name="last_post_time" type="int(11)" null="0" default="0"/>
<field name="params" type="text" null="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="published_pubaccess_id" columns="published,pub_access,id"/>
<key name="category_access" columns="accesstype,access"/>
<key name="parent_id" columns="parent_id"/>
</table>
<table name="kunena_configuration">
<field primary_key="yes" name="id" type="int(11)" null="0" default="0"/>
<field name="params" type="text" null="1"/>
<key name="PRIMARY" unique="1" columns="id"/>
</table>
<table name="kunena_keywords">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="name" type="varchar(40)" null="0"/>
<field name="public_count" type="int(11)" null="0"/>
<field name="total_count" type="int(11)" null="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="name" unique="1" columns="name"/>
<key name="public_count" columns="public_count"/>
<key name="total_count" columns="total_count"/>
</table>
<table name="kunena_keywords_map">
<field primary_key="yes" name="keyword_id" type="int(11)" null="0"/>
<field primary_key="yes" name="user_id" type="int(11)" null="0"/>
<field primary_key="yes" name="topic_id" type="int(11)" null="0"/>
<key name="keyword_user_topic" unique="1" columns="keyword_id,user_id,topic_id"/>
<key name="user_id" columns="user_id"/>
<key name="topic_user" columns="topic_id,user_id"/>
</table>
<table name="kunena_messages">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="parent" type="int(11)" null="1" default="0"/>
<field name="thread" type="int(11)" null="1" default="0"/>
<field name="catid" type="int(11)" null="0" default="0"/>
<field name="name" type="tinytext" null="1"/>
<field name="userid" type="int(11)" null="0" default="0"/>
<field name="email" type="tinytext" null="1"/>
<field name="subject" type="tinytext" null="1"/>
<field name="time" type="int(11)" null="0" default="0"/>
<field name="ip" type="varchar(128)" null="1"/>
<field name="topic_emoticon" type="int(11)" null="0" default="0"/>
<field name="locked" type="tinyint(4)" null="0" default="0"/>
<field name="hold" type="tinyint(4)" null="0" default="0"/>
<field name="ordering" type="int(11)" null="1" default="0"/>
<field name="hits" type="int(11)" null="1" default="0"/>
<field name="moved" type="tinyint(4)" null="1" default="0"/>
<field name="modified_by" type="int(7)" null="1"/>
<field name="modified_time" type="int(11)" null="1"/>
<field name="modified_reason" type="tinytext" null="1"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="thread" columns="thread"/>
<key name="ip" columns="ip"/>
<key name="userid" columns="userid"/>
<key name="time" columns="time"/>
<key name="locked" columns="locked"/>
<key name="hold_time" columns="hold,time"/>
<key name="parent_hits" columns="parent,hits"/>
<key name="catid_parent" columns="catid,parent"/>
</table>
<table name="kunena_messages_text">
<field primary_key="yes" name="mesid" type="int(11)" null="0" default="0"/>
<field name="message" type="text" null="0"/>
<key name="PRIMARY" unique="1" columns="mesid"/>
</table>
<table name="kunena_polls">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="title" type="varchar(100)" null="0"/>
<field name="threadid" type="int(11)" null="0"/>
<field name="polltimetolive" type="datetime" null="1"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="threadid" columns="threadid"/>
</table>
<table name="kunena_polls_options">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="pollid" type="int(11)" null="1"/>
<field name="text" type="varchar(100)" null="1"/>
<field name="votes" type="int(11)" null="1"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="pollid" columns="pollid"/>
</table>
<table name="kunena_polls_users">
<field name="pollid" type="int(11)" null="1"/>
<field name="userid" type="int(11)" null="1"/>
<field name="votes" type="int(11)" null="1"/>
<field name="lasttime" type="timestamp" null="0" default="0000-00-00 00:00:00"/>
<field name="lastvote" type="int(11)" null="1"/>
<key name="pollid" unique="1" columns="pollid,userid"/>
</table>
<table name="kunena_ranks">
<field primary_key="yes" name="rank_id" type="mediumint(

unsigned" null="0" extra="auto_increment"/>
<field name="rank_title" type="varchar(255)" null="0" default=""/>
<field name="rank_min" type="mediumint(

unsigned" null="0" default="0"/>
<field name="rank_special" type="tinyint(1) unsigned" null="0" default="0"/>
<field name="rank_image" type="varchar(255)" null="0" default=""/>
<key name="PRIMARY" unique="1" columns="rank_id"/>
</table>
<table name="kunena_sessions">
<field primary_key="yes" name="userid" type="int(11)" null="0" default="0"/>
<field name="allowed" type="text" null="1"/>
<field name="lasttime" type="int(11)" null="0" default="0"/>
<field name="readtopics" type="text" null="1"/>
<field name="currvisit" type="int(11)" null="0" default="0"/>
<key name="PRIMARY" unique="1" columns="userid"/>
<key name="currvisit" columns="currvisit"/>
</table>
<table name="kunena_smileys">
<field primary_key="yes" name="id" type="int(4)" null="0" extra="auto_increment"/>
<field name="code" type="varchar(12)" null="0" default=""/>
<field name="location" type="varchar(50)" null="0" default=""/>
<field name="greylocation" type="varchar(60)" null="0" default=""/>
<field name="emoticonbar" type="tinyint(4)" null="0" default="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
</table>
<table name="kunena_thankyou">
<field primary_key="yes" name="postid" type="int(11)" null="0"/>
<field primary_key="yes" name="userid" type="int(11)" null="0"/>
<field name="targetuserid" type="int(11)" null="0"/>
<field name="time" type="datetime" null="0"/>
<key name="postid" unique="1" columns="postid,userid"/>
<key name="userid" columns="userid"/>
<key name="targetuserid" columns="targetuserid"/>
</table>
<table name="kunena_topics">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="category_id" type="int(11)" null="0" default="0"/>
<field name="subject" type="tinytext" null="1"/>
<field name="icon_id" type="int(11)" null="0" default="0"/>
<field name="locked" type="tinyint(4)" null="0" default="0"/>
<field name="hold" type="tinyint(4)" null="0" default="0"/>
<field name="ordering" type="int(11)" null="0" default="0"/>
<field name="posts" type="int(11)" null="0" default="0"/>
<field name="hits" type="int(11)" null="0" default="0"/>
<field name="attachments" type="int(11)" null="0" default="0"/>
<field name="poll_id" type="int(11)" null="0" default="0"/>
<field name="moved_id" type="int(11)" null="0" default="0"/>
<field name="first_post_id" type="int(11)" null="0" default="0"/>
<field name="first_post_time" type="int(11)" null="0" default="0"/>
<field name="first_post_userid" type="int(11)" null="0" default="0"/>
<field name="first_post_message" type="text" null="1"/>
<field name="first_post_guest_name" type="tinytext" null="1"/>
<field name="last_post_id" type="int(11)" null="0" default="0"/>
<field name="last_post_time" type="int(11)" null="0" default="0"/>
<field name="last_post_userid" type="int(11)" null="0" default="0"/>
<field name="last_post_message" type="text" null="1"/>
<field name="last_post_guest_name" type="tinytext" null="1"/>
<field name="params" type="text" null="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="category_id" columns="category_id"/>
<key name="locked" columns="locked"/>
<key name="hold" columns="hold"/>
<key name="posts" columns="posts"/>
<key name="hits" columns="hits"/>
<key name="first_post_userid" columns="first_post_userid"/>
<key name="last_post_userid" columns="last_post_userid"/>
<key name="first_post_time" columns="first_post_time"/>
<key name="last_post_time" columns="last_post_time"/>
</table>
<table name="kunena_user_categories">
<field primary_key="yes" name="user_id" type="int(11)" null="0"/>
<field primary_key="yes" name="category_id" type="int(11)" null="0"/>
<field name="role" type="tinyint(4)" null="0" default="0"/>
<field name="allreadtime" type="datetime" null="1"/>
<field name="subscribed" type="tinyint(4)" null="0" default="0"/>
<field name="params" type="text" null="0"/>
<key name="PRIMARY" unique="1" columns="user_id,category_id"/>
<key name="category_subscribed" columns="category_id,subscribed"/>
<key name="role" columns="role"/>
</table>
<table name="kunena_user_read">
<field primary_key="yes" name="user_id" type="int(11)" null="0"/>
<field primary_key="yes" name="topic_id" type="int(11)" null="0"/>
<field name="category_id" type="int(11)" null="0"/>
<field name="message_id" type="int(11)" null="0"/>
<field name="time" type="datetime" null="0"/>
<key name="user_topic_id" unique="1" columns="user_id,topic_id"/>
<key name="category_user_id" columns="category_id,user_id"/>
<key name="time" columns="time"/>
</table>
<table name="kunena_user_topics">
<field primary_key="yes" name="user_id" type="int(11)" null="0" default="0"/>
<field primary_key="yes" name="topic_id" type="int(11)" null="0" default="0"/>
<field name="category_id" type="int(11)" null="0"/>
<field name="posts" type="mediumint(

" null="0" default="0"/>
<field name="last_post_id" type="int(11)" null="0" default="0"/>
<field name="owner" type="tinyint(4)" null="0" default="0"/>
<field name="favorite" type="tinyint(4)" null="0" default="0"/>
<field name="subscribed" type="tinyint(4)" null="0" default="0"/>
<field name="params" type="text" null="0"/>
<key name="user_topic_id" unique="1" columns="user_id,topic_id"/>
<key name="topic_id" columns="topic_id"/>
<key name="posts" columns="posts"/>
<key name="owner" columns="owner"/>
<key name="favorite" columns="favorite"/>
<key name="subscribed" columns="subscribed"/>
</table>
<table name="kunena_users">
<field primary_key="yes" name="userid" type="int(11)" null="0" default="0"/>
<field name="view" type="varchar(

" null="0" default="flat"/>
<field name="signature" type="text" null="1"/>
<field name="moderator" type="int(11)" null="1" default="0"/>
<field name="banned" type="datetime" null="1"/>
<field name="ordering" type="int(11)" null="1" default="0"/>
<field name="posts" type="int(11)" null="1" default="0"/>
<field name="avatar" type="varchar(255)" null="1"/>
<field name="karma" type="int(11)" null="1" default="0"/>
<field name="karma_time" type="int(11)" null="1" default="0"/>
<field name="group_id" type="int(4)" null="1" default="1"/>
<field name="uhits" type="int(11)" null="1" default="0"/>
<field name="personalText" type="tinytext" null="1"/>
<field name="gender" type="tinyint(4)" null="0" default="0"/>
<field name="birthdate" type="date" null="0" default="0001-01-01"/>
<field name="location" type="varchar(50)" null="1"/>
<field name="icq" type="varchar(50)" null="1"/>
<field name="aim" type="varchar(50)" null="1"/>
<field name="yim" type="varchar(50)" null="1"/>
<field name="msn" type="varchar(50)" null="1"/>
<field name="skype" type="varchar(50)" null="1"/>
<field name="twitter" type="varchar(50)" null="1"/>
<field name="facebook" type="varchar(50)" null="1"/>
<field name="gtalk" type="varchar(50)" null="1"/>
<field name="myspace" type="varchar(50)" null="1"/>
<field name="linkedin" type="varchar(50)" null="1"/>
<field name="delicious" type="varchar(50)" null="1"/>
<field name="friendfeed" type="varchar(50)" null="1"/>
<field name="digg" type="varchar(50)" null="1"/>
<field name="blogspot" type="varchar(50)" null="1"/>
<field name="flickr" type="varchar(50)" null="1"/>
<field name="bebo" type="varchar(50)" null="1"/>
<field name="websitename" type="varchar(50)" null="1"/>
<field name="websiteurl" type="varchar(50)" null="1"/>
<field name="rank" type="tinyint(4)" null="0" default="0"/>
<field name="hideEmail" type="tinyint(1)" null="0" default="1"/>
<field name="showOnline" type="tinyint(1)" null="0" default="1"/>
<field name="thankyou" type="int(11)" null="1" default="0"/>
<key name="PRIMARY" unique="1" columns="userid"/>
<key name="group_id" columns="group_id"/>
<key name="posts" columns="posts"/>
<key name="uhits" columns="uhits"/>
<key name="banned" columns="banned"/>
<key name="moderator" columns="moderator"/>
</table>
<table name="kunena_users_banned">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="userid" type="int(11)" null="1"/>
<field name="ip" type="varchar(128)" null="1"/>
<field name="blocked" type="tinyint(4)" null="0" default="0"/>
<field name="expiration" type="datetime" null="1"/>
<field name="created_by" type="int(11)" null="0"/>
<field name="created_time" type="datetime" null="0"/>
<field name="reason_private" type="text" null="1"/>
<field name="reason_public" type="text" null="1"/>
<field name="modified_by" type="int(11)" null="1"/>
<field name="modified_time" type="datetime" null="1"/>
<field name="comments" type="text" null="1"/>
<field name="params" type="text" null="1"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="userid" columns="userid"/>
<key name="ip" columns="ip"/>
<key name="expiration" columns="expiration"/>
<key name="created_time" columns="created_time"/>
</table>
<table name="kunena_version">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="version" type="varchar(20)" null="0"/>
<field name="versiondate" type="date" null="0"/>
<field name="installdate" type="date" null="0"/>
<field name="build" type="varchar(20)" null="0"/>
<field name="versionname" type="varchar(40)" null="1"/>
<field name="state" type="text" null="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
</table>
<table name="kunenadiscuss">
<field primary_key="yes" name="content_id" type="int(11)" null="0" default="0"/>
<field name="thread_id" type="int(11)" null="0" default="0"/>
<key name="PRIMARY" unique="1" columns="content_id"/>
</table>
</schema>

Last edit: 13 years 11 months ago by Matias.

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

Matias
Offline
Administrator

13 years 11 months ago #128768 by Matias

Replied by Matias on topic Upgrade from 1.7.2 to 2.0.1 breaks in last step

There seems to be a bug if you have conflicting menu items (same alias) in Joomla! 1.5. Easiest way to fix it is to remove all menu items that relate to Kunena. After installation just publish Forum in your default menu (usually main menu) and move it if needed.

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

nyabynghi
Topic Author
Offline
Junior Member

13 years 11 months ago #128806 by nyabynghi

Replied by nyabynghi on topic Upgrade from 1.7.2 to 2.0.1 breaks in last step

Thanks. I put the forum offline, is there a way to put it back on without going through the admin panel? I can't get into forum config as I receive the "incomplete installation" notification.

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

nyabynghi
Topic Author
Offline
Junior Member

13 years 11 months ago - 13 years 11 months ago #128811 by nyabynghi

Replied by nyabynghi on topic Upgrade from 1.7.2 to 2.0.1 breaks in last step

No worries, thanks a lot for your help. I later found out that there was still a redundant forum link in the main menu (i thought I had deleted this). I deleted from menu and trash and it looks ok now.

Thanks again.

Last edit: 13 years 11 months ago by sozzled. Reason: Change topic icon to "solved"

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

Matias
Offline
Administrator

13 years 11 months ago #128826 by Matias

Replied by Matias on topic Upgrade from 1.7.2 to 2.0.1 breaks in last step

If there is incomplete installation notification, you just need to run the installer again and hope that it completes. That is the only way to prevent issues as the database has changed.

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

Time to create page: 0.252 seconds