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.

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

More
11 years 9 months ago #1 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
11 years 9 months ago #2 by 810
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
11 years 9 months ago #3 by NickJWStone
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
11 years 9 months ago - 11 years 9 months ago #4 by 810
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: 11 years 9 months ago by 810.

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

More
11 years 9 months ago - 11 years 9 months ago #5 by NickJWStone
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: 11 years 9 months ago by NickJWStone.

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

More
11 years 9 months ago #6 by 810
are u using IE?

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

More
11 years 9 months ago - 11 years 9 months ago #7 by NickJWStone
I am at the moment, will try it in Firefox right now

update: same error in Firefox
Last edit: 11 years 9 months ago by NickJWStone.

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

More
11 years 9 months ago #8 by 810
use this:

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 t.id!=t.poll_id AND p.id IS NULL

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

More
11 years 9 months ago #9 by NickJWStone
Gives the same error

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

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

More
11 years 9 months ago #10 by 810
So did the poll worked on K2.0 or on K1.7

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

Time to create page: 0.379 seconds