- Posts: 7245
- Thank you received: 566
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
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 New Indicator
13 years 10 months ago #127762
by Matias
Replied by Matias on topic New Indicator
Can you copy first textarea from:
/administrator/index.php?option=com_kunena&view=install&layout=schema
to here?
/administrator/index.php?option=com_kunena&view=install&layout=schema
to here?
Please Log in or Create an account to join the conversation.
13 years 10 months ago - 13 years 10 months ago #127811
by itcc
Replied by itcc on topic New Indicator
Schema Difference
Database Schema
Code:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE schema>
<schema type="diff">
<table name="kunena_announcement" action="alter">
<field name="created_by" type="int(10)" null="0" default="0" action="alter" after="title"/>
</table>
<table name="kunena_categories" action="alter">
<field name="pub_access" type="int(11)" null="1" default="1" action="alter" after="access"/>
<field name="admin_access" type="int(11)" null="1" 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>
Database Schema
Code:
<?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(10)" null="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(8)" null="0" default="0"/>
<field name="numPosts" type="mediumint(8)" 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(8) unsigned" null="0" extra="auto_increment"/>
<field name="rank_title" type="varchar(255)" null="0" default=""/>
<field name="rank_min" type="mediumint(8) 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(8)" 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(8)" 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 10 months ago by itcc.
Please Log in or Create an account to join the conversation.
13 years 10 months ago #127816
by Matias
Replied by Matias on topic New Indicator
Thank you!
We already have fix for your issue and you can do it manually by running this query (just change DB prefix #_):
Running the query multiple times is safe and cannot do any harm.
Did you have earlier version of Kunena 2.0 or did you go up straight from Kunena 1.7?
Other differences are irrelevant, but I will look into those as well.
We already have fix for your issue and you can do it manually by running this query (just change DB prefix #_):
Code:
ALTER TABLE `#__kunena_user_read` MODIFY `time` int(11) NOT NULL AFTER `message_id`;
Did you have earlier version of Kunena 2.0 or did you go up straight from Kunena 1.7?
Other differences are irrelevant, but I will look into those as well.
Please Log in or Create an account to join the conversation.
13 years 10 months ago - 13 years 10 months ago #127821
by itcc
Replied by itcc on topic New Indicator
Thanks Matias!
It seems that this query fixed the issue.
And yes, I upgraded my Kunena forum form 1.7 version to v 2.0 about a week ago.
Now, I have only two issues with recaptcha and 'Login or Register' link missing in discuss plugin.
It seems that this query fixed the issue.
And yes, I upgraded my Kunena forum form 1.7 version to v 2.0 about a week ago.
Now, I have only two issues with recaptcha and 'Login or Register' link missing in discuss plugin.
Last edit: 13 years 10 months ago by sozzled. Reason: Change topic icon to "solved"
Please Log in or Create an account to join the conversation.
13 years 10 months ago #127823
by Matias
Replied by Matias on topic New Indicator
Important question: did you first migrate to Kunena 2.0.0 RC1/2?
I'm looking into the remaining issues today.
I'm looking into the remaining issues today.
Please Log in or Create an account to join the conversation.
13 years 10 months ago - 13 years 10 months ago #127826
by itcc
Replied by itcc on topic New Indicator
It was Kunena downloaded and installed on 2012-06-29.
The creation date of Kunena according xml file is 2012-06-27.
The creation date of Kunena according xml file is 2012-06-27.
Last edit: 13 years 10 months ago by itcc.
The following user(s) said Thank You: Matias
Please Log in or Create an account to join the conversation.
Time to create page: 0.219 seconds