OrderSprinter-Forum

von **Imbiss** » So 5. Jul 2026, 21:19

Nach 3 Tagen im Einsatz -> keine Probleme...

Läuft im Restaurant-Modus, hat aber auch Vorteile für mich zwecks der Unterscheidung für Bar oder Kartenzahlung.

Problem Stufe ich für mich als gelöst ein.

Grüße Daniel

von **Imbiss** » Mi 1. Jul 2026, 10:46

Hallo,

anbei der Log von Sonntag. Vielleicht bringt der neue Erkenntnisse. Ich habe zwischenzeitlich auch den Monitor für die Kundenansicht deaktivier, schien eine kurze Verbesserung gebracht zu haben, danach gleiches Problem.

Es läuft nur eine Session.

Ich spiele jetzt nochmal ein altes Backup ein, bringe nur meine Artikel in neuen Menülisten zum laufen (die Ur-Artikel, lösche ich dieses mal nicht)
Schnellkasse und dann hoffen wir mal dass es einen Unterschied bringt.

Code: Alles auswählen

[Sun Jun 28 02:16:19.075544 2026] [mpm_prefork:notice] [pid 774:tid 774] AH00163: Apache/2.4.66 (Debian) configured -- resuming normal operations
[Sun Jun 28 02:16:19.075705 2026] [core:notice] [pid 774:tid 774] AH00094: Command line: '/usr/sbin/apache2'
[Sun Jun 28 10:19:29.011674 2026] [php:error] [pid 13901:tid 13901] [client 172.0.0.4:56866] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 10:44:10.819446 2026] [php:error] [pid 14480:tid 14480] [client 172.0.0.4:57540] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 10:44:29.877631 2026] [php:error] [pid 14611:tid 14611] [client 172.0.0.4:57545] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 10:46:01.328971 2026] [php:error] [pid 13155:tid 13155] [client 172.0.0.4:57578] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 10:46:13.149638 2026] [php:error] [pid 15241:tid 15241] [client 172.0.0.4:57603] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 10:46:36.459126 2026] [php:error] [pid 15231:tid 15231] [client 172.0.0.4:57609] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 10:56:38.790854 2026] [php:error] [pid 12813:tid 12813] [client 172.0.0.4:57787] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 10:57:06.803406 2026] [php:error] [pid 15231:tid 15231] [client 172.0.0.4:57801] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 10:57:22.332897 2026] [php:error] [pid 15241:tid 15241] [client 172.0.0.4:57812] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:18:29.914197 2026] [php:error] [pid 15236:tid 15236] [client 172.0.0.4:58351] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:18:47.542138 2026] [php:error] [pid 15241:tid 15241] [client 172.0.0.4:58355] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:27:36.742210 2026] [mpm_prefork:notice] [pid 774:tid 774] AH00170: caught SIGWINCH, shutting down gracefully
[Sun Jun 28 11:27:55.497394 2026] [mpm_prefork:notice] [pid 787:tid 787] AH00163: Apache/2.4.66 (Debian) configured -- resuming normal operations
[Sun Jun 28 11:27:55.509514 2026] [core:notice] [pid 787:tid 787] AH00094: Command line: '/usr/sbin/apache2'
[Sun Jun 28 11:27:56.521907 2026] [php:error] [pid 805:tid 805] [client 172.0.0.4:58550] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/admin.php:860\nStack trace:\n#0 /var/www/html/php/admin.php(2156): Admin->getMessage()\n#1 /var/www/html/php/admin.php(446): Admin->getWaiterMessage()\n#2 /var/www/html/php/contenthandler.php(72): Admin->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/admin.php on line 860, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:27:56.524762 2026] [php:error] [pid 800:tid 800] [client 172.0.0.4:58578] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/queuecontent.php(3061): CommonUtils::getConfigValue()\n#2 /var/www/html/php/queuecontent.php(108): QueueContent::getliveorders()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568, referer: http://172.0.0.3/customersview.php?v=2.9.12
[Sun Jun 28 11:27:56.526361 2026] [php:error] [pid 803:tid 803] [client 172.0.0.4:58575] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/queuecontent.php(3061): CommonUtils::getConfigValue()\n#2 /var/www/html/php/queuecontent.php(108): QueueContent::getliveorders()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568, referer: http://172.0.0.3/customersview.php?v=2.9.12
[Sun Jun 28 11:27:56.527229 2026] [php:error] [pid 799:tid 799] [client 172.0.0.4:58547] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:497\nStack trace:\n#0 /var/www/html/php/queuecontent.php(3047): CommonUtils::execSql()\n#1 /var/www/html/php/queuecontent.php(105): QueueContent::updateliveorders()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/commonutils.php on line 497, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:27:56.527914 2026] [php:error] [pid 806:tid 806] [client 172.0.0.4:58552] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:483\nStack trace:\n#0 /var/www/html/php/roomtables.php(307): CommonUtils::fetchSqlAll()\n#1 /var/www/html/php/roomtables.php(95): Roomtables->getAllTablesAndRooms()\n#2 /var/www/html/php/roomtables.php(29): Roomtables->showAllRooms()\n#3 /var/www/html/php/contenthandler.php(81): Roomtables->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 483, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:27:56.529146 2026] [php:error] [pid 800:tid 800] [client 172.0.0.4:58556] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/queuecontent.php(3061): CommonUtils::getConfigValue()\n#2 /var/www/html/php/queuecontent.php(108): QueueContent::getliveorders()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568, referer: http://172.0.0.3/customersview.php?v=2.9.12
[Sun Jun 28 11:27:56.530234 2026] [php:error] [pid 805:tid 805] [client 172.0.0.4:58579] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/queuecontent.php(3061): CommonUtils::getConfigValue()\n#2 /var/www/html/php/queuecontent.php(108): QueueContent::getliveorders()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568, referer: http://172.0.0.3/customersview.php?v=2.9.12
[Sun Jun 28 11:27:56.531067 2026] [php:error] [pid 803:tid 803] [client 172.0.0.4:58553] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/products.php:1153\nStack trace:\n#0 /var/www/html/php/products.php(167): Products->getAllGeneralComments()\n#1 /var/www/html/php/contenthandler.php(78): Products->handleCommand()\n#2 {main}\n  thrown in /var/www/html/php/products.php on line 1153, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:27:56.538384 2026] [php:error] [pid 800:tid 800] [client 172.0.0.4:58580] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:497\nStack trace:\n#0 /var/www/html/php/queuecontent.php(3047): CommonUtils::execSql()\n#1 /var/www/html/php/queuecontent.php(105): QueueContent::updateliveorders()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/commonutils.php on line 497, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:27:56.539166 2026] [php:error] [pid 799:tid 799] [client 172.0.0.4:58576] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/tablemap.php:181\nStack trace:\n#0 /var/www/html/php/tablemap.php(433): TableMap::getTableMapPreferences()\n#1 {main}\n  thrown in /var/www/html/php/tablemap.php on line 181, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:27:56.559758 2026] [php:error] [pid 803:tid 803] [client 172.0.0.4:58583] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/queuecontent.php(3061): CommonUtils::getConfigValue()\n#2 /var/www/html/php/queuecontent.php(108): QueueContent::getliveorders()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568, referer: http://172.0.0.3/customersview.php?v=2.9.12
[Sun Jun 28 11:27:56.572413 2026] [php:error] [pid 849:tid 849] [client 172.0.0.4:58584] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/queuecontent.php(3061): CommonUtils::getConfigValue()\n#2 /var/www/html/php/queuecontent.php(108): QueueContent::getliveorders()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568, referer: http://172.0.0.3/customersview.php?v=2.9.12
[Sun Jun 28 11:27:56.590967 2026] [php:error] [pid 805:tid 805] [client 172.0.0.4:58582] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:483\nStack trace:\n#0 /var/www/html/php/roomtables.php(307): CommonUtils::fetchSqlAll()\n#1 /var/www/html/php/roomtables.php(95): Roomtables->getAllTablesAndRooms()\n#2 /var/www/html/php/roomtables.php(29): Roomtables->showAllRooms()\n#3 /var/www/html/php/contenthandler.php(81): Roomtables->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 483, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:27:56.593720 2026] [php:error] [pid 806:tid 806] [client 172.0.0.4:58581] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/products.php:1153\nStack trace:\n#0 /var/www/html/php/products.php(167): Products->getAllGeneralComments()\n#1 /var/www/html/php/contenthandler.php(78): Products->handleCommand()\n#2 {main}\n  thrown in /var/www/html/php/products.php on line 1153, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:27:56.599300 2026] [php:error] [pid 803:tid 803] [client 172.0.0.4:58587] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/tablemap.php:181\nStack trace:\n#0 /var/www/html/php/tablemap.php(433): TableMap::getTableMapPreferences()\n#1 {main}\n  thrown in /var/www/html/php/tablemap.php on line 181, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:27:56.603602 2026] [php:error] [pid 800:tid 800] [client 172.0.0.4:58585] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/queuecontent.php(3061): CommonUtils::getConfigValue()\n#2 /var/www/html/php/queuecontent.php(108): QueueContent::getliveorders()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568, referer: http://172.0.0.3/customersview.php?v=2.9.12
[Sun Jun 28 11:27:56.608510 2026] [php:error] [pid 799:tid 799] [client 172.0.0.4:58586] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/queuecontent.php(3061): CommonUtils::getConfigValue()\n#2 /var/www/html/php/queuecontent.php(108): QueueContent::getliveorders()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568, referer: http://172.0.0.3/customersview.php?v=2.9.12
[Sun Jun 28 11:27:56.838233 2026] [php:error] [pid 849:tid 849] [client 172.0.0.4:58588] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:483\nStack trace:\n#0 /var/www/html/php/printqueue.php(685): CommonUtils::fetchSqlAll()\n#1 /var/www/html/php/printqueue.php(134): PrintQueue->getBestLogoAsPngWithAlphaChannel()\n#2 /var/www/html/php/contenthandler.php(93): PrintQueue->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/commonutils.php on line 483, referer: http://172.0.0.3/index.html?v=2.9.12
[Sun Jun 28 11:27:56.892380 2026] [php:error] [pid 805:tid 805] [client 172.0.0.4:58589] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/admin.php(2011): CommonUtils::getConfigValue()\n#2 /var/www/html/php/admin.php(1935): Admin->getJsonMenuItemsAndVersionCore()\n#3 /var/www/html/php/admin.php(233): Admin->getJsonMenuItemsAndVersion()\n#4 /var/www/html/php/contenthandler.php(72): Admin->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568, referer: http://172.0.0.3/index.html?v=2.9.12
[Sun Jun 28 11:27:57.106346 2026] [php:error] [pid 806:tid 806] [client 172.0.0.4:58590] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/queuecontent.php(3061): CommonUtils::getConfigValue()\n#2 /var/www/html/php/queuecontent.php(108): QueueContent::getliveorders()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568, referer: http://172.0.0.3/customersview.php?v=2.9.12
[Sun Jun 28 11:27:57.130565 2026] [php:error] [pid 803:tid 803] [client 172.0.0.4:58591] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/queuecontent.php(3061): CommonUtils::getConfigValue()\n#2 /var/www/html/php/queuecontent.php(108): QueueContent::getliveorders()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568, referer: http://172.0.0.3/customersview.php?v=2.9.12
[Sun Jun 28 11:27:57.321091 2026] [php:error] [pid 800:tid 800] [client 172.0.0.4:58558] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/queuecontent.php(3061): CommonUtils::getConfigValue()\n#2 /var/www/html/php/queuecontent.php(108): QueueContent::getliveorders()\n#3 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568, referer: http://172.0.0.3/customersview.php?v=2.9.12
[Sun Jun 28 11:32:06.420227 2026] [php:notice] [pid 975:tid 975] [client 172.0.0.4:63138] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:32:06.433231 2026] [php:error] [pid 975:tid 975] [client 172.0.0.4:63138] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:32:42.904617 2026] [php:notice] [pid 800:tid 800] [client 172.0.0.4:63155] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:32:42.916818 2026] [php:error] [pid 800:tid 800] [client 172.0.0.4:63155] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:33:21.788307 2026] [mpm_prefork:notice] [pid 787:tid 787] AH00170: caught SIGWINCH, shutting down gracefully
[Sun Jun 28 11:33:22.015839 2026] [mpm_prefork:notice] [pid 1126:tid 1126] AH00163: Apache/2.4.66 (Debian) configured -- resuming normal operations
[Sun Jun 28 11:33:22.015929 2026] [core:notice] [pid 1126:tid 1126] AH00094: Command line: '/usr/sbin/apache2'
[Sun Jun 28 11:33:48.719502 2026] [php:notice] [pid 1132:tid 1132] [client 172.0.0.4:63196] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:33:48.735467 2026] [php:error] [pid 1132:tid 1132] [client 172.0.0.4:63196] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:42:08.535673 2026] [php:notice] [pid 1452:tid 1452] [client 172.0.0.4:63372] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 11:42:08.550678 2026] [php:error] [pid 1452:tid 1452] [client 172.0.0.4:63372] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 13:29:44.148214 2026] [php:notice] [pid 2613:tid 2613] [client 172.0.0.4:49484] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 13:29:44.159898 2026] [php:error] [pid 2613:tid 2613] [client 172.0.0.4:49484] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:09:40.466077 2026] [php:notice] [pid 1980:tid 1980] [client 172.0.0.4:52105] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:09:40.477342 2026] [php:error] [pid 1980:tid 1980] [client 172.0.0.4:52105] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:15:13.372721 2026] [php:notice] [pid 7297:tid 7297] [client 172.0.0.4:52256] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:15:13.390343 2026] [php:error] [pid 7297:tid 7297] [client 172.0.0.4:52256] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:43:13.078350 2026] [php:notice] [pid 8200:tid 8200] [client 172.0.0.4:52948] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:43:13.099351 2026] [php:error] [pid 8200:tid 8200] [client 172.0.0.4:52948] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:49:39.007111 2026] [php:notice] [pid 6284:tid 6284] [client 172.0.0.4:53138] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:49:39.019367 2026] [php:error] [pid 6284:tid 6284] [client 172.0.0.4:53138] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:50:12.954401 2026] [php:notice] [pid 8169:tid 8169] [client 172.0.0.4:53143] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:50:12.965297 2026] [php:error] [pid 8169:tid 8169] [client 172.0.0.4:53143] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:54:09.279837 2026] [php:notice] [pid 8498:tid 8498] [client 172.0.0.4:53240] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:54:09.293755 2026] [php:error] [pid 8498:tid 8498] [client 172.0.0.4:53240] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:56:00.195049 2026] [php:notice] [pid 5025:tid 5025] [client 172.0.0.4:53298] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:56:00.216459 2026] [php:error] [pid 5025:tid 5025] [client 172.0.0.4:53298] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:57:04.501933 2026] [php:notice] [pid 7443:tid 7443] [client 172.0.0.4:53317] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:57:04.516885 2026] [php:error] [pid 7443:tid 7443] [client 172.0.0.4:53317] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:57:38.019638 2026] [php:notice] [pid 8584:tid 8584] [client 172.0.0.4:53348] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 15:57:38.032522 2026] [php:error] [pid 8584:tid 8584] [client 172.0.0.4:53348] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:02:11.768744 2026] [php:notice] [pid 4739:tid 4739] [client 172.0.0.4:53453] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:02:11.783684 2026] [php:error] [pid 4739:tid 4739] [client 172.0.0.4:53453] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:02:33.546392 2026] [php:notice] [pid 7297:tid 7297] [client 172.0.0.4:53465] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:02:33.558816 2026] [php:error] [pid 7297:tid 7297] [client 172.0.0.4:53465] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:04:46.900354 2026] [php:notice] [pid 8382:tid 8382] [client 172.0.0.4:53502] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:04:46.918402 2026] [php:error] [pid 8382:tid 8382] [client 172.0.0.4:53502] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:06:22.064216 2026] [php:notice] [pid 8777:tid 8777] [client 172.0.0.4:53540] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:06:22.076602 2026] [php:error] [pid 8777:tid 8777] [client 172.0.0.4:53540] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:45:20.976077 2026] [php:notice] [pid 8660:tid 8660] [client 172.0.0.4:54441] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:45:20.985490 2026] [php:error] [pid 8660:tid 8660] [client 172.0.0.4:54441] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:50:28.241705 2026] [php:notice] [pid 10301:tid 10301] [client 172.0.0.4:54552] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:50:28.253395 2026] [php:error] [pid 10301:tid 10301] [client 172.0.0.4:54552] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:50:52.870405 2026] [php:notice] [pid 10273:tid 10273] [client 172.0.0.4:54564] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:50:52.881448 2026] [php:error] [pid 10273:tid 10273] [client 172.0.0.4:54564] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:51:06.737583 2026] [php:notice] [pid 7882:tid 7882] [client 172.0.0.4:54570] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 16:51:06.750988 2026] [php:error] [pid 7882:tid 7882] [client 172.0.0.4:54570] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 17:00:27.694944 2026] [php:notice] [pid 7893:tid 7893] [client 172.0.0.4:54766] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 17:00:27.707912 2026] [php:error] [pid 7893:tid 7893] [client 172.0.0.4:54766] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Sun Jun 28 17:03:33.820820 2026] [php:notice] [pid 9505:tid 9505] [client 172.0.0.4:54836] closing perf: started:0,transactionstarted:0,cleandone:16,nextclsid found:16,configread:21,clsinitindb:22,billidsfound:22,billsverified:32,tipscalculated:33,billsclosed:40,gotbillstotake:40,pricesum:41,prevclsfound:41,workevaled:44,queueitemclsidclosed:48,queueitemscleaned:48,queueitemsdone:49,queueitemsdelivered:51,queueitemsclosed:55,calcnewcash:55,salescalced:57,cashsumcalced:57,purecashsumcalced:57,cashsumssaved:58,histupdated:60,tsesigned:541,tablesoptimized:556,telemetry:708,versionchecked:721,closingcreated:9229, referer: http://172.0.0.3/manager.html?v=2.9.12
[Mon Jun 29 00:15:14.431897 2026] [mpm_prefork:notice] [pid 1126:tid 1126] AH00170: caught SIGWINCH, shutting down gracefully
[Mon Jun 29 02:15:18.961640 2026] [mpm_prefork:notice] [pid 764:tid 764] AH00163: Apache/2.4.66 (Debian) configured -- resuming normal operations
[Mon Jun 29 02:15:18.963261 2026] [core:notice] [pid 764:tid 764] AH00094: Command line: '/usr/sbin/apache2'
[Mon Jun 29 02:26:20.601135 2026] [mpm_prefork:notice] [pid 764:tid 764] AH00171: Graceful restart requested, doing restart

