<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">Thanks Jörg, this fixed "choose action" for me. The error saving queries persists.<div><br></div><div>Thilo</div><div><br></div><div><br></div><div><br><div>
<meta charset="UTF-8"><div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div style="color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;">—<br>Dr. Thilo Wiertz<br>Economic Geography and Sustainable Development</div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><br>University of Freiburg<br>Schreiberstr. 20<br>D-79085 Freiburg<br>Phone: 0761 203-3569</div></div></div></div>
</div>
<div><br><blockquote type="cite"><div>Am 01.03.2023 um 14:47 schrieb Jörg Knappen <j.knappen@mx.uni-saarland.de>:</div><br class="Apple-interchange-newline"><div><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><div style="font-size: 10pt; font-family: Verdana,Geneva,sans-serif"><p>Some users here had experienced similar problems that went away after clearing the browser cache. Try that and report if the problems persists.</p><p><br></p><p>Jörg Knappen</p><p><br></p><p id="reply-intro">Am 2023-03-01 14:10, schrieb Thilo Wiertz:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<div id="replybody1">
<div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">Dear all,
<div> </div>
<div>I just installed CQPweb 3.3.17. Since the db migration failed, I made a fresh install. However, I now encounter two unrelated errors:</div>
<div> </div>
<div>1. I cannot save queries. CQPweb shows a blank page, the apache error log says:</div>
<div> </div>
<div><em>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</em></div>
<div><em> </em></div>
<div>Is this a bug or perhaps an issue with my sql server?</div>
<div> </div>
<div> </div>
<div>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.</div>
<div> </div>
<div>Any help is much appreciated (particularly on the first problem)!</div>
<div> </div>
<div>Best,</div>
<div>Thilo</div>
</div>
</div>
<br>
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">_______________________________________________<br>CWB mailing list<br><a href="mailto:CWB@sslmit.unibo.it">CWB@sslmit.unibo.it</a><br><a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" target="_blank" rel="noopener noreferrer">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a></div>
</blockquote><p><br></p>
</div>
</div></blockquote></div><br></div></body></html>