×
Kunena 5.2 Beta 1 Released (24 Sep 2020)

The Kunena team is thrilled to announce the first public beta release of Kunena 5.2, a native Joomla extension for Joomla 3.9. This is a development release and should be only be used for testing; this version is not recommended for live websites at this stage.

The purpose of this release is to encourage testing by downloading, installing and identifying any problems or shortcomings that people may discover. K 5.2.0 B1 is stable and we are aware that people will discover defects. We encourage you to use the forum to report defects, as soon as they are discovered, so that the development team can work through the problems before the release of K 5.1 as a stable product. Reporting defects does not mean that the problems can or will be fixed. The Kunena team is looking forward to hearing your feedback on how well we have achieved our design goals.

× 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 Kunena 2.0.2 error 1005

More
7 years 10 months ago #1 by dimeoscuro
Hi :) , I recently had problems with my forum, just stopped working and I returned error database, restore a database backup that worked well and the error was the same. As I could not fix it, I decided to uninstall it and reinstall it, but now I can not install it and it returns the following error:
1005 - Se ha producido un error.
Can't create table 'jardinmysql.jn17_kunena_topics' (errno: -1) SQL=CREATE TABLE `jn17_kunena_topics` ( `id` int(11) NOT NULL auto_increment, `category_id` int(11) NOT NULL default '0', `subject` tinytext NULL, `icon_id` int(11) NOT NULL default '0', `locked` tinyint(4) NOT NULL default '0', `hold` tinyint(4) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `posts` int(11) NOT NULL default '0', `hits` int(11) NOT NULL default '0', `attachments` int(11) NOT NULL default '0', `poll_id` int(11) NOT NULL default '0', `moved_id` int(11) NOT NULL default '0', `first_post_id` int(11) NOT NULL default '0', `first_post_time` int(11) NOT NULL default '0', `first_post_userid` int(11) NOT NULL default '0', `first_post_message` text NULL, `first_post_guest_name` tinytext NULL, `last_post_id` int(11) NOT NULL default '0', `last_post_time` int(11) NOT NULL default '0', `last_post_userid` int(11) NOT NULL default '0', `last_post_message` text NULL, `last_post_guest_name` tinytext NULL, `params` text NOT NULL, PRIMARY KEY (id), KEY `category_id` (category_id), KEY `locked` (locked), KEY `hold` (hold), KEY `posts` (posts), KEY `hits` (hits), KEY `first_post_userid` (first_post_userid), KEY `last_post_userid` (last_post_userid), KEY `first_post_time` (first_post_time), KEY `last_post_time` (last_post_time) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
 

Can you help? Greetings!

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

More
7 years 10 months ago #2 by xillibit
Replied by xillibit on topic Kunena 2.0.2 error 1005
Hello,

Backup the data of your table jn17_kunena_topics not the structure in a safe place then delete the table et recreate it by using the query that you have in message et import the data.

What MySQL version are-you using ?

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
7 years 10 months ago #3 by dimeoscuro
Replied by dimeoscuro on topic Kunena 2.0.2 error 1005
Hi, thanks for replying. ;)
The mysql version is 5.5. Well, let's try that. And I'll have to do the same, table by table, if I start showing the same error with the following tables to install?

Greetings!

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

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.085 seconds