title: ( sdonate) 1067 Invalid default value for 'expiretime' in /var/www/donate/install.php:
body: <p>Error when running /install.php</p>
  
  <pre><code>[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-&gt;exec('CREATE table tr...')\n#1 {main}\n  thrown in /var/www/donate/install.php on line 258
  </code></pre>
  
  <p>Lines 239-260 of install.php:</p>
  
  <pre><code>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-&gt;exec($sql);
  </code></pre>
  
  <p>}</p>
  
  <p>software: sdonate.com
  not sure how to fix it, documentation shows no solutions.</p>
  
  <p>what would be a solution?</p>