andavis

I did it, the rest of the site seems ok, but the forum section is not working...

ΟΚ, 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.

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?

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?

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.

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.

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

 

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 ;

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...

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

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

I am not sure which files I have to delete, that they are not longer needed.

Can I hire someone to do this for me? 

In some way the problem is that "something" is changing all the index.php files in the server.

After restoring the /index.php and the /admin/index.php files I get this fix issue in my ACP.

Quote

Some of the source files for Invision Community have been modified.
/home/nginx/domains/michanikos.gr/public/admin/convertutf8/index.php
/home/nginx/domains/michanikos.gr/public/admin/install/index.php
/home/nginx/domains/michanikos.gr/public/admin/upgrade/index.php
/home/nginx/domains/michanikos.gr/public/api/graphql/index.php
/home/nginx/domains/michanikos.gr/public/api/index.php
/home/nginx/domains/michanikos.gr/public/oauth/authorize/index.php
/home/nginx/domains/michanikos.gr/public/oauth/callback/index.php
/home/nginx/domains/michanikos.gr/public/oauth/token/index.php
You should download an unmodified copy of those files and upload them to your server. Once that is done, check if the problem persists.

How can I get protected? Who can access and change this files? I have the latest IPS version.

16 minutes ago, teraßyte said:

What Invision Community & PHP versions are you using? Seems like the server is using the wrong PHP version.

The file initdata.php is from IP.Board 3.x, the file in 4.x is called init.php.

Can I delete initdata.php from server?

I cannot even access the site and the ACP. How can I disable them?

I am getting a HTTP ERROR 500 and the page is down.

From the server log I cann see:

[20-Sep-2023 03:27:27 UTC] PHP Fatal error:  Uncaught Error: Call to undefined function set_magic_quotes_runtime() in /home/nginx/domains/xxxxxx.com/public/initdata.php:382
Stack trace:
#0 /home/nginx/domains/xxxxxx.com/public/showthread.php(28): require_once()
#1 {main}
  thrown in /home/nginx/domains/xxxxxx.com/public/initdata.php on line 382

I tried the recovery mode solution:

But but I still cannot see the a login page (HTTP ERROR 500)

Is there any other suggestion to this?

Do we need to connect GA4 to Google Ads in order to work properly?

I think I need to hire someone to set up properly that, GA4, Google Ads, Tag etc.

There are just 10 days remaining for the migration to GA4 - Google Analytics 4.

Do we have any platform instructions for the process?

On 2/2/2023 at 10:08 PM, Daniel F said:

It sounds like you're using a custom template for the form ( check your database form option ) that contains PHP8-incompatible code.

How can I change the form template to use the default one?

We are waiting for the April release to solve that problem.

Until then we have to post every 2 hours our new content 24/7.

Oh no... Just updated to latest and this setting is a disaster for article publishers. With this option we could prepare our articles for all the week...

Please, try to resolve this! We need a solution!

Can we safely upgrade to 4.7.8?

Yes the problem still exists for the Admin account:

Is anybody still experiencing this problem?

Is there any option to mannualy opt-out all members from the newsletters?

In large communities trying to set up a newsletter reports the sender IP as spam and there is abuse problems with the server.