php - ( sdonate) 1067/var/www/donate/install.php : 中 'expiretime' 的默认值无效

Question

运行/install.php时出错

[Sat Nov 10 20:43:26.241729 2018] [:error] [pid 25855] [client 108.162.237.55:35442] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\r\n                endcommands TEXT,\r\n                transactionid TEXT,\r\n      ' at line 9 in /var/www/donate/install.php:258\nStack trace:\n#0 /var/www/donate/install.php(258): PDO->exec('CREATE table tr...')\n#1 {main}\n  thrown in /var/www/donate/install.php on line 258

install.php 的第 239-260 行:

if(tableExists($dbcon, 'transactions') === FALSE){
    $sql = "CREATE table transactions(
            id INT(11) AUTO_INCREMENT PRIMARY KEY,
            time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            purchaser TEXT,
            usernametype TEXT,
            username TEXT,
            game TEXT,
            expires INT(1),
            expiretime ,
            endcommands TEXT,
            transactionid TEXT,
            package TEXT,
            packageid TEXT,
            paymentmethod TEXT,
            value DECIMAL(11,2),
            status TEXT,
            params TEXT);";
    $dbcon->exec($sql);

}

软件:sdon​​ate.com不确定如何修复它，文档没有显示解决方案。

解决方案是什么？

Answer 1

expiretime 字段没有数据类型，因此出现语法错误。您需要提供数据类型(可能是基于字段名称的日期时间)。