pron lettura ddt e creazione 2.4.9

netcall

dasc3er wrote:
Se hai fatto fare una personalizzazione, contattaci via mail così da poter risolvere il problema...
Cosa che ti consiglio comunque di fare perché non ho idea di come sia la query che viene utilizzata e che produce l'errore.

Ho risolto!,

Era un prob. della query dei ddt, ho cancellato quella che c'era dalla precedente versione e lasciato il suo di default e funziona ora.!

ho notato solo un pic. prob sulle fatture.. non mi mostra la riga totale per ogni singola fattura.. prima usciva l'importo della fattura ora invece e vuoto, mentre se premo ed entro nella fattura me lo mostra.

Per caso sarà anche qua un prob di query o come posso far visualizzare i totali ?

dasc3er

È un problema noto della 2.4.9, se cerchi tra gli altri post trovi la soluzione. 😃

netcall

Ciao, buongiorno

Si si sto usando la 2.4.9 , ho fatto fare a voi qualche modifica ma questa no per niente.
In ogni caso mi sai dire come cancellare questa query ?

dasc3er

Se hai fatto fare una personalizzazione, contattaci via mail così da poter risolvere il problema...
Cosa che ti consiglio comunque di fare perché non ho idea di come sia la query che viene utilizzata e che produce l'errore.

netcall

Ciao a tutti, dopo aggiornamento funziona pare tutto tranne i ddt non li legge proprio

mi da questo errore

Si è verificato un'errore [uid: 7a6bd09]. Se il problema persiste siete pregati di chiedere assistenza tramite la sezione Bug.
Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'destinatari.ragione_sociale' in 'field list'" at /web/htdocs/www.mgm-industry.com/home/ManagerMGM/src/Database.php line 239

Si è verificato un'errore [uid: 7a6bd09]. Se il problema persiste siete pregati di chiedere assistenza tramite la sezione Bug.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'destinatari.ragione_sociale' in 'field list'

netcall

dasc3er wrote:
Cancella il file, ricarica la pagina e posta i contenuti del file.

caricata... qualche news?

dasc3er

Il problema causato da destinatari.ragione_sociale non è presente nella versioni di base del gestionale, quindi suppongo tu abbia personalizzato la query che evidentemente ora dà problemi.

Per quanto riguarda il problema apparente select * from zz_hook_cache where (hook_id = 2) order by key desc limit 1, dovrebbe essere risolto con la versione stabile della 2.4.9, che dovresti aver scaricato?

netcall

se puo' essere utile , appena premo su ddt in uscita mi esce fuori questa scritta da premere ok

DataTables warning: table id=main_50 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

dasc3er

Cancella il file, ricarica la pagina e posta i contenuti del file.

netcall

ok. metto tutto quel che mi ha messo nel file logs error.

