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

[Thilo Wiertz]

Thanks Jörg, this fixed "choose action" for me. The error saving queries persists.

Thilo



—
Dr. Thilo Wiertz
Economic Geography and Sustainable Development

University of Freiburg
Schreiberstr. 20
D-79085 Freiburg
Phone: 0761 203-3569

> Am 01.03.2023 um 14:47 schrieb Jörg Knappen <j.knappen at mx.uni-saarland.de>:
> 
> 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 <mailto: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/62b57d1f/attachment.html>