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

This category is for K 1.7 issues only.
To get started please see K 1.6 & K 1.7 Installation Guide in our Documentation Wiki

Question How to migrate from Kunena 1.5.14 to 1.6.3 on server with MySQL 5.5.8?

More
15 years 3 months ago - 15 years 3 months ago #85276 by joomlauser
How to migrate from Kunena 1.5.14 to 1.6.3 on server with MySQL 5.5.8? was created by joomlauser
How to migrate from Kunana 1.5.22 to 1.6.3 on serwer with mysql 5.5.8?
Durign installation preparing I am getting below message:

Uncaught Exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 9 SQL=CREATE TABLE `jos_kunena_version` ( `id` int(11) NOT NULL AUTO_INCREMENT, `version` varchar(20) NOT NULL, `versiondate` date NOT NULL, `installdate` date NOT NULL, `build` varchar(20) NOT NULL, `versionname` varchar(40) DEFAULT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

My hosting provider told me I should change in sql file "Type" into "Engine"
Where can I find this file?
Last edit: 15 years 3 months ago by joomlauser.

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

More
15 years 3 months ago - 15 years 3 months ago #85343 by joomlauser
Replied by joomlauser on topic How to migrate from Kunena 1.5.14 to 1.6.3 on server with MySQL 5.5.8?
Ok maybe I will ask from another site. Which file contains the sql syntax commands, that are used by migrator script after starting migration.
Last edit: 15 years 3 months ago by joomlauser.

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

More
15 years 3 months ago #85684 by xillibit
Replied by xillibit on topic How to migrate from Kunena 1.5.14 to 1.6.3 on server with MySQL 5.5.8?
Hello,

I have reported this bug, but i don't find where the "TYPE=MyISAM" come from
I don't provide support by PM, because this can be useful for someone else.

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

More
15 years 2 months ago #86366 by joomlauser
Replied by joomlauser on topic How to migrate from Kunena 1.5.14 to 1.6.3 on server with MySQL 5.5.8?

xillibit wrote: Hello,

I have reported this bug, but i don't find where the "TYPE=MyISAM" come from


Thanks xillibit I hope this bug will be resolved in the nearest future. I can share my site for test needs.

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

More
15 years 2 months ago #86420 by Matias
Replied by Matias on topic How to migrate from Kunena 1.5.14 to 1.6.3 on server with MySQL 5.5.8?
I think that it's the command we are using.. We are asking MySQL "How to create this table" and it seems to return the original CREATE TABLE, but in modified form.. MySQL seems to be broken when you run this command..

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

More
15 years 2 months ago #86432 by joomlauser
Replied by joomlauser on topic How to migrate from Kunena 1.5.14 to 1.6.3 on server with MySQL 5.5.8?
Above problem concerns also joomla 1.5 installator. During joomla installation on server with php 5.5.8 you get error: „You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near …”

But it that case all you have to do is replacing from TYPE=MyISAM to ENGINE=MyISAM content of sql file located in installation/sql/mysql/joomla.sql

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

Time to create page: 0.238 seconds