SQL Error



  • New user here. Just installed Shinobi from git head.

    ccio.Files is created by framework.sql:

    CREATE TABLE IF NOT EXISTS Files (
    ke varchar(50) NOT NULL,
    mid varchar(50) NOT NULL,
    name tinytext NOT NULL,
    size float NOT NULL DEFAULT '0',
    details text NOT NULL,
    status int(1) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

    Notice no 'date' field. But 'pm2 log' shows this error:

    1|cron | sqlMessage: 'Unknown column 'date' in 'where clause'',
    1|cron | sqlState: '42S22',
    1|cron | index: 0,
    1|cron | sql: 'SELECT * FROM Files WHERE ke='D7MWu1WAu6' AND date < DATE_SUB(NOW(), INTERVAL 10 DAY)' }

    Looks like the problem line is in cron.js on line 374.

        var fileBinQuery = " FROM Files WHERE ke=? AND `date` < "+s.sqlDate('? D

 

Looks like your connection to Shinobi Forum was lost, please wait while we try to reconnect.