Nachtrag:
Also ich bin fast der Meinung dass es am Schnellkassen Modus liegt. Ist er aktiviert kommen die Fehler. Ist er deaktiviert, sieht es erstmal gut aus.

Nächste "Test" erfolgt am Freitag

von **pichel** » Fr 26. Jun 2026, 18:00

Hallo,

ich habe keine Ahnung, warum du diese Fehler hast, aber würde dir trotzdem empfehlen, jetztt erst mal die Änderung vorzunehmen, die ich dir oben geschrieben habe und dann nochmal zu testen.

Gruß,

Stefan

von **Imbiss** » Fr 26. Jun 2026, 15:38

Hey ho,

so weiter gehts. Habe ein Backup eingespielt, welches nach der Installation erstellt wurde. Habe lediglich Artikel angelegt, so dass ich es für mich nutzen kann. Und hatte trotzdem weiterhin den Fehler. Die Änderung in der Commonutils.php habe ich mit dem Einspielen des Backups noch nicht geändert...also alles noch im "Urzustand"

Code: Alles auswählen

root@kasse:/var/log/apache2# cat error.log
[Fri Jun 26 00:10:19.393585 2026] [mpm_prefork:notice] [pid 770:tid 770] AH00163: Apache/2.4.66 (Debian) configured -- resuming normal operations
[Fri Jun 26 00:10:19.393635 2026] [core:notice] [pid 770:tid 770] AH00094: Command line: '/usr/sbin/apache2'
[Fri Jun 26 00:15:11.857946 2026] [mpm_prefork:notice] [pid 770:tid 770] AH00170: caught SIGWINCH, shutting down gracefully
[Fri Jun 26 02:15:20.073265 2026] [mpm_prefork:notice] [pid 791:tid 791] AH00163: Apache/2.4.66 (Debian) configured -- resuming normal operations
[Fri Jun 26 02:15:20.073959 2026] [core:notice] [pid 791:tid 791] AH00094: Command line: '/usr/sbin/apache2'
[Fri Jun 26 10:00:35.624144 2026] [php:notice] [pid 900:tid 900] [client 172.0.0.4:60945] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiter.html?v=2.9.12
[Fri Jun 26 10:00:35.629381 2026] [php:error] [pid 900:tid 900] [client 172.0.0.4:60945] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiter.html?v=2.9.12
[Fri Jun 26 10:00:49.420970 2026] [php:notice] [pid 13616:tid 13616] [client 172.0.0.4:60950] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiter.html?v=2.9.12
[Fri Jun 26 10:00:49.429271 2026] [php:error] [pid 13616:tid 13616] [client 172.0.0.4:60950] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiter.html?v=2.9.12
[Fri Jun 26 10:58:21.878090 2026] [php:error] [pid 14750:tid 14750] [client 172.0.0.4:62048] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Fri Jun 26 10:59:26.906666 2026] [php:error] [pid 15340:tid 15340] [client 172.0.0.4:62058] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Fri Jun 26 11:00:46.922390 2026] [php:error] [pid 14759:tid 14759] [client 172.0.0.4:62105] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Fri Jun 26 11:35:49.781403 2026] [php:error] [pid 16720:tid 16720] [client 172.0.0.4:63124] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Fri Jun 26 11:36:11.598554 2026] [php:error] [pid 16450:tid 16450] [client 172.0.0.4:63129] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Fri Jun 26 11:36:32.389633 2026] [php:error] [pid 16721:tid 16721] [client 172.0.0.4:63144] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Fri Jun 26 11:38:49.065936 2026] [php:error] [pid 16692:tid 16692] [client 172.0.0.4:63191] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Fri Jun 26 11:39:06.820758 2026] [php:error] [pid 16451:tid 16451] [client 172.0.0.4:63210] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work' in /var/www/html/php/commonutils.php:106\nStack trace:\n#0 /var/www/html/php/commonutils.php(106): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(2735): CommonUtils->verifyLastBillId()\n#2 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#3 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#4 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#5 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#6 {main}\n  thrown in /var/www/html/php/commonutils.php on line 106, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12

