'guests' app: missing table 'oc_guests_users'

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 , displayname FROM oc_guests_users WHERE 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?

Thanks!

Hey,
try this :

– Table structure for table oc_guests_users

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 */; 

Good luck

You are my Hero Of The Day! :prince:

this solve my issue and everything is working as expected!
Thank you so much!