[2019-05-23 10:37:10] Logs.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'destinatari.ragione_sociale' in 'field list'" at /web/htdocs/www.miosito.com/home/Manager/src/Database.php line 239 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'destinatari.ragione_sociale' in 'field list' at /web/htdocs/www.miosito.com/home/Manager/src/Database.php:239)"}
{"url":"/Manager/ajax_dataload.php?id_module=26&id_plugin=&id_parent=&draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=false&columns%5B0%5D%5Borderable%5D=false&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=2&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=3&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=4&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=5&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=true&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=6&columns%5B6%5D%5Bname%5D=&columns%5B6%5D%5Bsearchable%5D=true&columns%5B6%5D%5Borderable%5D=true&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B7%5D%5Bdata%5D=7&columns%5B7%5D%5Bname%5D=&columns%5B7%5D%5Bsearchable%5D=true&columns%5B7%5D%5Borderable%5D=true&columns%5B7%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B7%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B8%5D%5Bdata%5D=8&columns%5B8%5D%5Bname%5D=&columns%5B8%5D%5Bsearchable%5D=true&columns%5B8%5D%5Borderable%5D=true&columns%5B8%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B8%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B9%5D%5Bdata%5D=9&columns%5B9%5D%5Bname%5D=&columns%5B9%5D%5Bsearchable%5D=true&columns%5B9%5D%5Borderable%5D=true&columns%5B9%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B9%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=171&search%5Bvalue%5D=&search%5Bregex%5D=false&=1558600629960","ip":"82.61.55.55","http_method":"GET","server":"www.miosito.com","referrer":"http://www.miosito.com/Manager/controller.php?id_module=26","unique_id":"XOZbtr52jBxy2uBUgdTrggAAAAE","uid":"8e2e0a7"}
[2019-05-23 10:37:10] Logs.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'destinatari.ragione_sociale' in 'field list' {"code":"42S22","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'destinatari.ragione_sociale' in 'field list'","file":"/web/htdocs/www.miosito.com/home/Manager/src/Database.php","line":239,"trace":"#0 /web/htdocs/www.miosito.com/home/Manager/src/Database.php(239): PDO->prepare('SELECT COUNT()...')\n#1 /web/htdocs/www.miosito.com/home/Manager/src/Database.php(313): Database->fetchArray('SELECT COUNT()...', Array)\n#2 /web/htdocs/www.miosito.com/home/Manager/ajax_dataload.php(40): Database->fetchNum('SELECT dt_ddt.i...')\n#3 {main}"}
{"url":"/Manager/ajax_dataload.php?id_module=26&id_plugin=&id_parent=&draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=false&columns%5B0%5D%5Borderable%5D=false&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=2&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=3&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=4&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=5&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=true&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=6&columns%5B6%5D%5Bname%5D=&columns%5B6%5D%5Bsearchable%5D=true&columns%5B6%5D%5Borderable%5D=true&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B7%5D%5Bdata%5D=7&columns%5B7%5D%5Bname%5D=&columns%5B7%5D%5Bsearchable%5D=true&columns%5B7%5D%5Borderable%5D=true&columns%5B7%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B7%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B8%5D%5Bdata%5D=8&columns%5B8%5D%5Bname%5D=&columns%5B8%5D%5Bsearchable%5D=true&columns%5B8%5D%5Borderable%5D=true&columns%5B8%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B8%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B9%5D%5Bdata%5D=9&columns%5B9%5D%5Bname%5D=&columns%5B9%5D%5Bsearchable%5D=true&columns%5B9%5D%5Borderable%5D=true&columns%5B9%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B9%5D%5Bsearch%5D%5Bregex%5D=false&start=0&length=171&search%5Bvalue%5D=&search%5Bregex%5D=false&=1558600629960","ip":"82.61.55.55","http_method":"GET","server":"www.miosito.com","referrer":"http://www.miosito.com/Manager/controller.php?id_module=26","unique_id":"XOZbtr52jBxy2uBUgdTrggAAAAE","uid":"8e2e0a7"}
[2019-05-23 10:37:11] Logs.ERROR: Uncaught Exception Illuminate\Database\QueryException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * from zz_hook_cache where (hook_id = 1) order by key desc limit 1)" at /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php line 647 {"exception":"[object] (Illuminate\Database\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * from zz_hook_cache where (hook_id = 1) order by key desc limit 1) at /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php:647, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' at /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php:319)"}
{"url":"/Manager/ajax.php?op=hook&id=1","ip":"82.61.55.55","http_method":"GET","server":"www.miosito.com","referrer":"http://www.miosito.com/Manager/controller.php?id_module=26","unique_id":"XOZbtjbcf05yPyFwmO3k-gAAAAQ","uid":"6929748"}
[2019-05-23 10:37:11] Logs.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * from zz_hook_cache where (hook_id = 1) order by key desc limit 1) {"code":"42S22","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * from zz_hook_cache where (hook_id = 1) order by key desc limit 1)","file":"/web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php","line":647,"trace":"#0 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select * from ...', Array, Object(Closure))\n#1 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php(326): Illuminate\\Database\\Connection->run('select * from...', Array, Object(Closure))\n#2 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Query/Builder.php(1706): Illuminate\Database\Connection->select('select * from ...', Array, true)\n#3 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Query/Builder.php(1690): Illuminate\\Database\\Query\\Builder->runSelect()\n#4 /web/htdocs/www.miosito.com/home/Manager/src/Database.php(480): Illuminate\\Database\\Query\\Builder->get()\n#5 /web/htdocs/www.miosito.com/home/Manager/src/Database.php(503): Database->select('zz_hook_cache', '*', Array, Array, 1, false)\n#6 /web/htdocs/www.miosito.com/home/Manager/src/Models/Hook.php(77): Database->selectOne('zz_hook_cache', '*', Array, Array)\n#7 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(432): Models\\Hook->getCacheAttribute(NULL)\n#8 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(333): Illuminate\\Database\\Eloquent\\Model->mutateAttribute('cache', NULL)\n#9 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(306): Illuminate\\Database\\Eloquent\\Model->getAttributeValue('cache')\n#10 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Model.php(1279): Illuminate\\Database\\Eloquent\\Model->getAttribute('cache')\n#11 /web/htdocs/www.miosito.com/home/Manager/src/Models/Hook.php(22): Illuminate\\Database\\Eloquent\\Model->__get('cache')\n#12 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(432): Models\\Hook->getIsCachedAttribute(NULL)\n#13 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(333): Illuminate\\Database\\Eloquent\\Model->mutateAttribute('is_cached', NULL)\n#14 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(306): Illuminate\\Database\\Eloquent\\Model->getAttributeValue('is_cached')\n#15 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Model.php(1279): Illuminate\\Database\\Eloquent\\Model->getAttribute('is_cached')\n#16 /web/htdocs/www.miosito.com/home/Manager/src/Models/Hook.php(46): Illuminate\\Database\\Eloquent\\Model->__get('is_cached')\n#17 /web/htdocs/www.miosito.com/home/Manager/ajax.php(104): Models\\Hook->execute()\n#18 {main}"} {"url":"/Manager/ajax.php?op=hook&id=1","ip":"82.61.55.55","http_method":"GET","server":"www.miosito.com","referrer":"http://www.miosito.com/Manager/controller.php?id_module=26","unique_id":"XOZbtjbcf05yPyFwmO3k-gAAAAQ","uid":"6929748"} [2019-05-23 10:37:11] Logs.ERROR: Uncaught Exception Illuminate\Database\QueryException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * fromzz_hook_cachewhere (hook_id= 3) order bykeydesc limit 1)" at /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php line 647 {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * fromzz_hook_cachewhere (hook_id= 3) order bykeydesc limit 1) at /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php:647, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' at /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php:319)"} {"url":"/Manager/ajax.php?op=hook&id=3","ip":"82.61.55.55","http_method":"GET","server":"www.miosito.com","referrer":"http://www.miosito.com/Manager/controller.php?id_module=26","unique_id":"XOZbtm7zmqoPsUq-kLRjngAAAAM","uid":"ed411d7"} [2019-05-23 10:37:11] Logs.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * fromzz_hook_cachewhere (hook_id= 3) order bykeydesc limit 1) {"code":"42S22","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * fromzz_hook_cachewhere (hook_id= 3) order bykeydesc limit 1)","file":"/web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php","line":647,"trace":"#0 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php(607): Illuminate\\Database\\Connection->runQueryCallback('select * from...', Array, Object(Closure))\n#1 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php(326): Illuminate\Database\Connection->run('select * from ...', Array, Object(Closure))\n#2 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Query/Builder.php(1706): Illuminate\\Database\\Connection->select('select * from...', Array, true)\n#3 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Query/Builder.php(1690): Illuminate\Database\Query\Builder->runSelect()\n#4 /web/htdocs/www.miosito.com/home/Manager/src/Database.php(480): Illuminate\Database\Query\Builder->get()\n#5 /web/htdocs/www.miosito.com/home/Manager/src/Database.php(503): Database->select('zz_hook_cache', '', Array, Array, 1, false)\n#6 /web/htdocs/www.miosito.com/home/Manager/src/Models/Hook.php(77): Database->selectOne('zz_hook_cache', '', Array, Array)\n#7 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(432): Models\Hook->getCacheAttribute(NULL)\n#8 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(333): Illuminate\Database\Eloquent\Model->mutateAttribute('cache', NULL)\n#9 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(306): Illuminate\Database\Eloquent\Model->getAttributeValue('cache')\n#10 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Model.php(1279): Illuminate\Database\Eloquent\Model->getAttribute('cache')\n#11 /web/htdocs/www.miosito.com/home/Manager/src/Models/Hook.php(22): Illuminate\Database\Eloquent\Model->get('cache')\n#12 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(432): Models\Hook->getIsCachedAttribute(NULL)\n#13 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(333): Illuminate\Database\Eloquent\Model->mutateAttribute('is_cached', NULL)\n#14 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(306): Illuminate\Database\Eloquent\Model->getAttributeValue('is_cached')\n#15 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Model.php(1279): Illuminate\Database\Eloquent\Model->getAttribute('is_cached')\n#16 /web/htdocs/www.miosito.com/home/Manager/src/Models/Hook.php(46): Illuminate\Database\Eloquent\Model->get('is_cached')\n#17 /web/htdocs/www.miosito.com/home/Manager/ajax.php(104): Models\Hook->execute()\n#18 {main}"}
{"url":"/Manager/ajax.php?op=hook&id=3","ip":"82.61.55.55","http_method":"GET","server":"www.miosito.com","referrer":"http://www.miosito.com/Manager/controller.php?id_module=26","unique_id":"XOZbtm7zmqoPsUq-kLRjngAAAAM","uid":"ed411d7"}
[2019-05-23 10:37:11] Logs.ERROR: Uncaught Exception Illuminate\Database\QueryException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * from zz_hook_cache where (hook_id = 4) order by key desc limit 1)" at /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php line 647 {"exception":"[object] (Illuminate\Database\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * from zz_hook_cache where (hook_id = 4) order by key desc limit 1) at /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php:647, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' at /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php:319)"}
{"url":"/Manager/ajax.php?op=hook&id=4","ip":"82.61.55.55","http_method":"GET","server":"www.miosito.com","referrer":"http://www.miosito.com/Manager/controller.php?id_module=26","unique_id":"XOZbtls3URPqisr6b-lWcQAAAAA","uid":"9e98e5d"}
[2019-05-23 10:37:11] Logs.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * from zz_hook_cache where (hook_id = 4) order by key desc limit 1) {"code":"42S22","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * from zz_hook_cache where (hook_id = 4) order by key desc limit 1)","file":"/web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php","line":647,"trace":"#0 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select * from ...', Array, Object(Closure))\n#1 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php(326): Illuminate\\Database\\Connection->run('select * from...', Array, Object(Closure))\n#2 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Query/Builder.php(1706): Illuminate\Database\Connection->select('select * from ...', Array, true)\n#3 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Query/Builder.php(1690): Illuminate\\Database\\Query\\Builder->runSelect()\n#4 /web/htdocs/www.miosito.com/home/Manager/src/Database.php(480): Illuminate\\Database\\Query\\Builder->get()\n#5 /web/htdocs/www.miosito.com/home/Manager/src/Database.php(503): Database->select('zz_hook_cache', '*', Array, Array, 1, false)\n#6 /web/htdocs/www.miosito.com/home/Manager/src/Models/Hook.php(77): Database->selectOne('zz_hook_cache', '*', Array, Array)\n#7 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(432): Models\\Hook->getCacheAttribute(NULL)\n#8 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(333): Illuminate\\Database\\Eloquent\\Model->mutateAttribute('cache', NULL)\n#9 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(306): Illuminate\\Database\\Eloquent\\Model->getAttributeValue('cache')\n#10 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Model.php(1279): Illuminate\\Database\\Eloquent\\Model->getAttribute('cache')\n#11 /web/htdocs/www.miosito.com/home/Manager/src/Models/Hook.php(22): Illuminate\\Database\\Eloquent\\Model->__get('cache')\n#12 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(432): Models\\Hook->getIsCachedAttribute(NULL)\n#13 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(333): Illuminate\\Database\\Eloquent\\Model->mutateAttribute('is_cached', NULL)\n#14 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(306): Illuminate\\Database\\Eloquent\\Model->getAttributeValue('is_cached')\n#15 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Model.php(1279): Illuminate\\Database\\Eloquent\\Model->getAttribute('is_cached')\n#16 /web/htdocs/www.miosito.com/home/Manager/src/Models/Hook.php(46): Illuminate\\Database\\Eloquent\\Model->__get('is_cached')\n#17 /web/htdocs/www.miosito.com/home/Manager/ajax.php(104): Models\\Hook->execute()\n#18 {main}"} {"url":"/Manager/ajax.php?op=hook&id=4","ip":"82.61.55.55","http_method":"GET","server":"www.miosito.com","referrer":"http://www.miosito.com/Manager/controller.php?id_module=26","unique_id":"XOZbtls3URPqisr6b-lWcQAAAAA","uid":"9e98e5d"} [2019-05-23 10:37:12] Logs.ERROR: Uncaught Exception Illuminate\Database\QueryException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * fromzz_hook_cachewhere (hook_id= 2) order bykeydesc limit 1)" at /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php line 647 {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * fromzz_hook_cachewhere (hook_id= 2) order bykeydesc limit 1) at /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php:647, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' at /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php:319)"} {"url":"/Manager/ajax.php?op=hook&id=2","ip":"82.61.55.55","http_method":"GET","server":"www.miosito.com","referrer":"http://www.miosito.com/Manager/controller.php?id_module=26","unique_id":"XOZbthm53kwiFZiABc-MfwAAAAU","uid":"1cf6c7f"} [2019-05-23 10:37:12] Logs.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * fromzz_hook_cachewhere (hook_id= 2) order bykeydesc limit 1) {"code":"42S22","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'order clause' (SQL: select * fromzz_hook_cachewhere (hook_id= 2) order bykeydesc limit 1)","file":"/web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php","line":647,"trace":"#0 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php(607): Illuminate\\Database\\Connection->runQueryCallback('select * from...', Array, Object(Closure))\n#1 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Connection.php(326): Illuminate\Database\Connection->run('select * from ...', Array, Object(Closure))\n#2 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Query/Builder.php(1706): Illuminate\\Database\\Connection->select('select * from...', Array, true)\n#3 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Query/Builder.php(1690): Illuminate\Database\Query\Builder->runSelect()\n#4 /web/htdocs/www.miosito.com/home/Manager/src/Database.php(480): Illuminate\Database\Query\Builder->get()\n#5 /web/htdocs/www.miosito.com/home/Manager/src/Database.php(503): Database->select('zz_hook_cache', '', Array, Array, 1, false)\n#6 /web/htdocs/www.miosito.com/home/Manager/src/Models/Hook.php(77): Database->selectOne('zz_hook_cache', '', Array, Array)\n#7 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(432): Models\Hook->getCacheAttribute(NULL)\n#8 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(333): Illuminate\Database\Eloquent\Model->mutateAttribute('cache', NULL)\n#9 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(306): Illuminate\Database\Eloquent\Model->getAttributeValue('cache')\n#10 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Model.php(1279): Illuminate\Database\Eloquent\Model->getAttribute('cache')\n#11 /web/htdocs/www.miosito.com/home/Manager/src/Models/Hook.php(22): Illuminate\Database\Eloquent\Model->get('cache')\n#12 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(432): Models\Hook->getIsCachedAttribute(NULL)\n#13 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(333): Illuminate\Database\Eloquent\Model->mutateAttribute('is_cached', NULL)\n#14 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php(306): Illuminate\Database\Eloquent\Model->getAttributeValue('is_cached')\n#15 /web/htdocs/www.miosito.com/home/Manager/vendor/illuminate/database/Eloquent/Model.php(1279): Illuminate\Database\Eloquent\Model->getAttribute('is_cached')\n#16 /web/htdocs/www.miosito.com/home/Manager/src/Models/Hook.php(46): Illuminate\Database\Eloquent\Model->get('is_cached')\n#17 /web/htdocs/www.miosito.com/home/Manager/ajax.php(104): Models\Hook->execute()\n#18 {main}"}
{"url":"/Manager/ajax.php?op=hook&id=2","ip":"82.61.55.55","http_method":"GET","server":"www.miosito.com","referrer":"http://www.miosito.com/Manager/controller.php?id_module=26","unique_id":"XOZbthm53kwiFZiABc-MfwAAAAU","uid":"1cf6c7f"}

