- Posts: 5
- Thank you received: 1
Kunena 6.3.0 released
The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3
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 9 months ago - 11 years 9 months ago #1
by jasperli
Upgrade from 1.7.2 to 2.0.1 breaks in last step was created by jasperli
Hello,
After upgrading to 2.0.1 the installation stops and spits out a lot of code:
I have checked /index.php?option=com_kunena&view=install&layout=schema
and it displays:
Schema difference
Database Scheme
Before upgrade i have disabled the integration plugins as well.
Please advise!
Jasper
After upgrading to 2.0.1 the installation stops and spits out a lot of code:
Code:
#0 KunenaError::checkDatabaseError() called at [/var/www/clients/client2/web4/web/administrator/components/com_kunena/libraries/forum/category/helper.php:437] #1 KunenaForumCategoryHelper::fixAliases() called at [/var/www/clients/client2/web4/web/administrator/components/com_kunena/install/model.php:674] #2 KunenaModelInstall->stepFinish() #3 call_user_func(Array ([0] => KunenaModelInstall Object ([] => 1,[] => ,[] => Array (),[] => Array (),[] => ,[] => ,[] => Array ([0] => Array ([prefix] => kunena_,[table] => kunena_version),[1] => Array ([prefix] => fb_,[table] => fb_version)),[] => ,[steps] => Array ([0] => Array ([step] => ,[menu] => Select an Installation or Upgrade Option),[1] => Array ([step] => Prepare,[menu] => Prepare Installation),[2] => Array ([step] => Extract,[menu] => Extract Component),[3] => Array ([step] => Plugins,[menu] => Install Plug-ins),[4] => Array ([step] => Database,[menu] => Update Database),[5] => Array ([step] => Finish,[menu] => Finish Installation),[6] => Array ([step] => ,[menu] => Installation completed)),[] => JDatabaseMySQLi Object ([name] => mysqli,[] => `,[] => 0000-00-00 00:00:00,[] => 5.0.4,[] => c225skileraar,[] => mysqli Object ([affected_rows] => ,[client_info] => ,[client_version] => ,[connect_errno] => ,[connect_error] => ,[errno] => ,[error] => ,[field_count] => ,[host_info] => ,[info] => ,[insert_id] => ,[server_info] => ,[server_version] => ,[sqlstate] => ,[protocol_version] => ,[thread_id] => ,[warning_count] => ),[] => 0,[] => ,[] => ,[] => 0,[] => Array (),[] => 0,[] => UPDATE #__kunena_aliases AS a INNER JOIN #__kunena_categories AS c ON a.alias = c.alias SET a.item = c.id WHERE a.type='catid',[] => jos_,[] => 1,[] => 1267,[] => Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=UPDATE jos_kunena_aliases AS a INNER JOIN jos_kunena_categories AS c ON a.alias = c.alias SET a.item = c.id WHERE a.type='catid',[] => ,[] => Array ()),[] => install,[] => com_kunena,[] => JObject Object ([] => Array (),[default_max_time] => 30,[max_time] => 300,[task] => 0,[action] => upgrade,[step] => 5,[version] => stdClass Object ([id] => 17,[version] => 1.7.2,[versiondate] => 2012-01-31,[installdate] => 2012-05-06,[build] => 5215,[versionname] => Omega,[state] => ,[prefix] => kunena_,[component] and more.....
I have checked /index.php?option=com_kunena&view=install&layout=schema
and it displays:
Schema difference
Code:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE schema>
<schema type="diff">
<table name="kunena_announcement" action="alter">
<field name="title" type="tinytext" null="0" action="alter" after="id"/>
</table>
</schema>
Database Scheme
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="1"/>
<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>
</schema>
Before upgrade i have disabled the integration plugins as well.
Please advise!
Jasper
Last edit: 11 years 9 months ago by jasperli.
Please Log in or Create an account to join the conversation.
11 years 9 months ago #2
by Matias
Replied by Matias on topic Upgrade from 1.7.2 to 2.0.1 breaks in last step
I think I know what's happening, but I'm not 100% sure why.
Can you run these 3 queries in phpMyAdmin (remember to put your prefix instead of #_) and tell which one of those fails:
Can you run these 3 queries in phpMyAdmin (remember to put your prefix instead of #_) and tell which one of those fails:
Code:
UPDATE #__kunena_aliases AS a INNER JOIN #__kunena_categories AS c ON a.alias = c.alias SET a.item = c.id WHERE a.type='catid';
DELETE a FROM #__kunena_aliases AS a LEFT JOIN #__kunena_categories AS c ON a.item = c.id WHERE a.type='catid' AND c.id IS NULL;
INSERT IGNORE INTO #__kunena_aliases (alias, type, item) SELECT alias, 'catid' AS type, id AS item FROM #__kunena_categories WHERE alias!='';
Please Log in or Create an account to join the conversation.
11 years 9 months ago - 11 years 9 months ago #3
by jasperli
Replied by jasperli on topic Upgrade from 1.7.2 to 2.0.1 breaks in last step
Hello Matthias,
It is the first one that break:
With this error message:
I have checked the kunena tables through phpmyadmin and yes there are some tables with unicode_ci and some with general_ci. My database collation is set to unicode_ci standard because of the multi language website.
Jasper
It is the first one that break:
Code:
UPDATE #__kunena_aliases AS a INNER JOIN #__kunena_categories AS c ON a.alias = c.alias SET a.item = c.id WHERE a.TYPE='catid';
With this error message:
Code:
#1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
I have checked the kunena tables through phpmyadmin and yes there are some tables with unicode_ci and some with general_ci. My database collation is set to unicode_ci standard because of the multi language website.
Jasper
Last edit: 11 years 9 months ago by jasperli.
Please Log in or Create an account to join the conversation.
11 years 8 months ago #4
by jasperli
Replied by jasperli on topic Upgrade from 1.7.2 to 2.0.1 breaks in last step
Hello Matthias,
Could you maybe give me a hand how to solve this one?
I don't know what to do to get my forum alive again
a fresh install of kunena on the same webserver works wit no errors. But then offcourse, i'll loose all my posts.
Jasper
Could you maybe give me a hand how to solve this one?
I don't know what to do to get my forum alive again
a fresh install of kunena on the same webserver works wit no errors. But then offcourse, i'll loose all my posts.Jasper
Please Log in or Create an account to join the conversation.
11 years 8 months ago #5
by Aviticus
Replied by Aviticus on topic Upgrade from 1.7.2 to 2.0.1 breaks in last step
I have the same errors. I set upgraded from 1.7.2 to 2.0.1 on my test site and the same errors are appear in both the backend and frontend. Any help would be greatly appreciated.
Please Log in or Create an account to join the conversation.
11 years 7 months ago #6
by jasperli
Replied by jasperli on topic [solved] Upgrade from 1.7.2 to 2.0.1 breaks in last step
Fixed!
In phpmyadmin run these two queries and then upgrade kunena:
ALTER TABLE jos_kunena_aliases CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_ci';
ALTER TABLE jos_kunena_categories CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_ci';
Jasper
In phpmyadmin run these two queries and then upgrade kunena:
ALTER TABLE jos_kunena_aliases CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_ci';
ALTER TABLE jos_kunena_categories CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_ci';
Jasper
The following user(s) said Thank You: chetanmadaan
Please Log in or Create an account to join the conversation.
Time to create page: 0.518 seconds