<div dir="ltr"><div dir="ltr">On Tue, May 14, 2019 at 8:27 AM Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>> wrote:<br></div><div dir="ltr"><br></div><div class="gmail_quote"><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_6298031643109876776WordSection1">
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">This one is because you don’t have the mbstring extension for PHP, which is required.
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-family:Verdana,sans-serif;font-size:10pt">If on Debian / ubuntu,
</span><b style="color:rgb(31,73,125);font-family:Verdana,sans-serif;font-size:10pt">sudo apt-get install php-mbstring</b><br></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125);font-family:Verdana,sans-serif;font-size:10pt">then restart Apache</span></p></div></div></blockquote><div><br></div><div>Thanks for the pointer, Andrew. Installing <font face="courier new, monospace">php-mbstring</font> does indeed allow the STTR to be calculated manually, using the <font face="courier new, monospace">php execute-cli.php update_all_missing_sttr</font> script. It's still not being calculated automatically when creating a corpus, though (I just tried with the latest build, 1202 or so). </div><div><br></div><div>Mind you, I'm actually <i>importing</i> the corpus I'm using into CQPweb (I compile it with CQP on another machine). Could this be the issue?</div><div><br></div><div>Cheers,</div><div>Scott</div><div><br></div><div><br></div><div> </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_6298031643109876776WordSection1"><p class="MsoNormal"><br></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">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> 14 May 2019 07:43<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>
<p class="MsoNormal">Fixed indeed, Andrew. Thanks so much!<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">On another matter, corpus creation doesn't seem to generate the STTR statistic that the manual indicates it should (13.10). The Corpus Metadata page simply states:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<blockquote style="margin-left:30pt;margin-right:0cm">
<div>
<p class="MsoNormal">Standardised type:token ratio (1,000-token basis) / Cannot be displayed (STTR not cached)<u></u><u></u></p>
</div>
</blockquote>
<div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">I ran the script to generate the STTR, and got the following error:<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"">/var/www/html/cqpweb/bin$ php execute-cli.php update_all_missing_sttr</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 Fatal error: Uncaught Error: Call to undefined function mb_strtolower() in /var/www/html/cqpweb/lib/corpus-lib.php:644</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Stack trace:</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">#0 /var/www/html/cqpweb/lib/corpus-lib.php(585): calculate_sttr('coscach', 1000)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">#1 /var/www/html/cqpweb/lib/admin-lib.php(1247): update_corpus_sttr('coscach')</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">#2 /var/www/html/cqpweb/lib/execute.php(177): update_all_missing_sttr()</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">#3 /var/www/html/cqpweb/bin/execute-cli.php(59): require('/var/www/html/c...')</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">#4 {main}</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> thrown in /var/www/html/cqpweb/lib/corpus-lib.php on line 644</span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Running the script with sudo had the same result.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Best wishes,<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">On Sun, May 12, 2019 at 6:09 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>
<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)">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)">I think I’ve fixed this bug.
</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)">Re the messages about gd and mysqli, they weren’t the cause of this issue, and I suspect they are not
a problem. </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)">This bit explains the issue:</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-family:"Courier New"">(tried:
<b>/usr/lib/php/20170718/gd2</b> (/usr/lib/php/20170718/gd2: cannot open shared object file: No such file or directory),
<b>/usr/lib/php/20170718/gd2.so</b> (/usr/lib/php/20170718/gd2.so: cannot open shared object file: No such file or directory))</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)">It is looking for these extensions in a place where they aren’t. However, subsequent to this things
work normally, so I guess this is just something that happens at startup.</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> 12 May 2019 19:40<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</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>
<p class="MsoNormal">Dear Andrew,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Here's the last part of my
<span style="font-family:"Courier New"">/var/log/apache2/error.log</span>:<u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">[Sun May 12 13:27:42.660546 2019] [mpm_prefork:notice] [pid 30430] AH00171: Graceful restart requested, doing restart</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">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</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">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</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">[Sun May 12 13:27:42.702400 2019] [mpm_prefork:notice] [pid 30430] AH00163: Apache/2.4.29 (Ubuntu) configured -- resuming normal operations</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">[Sun May 12 13:27:42.702429 2019] [core:notice] [pid 30430] AH00094: Command line: '/usr/sbin/apache2'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">[Sun May 12 13:27:42.793641 2019] [mpm_prefork:notice] [pid 30430] AH00169: caught SIGTERM, shutting down</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">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</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">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</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">[Sun May 12 13:27:42.877221 2019] [mpm_prefork:notice] [pid 31262] AH00163: Apache/2.4.29 (Ubuntu) configured -- resuming normal operations</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">[Sun May 12 13:27:42.877254 2019] [core:notice] [pid 31262] AH00094: Command line: '/usr/sbin/apache2'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">[Sun May 12 13:30:10.572955 2019] [mpm_prefork:notice] [pid 31262] AH00169: caught SIGTERM, shutting down</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">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</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">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</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">[Sun May 12 13:30:56.766095 2019] [mpm_prefork:notice] [pid 1512] AH00163: Apache/2.4.29 (Ubuntu) configured -- resuming normal operations</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">[Sun May 12 13:30:56.766213 2019] [core:notice] [pid 1512] AH00094: Command line: '/usr/sbin/apache2'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">[Sun May 12 13:42:06.648270 2019] [mpm_prefork:notice] [pid 1512] AH00169: caught SIGTERM, shutting down</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">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</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">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</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">[Sun May 12 13:47:46.622367 2019] [mpm_prefork:notice] [pid 4430] AH00163: Apache/2.4.29 (Ubuntu) configured -- resuming normal operations</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">[Sun May 12 13:47:46.622464 2019] [core:notice] [pid 4430] AH00094: Command line: '/usr/sbin/apache2'</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">[Sun May 12 13:59:18.897264 2019] [php7:error] [pid 4434] [client
</span><a href="http://190.47.255.254:46430" target="_blank"><span style="font-family:"Courier New"">190.47.255.254:46430</span></a><span style="font-family:"Courier New"">] 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:
</span><a href="http://146.155.44.196/dickens/index.php?ui=manageMetadata&createMetadataFromXml=1" target="_blank"><span style="font-family:"Courier New"">http://146.155.44.196/dickens/index.php?ui=manageMetadata&createMetadataFromXml=1</span></a><u></u><u></u></p>
</div>
</div>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">There appear to be obvious problems with my PHP install, as there are errors about not being able to open <span style="font-family:"Courier New"">gd2</span> and <span style="font-family:"Courier New"">mysqli</span>.
But I'm not sure what the problem is, as <span style="font-family:"Courier New"">gd2</span> is installed: <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"">$ sudo apt show php-gd</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Package: php-gd</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Version: 1:7.2+60ubuntu1</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Priority: optional</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Section: php</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Source: php-defaults (60ubuntu1)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Origin: Ubuntu</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Maintainer: Ubuntu Developers <</span><a href="mailto:ubuntu-devel-discuss@lists.ubuntu.com" target="_blank"><span style="font-family:"Courier New"">ubuntu-devel-discuss@lists.ubuntu.com</span></a><span style="font-family:"Courier New"">></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Original-Maintainer: Debian PHP Maintainers <</span><a href="mailto:pkg-php-maint@lists.alioth.debian.org" target="_blank"><span style="font-family:"Courier New"">pkg-php-maint@lists.alioth.debian.org</span></a><span style="font-family:"Courier New"">></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Bugs:
</span><a href="https://bugs.launchpad.net/ubuntu/+filebug" target="_blank"><span style="font-family:"Courier New"">https://bugs.launchpad.net/ubuntu/+filebug</span></a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Installed-Size: 12.3 kB</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Depends: php-common, php7.2-gd</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Supported: 5y</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Download-Size: 1,996 B</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">APT-Manual-Installed: yes</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">APT-Sources:
</span><a href="http://cl.archive.ubuntu.com/ubuntu" target="_blank"><span style="font-family:"Courier New"">http://cl.archive.ubuntu.com/ubuntu</span></a><span style="font-family:"Courier New""> bionic/main amd64 Packages</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Description: GD module for PHP [default]</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> This package provides a GD module for PHP.</span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif">Furthermore, PHP
<i>seems</i> to indicate GD is enabled (assuming I'm interpreting this file correctly):</span><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"">$ php -i | grep "GD"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">gd</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">/etc/php/7.2/cli/conf.d/20-gd.ini,</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">GD Support => enabled</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">GD headers Version => 2.2.5</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">GD library Version => 2.2.5</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">gd.jpeg_ignore_warning => 1 => 1</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif"> </span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif">As to
</span><span style="font-family:"Courier New"">mysqli</span><span style="font-family:Arial,sans-serif">, it doesn't have it's own package, but appears to be part of </span><span style="font-family:"Courier New"">php-db</span><span style="font-family:Arial,sans-serif">,
which I have installed:</span><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"">$ sudo apt show php-db</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Package: php-db</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Version: 1.9.2-2ubuntu1</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Priority: optional</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Section: universe/web</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Origin: Ubuntu</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Maintainer: Ubuntu Developers <</span><a href="mailto:ubuntu-devel-discuss@lists.ubuntu.com" target="_blank"><span style="font-family:"Courier New"">ubuntu-devel-discuss@lists.ubuntu.com</span></a><span style="font-family:"Courier New"">></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Original-Maintainer: Debian PHP PEAR Maintainers <</span><a href="mailto:pkg-php-pear@lists.alioth.debian.org" target="_blank"><span style="font-family:"Courier New"">pkg-php-pear@lists.alioth.debian.org</span></a><span style="font-family:"Courier New"">></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Bugs:
</span><a href="https://bugs.launchpad.net/ubuntu/+filebug" target="_blank"><span style="font-family:"Courier New"">https://bugs.launchpad.net/ubuntu/+filebug</span></a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Installed-Size: 577 kB</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Depends: php-common, php-pear (>= 1.10.0)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Homepage:
</span><a href="http://pear.php.net/package/DB" target="_blank"><span style="font-family:"Courier New"">http://pear.php.net/package/DB</span></a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Download-Size: 71.4 kB</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">APT-Manual-Installed: yes</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">APT-Sources:
</span><a href="http://cl.archive.ubuntu.com/ubuntu" target="_blank"><span style="font-family:"Courier New"">http://cl.archive.ubuntu.com/ubuntu</span></a><span style="font-family:"Courier New""> bionic/universe amd64 Packages</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">Description: Database Abstraction Layer</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> DB is a database abstraction layer providing:</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> * an OO-style query API</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> * portability features that make programs written for one DBMS work with</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> other DBMS's</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> * a DSN (data source name) format for specifying database servers</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> * prepare/execute (bind) emulation for databases that don't support it</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> natively</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> * a result object for each query response</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> * portable error codes</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> * sequence emulation</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> * sequential and non-sequential row fetching as well as bulk fetching</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> * formats fetched rows as associative arrays, ordered arrays or objects</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> * row limit support</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> * transactions support</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> * table information interface</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> * DocBook and phpDocumentor API documentation</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""> DB layers itself on top of PHP's existing</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> database extensions.</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""> Drivers for the following extensions pass</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> the complete test suite and provide</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> interchangeability when all of DB's</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> portability options are enabled:</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""> fbsql, ibase, informix, msql, mssql,</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> mysql, mysqli, oci8, odbc, pgsql,</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> sqlite and sybase.</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""> There is also a driver for the dbase</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> extension, but it can't be used</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> interchangeably because dbase doesn't</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> support many standard DBMS features.</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""> DB is compatible with PHP 5 and PHP 7.</span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">And here's the PHP info about
<span style="font-family:"Courier New"">mysqli</span>:<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"">$ php -i | grep "mysqli"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">/etc/php/7.2/cli/conf.d/20-mysqli.ini,</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">mysqli</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">MysqlI Support => enabled</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">mysqli.allow_local_infile => Off => Off</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">mysqli.allow_persistent => On => On</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">mysqli.default_host => no value => no value</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">mysqli.default_port => 3306 => 3306</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">mysqli.default_pw => no value => no value</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">mysqli.default_socket => no value => no value</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">mysqli.default_user => no value => no value</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">mysqli.max_links => Unlimited => Unlimited</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">mysqli.max_persistent => Unlimited => Unlimited</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">mysqli.reconnect => Off => Off</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">mysqli.rollback_on_cached_plink => Off => Off</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">API Extensions => mysqli,pdo_mysql</span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif">Also note that in </span><span style="font-family:"Courier New"">/etc/php/7.2/apache2/php.ini</span><span style="font-family:Arial,sans-serif">,
I've got both </span><span style="font-family:"Courier New";color:black">extension=gd2</span><span style="font-family:Arial,sans-serif;color:black"> and </span><span style="font-family:"Courier New";color:black">extension=mysqli</span><span style="font-family:Arial,sans-serif;color:black">
<u>un</u>commented, for what that's worth.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Hope this helps!<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Best wishes,<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>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">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:<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" style="margin-left:4.8pt">
<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" style="margin-left:4.8pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:4.8pt">
<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.)</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:4.8pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:4.8pt">
<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" style="margin-left:4.8pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:4.8pt">
<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" style="margin-left:4.8pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:4.8pt">
<b><span lang="EN-US">From:</span></b><span lang="EN-US"> </span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US"> <</span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US">>
<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 <</span><a href="mailto:cwb@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb@sslmit.unibo.it</span></a><span lang="EN-US">><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" style="margin-left:4.8pt">
<u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-left:4.8pt">
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" style="margin-left:4.8pt">
<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" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:4.8pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:4.8pt">
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" style="margin-left:4.8pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:4.8pt">
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" style="margin-left:4.8pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:4.8pt">
Cheers,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:4.8pt">
Scott<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:4.8pt">
<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" style="margin-left:9.6pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:9.6pt">
<b><span lang="EN-US">From:</span></b><span lang="EN-US"> </span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US"> <</span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US">>
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 11 May 2019 21:26<br>
<b>To:</b> Uhrig, Peter <</span><a href="mailto:peter.uhrig@fau.de" target="_blank"><span lang="EN-US">peter.uhrig@fau.de</span></a><span lang="EN-US">><br>
<b>Cc:</b> Open source development of the Corpus WorkBench <</span><a href="mailto:cwb@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb@sslmit.unibo.it</span></a><span lang="EN-US">><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" style="margin-left:9.6pt">
<u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
Dear Andrew, Peter and everyone else,<u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
Thanks in advance!<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
Scott<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<b>[1] ERROR WHEN CREATING Text-by-text freq-lists</b><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">An SQL query did not run successfully!</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">PHP debugging backtrace</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">array(7) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(300)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(9) "exiterror"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(131) "Original query: </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">analyze NO_WRITE_TO_BINLOG table </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> NULL</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> NULL</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(178)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(20) "exiterror_mysqlquery"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(1064)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [3]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(579)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(12) "do_sql_query"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [4]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(751)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(18) "get_sql_table_size"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(4) "word"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [5]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(695)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(28) "update_corpus_freqtable_size"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(7) "dickens"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [6]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(177)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(19) "make_cwb_freq_index"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(7) "dickens"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [7]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(1)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(7) "require"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">}</span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<b>[2] ERROR WHEN CREATING Word and annotation frequency tables</b><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">An SQL query did not run successfully!</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">PHP debugging backtrace</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">array(7) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(300)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(9) "exiterror"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(131) "Original query: </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">analyze NO_WRITE_TO_BINLOG table </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> NULL</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> NULL</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(178)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(20) "exiterror_mysqlquery"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(1064)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [3]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(579)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(12) "do_sql_query"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [4]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(751)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(18) "get_sql_table_size"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(4) "word"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [5]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(166)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(28) "update_corpus_freqtable_size"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(7) "dickens"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [6]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(177)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(22) "corpus_make_freqtables"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(7) "dickens"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [7]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(1)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(7) "require"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">}</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">Viewing mySQL table</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">An SQL query did not run successfully!</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">Error # 1103: Incorrect table name ''</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">PHP debugging backtrace</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">array(5) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(300)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(9) "exiterror"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(115) "Original query: </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">SELECT * FROM `` </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(38) "Error # 1103: Incorrect table name '' "</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> NULL</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> NULL</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(178)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(20) "exiterror_mysqlquery"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(3) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(1103)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [1]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(23) "Incorrect table name ''"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [2]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(95) "SELECT * FROM `` </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [3]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(5267)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(12) "do_sql_query"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(95) "SELECT * FROM `` </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [4]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(361)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(19) "do_adm_ui_tableview"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(0) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [5]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(4) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["file"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["line"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> int(1)</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["args"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> array(1) {</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> [0]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<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" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> ["function"]=></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> string(7) "require"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New""> }</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<span style="font-family:"Courier New"">}</span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
<u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-left:9.6pt">
<u></u><u></u></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:9.6pt">
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" style="margin-left:14.4pt">
<span lang="DE" style="color:rgb(0,112,192)">Hi Scott,</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="DE" style="color:rgb(0,112,192)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<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" style="margin-left:14.4pt">
<span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<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" style="margin-left:14.4pt">
<span lang="EN-US" style="font-family:"Courier New"">> enabled/</span><span lang="EN-US">. </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<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" style="margin-left:14.4pt">
<span lang="EN-US" style="color:rgb(0,112,192)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="EN-US" style="color:rgb(0,112,192)">So to answer your questions:</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="EN-US"> </span><u></u><u></u></p>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-left:14.4pt">
<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" style="margin-left:14.4pt">
<span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<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" style="margin-left:14.4pt">
<span lang="EN-US"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:14.4pt">
<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" style="margin-left:14.4pt">
<span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<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" style="margin-left:14.4pt">
<span lang="FR" style="color:rgb(0,112,192)">DocumentRoot /var/www/html</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="FR" style="color:rgb(0,112,192)">to</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="FR" style="color:rgb(0,112,192)">DocumentRoot /var/www/html/cqpweb</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="FR" style="color:rgb(0,112,192)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<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" style="margin-left:14.4pt">
<span lang="EN-US" style="color:rgb(0,112,192)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<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" style="margin-left:14.4pt">
<span lang="EN-US" style="color:rgb(0,112,192)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<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" style="margin-left:14.4pt">
<span lang="EN-US"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:14.4pt">
<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" style="margin-left:14.4pt">
<span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="EN-US" style="color:rgb(0,112,192)">Leave it as it is.</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="EN-US"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="EN-US">4. And finally, is the following correct?</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="EN-US"> </span><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="DE" style="font-family:"Courier New""><Directory "/var/www/html/cqpweb"></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="DE" style="font-family:"Courier New""> AllowOverride None</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="DE" style="font-family:"Courier New""> Require all granted</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="DE" style="font-family:"Courier New""> Options FollowSymlinks</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="DE" style="font-family:"Courier New""></Directory></span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="DE"> </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:14.4pt">
<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" style="margin-left:14.4pt">
<span lang="DE"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<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" style="margin-left:14.4pt">
<span lang="EN-US" style="color:rgb(0,112,192)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="EN-US" style="color:rgb(0,112,192)">Best,</span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="EN-US" style="color:rgb(0,112,192)">Peter</span><u></u><u></u></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="DE"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="DE"> </span><u></u><u></u></p>
<div>
<div>
<p class="MsoNormal" style="margin-left:14.4pt">
<span lang="DE">On Thu, May 9, 2019 at 8:16 AM Hardie, Andrew <</span><a href="mailto:a.hardie@lancaster.ac.uk" target="_blank"><span lang="DE">a.hardie@lancaster.ac.uk</span></a><span lang="DE">> 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" style="margin-left:19.2pt">
<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" style="margin-left:19.2pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:19.2pt">
<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" style="margin-left:19.2pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:19.2pt">
<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" style="margin-left:19.2pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:19.2pt">
<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
</span><a href="http://localhost/cqpweb" target="_blank"><span style="font-size:10pt;font-family:Verdana,sans-serif">http://localhost/cqpweb</span></a><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> (or whatever) which should
be working for you now. </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:19.2pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:19.2pt">
<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" style="margin-left:19.2pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:19.2pt">
<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" style="margin-left:19.2pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:19.2pt">
<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" style="margin-left:19.2pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:19.2pt">
<span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:19.2pt">
<b><span lang="EN-US">From:</span></b><span lang="EN-US"> </span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US"> <</span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US">>
<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 <</span><a href="mailto:cwb@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb@sslmit.unibo.it</span></a><span lang="EN-US">><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" style="margin-left:19.2pt">
<u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-left:19.2pt">
Hi All,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:19.2pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:19.2pt">
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" style="margin-left:19.2pt">
<u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal" style="margin-left:19.2pt">
<span style="font-family:"Courier New""><Directory "/var/www/html/cqpweb"></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:19.2pt">
<span style="font-family:"Courier New""> AllowOverride None</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:19.2pt">
<span style="font-family:"Courier New""> Require all granted</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:19.2pt">
<span style="font-family:"Courier New""> Options FollowSymlinks</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:19.2pt">
<span style="font-family:"Courier New""></Directory></span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-left:19.2pt">
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:19.2pt">
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" style="margin-left:19.2pt">
<u></u><u></u></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>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it" target="_blank">CWB@sslmit.unibo.it</a><br>
<a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" rel="noreferrer" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_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></div>