Forum topics disappeared

[andavis]

Suddenly the forum and all the ads in the page disappeared.

If i click a forum thread url I get this error:

ERR_TOO_MANY_REDIRECTS

 

 

 

[Marc]

I would advise on checking your database to see what is in the forums_forums table. You dont appear to have any forums, when looking in your admin CP

 

[Miss_B]

Are there any detailed error messages logged in at the System Logs page in the Admin Panel?

[Marc]

Just checked this, and seems not

[Randy Calvert]

Is there anything in the admin log to reflect something was deleted by a human via ACP?

[Marc]

13 minutes ago, Randy Calvert said:

Is there anything in the admin log to reflect something was deleted by a human via ACP?

Nope

[andavis]

At the "Get Support" page in the ACP I had some suggestion to fix in the database section and I accepted them.

[Marc]

As mentioned above, you need to check that table. At present you appear to have no forums. If that is the case, its very likely you need to revert to backup here

[andavis]

OK I recovered a backup, the forum was OK for some hours and now again the same errors. 

At the Get support page there is also a database error...

[Randy Calvert]

Check the database table again...  did that table get removed again?  If so, it sounds like a problem with your hosting provider.  I'm assuming you have not installed any 3rd party resources recently.  If so, have you confirmed they're removed as the source of the problem by removing them?

[Miss_B]

8 minutes ago, andavis said:

At the Get support page there is also a database error...

What does it say? 

[andavis]

Quote

There are some problems with your database. Normally it is safe to try to fix these problems automatically however if your community is large, you may want to run the necessary queries manually. If so, the queries to run are:

ALTER TABLE `ipb_core_clubs` DROP INDEX `location_lat`, ADD KEY `location_lat` (`location_lat`,`location_long`), ADD KEY `type` (`type`), ADD KEY `name` (`name`(191)), ADD KEY `content` (`content`), ADD KEY `last_activity` (`last_activity`);

CREATE TABLE `ipb_forums_forums_new` LIKE `ipb_forums_forums`;

