I accidentally deleted a table using content cleaner

1

Hi,
I shouldn’t have done it but I accidentally deleted the customizer_files table using the content cleaner.

image
image892×266 31.8 KB

After that I’m unable to login to my (self-hosted) KanBoard at all. Below is the error I am getting.

Internal Error: SQL Error[42S02]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'oliyayxt_shsync1.customizer_files' doesn't exist

Let’s say if this table is created by some plugin and I disable that plugin (by running SQL in the backend) - will I be able to use KanBoard again?

Please help!

Ravi

2

A reliable backup is your friend.

  1. Remove/uninstall customizer
  2. Reset the plugin registration
    image
    image520×181 48.8 KB
  3. Reinstall customizer, this should recreate the table, of course without the table contents

Good luck.

1 Like
3

Hi had a similar problem a while ago. My data and database backup was 2 weeks old, but the backup my webspace provider did only was 5 Minutes old. So I was able to restore the KANBOARD without any data loss after a phone call with my provider.

I don’t know wheather this info can help you.

4

Thanks a lot! That worked like a charm.

Ravi.

5

I just renamed the customizer plugin folder name to .customizer and I was able to login to my KanBoard. I then purged unused plugin entries like @alfredb said and reinstalled the customizer plugin once again.

image
image605×616 23.4 KB

Thank you for the advise though. If this didn’t worked out, then I probably would’ve called my hosting provider like you suggested.

1 Like
6

What type of database are you using, and how do you backup your installation?

7

I’m running it in a shared hosting space installed via Softaculous App installer in cPanel.

8

Unfortunately, I don’t know this in detail.