[CWB] Two CQPweb errors: save query result, and choose action

[Thilo Wiertz]

Dear all,

I just installed CQPweb 3.3.17. Since the db migration failed, I made a fresh install. However, I now encounter two unrelated errors:

1. I cannot save queries. CQPweb shows a blank page, the apache error log says:

Uncaught mysqli_sql_exception: 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 '} and user_id = 1 and savename = 'sustainab'  and save_status = 1 \n\t/* from User' at line 1 in /var/www/html/diskurs/lib/sql-lib.php:513\nStack trace:\n#0 /var/www/html/diskurs/lib/sql-lib.php(513): mysqli_query()\n#1 /var/www/html/diskurs/lib/sql-lib.php(838): do_sql_query()\n#2 /var/www/html/diskurs/lib/cache-lib.php(2565): sql_has_results()\n#3 /var/www/html/diskurs/lib/cache-lib.php(2585): savename_in_use()\n#4 /var/www/html/diskurs/lib/savequery-act.php(97): guarantee_distinct_savename()\n#5 /var/www/html/diskurs/exe/savequery-act.php(1): require('...')\n#6 {main}\n  thrown in /var/www/html/diskurs/lib/sql-lib.php on line 513

Is this a bug or perhaps an issue with my sql server?


2. The "Choose action…" select box in the query results view does not work on Firefox or Chrome (on Mac). It just turns grey and nothing happens. Safari works fine.

Any help is much appreciated (particularly on the first problem)!

Best,
Thilo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20230301/7e56f244/attachment.html>