Please help. I want to install the update Version 4.7.20 of Invision Community, but I'm getting this error:

IPS\Db\Exception: Table 'admin_board.core_output_cache' doesn't exist (1146)

 

IPS\Db\Exception: Table 'admin_board.core_output_cache' doesn't exist (1146)

What version are you trying to upgrade from? The error message indicates that core_output_cache table doesn't exist. Can you check the database and see if that's indeed the case? If that table is indeed missing, you can re add it and give the upgrade another go.

Please check your database to see if that table is present. If it isnt, you would need to revert back to your backup first of all, as we need to determine why this has happened. Once reverted:

• Check the database to see if the table exists

• Go to system>Support, and ensure there is nothing showing under the database section (including recommendations). If there is, address those first

• Try the upgrade again

Hi, thanks for the advice. My current version is v4.7.19.

I checked the database, and indeed, there is no "core_output_cache" table.
Recently, our forum had issues due to a lack of disk space. This might have caused the table to be missing from the database.

I'll check how far I can roll back from backups.
Thanks!

Edited March 19Mar 19 by Digital Storm

Please check the support area of your admin CP first of all, and see whats showing there

 

I'll check how far I can roll back from backups.

Before you roll back to a previous backup, try to re add that table first and see if it would help. You can take its schema from your most recent backup file to add it to the database. Hopefully that would be enough and you won't have to revert back to a previous backup.

 

Before you roll back to a previous backup, try to re add that table first and see if it would help. You can take its schema from your most recent backup file to add it to the database. Hopefully that would be enough and you won't have to revert back to a previous backup.

^ please do not do this. As I have said above, I would like the users to check the support area of the admin CP. If it cannot be corrected from there, we need to take a look at the instance to see why his may be the case. I completely understand you are attempting to work around the issue, but this will simply mean this happens over and over, without an actual resolution to the cause.

 

^ please do not do this. As I have said above, I would like the users to check the support area of the admin CP. If it cannot be corrected from there, we need to take a look at the instance to see why his may be the case. I completely understand you are attempting to work around the issue, but this will simply mean this happens over and over, without an actual resolution to the cause.

I hear you. Personally I think that since the OP has already run the upgrader and it has stopped at the aforementioned error, recreating the missing table is the quickest way to see if the missing table is the only issue, or there are other issues. If the former, then the upgrade will be performed successfully and the diagnosing can be performed afterwards. Like that no content will be lost if the recent database backup isn't so recent.

If there will be additional issues after the re adding of the missing table, then a backup roll back is in order and they can go from there.

Anyways, that's my personal opinion on the matter, and I think that I am entitled to it. The OP is free to do as they please.

Thank you for your advice. What should I do if I can't roll back from backups and System → Support is showing database errors?

 

Thank you for your advice. What should I do if I can't roll back from backups and System → Support is showing database errors?

Is this due to not having he backups, or something else? Please update all access details on file and we can log in to take a look. However the first thing that you do need to do there is ensure you are on PHP 8.1

Yes, it’s because we don’t have any backups. I’ve installed PHP 8.1 and updated the Access Information in the Client Area so you can log in and check.

Please let us know how we can fix this error.

I will need to escalate this for you. Before you continue anywhere though, please take a full backup. You should really be taking regular backups, and if you are upgrading, take a backup first

Unfortunately, I’m unable to create a database backup because I’m getting this error

mysqldump: Got error: 1146: Table 'admin_board.core_output_cache' doesn't exist when using LOCK TABLES

 

Unfortunately, I’m unable to create a database backup because I’m getting this error

mysqldump: Got error: 1146: Table 'admin_board.core_output_cache' doesn't exist when using LOCK TABLES

Seeing the fact that you don't have a backup, what you can do is install the same version of Ipb that you are running on your main site to a test folder, using a separate database and then export the missing table from there and add it to the database of your main forum.

 

Seeing the fact that you don't have a backup, what you can do is install the same version of Ipb that you are running on your main site to a test folder, using a separate database and then export the missing table from there and add it to the database of your main forum.

Sounds like a plan. Thank you!

If you are getting that error when you are trying to make a backup, you really need to contact your hosting company on this, as this looks to be what is causing you the core issue. If the table is missing entirely, you should still be able to backup your site. So something is wrong on your server there

 

Sounds like a plan. Thank you!

No problem. Here, I can save you some time. This is the table structure of Ipb 4.7.20. Copy the below code and paste it to the SQL box of your forum's database phpmyadmin. If you are using a prefix for your database table, append it to the table name in the query before you run it. After you run the query, make a backup of the database. Hopefully this is the only issue with your database and you will be able to finish the upgrade.

DROP TABLE IF EXISTS core_output_cache;

CREATE TABLE core_output_cache (

cache_key varchar(100) NOT NULL DEFAULT '' COMMENT 'The key',

cache_value longtext NOT NULL COMMENT 'The output HTML',

cache_meta mediumtext NOT NULL COMMENT 'JSON headers and meta data',

cache_expire int(11) NOT NULL DEFAULT 0 COMMENT 'Unix timestamp of when the cache expires'

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Edited March 21Mar 21 by Miss_B

 

mysqldump: Got error: 1146: Table 'admin_board.core_output_cache' doesn't exist when using LOCK TABLES

I forgot to ask, do you manage your own Vps?Dedicated Box, or are you on a shared hosting?

 

No problem. Here, I can save you some time. This is the table structure of Ipb 4.7.20. Copy the below code and paste it to the SQL box of your forum's database phpmyadmin. If you are using a prefix for your database table, append it to the table name in the query before you run it. After you run the query, make a backup of the database. Hopefully this is the only issue with your database and you will be able to finish the upgrade.

DROP TABLE IF EXISTS core_output_cache;

CREATE TABLE core_output_cache (

cache_key varchar(100) NOT NULL DEFAULT '' COMMENT 'The key',

cache_value longtext NOT NULL COMMENT 'The output HTML',

cache_meta mediumtext NOT NULL COMMENT 'JSON headers and meta data',

cache_expire int(11) NOT NULL DEFAULT 0 COMMENT 'Unix timestamp of when the cache expires'

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Hi! Your advice helped me fix the issue and successfully complete the update. We’re on our own VPS.

Thank you for the helpful tip, and have a great day! :)

 

Hi! Your advice helped me fix the issue and successfully complete the update. We’re on our own VPS.

Thank you for the helpful tip, and have a great day! :)

Happy to have been of help! :)