<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Dear Andrew,</div><div dir="ltr"><br></div><div dir="ltr">Here's the last part of my <font face="monospace, monospace">/var/log/apache2/error.log</font>:<div><br></div><div><div><span style="font-family:monospace,monospace">[Sun May 12 13:27:42.660546 2019] [mpm_prefork:notice] [pid 30430] AH00171: Graceful restart requested, doing restart</span><br></div><div><font face="monospace, monospace">PHP Warning: PHP Startup: Unable to load dynamic library 'gd2' (tried: /usr/lib/php/20170718/gd2 (/usr/lib/php/20170718/gd2: cannot open shared object file: No such file or directory), /usr/lib/php/20170718/gd2.so (/usr/lib/php/20170718/gd2.so: cannot open shared object file: No such file or directory)) in Unknown on line 0</font></div><div><font face="monospace, monospace">PHP Warning: PHP Startup: Unable to load dynamic library 'mysqli' (tried: /usr/lib/php/20170718/mysqli (/usr/lib/php/20170718/mysqli: cannot open shared object file: No such file or directory), /usr/lib/php/20170718/mysqli.so (/usr/lib/php/20170718/mysqli.so: undefined symbol: mysqlnd_global_stats)) in Unknown on line 0</font></div><div><font face="monospace, monospace">[Sun May 12 13:27:42.702400 2019] [mpm_prefork:notice] [pid 30430] AH00163: Apache/2.4.29 (Ubuntu) configured -- resuming normal operations</font></div><div><font face="monospace, monospace">[Sun May 12 13:27:42.702429 2019] [core:notice] [pid 30430] AH00094: Command line: '/usr/sbin/apache2'</font></div><div><font face="monospace, monospace">[Sun May 12 13:27:42.793641 2019] [mpm_prefork:notice] [pid 30430] AH00169: caught SIGTERM, shutting down</font></div><div><font face="monospace, monospace">PHP Warning: PHP Startup: Unable to load dynamic library 'gd2' (tried: /usr/lib/php/20170718/gd2 (/usr/lib/php/20170718/gd2: cannot open shared object file: No such file or directory), /usr/lib/php/20170718/gd2.so (/usr/lib/php/20170718/gd2.so: cannot open shared object file: No such file or directory)) in Unknown on line 0</font></div><div><font face="monospace, monospace">PHP Warning: PHP Startup: Unable to load dynamic library 'mysqli' (tried: /usr/lib/php/20170718/mysqli (/usr/lib/php/20170718/mysqli: cannot open shared object file: No such file or directory), /usr/lib/php/20170718/mysqli.so (/usr/lib/php/20170718/mysqli.so: undefined symbol: mysqlnd_global_stats)) in Unknown on line 0</font></div><div><font face="monospace, monospace">[Sun May 12 13:27:42.877221 2019] [mpm_prefork:notice] [pid 31262] AH00163: Apache/2.4.29 (Ubuntu) configured -- resuming normal operations</font></div><div><font face="monospace, monospace">[Sun May 12 13:27:42.877254 2019] [core:notice] [pid 31262] AH00094: Command line: '/usr/sbin/apache2'</font></div><div><font face="monospace, monospace">[Sun May 12 13:30:10.572955 2019] [mpm_prefork:notice] [pid 31262] AH00169: caught SIGTERM, shutting down</font></div><div><font face="monospace, monospace">PHP Warning: PHP Startup: Unable to load dynamic library 'gd2' (tried: /usr/lib/php/20170718/gd2 (/usr/lib/php/20170718/gd2: cannot open shared object file: No such file or directory), /usr/lib/php/20170718/gd2.so (/usr/lib/php/20170718/gd2.so: cannot open shared object file: No such file or directory)) in Unknown on line 0</font></div><div><font face="monospace, monospace">PHP Warning: PHP Startup: Unable to load dynamic library 'mysqli' (tried: /usr/lib/php/20170718/mysqli (/usr/lib/php/20170718/mysqli: cannot open shared object file: No such file or directory), /usr/lib/php/20170718/mysqli.so (/usr/lib/php/20170718/mysqli.so: undefined symbol: mysqlnd_global_stats)) in Unknown on line 0</font></div><div><font face="monospace, monospace">[Sun May 12 13:30:56.766095 2019] [mpm_prefork:notice] [pid 1512] AH00163: Apache/2.4.29 (Ubuntu) configured -- resuming normal operations</font></div><div><font face="monospace, monospace">[Sun May 12 13:30:56.766213 2019] [core:notice] [pid 1512] AH00094: Command line: '/usr/sbin/apache2'</font></div><div><font face="monospace, monospace">[Sun May 12 13:42:06.648270 2019] [mpm_prefork:notice] [pid 1512] AH00169: caught SIGTERM, shutting down</font></div><div><font face="monospace, monospace">PHP Warning: PHP Startup: Unable to load dynamic library 'gd2' (tried: /usr/lib/php/20170718/gd2 (/usr/lib/php/20170718/gd2: cannot open shared object file: No such file or directory), /usr/lib/php/20170718/gd2.so (/usr/lib/php/20170718/gd2.so: cannot open shared object file: No such file or directory)) in Unknown on line 0</font></div><div><font face="monospace, monospace">PHP Warning: PHP Startup: Unable to load dynamic library 'mysqli' (tried: /usr/lib/php/20170718/mysqli (/usr/lib/php/20170718/mysqli: cannot open shared object file: No such file or directory), /usr/lib/php/20170718/mysqli.so (/usr/lib/php/20170718/mysqli.so: undefined symbol: mysqlnd_global_stats)) in Unknown on line 0</font></div><div><font face="monospace, monospace">[Sun May 12 13:47:46.622367 2019] [mpm_prefork:notice] [pid 4430] AH00163: Apache/2.4.29 (Ubuntu) configured -- resuming normal operations</font></div><div><font face="monospace, monospace">[Sun May 12 13:47:46.622464 2019] [core:notice] [pid 4430] AH00094: Command line: '/usr/sbin/apache2'</font></div><div><font face="monospace, monospace">[Sun May 12 13:59:18.897264 2019] [php7:error] [pid 4434] [client <a href="http://190.47.255.254:46430" target="_blank">190.47.255.254:46430</a>] PHP Fatal error: Uncaught Error: Call to undefined function list_corpus_annotations() in /var/www/html/cqpweb/lib/freqtable-lib.php:457\nStack trace:\n#0 /var/www/html/cqpweb/lib/corpus-lib.php(932): make_cwb_freq_index('dickens')\n#1 /var/www/html/cqpweb/lib/metadata-act.php(181): setup_all_corpus_freqlist_data('dickens')\n#2 /var/www/html/cqpweb/exe/metadata-admin.php(1): require('/var/www/html/c...')\n#3 {main}\n thrown in /var/www/html/cqpweb/lib/freqtable-lib.php on line 457, referer: <a href="http://146.155.44.196/dickens/index.php?ui=manageMetadata&createMetadataFromXml=1" target="_blank">http://146.155.44.196/dickens/index.php?ui=manageMetadata&createMetadataFromXml=1</a></font></div></div></div><div><br></div><div>There appear to be obvious problems with my PHP install, as there are errors about not being able to open <font face="monospace, monospace">gd2</font> and <font face="monospace, monospace">mysqli</font>. But I'm not sure what the problem is, as <span style="font-family:monospace,monospace">gd2</span> is installed: </div><div><br></div><div><div><font face="monospace, monospace">$ sudo apt show php-gd</font></div><div><font face="monospace, monospace">Package: php-gd</font></div><div><font face="monospace, monospace">Version: 1:7.2+60ubuntu1</font></div><div><font face="monospace, monospace">Priority: optional</font></div><div><font face="monospace, monospace">Section: php</font></div><div><font face="monospace, monospace">Source: php-defaults (60ubuntu1)</font></div><div><font face="monospace, monospace">Origin: Ubuntu</font></div><div><font face="monospace, monospace">Maintainer: Ubuntu Developers <<a href="mailto:ubuntu-devel-discuss@lists.ubuntu.com">ubuntu-devel-discuss@lists.ubuntu.com</a>></font></div><div><font face="monospace, monospace">Original-Maintainer: Debian PHP Maintainers <<a href="mailto:pkg-php-maint@lists.alioth.debian.org">pkg-php-maint@lists.alioth.debian.org</a>></font></div><div><font face="monospace, monospace">Bugs: <a href="https://bugs.launchpad.net/ubuntu/+filebug">https://bugs.launchpad.net/ubuntu/+filebug</a></font></div><div><font face="monospace, monospace">Installed-Size: 12.3 kB</font></div><div><font face="monospace, monospace">Depends: php-common, php7.2-gd</font></div><div><font face="monospace, monospace">Supported: 5y</font></div><div><font face="monospace, monospace">Download-Size: 1,996 B</font></div><div><font face="monospace, monospace">APT-Manual-Installed: yes</font></div><div><font face="monospace, monospace">APT-Sources: <a href="http://cl.archive.ubuntu.com/ubuntu">http://cl.archive.ubuntu.com/ubuntu</a> bionic/main amd64 Packages</font></div><div><font face="monospace, monospace">Description: GD module for PHP [default]</font></div><div><font face="monospace, monospace"> This package provides a GD module for PHP.</font></div></div><div><font face="monospace, monospace"><br></font></div><div><font face="arial, helvetica, sans-serif">Furthermore, PHP <i>seems</i> to indicate GD is enabled (assuming I'm interpreting this file correctly):</font></div><div><font face="arial, helvetica, sans-serif"><br></font></div><div><div><font face="monospace, monospace">$ php -i | grep "GD"</font></div><div><font face="monospace, monospace">gd</font></div><div><font face="monospace, monospace">/etc/php/7.2/cli/conf.d/20-gd.ini,</font></div><div><font face="monospace, monospace">GD Support => enabled</font></div><div><font face="monospace, monospace">GD headers Version => 2.2.5</font></div><div><font face="monospace, monospace">GD library Version => 2.2.5</font></div><div><font face="monospace, monospace">gd.jpeg_ignore_warning => 1 => 1</font></div><div style="font-family:arial,helvetica,sans-serif"><br></div></div><div style="font-family:arial,helvetica,sans-serif"><br></div><div><font face="arial, helvetica, sans-serif">As to </font><font face="monospace, monospace">mysqli</font><font face="arial, helvetica, sans-serif">, it doesn't have it's own package, but appears to be part of </font><font face="monospace, monospace">php-db</font><span style="font-family:arial,helvetica,sans-serif">, which I have installed:</span></div><div><span style="font-family:arial,helvetica,sans-serif"><br></span></div><div><div><font face="monospace, monospace">$ sudo apt show php-db</font></div><div><font face="monospace, monospace">Package: php-db</font></div><div><font face="monospace, monospace">Version: 1.9.2-2ubuntu1</font></div><div><font face="monospace, monospace">Priority: optional</font></div><div><font face="monospace, monospace">Section: universe/web</font></div><div><font face="monospace, monospace">Origin: Ubuntu</font></div><div><font face="monospace, monospace">Maintainer: Ubuntu Developers <<a href="mailto:ubuntu-devel-discuss@lists.ubuntu.com">ubuntu-devel-discuss@lists.ubuntu.com</a>></font></div><div><font face="monospace, monospace">Original-Maintainer: Debian PHP PEAR Maintainers <<a href="mailto:pkg-php-pear@lists.alioth.debian.org">pkg-php-pear@lists.alioth.debian.org</a>></font></div><div><font face="monospace, monospace">Bugs: <a href="https://bugs.launchpad.net/ubuntu/+filebug">https://bugs.launchpad.net/ubuntu/+filebug</a></font></div><div><font face="monospace, monospace">Installed-Size: 577 kB</font></div><div><font face="monospace, monospace">Depends: php-common, php-pear (>= 1.10.0)</font></div><div><font face="monospace, monospace">Homepage: <a href="http://pear.php.net/package/DB">http://pear.php.net/package/DB</a></font></div><div><font face="monospace, monospace">Download-Size: 71.4 kB</font></div><div><font face="monospace, monospace">APT-Manual-Installed: yes</font></div><div><font face="monospace, monospace">APT-Sources: <a href="http://cl.archive.ubuntu.com/ubuntu">http://cl.archive.ubuntu.com/ubuntu</a> bionic/universe amd64 Packages</font></div><div><font face="monospace, monospace">Description: Database Abstraction Layer</font></div><div><font face="monospace, monospace"> DB is a database abstraction layer providing:</font></div><div><font face="monospace, monospace"> * an OO-style query API</font></div><div><font face="monospace, monospace"> * portability features that make programs written for one DBMS work with</font></div><div><font face="monospace, monospace"> other DBMS's</font></div><div><font face="monospace, monospace"> * a DSN (data source name) format for specifying database servers</font></div><div><font face="monospace, monospace"> * prepare/execute (bind) emulation for databases that don't support it</font></div><div><font face="monospace, monospace"> natively</font></div><div><font face="monospace, monospace"> * a result object for each query response</font></div><div><font face="monospace, monospace"> * portable error codes</font></div><div><font face="monospace, monospace"> * sequence emulation</font></div><div><font face="monospace, monospace"> * sequential and non-sequential row fetching as well as bulk fetching</font></div><div><font face="monospace, monospace"> * formats fetched rows as associative arrays, ordered arrays or objects</font></div><div><font face="monospace, monospace"> * row limit support</font></div><div><font face="monospace, monospace"> * transactions support</font></div><div><font face="monospace, monospace"> * table information interface</font></div><div><font face="monospace, monospace"> * DocBook and phpDocumentor API documentation</font></div><div><font face="monospace, monospace"> .</font></div><div><font face="monospace, monospace"> DB layers itself on top of PHP's existing</font></div><div><font face="monospace, monospace"> database extensions.</font></div><div><font face="monospace, monospace"> .</font></div><div><font face="monospace, monospace"> Drivers for the following extensions pass</font></div><div><font face="monospace, monospace"> the complete test suite and provide</font></div><div><font face="monospace, monospace"> interchangeability when all of DB's</font></div><div><font face="monospace, monospace"> portability options are enabled:</font></div><div><font face="monospace, monospace"> .</font></div><div><font face="monospace, monospace"> fbsql, ibase, informix, msql, mssql,</font></div><div><font face="monospace, monospace"> mysql, mysqli, oci8, odbc, pgsql,</font></div><div><font face="monospace, monospace"> sqlite and sybase.</font></div><div><font face="monospace, monospace"> .</font></div><div><font face="monospace, monospace"> There is also a driver for the dbase</font></div><div><font face="monospace, monospace"> extension, but it can't be used</font></div><div><font face="monospace, monospace"> interchangeably because dbase doesn't</font></div><div><font face="monospace, monospace"> support many standard DBMS features.</font></div><div><font face="monospace, monospace"> .</font></div><div><font face="monospace, monospace"> DB is compatible with PHP 5 and PHP 7.</font></div></div><div><span style="font-family:arial,helvetica,sans-serif"><br></span></div><div>And here's the PHP info about <font face="monospace, monospace">mysqli</font>:</div><div><br></div><div><div><font face="monospace, monospace">$ php -i | grep "mysqli"</font></div><div><font face="monospace, monospace">/etc/php/7.2/cli/conf.d/20-mysqli.ini,</font></div><div><font face="monospace, monospace">mysqli</font></div><div><font face="monospace, monospace">MysqlI Support => enabled</font></div><div><font face="monospace, monospace">mysqli.allow_local_infile => Off => Off</font></div><div><font face="monospace, monospace">mysqli.allow_persistent => On => On</font></div><div><font face="monospace, monospace">mysqli.default_host => no value => no value</font></div><div><font face="monospace, monospace">mysqli.default_port => 3306 => 3306</font></div><div><font face="monospace, monospace">mysqli.default_pw => no value => no value</font></div><div><font face="monospace, monospace">mysqli.default_socket => no value => no value</font></div><div><font face="monospace, monospace">mysqli.default_user => no value => no value</font></div><div><font face="monospace, monospace">mysqli.max_links => Unlimited => Unlimited</font></div><div><font face="monospace, monospace">mysqli.max_persistent => Unlimited => Unlimited</font></div><div><font face="monospace, monospace">mysqli.reconnect => Off => Off</font></div><div><font face="monospace, monospace">mysqli.rollback_on_cached_plink => Off => Off</font></div><div><font face="monospace, monospace">API Extensions => mysqli,pdo_mysql</font></div></div><div><br></div><div><font face="arial, helvetica, sans-serif">Also note that in </font><font face="monospace, monospace">/etc/php/7.2/apache2/php.ini</font><font face="arial, helvetica, sans-serif">, I've got both </font><span style="color:rgb(0,0,0)"><font face="monospace, monospace">extension=gd2</font><font face="arial, helvetica, sans-serif"> and </font></span><span style="color:rgb(0,0,0)"><font face="monospace, monospace">extension=mysqli</font></span><span style="font-family:arial,helvetica,sans-serif;color:rgb(0,0,0)"> <u>un</u>commented, for what that's worth.</span></div><div><br></div><div>Hope this helps!</div><div><br></div><div>Best wishes,</div><div>Scott</div><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, May 12, 2019 at 12:39 PM Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-GB">
<div class="gmail-m_-7687665407045022106gmail-m_4106023708015916959WordSection1">
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">>>></span> One further issue: when I go to
<i>Admin tools</i> > <i>Manage text metadata</i> > <i>Create metadata table from corpus XML annotations</i> and then hit the
<i>Create metadata table from XML using the settings above</i> button, there's a brief pause and I then land on a blank screen. There's no error message (or anything else) there.<u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">There will probably be an error message in your Apache log (/var/log/apache2/error.log ; yesterday’s is .1, the day before’s .2, etc.)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">best<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">Andrew.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif"> <a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a> <<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a>>
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 12 May 2019 05:16<br>
<b>To:</b> Open source development of the Corpus WorkBench <<a href="mailto:cwb@sslmit.unibo.it" target="_blank">cwb@sslmit.unibo.it</a>><br>
<b>Subject:</b> Re: [CWB] [CQPweb] Final step? Getting Apache to point at CQPweb's root directory<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">On Sat, May 11, 2019 at 8:05 PM Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> wrote:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">All 3 issues fixed in latest commit, thanks for the bug reports.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">(1 & 2 were the same bug.)</span><u></u><u></u></p>
</div>
</div>
</blockquote>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks very much, Andrew. Now, all the buttons on URL/dickens/index.php?ui=manageFreqLists work correctly.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">One further issue: when I go to <i>Admin tools</i> > <i>Manage text metadata</i> > <i>Create metadata table from corpus XML annotations</i> and then hit the
<i>Create metadata table from XML using the settings above</i> button, there's a brief pause and I then land on a blank screen. There's no error message (or anything else) there.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Cheers,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Scott<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span lang="EN-US" style="font-size:11pt;font-family:Calibri,sans-serif">
<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a> <<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a>>
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 11 May 2019 21:26<br>
<b>To:</b> Uhrig, Peter <<a href="mailto:peter.uhrig@fau.de" target="_blank">peter.uhrig@fau.de</a>><br>
<b>Cc:</b> Open source development of the Corpus WorkBench <<a href="mailto:cwb@sslmit.unibo.it" target="_blank">cwb@sslmit.unibo.it</a>><br>
<b>Subject:</b> Re: [CWB] [CQPweb] Final step? Getting Apache to point at CQPweb's root directory</span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Dear Andrew, Peter and everyone else,<u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks so much for your guys' assistance! I've now got the CQPweb server up and running in a VM and it seems to be mostly working. I'm running into a few problems with CQPweb itself,
though, and I'd greatly appreciate a hand.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I can successfully import the Dickens corpus (<i>Install new corpus</i> > <i>Click here to install a corpus you have already indexed in CWB
</i>> [fill in appropriate fields] > <i>Install corpus with settings above</i>). And I can successfully add the metadata (<i>Design and insert a text-metadata table for the corpus</i> >
<i>Click here to install metadata from within-corpus XML annotation</i> > [select fields and add descriptions] >
<i>Create metadata table from XML using the settings above</i>). <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I can also create the frequency table for text begin/end positions (<i>Admin tools</i> >
<i>Manage frequency lists</i> > <i>Text begin/end positions</i> > <i>Update CWB text-position records</i>). So far, so good!<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><b>PROBLEM 1.</b> When I go to create the text-by-text frequency lists (<i>Admin tools</i> > <i>Manage frequency lists</i> >
<i>Text-by-text freq-lists</i> > <i>Update CWB frequency table</i>) I get an error [1].<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><b>PROBLEM 2.</b> When I go to create the word and annotation frequency tables (<i>Admin tools</i> > <i>Manage frequency lists</i> >
<i>Frequency tables</i> > <i>Create frequency tables</i>) I get an error [2].<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">In both cases there's a 4-5 second delay between when I hit the button and when the error us shown, accompanied by a large CPU spike, so something right is presumably happening
before the errors are thrown.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><b>PROBLEM 3:</b> <i>Backend system</i> >
<i>View a MySQL table</i> fails with an error [3].<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><b>PROBLEM 4:</b> Diagnosing problems with
<i>Backend system</i> > <i>System diagnostics</i> fails with a blank screen.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks in advance!<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Scott<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><b>[1] ERROR WHEN CREATING Text-by-text freq-lists</b><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">CQPweb encountered an error and could not continue.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">An SQL query did not run successfully!</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Original query: analyze NO_WRITE_TO_BINLOG table /* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:02 */</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Error # 1064: 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 '' at line 2</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">PHP debugging backtrace</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">array(7) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(300)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(9) "exiterror"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(38) "An SQL query did not run successfully!"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(131) "Original query: </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">analyze NO_WRITE_TO_BINLOG table </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> /* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:02 */</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(161) "Error # 1064: 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 '' at line 2 "</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> NULL</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> NULL</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(178)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(20) "exiterror_mysqlquery"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(1064)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(146) "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 '' at line 2"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(111) "analyze NO_WRITE_TO_BINLOG table </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> /* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:02 */"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [3]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(579)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(12) "do_sql_query"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(111) "analyze NO_WRITE_TO_BINLOG table </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> /* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:02 */"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [4]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(39) "/var/www/html/cqpweb/lib/corpus-lib.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(751)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(18) "get_sql_table_size"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(4) "word"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [5]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(42) "/var/www/html/cqpweb/lib/freqtable-lib.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(695)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(28) "update_corpus_freqtable_size"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(7) "dickens"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [6]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(36) "/var/www/html/cqpweb/lib/execute.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(177)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(19) "make_cwb_freq_index"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(7) "dickens"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [7]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(36) "/var/www/html/cqpweb/exe/execute.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(1)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(36) "/var/www/html/cqpweb/lib/execute.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(7) "require"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">}</span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><b>[2] ERROR WHEN CREATING Word and annotation frequency tables</b><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">CQPweb encountered an error and could not continue.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">An SQL query did not run successfully!</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Original query: analyze NO_WRITE_TO_BINLOG table /* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:08 */</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Error # 1064: 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 '' at line 2</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">PHP debugging backtrace</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">array(7) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(300)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(9) "exiterror"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(38) "An SQL query did not run successfully!"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(131) "Original query: </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">analyze NO_WRITE_TO_BINLOG table </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> /* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:08 */</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(161) "Error # 1064: 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 '' at line 2 "</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> NULL</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> NULL</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(178)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(20) "exiterror_mysqlquery"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(1064)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(146) "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 '' at line 2"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(111) "analyze NO_WRITE_TO_BINLOG table </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> /* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:08 */"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [3]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(579)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(12) "do_sql_query"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(111) "analyze NO_WRITE_TO_BINLOG table </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> /* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:08 */"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [4]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(39) "/var/www/html/cqpweb/lib/corpus-lib.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(751)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(18) "get_sql_table_size"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(4) "word"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [5]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(42) "/var/www/html/cqpweb/lib/freqtable-lib.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(166)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(28) "update_corpus_freqtable_size"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(7) "dickens"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [6]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(36) "/var/www/html/cqpweb/lib/execute.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(177)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(22) "corpus_make_freqtables"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(7) "dickens"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [7]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(36) "/var/www/html/cqpweb/exe/execute.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(1)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(36) "/var/www/html/cqpweb/lib/execute.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(7) "require"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">}</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">CQPweb v3.2.34 © 2008-2019 Help! on CQPweb You are logged in as user [scott]</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-family:Arial,sans-serif">[3]
<i>BACKEND SYSTEM</i> > </span><i>VIEW A MYSQL TABLE</i></b> <b><span style="font-family:Arial,sans-serif">ERROR</span></b><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Viewing mySQL table</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">An SQL query did not run successfully!</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Original query: SELECT * FROM `` /* from User: scott | Function: do_adm_ui_tableview() | 2019-May-11 17:20 */</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Error # 1103: Incorrect table name ''</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">PHP debugging backtrace</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">array(5) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(300)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(9) "exiterror"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(38) "An SQL query did not run successfully!"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(115) "Original query: </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">SELECT * FROM `` </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> /* from User: scott | Function: do_adm_ui_tableview() | 2019-May-11 17:20 */</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(38) "Error # 1103: Incorrect table name '' "</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> NULL</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> NULL</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(178)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(20) "exiterror_mysqlquery"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(1103)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(23) "Incorrect table name ''"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(95) "SELECT * FROM `` </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> /* from User: scott | Function: do_adm_ui_tableview() | 2019-May-11 17:20 */"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [3]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(45) "/var/www/html/cqpweb/lib/admin-home-forms.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(5267)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(12) "do_sql_query"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(95) "SELECT * FROM `` </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> /* from User: scott | Function: do_adm_ui_tableview() | 2019-May-11 17:20 */"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [4]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(38) "/var/www/html/cqpweb/lib/adminhome.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(361)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(19) "do_adm_ui_tableview"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(0) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [5]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(34) "/var/www/html/cqpweb/adm/index.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> int(1)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(38) "/var/www/html/cqpweb/lib/adminhome.php"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> string(7) "require"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">}</span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">On Thu, May 9, 2019 at 2:36 PM Uhrig, Peter <<a href="mailto:peter.uhrig@fau.de" target="_blank">peter.uhrig@fau.de</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin:5pt 0cm 5pt 4.8pt">
<div>
<div>
<p class="MsoNormal"><span lang="DE" style="color:rgb(0,112,192)">Hi Scott,</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="DE" style="color:rgb(0,112,192)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">I hope it is okay if I answer.</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">> I've got two copies of </span><span lang="EN-US" style="font-family:"Courier New"">000-default.conf</span><span lang="EN-US"> on a fresh Apache install, one
in </span><span lang="EN-US" style="font-family:"Courier New"">/etc/apache2/sites-available/</span><span lang="EN-US"> and one in </span><span lang="EN-US" style="font-family:"Courier New"">/etc/apache2/site</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Courier New"">> enabled/</span><span lang="EN-US">. </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">This is very unlikely. What you usually have is the file in sites-available and a symbolic link to that file in sites-enabled. These links
are created by the helper command a2ensite (=apache2 enable site) and removed by a2dissite (=apache2 disable site).</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">So to answer your questions:</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<div>
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">1. Is
</span><span lang="EN-US" style="font-family:"Courier New"">/sites-enabled</span><span lang="EN-US"> then the best place for the
</span><span lang="EN-US" style="font-family:"Courier New""><Directory></span><span lang="EN-US"> directive for the purposes I outlined above?</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">Usually, this would be changed in the file which sits in sites-available and thus also be there in the link to it in sites-enabled.</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">2. Is adding the </span><span lang="EN-US" style="font-family:"Courier New""><Directory></span><span lang="EN-US"> directive to the appropriate </span><span lang="EN-US" style="font-family:"Courier New"">000-default.conf</span><span lang="EN-US">
file enough to change the server's document root, or are additional steps required?</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">You need to change the following line in that file:</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">DocumentRoot /var/www/html</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">to</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">DocumentRoot /var/www/html/cqpweb</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">This line sits in the Virtual Host *:80 by default, which means it will react to whatever it is called with on port 80. This is the default.
Leave it like that.</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">A note: If you followed Andrew’s installation instructions, the directory is actually called /var/www/html/CQPweb – the capitalization makes
a difference, so you may want to double-check.</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">As far as I know, you will not need this directory directive.</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">3. Considering you recommend against virtual hosts, should I delete the large
</span><span lang="EN-US" style="font-family:"Courier New""><VirtualHost></span><span lang="EN-US"> entry that's already in both copies of </span><span lang="EN-US" style="font-family:"Courier New"">000-default.conf</span><span lang="EN-US">, or just add the </span><span lang="EN-US" style="font-family:"Courier New""><Directory></span><span lang="EN-US"> directive
before or after it? </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">Leave it as it is.</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">4. And finally, is the following correct?</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><span lang="DE" style="font-family:"Courier New""><Directory "/var/www/html/cqpweb"></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE" style="font-family:"Courier New""> AllowOverride None</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE" style="font-family:"Courier New""> Require all granted</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE" style="font-family:"Courier New""> Options FollowSymlinks</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE" style="font-family:"Courier New""></Directory></span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><span lang="DE"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE">I ask because the your manual and Stefan's instruction document have different options for
</span><span lang="DE" style="font-family:"Courier New"">AllowOverride</span><span lang="DE">, and also because </span><span lang="DE" style="font-family:"Courier New"">Options FollowSymlinks</span><span lang="DE"> doesn't appear in much documentation (in fact,
I'm not sure where I got it from!).</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">Looks good to me, but I don’t think you need any of this. What is your OS?</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">Best,</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">Peter</span><u></u><u></u></p>
</div>
</div>
</div>
<p class="MsoNormal"><span lang="DE"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="DE"> </span><u></u><u></u></p>
<div>
<div>
<p class="MsoNormal"><span lang="DE">On Thu, May 9, 2019 at 8:16 AM Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> wrote:</span><u></u><u></u></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin:5pt 0cm 5pt 4.8pt">
<div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">Hi Scott,</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">The <Directory> directive doesn’t turn a folder into your server’s root : it just specifies options
that apply only to that folder.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">the directive that specifies the root is
<b>DocumentRoot</b> and depending on your setup you may find it in <b>apache2.conf</b> or in
<b>000-default.conf</b> .</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">You have two options, either change the document root, or else simply access your CQPweb via
<a href="http://localhost/cqpweb" target="_blank">http://localhost/cqpweb</a> (or whatever) which should be working for you now.
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">Generally I would say that you don’t want to add a “cqpweb” file in sites-available unless you really
do want to operate it as a separate vhost (in which cast you’d need a <VirtualHost> directive in that config file). If you
<i>aren’t</i> using such a vhost then the <Directory> directive should probably go inot 000-default.conf</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">best</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">Andrew
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US">
<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a> <<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a>>
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 09 May 2019 11:33<br>
<b>To:</b> Open source development of the Corpus WorkBench <<a href="mailto:cwb@sslmit.unibo.it" target="_blank">cwb@sslmit.unibo.it</a>><br>
<b>Subject:</b> [CWB] [CQPweb] Final step? Getting Apache to point at CQPweb's root directory</span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Hi All,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Except for the problem pointed out by Peter yesterday [1], which I'm also facing, I seem to be just a step or two away from having a working CQPweb install. I just can't get Apache
to point to CQPweb's directory as its document root. In <span style="font-family:"Courier New"">/etc/apache2/sites-available/cqpweb.conf</span> I've got the following, which I would think would be enough:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""><Directory "/var/www/html/cqpweb"></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> AllowOverride None</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> Require all granted</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> Options FollowSymlinks</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""></Directory></span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">But alas, Apache opens one of those typical "Welcome to Apache" pages rather than
<span style="font-family:"Courier New"">/var/www/html/cqpweb/index.php</span>, which consists of <span style="font-family:"Courier New""><?php require('lib/mainhome.php');</span>, and so is clearly not what's being opened. Could someone point me in the right
direction? I've tried both <span style="font-family:"Courier New"">AllowOverride None</span> (as per the admin manual) and
<span style="font-family:"Courier New"">AllowOverride All</span> (as per Stefan's instruction document), to no avail.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> </p></div></div></div></div></div></div></div></div></blockquote></div></div></div></blockquote></div></div></div></blockquote></div></div></div></div></div></div>
</blockquote></div></div></div></div></div></div></div></div></div></div></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail-m_-7687665407045022106gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div style="font-size:12.7273px">Dr. Scott Sadowsky<br>Profesor Asistente de Lingüística</div><div dir="ltr" style="font-size:12.7273px">Pontificia Universidad Católica de Chile<br></div><div dir="ltr" style="font-size:12.7273px"><br></div><div dir="ltr" style="font-size:12.7273px">ssadowsky gmail com</div><div dir="ltr" style="font-size:12.7273px">scsadowsky uc cl<br><a href="http://sadowsky.cl/" target="_blank">http://sadowsky.cl/</a></div><div dir="ltr" style="font-size:12.7273px"> </div></div></div></div></div></div></div></div></div></div></div>