netcall

nessuno mi saì dire come risolvere?

dasc3er

Puoi condividere i contenuti della cartella logs/?

netcall

certamente, anche se e un po lungo metto. ho tolto parecchie parti xche diventava troppo lungo da mettere qua. spero che cmq riuscite a capire. bho

[2019-05-23 10:08:38] Logs.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'data_scadenza' in 'field list'" at /web/htdocs/www.miosito.com/home/Manager/src/Database.php line 239 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'data_scadenza' in 'field list' at /web/htdocs/www.miosito.com/home/Manager/src/Database.php:239)"}
{"url":"/Manager/modules/dashboard/actions.php?op=load_intreventi&mese=052019","ip":"xxx.xxx.xxx.xxx","http_method":"GET","server":"www.miosito.com","referrer":"http://www.miosito.com/Manager/controller.php?id_module=1","unique_id":"XOZVBVFhISGW8lQyJFjwEgAAAAM","uid":"6f449c1"}
[2019-05-23 10:08:38] Logs.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'data_scadenza' in 'field list' {"code":"42S22","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'data_scadenza' in 'field list'","file":"/web/htdocs/www.miosito.com/home/Manager/src/Database.php","line":239,"trace":"#0 /web/htdocs/www.miosito.com/home/Manager/src/Database.php(239): PDO->prepare('SELECT id, rich...')\n#1 /web/htdocs/www.miosito.com/home/Manager/modules/dashboard/actions.php(148): Database->fetchArray('SELECT id, rich...')\n#2 {main}"}
{"url":"/Manager/modules/dashboard/actions.php?op=load_intreventi&mese=052019","ip":"xxx.xxx.xxx.xxx","http_method":"GET","server":"www.miosito.com","referrer":"http://www.miosito.com/Manager/controller.php?id_module=1","unique_id":"XOZVBVFhISGW8lQyJFjwEgAAAAM","uid":"6f449c1"}
[2019-05-23 10:08:39] Logs.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'data_scadenza' in 'field list'" at /web/htdocs/www.miosito.com/home/Manager/src/Database.php line 239 {"exception":"[object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'data_scadenza' in 'field list' at /web/htdocs/www.miosito.com/home/Manager/src/Database.php:239)"}
{"url":"/Manager/modules/dashboard/actions.php?op=load_intreventi&mese=052019","ip":"xxx.xxx.xxx.xxx","http_method":"GET","server":"www.miosito.com","referrer":"http://www.miosito.com/Manager/controller.php?id_module=1","unique_id":"XOZVBjbcf05yPyFwmO3jOgAAAAQ","uid":"1e04d63"}
[2019-05-23 10:08:39] Logs.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'data_scadenza' in 'field list' {"code":"42S22","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'data_scadenza' in 'field list'","file":"/web/htdocs/www.miosito.com/home/Manager/src/Database.php","line":239,"trace":"#0 /web/htdocs/www.miosito.com/home/Manager/src/Database.php(239): PDO->prepare('SELECT id, rich...')\n#1 /web/htdocs/www.miosito.com/home/Manager/modules/dashboard/actions.php(148): Database->fetchArray('SELECT id, rich...')\n#2 {main}"}