Shinobi sqlite install is broken
I tried quite a few combinations now, but basically any way I try, the install using sqlite (I only am planning on controlling two cameras, so a full mysql database seems overblown) is broken.
I tried:
testing and stable
Centos7, Ubuntu 18.04, Ubuntu 17.10
Originally LXC containers, but full VMs are also not working.
Only Error in the logs is the following:
s.sqlQuery QUERY ERRORED CREATE TABLE IF NOT EXISTS `Cloud Videos` (`mid` varchar(50) NOT NULL,`ke` varchar(50) DEFAULT NULL,`href` text NOT NULL,`size` float DEFAULT NULL,`time` timestamp NULL DEFAULT NULL,`end` timestamp NULL DEFAULT NULL,`status` int(1) DEFAULT '0' COMMENT '0:Complete,1:Read,2:Archive',`details` text) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
0|camera | s.sqlQuery ERROR { Error: CREATE TABLE IF NOT EXISTS `Cloud Videos` (`mid` varchar(50) NOT NULL,`ke` varchar(50) DEFAULT NULL,`href` text NOT NULL,`size` float DEFAULT NULL,`time` timestamp NULL DEFAULT NULL,`end` timestamp NULL DEFAULT NULL,`status` int(1) DEFAULT '0' COMMENT '0:Complete,1:Read,2:Archive',`details` text) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; - SQLITE_ERROR: near "COMMENT": syntax error
0|camera | at Error (native) errno: 1, code: 'SQLITE_ERROR' }
0|camera | { Error: CREATE TABLE IF NOT EXISTS `Cloud Videos` (`mid` varchar(50) NOT NULL,`ke` varchar(50) DEFAULT NULL,`href` text NOT NULL,`size` float DEFAULT NULL,`time` timestamp NULL DEFAULT NULL,`end` timestamp NULL DEFAULT NULL,`status` int(1) DEFAULT '0' COMMENT '0:Complete,1:Read,2:Archive',`details` text) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; - SQLITE_ERROR: near "COMMENT": syntax error
0|camera | at Error (native) errno: 1, code: 'SQLITE_ERROR' }
Most of the time, the web ui comes up fine, but trying to log in will just reload the page quickly and not show any errors, but also not logging in.
If you need any further information, please dont hesitate to ask.
Edited by Moe