[DQT] Unknown error in PHP log

[jeffersoncasimir]

Seen when testing. Unknown origin. Not yet reproduced. [Fri Jun 13 11:51:11.772818 2025] [php:notice] [pid 50634] [client 192.168.122.1:49900] [ERROR] SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'new' at row 1#0 /var/www/Loris/php/libraries/Database.class.inc(1203): PDOStatement->execute()\n#1 /var/www/Loris/php/libraries/Database.class.inc(428): Database->trackChanges()\n#2 /var/www/Loris/php/libraries/Database.class.inc(249): Database->_realinsert()\n#3 /var/www/Loris/modules/dataquery/php/endpoints/queries.class.inc(128): Database->unsafeinsert()\n#4 /var/www/Loris/modules/dataquery/php/endpoints/queries.class.inc(65): LORIS\\dataquery\\endpoints\\Queries->_storeQuery()\n#5 /var/www/Loris/modules/dataquery/php/queries.class.inc(49): LORIS\\dataquery\\endpoints\\Queries->handle()\n#6 /var/www/Loris/src/Middleware/UserPageDecorationMiddleware.php(249): LORIS\\dataquery\\Queries->handle()\n#7 /var/www/Loris/src/Middleware/PageDecorationMiddleware.php(59): LORIS\\Middleware\\UserPageDecorationMiddleware->process()\n#8 /var/www/Loris/php/libraries/NDB_Page.class.inc(731): LORIS\\Middleware\\PageDecorationMiddleware->process()\n#9 /var/www/Loris/php/libraries/Module.class.inc(322): NDB_Page->process()\n#10 /var/www/Loris/src/Middleware/ResponseGenerator.php(51): Module->handle()\n#11 /var/www/Loris/src/Middleware/AuthMiddleware.php(64): LORIS\\Middleware\\ResponseGenerator->process()\n#12 /var/www/Loris/src/Router/ModuleRouter.php(75): LORIS\\Middleware\\AuthMiddleware->process()\n#13 /var/www/Loris/src/Middleware/ExceptionHandlingMiddleware.php(55): LORIS\\Router\\ModuleRouter->handle()\n#14 /var/www/Loris/src/Router/BaseRouter.php(127): LORIS\\Middleware\\ExceptionHandlingMiddleware->process()\n#15 /var/www/Loris/src/Middleware/ResponseGenerator.php(51): LORIS\\Router\\BaseRouter->handle()\n#16 /var/www/Loris/src/Middleware/AWS.php(35): LORIS\\Middleware\\ResponseGenerator->process()\n#17 /var/www/Loris/src/Middleware/ContentLength.php(53): LORIS\\Middleware\\AWS->process()\n#18 /var/www/Loris/htdocs/index.php(115): LORIS\\Middleware\\ContentLength->process()\n#19 {main}, referer: https://test-dev-270.loris.ca/dataquery/

[driusan]

This looks like a problem with the history table for very large queries (>64kb of json).

history.new is text datatype. dataquery_queries.Query is JSON (longtext).

[ridz1208]

dup of https://github.com/aces/Loris/issues/9865