Author Topic: PHP fatal error with `models` table  (Read 6533 times)

Offline mheadroom

  • Newbie
  • *
  • Posts: 1
  • Helpful: +0/-0
PHP fatal error with `models` table
« on: 2017-02-09, 07:19:19 pm »
Updated to version 0.6.9.0 and started having this php fatal error pop up in the PHP error log:
Code: [Select]
[07-Feb-2017 21:52:12 America/Chicago] PHP Fatal error:  Uncaught exception 'lithium\data\model\QueryException' with message 'DESCRIBE `models`: Table 'nzedb.models' doesn't exist' in /var/www/nzedb/libraries/lithium/data/source/Database.php:1604
Stack trace:
#0 /var/www/nzedb/libraries/lithium/aop/Filters.php(231): lithium\data\source\Database->lithium\data\source\{closure}(Array)
#1 /var/www/nzedb/libraries/lithium/data/source/Database.php(1605): lithium\aop\Filters::run(Object(lithium\data\source\database\adapter\MySql), '_error', Array, Object(Closure))
#2 /var/www/nzedb/libraries/lithium/data/source/database/adapter/MySql.php(406): lithium\data\source\Database->_error('DESCRIBE `model...')
#3 /var/www/nzedb/libraries/lithium/aop/Filters.php(231): lithium\data\source\database\adapter\MySql->lithium\data\source\database\adapter\{closure}(Array)
#4 /var/www/nzedb/libraries/lithium/data/source/database/adapter/MySql.php(409): lithium\aop\Filters::run(Object(lithium\data\source\database\adapter\MySql), '_execute', Array, Object(Closure))
#5 /var/www/nzedb/libraries in /var/www/nzedb/libraries/lithium/data/source/Database.php on line 1604

The `models` table doesn't exist, and I ran a fresh install elsewhere to confirm it isn't being created. As a work-around I created the table with `id` and `name` columns, and this error disappeared from the logs -- but the table is now being populated with tons empty rows:
Code: [Select]
mysql> select * from models order by id desc limit 0,2;
+--------+------+
| id     | name |
+--------+------+
| 364072 |      |
| 364071 |      |
+--------+------+

It's either a bug or my database is pooched and I can't seem to recover from that. Any suggestions? thx

Offline drakejones

  • Junior Indexer
  • **
  • Posts: 29
  • Helpful: +3/-0
Re: PHP fatal error with `models` table
« Reply #1 on: 2017-02-20, 06:38:44 am »
I'm getting similar errors:

Code: [Select]
Every 2.0s: tail -s 30 /var/www/nZEDb/resources/logs/php_errors.log                                                                                                                                      Mon Feb 20 15:37:19 2017

Stack trace:
#0 /var/www/nZEDb/libraries/lithium/aop/Filters.php(231): lithium\data\source\Database->lithium\data\source\{closure}(Array)
#1 /var/www/nZEDb/libraries/lithium/data/source/Database.php(1605): lithium\aop\Filters::run(Object(lithium\data\source\database\adapter\MySql), '_error', Array, Object(Closure))
#2 /var/www/nZEDb/libraries/lithium/data/source/database/adapter/MySql.php(406): lithium\data\source\Database->_error('SELECT `Setting...')
#3 /var/www/nZEDb/libraries/lithium/aop/Filters.php(231): lithium\data\source\database\adapter\MySql->lithium\data\source\database\adapter\{closure}(Array)
#4 /var/www/nZEDb/libraries/lithium/data/source/database/adapter/MySql.php(409): lithium\aop\Fil in /var/www/nZEDb/libraries/lithium/data/source/Database.php on line 1604
[20-Feb-2017 15:36:33 Europe/Rome] PHP Warning:  stream_socket_client(): SSL: Handshake timed out in /var/www/nZEDb/libs/PEAR/Net_NNTP/NNTP/Protocol/Client.php on line 514
[20-Feb-2017 15:36:33 Europe/Rome] PHP Warning:  stream_socket_client(): Failed to enable crypto in /var/www/nZEDb/libs/PEAR/Net_NNTP/NNTP/Protocol/Client.php on line 514
[20-Feb-2017 15:36:33 Europe/Rome] PHP Warning:  stream_socket_client(): unable to connect to tls://news.eu.usenetserver.com:563 (Unknown error) in /var/www/nZEDb/libs/PEAR/Net_NNTP/NNTP/Protocol/Client.php on line 514
[20-Feb-2017 15:36:33 Europe/Rome] PHP Notice:  Only variables should be assigned by reference in /usr/share/php/PEAR.php on line 601