- Posts: 1
- Thank you received: 1
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 section is for questions directly related to the procedure for installing Kunena for the first time or upgrading from an older version of Kunena.
Use this category:
Use a different category to ask questions about problems that you may be having after you successfully installed or upgraded the currently supported version. If you are unsure what is the current supported version of Kunena, please go to the download page.
Use this category:
- to ask how to install or upgrade; or
- if you encountered problems during the installation or upgrade procedure.
Use a different category to ask questions about problems that you may be having after you successfully installed or upgraded the currently supported version. If you are unsure what is the current supported version of Kunena, please go to the download page.
Question error: "Kunena Installation Failed!"
- Olivier @ Octopoos
-
- Offline
- New Member
-
Less
More
9 years 1 day ago #185222
by Olivier @ Octopoos
Replied by Olivier @ Octopoos on topic error: "Kunena Installation Failed!"
Hi everyone,
We've encountered this error on a MySql database with a utf8mb4_unicode_ci collation.
The issue comes from the query that tries to create the #__kunena_attachments table because the index for this table is too long. To fix this, we've previously created the table through this query where we've reduced the size of the 'filename' and 'filename_real' columns from 255 to 190:
CREATE TABLE `#__kunena_attachments` (`id` int(11) NOT NULL auto_increment,`mesid` int(11) NOT NULL default '0',`userid` int(11) NOT NULL default '0',`protected` tinyint(4) NOT NULL default '0',`hash` char(32) NULL,`size` int(11) NULL,`folder` varchar(255) NOT NULL,`filetype` varchar(20) NOT NULL,`filename` varchar(190) NOT NULL,`filename_real` varchar(190) NOT NULL default '',`caption` varchar(255) NOT NULL default '',PRIMARY KEY (id),KEY `mesid` (mesid),KEY `userid` (userid),KEY `hash` (hash),KEY `filename` (filename),KEY `filename_real` (filename_real) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
After this, we've been able to install Kunena 5.0.7 without any other issue. There may be some other checks to do with posts attachments but at least, Kunena is installed!
We've encountered this error on a MySql database with a utf8mb4_unicode_ci collation.
The issue comes from the query that tries to create the #__kunena_attachments table because the index for this table is too long. To fix this, we've previously created the table through this query where we've reduced the size of the 'filename' and 'filename_real' columns from 255 to 190:
CREATE TABLE `#__kunena_attachments` (`id` int(11) NOT NULL auto_increment,`mesid` int(11) NOT NULL default '0',`userid` int(11) NOT NULL default '0',`protected` tinyint(4) NOT NULL default '0',`hash` char(32) NULL,`size` int(11) NULL,`folder` varchar(255) NOT NULL,`filetype` varchar(20) NOT NULL,`filename` varchar(190) NOT NULL,`filename_real` varchar(190) NOT NULL default '',`caption` varchar(255) NOT NULL default '',PRIMARY KEY (id),KEY `mesid` (mesid),KEY `userid` (userid),KEY `hash` (hash),KEY `filename` (filename),KEY `filename_real` (filename_real) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
After this, we've been able to install Kunena 5.0.7 without any other issue. There may be some other checks to do with posts attachments but at least, Kunena is installed!
The following user(s) said Thank You: xillibit
The topic has been locked.
8 years 11 months ago #185252
by xillibit
I don't provide support by PM, because this can be useful for someone else.
Replied by xillibit on topic error: "Kunena Installation Failed!"
@Olivier @ Octopoos : thanks for your feedback, i have made the change it should be integrated into Kunena 5.0.8
I don't provide support by PM, because this can be useful for someone else.
The topic has been locked.
8 years 10 months ago - 8 years 10 months ago #186538
by Hutchy68
Replied by Hutchy68 on topic error: "Kunena Installation Failed!"
Updating from 5.0.7 to 5.0.8 failed on PHP 7. Manually set back PHP to 5.6.x and updated by uploading package. 5.0.8 to 5.0.9, failed again on PHP 7, setting PHP to 5.6.x and updated by uploading package. So IMO it is not fixed. Do users have to do the database fix manually?
Last edit: 8 years 10 months ago by Hutchy68.
The topic has been locked.
8 years 10 months ago #186556
by xillibit
I don't provide support by PM, because this can be useful for someone else.
Replied by xillibit on topic error: "Kunena Installation Failed!"
The fix is only for clean installation of Kunena, so in your case by just doing an update of Kunena you aren't concerned by this fix.
I don't provide support by PM, because this can be useful for someone else.
The topic has been locked.
5 years 1 day ago #217224
by fridi
Replied by fridi on topic error: "Kunena Installation Failed!"
Still the same error in J3.9.26 on PHP7.4 with a first time install of K5.2.4. So what is the solution?
The topic has been locked.
5 years 23 hours ago #217226
by rich
Important! Always create a backup before you make any changes to your website!
Replied by rich on topic error: "Kunena Installation Failed!"
== Topic closed ==
Do not reopen any age-old topics. This topic has been created 4 years ago, so it can't be the same error.
Enable the debug mode, then try again the installation, and if you get error messages, create an own topic with this information, please.
Do not reopen any age-old topics. This topic has been created 4 years ago, so it can't be the same error.
Enable the debug mode, then try again the installation, and if you get error messages, create an own topic with this information, please.
Important! Always create a backup before you make any changes to your website!
The topic has been locked.
Time to create page: 0.299 seconds