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

[Hardie, Andrew]

Hi Thilo,

Thanks for the bug reports, and thanks to Jörg for the input.

Re the menu error. This happens when a cached copy of some JavaScript file is used instead of downloading the modified version from the server. I don't know why this happens (browsers are supposed to check with the server if there is an updated version of a file in cache, and the server ought to know that the file has changed) so I don't know how to stop it.

Clearing the cache obviously works but there is actually a quicker technique - just hit "hard refresh" on whatever page has the problem. That forces reload of all cached resources without having to go into your cache settings.

Chrome / Firefox:

·         Shortcut on Mac - command + shift + R

·         Shortcut on Win - control + F5

And on safari it's [option + command + E] I believe.

Re the save query error - bug located and fixed, fix is in the commit I just did (1833).

best

Andrew.

From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Thilo Wiertz
Sent: 01 March 2023 15:49
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: Re: [CWB] Two CQPweb errors: save query result, and choose action

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<mailto: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<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7C6f99e7dde0a74c3dcdde08db1a6cbe1f%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C638132827037090175%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=0KLrq3wjIubiiYl79bOtE98IKjIJ70n992GYwyrVWv4%3D&reserved=0>



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20230301/ea4196aa/attachment-0001.html>