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 FAILED during migrate - SQL syntax error

More
15 years 3 months ago #83559 by karph
FAILED during migrate - SQL syntax error was created by karph
Hi

I getting this message during migarting from 1.5.9 to 1.6.3

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=InnoDB AUTO_INCREMENT=2 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=InnoDB AUTO_INCREMENT=2 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Im using MySQL 5.5.8 & PHP 5.3.5
I know the problem is with the TYPE=InnoDB that shuold replace with ENGINE=InnoDB for this version of MySQL.
Whare can I change it?

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

More
15 years 3 months ago #83560 by fxstein
Replied by fxstein on topic Re: FAILED during migrate - SQL syntax error
Hi,

Kunena does NOT specify the following settings:
Code:
TYPE=InnoDB AUTO_INCREMENT=2

Looks like they are setup as the defaults on your database, but as you point out they might be for an older version of mysql.

Hope this helps!
We love stars on the Joomla Extension Directory . :-)

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

More
15 years 3 months ago - 15 years 3 months ago #85261 by joomlauser
Replied by joomlauser on topic Re: FAILED during migrate - SQL syntax error
I have got the same problem any idea how to solve it? How to change default database type?

I think that the problem is using the newest MySQL version (5.5.8) on my webhosting.
probably the main reason is use of obsolete "TYPE" - apparently a new mySQL calls the word "ENGINE".
Last edit: 15 years 3 months ago by joomlauser.

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

Time to create page: 0.258 seconds