- Posts: 23
- 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
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
11 years 8 months ago - 11 years 8 months ago #1
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
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>
<!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: 11 years 8 months ago by Matias.
Please Log in or Create an account to join the conversation.
11 years 8 months ago #2
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.
11 years 8 months ago #3
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.
11 years 8 months ago - 11 years 8 months ago #4
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.
Thanks again.
Last edit: 11 years 8 months ago by sozzled. Reason: Change topic icon to "solved"
Please Log in or Create an account to join the conversation.
11 years 8 months ago #5
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.480 seconds