ALTER TABLE `ipb_forums_forums_new` ADD COLUMN `id` SMALLINT NOT NULL AUTO_INCREMENT , ADD COLUMN `topics` INT UNSIGNED NOT NULL DEFAULT 0 , ADD COLUMN `password` VARCHAR (32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , ADD COLUMN `password_override` VARCHAR (255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , ADD COLUMN `last_title` VARCHAR (255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , ADD COLUMN `qa_rate_questions` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , ADD COLUMN `solved_stats_from_cutoff` INT NOT NULL DEFAULT 0 , ADD PRIMARY KEY (`id`), ADD KEY `forum_password` (`password`), DROP INDEX `widget_performance`, ADD KEY `widget_performance` (`min_posts_view`,`password`(20),`password_override`(160),`can_view_others`);

INSERT IGNORE INTO `ipb_forums_forums_new` SELECT * FROM `ipb_forums_forums`;

DROP TABLE `ipb_forums_forums`;

RENAME TABLE `ipb_forums_forums_new` TO `ipb_forums_forums`;

ALTER TABLE `ipb_gallery_images` ADD KEY `image_file_size` (`image_file_size`), ADD KEY `image_views` (`image_views`);

ALTER TABLE `ipb_cms_databases` ADD COLUMN `database_comments_perpage` TINYINT NOT NULL DEFAULT 0 ;

or

There are some problems with your database. Normally it is safe to try to fix these problems automatically however if your community is large, you may want to run the necessary queries manually. If so, the queries to run are:
ALTER TABLE `ipb_core_clubs` DROP INDEX `location_lat`, ADD KEY `location_lat` (`location_lat`,`location_long`), ADD KEY `type` (`type`), ADD KEY `name` (`name`(191)), ADD KEY `content` (`content`), ADD KEY `last_activity` (`last_activity`);
CREATE TABLE `ipb_forums_forums_new` LIKE `ipb_forums_forums`;
ALTER TABLE `ipb_forums_forums_new` ADD COLUMN `id` SMALLINT NOT NULL AUTO_INCREMENT , ADD COLUMN `topics` INT UNSIGNED NOT NULL DEFAULT 0 , ADD COLUMN `password` VARCHAR (32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , ADD COLUMN `password_override` VARCHAR (255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , ADD COLUMN `last_title` VARCHAR (255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , ADD COLUMN `qa_rate_questions` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL , ADD COLUMN `solved_stats_from_cutoff` INT NOT NULL DEFAULT 0 , ADD PRIMARY KEY (`id`), ADD KEY `forum_password` (`password`), DROP INDEX `widget_performance`, ADD KEY `widget_performance` (`min_posts_view`,`password`(20),`password_override`(160),`can_view_others`);
INSERT IGNORE INTO `ipb_forums_forums_new` SELECT * FROM `ipb_forums_forums`;
DROP TABLE `ipb_forums_forums`;
RENAME TABLE `ipb_forums_forums_new` TO `ipb_forums_forums`;
ALTER TABLE `ipb_gallery_images` ADD KEY `image_file_size` (`image_file_size`), ADD KEY `image_views` (`image_views`);
ALTER TABLE `ipb_cms_databases` ADD COLUMN `database_comments_perpage` TINYINT NOT NULL DEFAULT 0 ;

Edited January 15 by andavis

[Jim M]

Does the data disappear when you run the fix on that?  

[andavis]

When I did that all the forums disappeared.

Marc checked and said:

8 hours ago, Marc Stridgen said:

I would advise on checking your database to see what is in the forums_forums table. You dont appear to have any forums, when looking in your admin CP

 

 

[Jim M]

1 minute ago, andavis said:

When I did that all the forums disappeared.

Marc checked and said:

 

Sorry, let me rephrase what I meant. After you did the restore, did you run that again and that is when the data disappeared again?

[Nathan Explosion]

Which of these is the order of things happening?

Option 1:

1. You ran the support tool, and actioned its suggestions
2. and then your forums disappeared

Option 2:

1. Your forums disappeared so...
2. You then ran the support tool, and actioned its suggestions.

[andavis]

No after the restore I didn't run anything, just waiting to check that everything was allright.

But two hours ago the same problem appeared.

[Jim M]

2 minutes ago, andavis said:

No after the restore I didn't run anything, just waiting to check that everything was allright.

But two hours ago the same problem appeared.

I would advise contacting your hosting provider then to see what is happening on the server. Ultimately, I would think that something is happening on the server to have this happen.

If they are unsure, you can also do another restore of your database and simplify your environment. Disable any third party applications/plugins, integrations, APIs, etc... Only have the core software touching your database.

[andavis]

2 minutes ago, Nathan Explosion said:

Which of these is the order of things happening?

Option 1:

1. You ran the support tool, and actioned its suggestions
2. and then your forums disappeared

Option 2:

1. Your forums disappeared so...
2. You then ran the support tool, and actioned its suggestions.

Earlier today I did the option 1, so I restored a backup and problem solved for 2-3 hours.

Now the same problem with the database and some other suggestion in the Get Support page come again and I am looking for a solution.

[Marc]

As mentioned by my colleague above, you really need to contact your hosting company on this. If things are disapearing without any interaction from yourself, its probably way outside of your software that this is happening

[andavis]

It is the 3rd time I am restoring the forum from a backup and after 2 hours the same problem.

I get a critical update error for database issues.

Can anybody from Invision Team check for a solution?

[Jim M]

I would advise checking that with your hosting provider because something is happening when that executes. It is best for your hosting provider to review what is happening.

[andavis]

The hosting insist that there isn't any other problem in the server.

The database errors I can get from the Get Support page are:

There are some problems with your database. Normally it is safe to try to fix these problems automatically however if your community is large, you may want to run the necessary queries manually. If so, the queries to run are:
CREATE TABLE `ipb_forums_forums_new` LIKE `ipb_forums_forums`;

ALTER TABLE `ipb_forums_forums_new` ADD COLUMN `id` SMALLINT NOT NULL AUTO_INCREMENT , ADD COLUMN `topics` INT UNSIGNED NOT NULL DEFAULT 0 , ADD COLUMN `posts` INT UNSIGNED NOT NULL DEFAULT 0 , ADD

COLUMN `last_post` INT NULL , ADD PRIMARY KEY (`id`);

INSERT IGNORE INTO `ipb_forums_forums_new` SELECT * FROM `ipb_forums_forums`;

DROP TABLE `ipb_forums_forums`;

RENAME TABLE `ipb_forums_forums_new` TO `ipb_forums_forums`;

--

Are there any recomendations from you?

[Jim M]

You would need to have them execute those commands on your database and see what happens. Explain to them that when the software does it, the database encounters problems.

[andavis]

ΟΚ, so you also believe that this queries are correct and will probably solve the problem? The last time I run them the website was down and there were no forum catogories, post etc.