von **pichel** » Mi 24. Jun 2026, 13:50

dann gibt es da wahrscheinlich irgendwo eine Einstellung, die ich nicht kenne oder übersehen habe. vielleicht kannst Du mir an s.pichel@ordersprinter.de schreiben

von **Imbiss** » Mi 24. Jun 2026, 13:42

Das würde ich gern...

Leider bist du nicht berechtigt, diese Funktion zu nutzen. Du hast dich vermutlich erst vor kurzem registriert und musst dich noch mehr an Diskussionen im Board beteiligen, damit du diese Funktion nutzen kannst.

Grüße Daniel

von **pichel** » Mi 24. Jun 2026, 12:32

Hi,

aber das ist doch jetzt eine ganz andere fehlermeldung. diese fehlermeldung beschreibt, dass der Zugriff auf die Datenbank nicht funktioniert.

magst du mir mal deine telefonnummer per PN schicken?

Gruß,

Stefan

von **Imbiss** » Mi 24. Jun 2026, 11:19

Hallo,

leider das selbe Problem, eher sogar noch öfters. Code in der commonutils.php habe ich nach den Vorgaben geändert.

Code: Alles auswählen

[Wed Jun 24 00:08:09.460527 2026] [mpm_prefork:notice] [pid 799:tid 799] AH00163: Apache/2.4.66 (Debian) configured -- resuming normal operations
[Wed Jun 24 00:08:09.460563 2026] [core:notice] [pid 799:tid 799] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jun 24 00:15:00.814457 2026] [mpm_prefork:notice] [pid 799:tid 799] AH00170: caught SIGWINCH, shutting down gracefully
[Wed Jun 24 02:15:20.501797 2026] [mpm_prefork:notice] [pid 794:tid 794] AH00163: Apache/2.4.66 (Debian) configured -- resuming normal operations
[Wed Jun 24 02:15:20.502863 2026] [core:notice] [pid 794:tid 794] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jun 24 02:15:23.510021 2026] [php:error] [pid 810:tid 810] [client 127.0.0.1:58376] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/printqueue.php(780): CommonUtils::getConfigValue()\n#2 /var/www/html/php/printqueue.php(122): PrintQueue->getReceiptConfig()\n#3 /var/www/html/php/contenthandler.php(93): PrintQueue->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568
[Wed Jun 24 02:15:23.531054 2026] [php:error] [pid 811:tid 811] [client 127.0.0.1:58390] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in /var/www/html/php/commonutils.php:568\nStack trace:\n#0 /var/www/html/php/commonutils.php(579): CommonUtils::getTableValue()\n#1 /var/www/html/php/printqueue.php(780): CommonUtils::getConfigValue()\n#2 /var/www/html/php/printqueue.php(122): PrintQueue->getReceiptConfig()\n#3 /var/www/html/php/contenthandler.php(93): PrintQueue->handleCommand()\n#4 {main}\n  thrown in /var/www/html/php/commonutils.php on line 568
[Wed Jun 24 10:33:51.681057 2026] [php:warn] [pid 823:tid 823] [client 172.0.0.246:60418] PHP Warning:  Undefined array key "arg" in /var/www/html/php/utilities/osqrcode.php on line 46, referer: http://172.0.0.3/preferences.html?v=2.9.12
[Wed Jun 24 10:46:17.508153 2026] [php:notice] [pid 14893:tid 14893] [client 172.0.0.4:58492] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:46:17.525109 2026] [php:error] [pid 14893:tid 14893] [client 172.0.0.4:58492] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:46:28.463925 2026] [php:notice] [pid 14453:tid 14453] [client 172.0.0.4:58498] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:46:28.479914 2026] [php:error] [pid 14453:tid 14453] [client 172.0.0.4:58498] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:47:25.795362 2026] [php:notice] [pid 14436:tid 14436] [client 172.0.0.4:58513] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:47:25.808945 2026] [php:error] [pid 14436:tid 14436] [client 172.0.0.4:58513] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:48:25.271191 2026] [php:notice] [pid 14816:tid 14816] [client 172.0.0.4:58529] Checking last used billid in work table went wrong: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:48:25.284149 2026] [php:error] [pid 14816:tid 14816] [client 172.0.0.4:58529] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ordersprinter`.`os_billproducts`, CONSTRAINT `os_billproducts_ibfk_1` FOREIGN KEY (`queueid`) REFERENCES `os_queue` (`id`)) in /var/www/html/php/queuecontent.php:2803\nStack trace:\n#0 /var/www/html/php/queuecontent.php(2803): PDOStatement->execute()\n#1 /var/www/html/php/queuecontent.php(1644): QueueContent->declarePaidCreateBillReturnBillId()\n#2 /var/www/html/php/queuecontent.php(1265): QueueContent->addProductListToQueueCore()\n#3 /var/www/html/php/queuecontent.php(91): QueueContent->addProductListToQueue()\n#4 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#5 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 2803, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:49:58.398404 2026] [php:notice] [pid 14453:tid 14453] [client 172.0.0.4:58547] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:49:58.402730 2026] [php:error] [pid 14453:tid 14453] [client 172.0.0.4:58547] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:50:09.062217 2026] [php:notice] [pid 15327:tid 15327] [client 172.0.0.4:58562] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:50:09.068597 2026] [php:error] [pid 15327:tid 15327] [client 172.0.0.4:58562] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:50:10.878703 2026] [php:notice] [pid 816:tid 816] [client 172.0.0.4:58564] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:50:10.884713 2026] [php:error] [pid 816:tid 816] [client 172.0.0.4:58564] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:50:16.052985 2026] [php:notice] [pid 15212:tid 15212] [client 172.0.0.4:58561] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:50:16.058529 2026] [php:error] [pid 15212:tid 15212] [client 172.0.0.4:58561] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:50:17.052942 2026] [php:notice] [pid 14627:tid 14627] [client 172.0.0.4:58566] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:50:17.057406 2026] [php:error] [pid 14627:tid 14627] [client 172.0.0.4:58566] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:50:19.552075 2026] [php:notice] [pid 14436:tid 14436] [client 172.0.0.4:58568] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:50:19.559326 2026] [php:error] [pid 14436:tid 14436] [client 172.0.0.4:58568] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:53:35.156354 2026] [php:notice] [pid 15212:tid 15212] [client 172.0.0.4:58621] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:53:35.162378 2026] [php:error] [pid 15212:tid 15212] [client 172.0.0.4:58621] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:54:00.326932 2026] [php:notice] [pid 14436:tid 14436] [client 172.0.0.4:58641] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:54:00.333117 2026] [php:error] [pid 14436:tid 14436] [client 172.0.0.4:58641] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:54:02.212481 2026] [php:notice] [pid 810:tid 810] [client 172.0.0.4:58654] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:54:02.219886 2026] [php:error] [pid 810:tid 810] [client 172.0.0.4:58654] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:54:04.123602 2026] [php:notice] [pid 816:tid 816] [client 172.0.0.4:58656] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:54:04.128145 2026] [php:error] [pid 816:tid 816] [client 172.0.0.4:58656] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:54:07.463908 2026] [php:notice] [pid 14810:tid 14810] [client 172.0.0.4:58655] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:54:07.471118 2026] [php:error] [pid 14810:tid 14810] [client 172.0.0.4:58655] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:54:08.466485 2026] [php:notice] [pid 15464:tid 15464] [client 172.0.0.4:58657] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:54:08.473717 2026] [php:error] [pid 15464:tid 15464] [client 172.0.0.4:58657] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:54:09.486195 2026] [php:notice] [pid 14847:tid 14847] [client 172.0.0.4:58658] Error in creation of cancel print job: SQLSTATE[HY000]: General error: 1020 Record has changed since last read in table 'os_work', referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 10:54:09.494041 2026] [php:error] [pid 14847:tid 14847] [client 172.0.0.4:58658] PHP Fatal error:  Uncaught PDOException: There is no active transaction in /var/www/html/php/queuecontent.php:1989\nStack trace:\n#0 /var/www/html/php/queuecontent.php(1989): PDO->commit()\n#1 /var/www/html/php/queuecontent.php(141): QueueContent->removeProductFromQueue()\n#2 /var/www/html/php/contenthandler.php(75): QueueContent->handleCommand()\n#3 {main}\n  thrown in /var/www/html/php/queuecontent.php on line 1989, referer: http://172.0.0.3/waiterdesktop.php?v=2.9.12
[Wed Jun 24 11:02:45.825900 2026] [php:warn] [pid 15716:tid 15716] [client 172.0.0.246:64798] PHP Warning:  Undefined array key "arg" in /var/www/html/php/utilities/osqrcode.php on line 46, referer: http://172.0.0.3/preferences.html?v=2.9.12

von **pichel** » Mo 22. Jun 2026, 20:55

Hallo Daniel,

im Error_log ist folgende Aussage das Entscheidende: "Record has changed since last read in table 'os_work' "

Das kommt so zustande (vereinfacht erklärt):

1. Prozess A liest einen Datensatz aus os_work.
2. Prozess B ändert denselben Datensatz.
3. Prozess A versucht nun auf Basis seiner alten Daten zu schreiben.
4. Die Datenbank erkennt, dass sich der Datensatz inzwischen geändert hat und wirft Fehler 1020.

Das nennt man einen Concurrency-/Race-Condition-Fehler.

Die Wahrscheinlichkeit für so eine Race Condition nimmt mit der Anzahl der Prozesse, die meist im gleichen Maß wie die Anzahl der aktiven Nutzer wächst, zu. Natürlich reden wir von Wahrscheinlichkeiten, d.h. es kann auch bei einem einelnen Nutzer passieren (in die Work-Tabelle werden auch regelmäßig die Ergebnisse vom Printercheck usw. eingetragen).

Wenn aber dieser Fehler häufiger auftritt, du aber stets der einzige Nutzer bist, würde ich auf ein konzeptuelles Problem tippen ("Bug"). Allerdings habe ich diesen Fehler bisher so nicht berichtet bekommen (wobei die meisten Fehlerreports leider keine error_logs enthalten).

Nun zu den Änderungen: Du musst nicht jede Zeile eintippen. Nur die mit dunkelgrüner Hintergrundfarbe markierten Zeilen sind neu, davon sind die meisten Zeilen mit // beginnend nur Kommentare, die ich zum besseren Verständnis eingefügt habe. Die hellgrünen Zeilen sind nur Einrückungen. Aber wenn es hilft, hier die Funktion als Text:

Code: Alles auswählen

	function verifyLastBillId($pdo,$nextIdToUse) {
		if ($nextIdToUse == 1) {
			return true;
		}
		if (is_null($pdo)) {
			$pdo = $this->dbutils->openDbAndReturnPdo();
		}
		$nextIdToUse = intval($nextIdToUse);

		$lastBillInc = null;
		try {
			$sql = "SELECT value,signature FROM %work% WHERE item=?";
			$stmt = $pdo->prepare($this->dbutils->resolveTablenamesInSqlString($sql));
			$stmt->execute(array("lastbillid"));
			$row =$stmt->fetchObject();
			$lastBillid = intval($row->value);
			$lastBillInc = $lastBillid+1;
		} catch (Exception $ex) {
			// there are potential parallel write accesses to work table not secured by
			// serialized transactions, so getting the billid may go wrong. This check is 
			// not that important anymore because of signature process via TSE. So just log it!
			error_log("Checking last used billid in work table went wrong: " . $ex->getMessage());
		}
		
		if (!is_null($lastBillInc) && ($lastBillInc != $nextIdToUse)) {
			return false;
		} else {
			// is id already used in bill table?
			$sql = "SELECT id FROM %bill% WHERE id=?";
			$stmt = $pdo->prepare($this->dbutils->resolveTablenamesInSqlString($sql));
			$stmt->execute(array($nextIdToUse));
			if ($stmt->rowCount() > 0) {
				return false;
			} else {
				// is there a gap or does the previous id exist?
				$sql = "SELECT id FROM %bill% WHERE id=?";
				$stmt = $pdo->prepare($this->dbutils->resolveTablenamesInSqlString($sql));
				$stmt->execute(array($nextIdToUse - 1));
				if ($stmt->rowCount() != 1) {
					return false;
				} else {
					return true;
				}
			}
		}
	}

Gruß,

Stefan

von **Imbiss** » Mo 22. Jun 2026, 09:00

Hallo,

vorab ich bin alleine

Also keine Überschneidung von mehreren Geräten. Netzwerk habe ich inzwischen vollständig auf Kabel umgestellt und ohne Switch...

Ich hoffe dass ich spätestens morgen dazu kommen die Änderung durchzuführen, um es dann Testen zu können.

Danke schon mal für die Rückmeldung.

Grüße Daniel

OrderSprinter-Forum

php Error

Antwort erstellen

Ansicht erweitern Die letzten Beiträge des Themas: php Error

Re: php Error

Re: php Error

Re: php Error

Re: php Error

Re: php Error

Re: php Error

Re: php Error

Re: php Error

Re: php Error

Re: php Error