I’ve installed the ‘guests’ app but receiving a lot of errors mentioning a missing table ‘oc_guests_users’
NC version is 18.0.4 updated since the very beginning of OwnCloud
[no app in context] Error: Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing ‘SELECT
uid_lower = ?’ with params [""]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘nextcloud.oc_guests_users’ doesn’t exist at <>
I’ve checked the database and indeed, the table is missing.
occ maintenance:repair and deleting/ reinstalling the app didn’t help so is there any possibility to create this table manually?
try this :
– Table structure for table
DROP TABLE IF EXISTS `oc_guests_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oc_guests_users` (
`uid` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`uid_lower` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`displayname` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
`password` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
PRIMARY KEY (`uid`),
KEY `guests_user_uid_lower` (`uid_lower`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;
/*!40101 SET character_set_client = @saved_cs_client */;
You are my Hero Of The Day!
this solve my issue and everything is working as expected!
Thank you so much!