Oc_properties table gone missing

ℹ️ Support
1

It would seem that my install doesn’t have the table ‘oc_properties’… I’m not sure why it disapered.

But i am currently not in a position to re-install… and this had been a NC that i have had for a long time.

Could someone post the schema for this table i will try and rebuild the table to see if this fixes the issue.

This currently prevents my remote clients from updating.

The logs are showing:

Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing ‘SELECT * FROM oc_properties WHERE userid = ? AND propertypath = ? AND propertyname in (?)’ with params [“alainm”, “/”, “{http://owncloud.org/ns}checksums”]: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘admin_muzecloud.oc_properties’ doesn’t exist

[/details]

Nextcloud version (eg, 18.0.2): 18.0.1
Operating system and version (eg, Ubuntu 20.04): Ubuntu 16.04
Apache or nginx version (eg, Apache 2.4.25): both
PHP version (eg, 7.1): 7.2

Is this the first time you’ve seen this error? (Y/N): N

2

Here it is (NC 18.0.4):

MariaDB [nextcloud]> describe oc_properties;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| userid        | varchar(64)  | NO   | MUL |         |                |
| propertypath  | varchar(255) | NO   |     |         |                |
| propertyname  | varchar(255) | NO   |     |         |                |
| propertyvalue | longtext     | NO   |     | NULL    |                |
| id            | bigint(20)   | NO   | PRI | NULL    | auto_increment |
+---------------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)