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.

Question Upgrade from K2.0 to K.2.0.1 SQL failed

More
13 years 10 months ago #128144 by NickJWStone
Upgrade from K2.0 to K.2.0.1 SQL failed was created by NickJWStone
Hi,

just tried to update the forum from K2.0 to K2.0.1

got the following error and status failed:
SQL Query: UPDATE #__kunena_polls_users AS a INNER JOIN #__kunena_topics AS t ON t.id=a.pollid LEFT JOIN #__kunena_polls AS p ON p.id=a.pollid SET a.pollid=t.poll_id WHERE t.poll_id>0 AND p.id IS NULL

any solution?

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

More
13 years 10 months ago #128148 by 810
Replied by 810 on topic Upgrade from K2.0 to K.2.0.1 SQL failed
Hi, does the poll worked before?

can you check /administrator/index.php?option=com_kunena&view=install&layout=schema

and paste the results here.


regards 810

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

More
13 years 10 months ago #128150 by NickJWStone
Replied by NickJWStone on topic Upgrade from K2.0 to K.2.0.1 SQL failed
Hi,

Polls were working before.

here the requested results:

Schema difference:
Code:
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE schema> <schema type="diff"> <table name="kunenadiscuss" action="unknown"/> </schema>

and

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(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="0"/> <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="int(11)" 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>

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

More
13 years 10 months ago - 13 years 10 months ago #128152 by 810
Replied by 810 on topic Upgrade from K2.0 to K.2.0.1 SQL failed
can you do the sql manualy :
UPDATE #__kunena_polls_users AS a INNER JOIN #__kunena_topics AS t ON t.id=a.pollid LEFT JOIN #__kunena_polls AS p ON p.id=a.pollid SET a.pollid=t.poll_id WHERE t.poll_id>0 AND p.id IS NULL

replace
#_ = with your own prefix
Last edit: 13 years 10 months ago by 810.

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

More
13 years 10 months ago - 13 years 10 months ago #128153 by NickJWStone
Replied by NickJWStone on topic Upgrade from K2.0 to K.2.0.1 SQL failed
Gives the following error:

MySQL retourneerde:
#1054 - Unknown column 'gt' in 'where clause'


The edited SQL gives the following:

#1062 - Duplicate entry '1-42' for key 'pollid'

Last edit: 13 years 10 months ago by NickJWStone.

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

More
13 years 10 months ago #128156 by 810
Replied by 810 on topic Upgrade from K2.0 to K.2.0.1 SQL failed
are u using IE?

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

Time to create page: 0.260 seconds