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

[Jörg Knappen]

Some users here had  experienced similar problems that went away after 
clearing the browser cache. Try that and report if the problems 
persists.

Jörg Knappen

Am 2023-03-01 14:10, schrieb 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
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20230301/85bc4fe8/attachment.html>