Salve,
sto riscontrando un problema in fase di aggiornamento dalla versione 2.2 (installata da circa 3 anni e migrata da vers. precedenti) a qualsiasi altra versione successiva. Ho effettuato svariati tentativi, sia tramite l'updater interno al software, sia eseguendo l'update manuale, ma il risultato è sempre lo stesso: pagina bianca con 2 righe: "Si è verificato un'errore [uid: 51d4774]".
L'url diventa nomesito#tab_1 e si blocca qua, non fa altro.
Siccome il db del software contiene molti dati che usiamo tutti i giorni (anagrafiche, articoli, ddt di vendita e di acquisto, etc.), sapreste aiutarmi a risolvere?
Questo è il contenuto del log:
[2019-06-17 16:30:04] Logs.ERROR: Uncaught Exception 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 'SHOW TABLES LIKE 'zz_modules') AS count' at line 1" at C:\wamp\www\gestionale22\src\Database.php line 239 {"exception":"[object] (PDOException(code: 42000): 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 'SHOW TABLES LIKE 'zz_modules') AS count' at line 1 at C:\wamp\www\gestionale22\src\Database.php:239)"}
{"url":"/gestionale22/","ip":"::1","http_method":"GET","server":"localhost","referrer":"http://localhost/gestionale22/controller.php?id_module=6","uid":"01c50dc"}
[2019-06-17 16:30:04] Logs.ERROR: 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 'SHOW TABLES LIKE 'zz_modules') AS count' at line 1 {"code":"42000","message":"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 'SHOW TABLES LIKE 'zz_modules') AS count' at line 1","file":"C:\wamp\www\gestionale22\src\Database.php","line":239,"trace":"#0 C:\wamp\www\gestionale22\src\Database.php(239): PDO->prepare('SELECT COUNT()...')\n#1 C:\wamp\www\gestionale22\src\Database.php(313): Database->fetchArray('SELECT COUNT()...', Array)\n#2 C:\wamp\www\gestionale22\include\custom\top.php(6): Database->fetchNum('SHOW TABLES LIK...')\n#3 C:\wamp\www\gestionale22\include\init\update.php(125): include_once('C:\\wamp\\www\\ges...')\n#4 C:\wamp\www\gestionale22\index.php(67): include_once('C:\\wamp\\www\\ges...')\n#5 {main}"}
{"url":"/gestionale22/","ip":"::1","http_method":"GET","server":"localhost","referrer":"http://localhost/gestionale22/controller.php?id_module=6","uid":"01c50dc"}
[2019-06-17 16:30:17] Logs.ERROR: Uncaught Exception 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 'SHOW TABLES LIKE 'zz_modules') AS count' at line 1" at C:\wamp\www\gestionale22\src\Database.php line 239 {"exception":"[object] (PDOException(code: 42000): 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 'SHOW TABLES LIKE 'zz_modules') AS count' at line 1 at C:\wamp\www\gestionale22\src\Database.php:239)"}
{"url":"/gestionale22/","ip":"::1","http_method":"GET","server":"localhost","referrer":null,"uid":"51d4774"}
[2019-06-17 16:30:17] Logs.ERROR: 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 'SHOW TABLES LIKE 'zz_modules') AS count' at line 1 {"code":"42000","message":"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 'SHOW TABLES LIKE 'zz_modules') AS count' at line 1","file":"C:\wamp\www\gestionale22\src\Database.php","line":239,"trace":"#0 C:\wamp\www\gestionale22\src\Database.php(239): PDO->prepare('SELECT COUNT()...')\n#1 C:\wamp\www\gestionale22\src\Database.php(313): Database->fetchArray('SELECT COUNT()...', Array)\n#2 C:\wamp\www\gestionale22\include\custom\top.php(6): Database->fetchNum('SHOW TABLES LIK...')\n#3 C:\wamp\www\gestionale22\include\init\update.php(125): include_once('C:\\wamp\\www\\ges...')\n#4 C:\wamp\www\gestionale22\index.php(67): include_once('C:\\wamp\\www\\ges...')\n#5 {main}"}
{"url":"/gestionale22/","ip":"::1","http_method":"GET","server":"localhost","referrer":null,"uid":"51d4774"}
PS:
Ovviamente, l'update lo sto facendo in ambiente di test, il software in produzione è sul server e funzionante con ver. 2.2.
