Accidentally deleted 'whats_new' table

ℹ️ Support
1

I was a bit thorough when cleaning up a years old database, and accidentally deleted my “oc_whats_new” table.

Now of course the error log is being flooded with Nextcloud not being able to find it:
An exception occurred while executing 'SELECT * FROM 'oc_whats_new' WHERE 'version' = ?' with params ["20.0.10"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.oc_whats_new' doesn't exist

So, my question is - how would I go about recreating that table? I unfortunately haven’t found any info on this table. Been looking on and off for several months now. Any help would be appreciated! Thank you all for your time :slight_smile:

Someone just giving me a pastebin dump of their table would also work - only if this table doesn’t contain any sensitive data of course!

2

So you’ve now learned the most important IT lesson “Always create a backup BEFORE you’re changing anything!” :wink:

> describe oc_whats_new;
+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| id         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| version    | varchar(64)      | NO   | UNI | 11      |                |
| etag       | varchar(64)      | NO   |     |         |                |
| last_check | int(10) unsigned | NO   |     | 0       |                |
| data       | longtext         | NO   |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+```
1 Like
3

Cheers mate!
Let’s just say, I should have done a dump before taking the snapshot.

1 Like