<div dir="ltr"><div><div><div><div>Hi Andrew<br></div>You are right! I have two installation of CQPweb with different database names.<br></div>Sorry for adding noise to the list.<br></div>Bests,<br></div>Jorge<br><br><div><div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2017-09-20 21:55 GMT+02:00 Hardie, Andrew <span dir="ltr"><<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-GB">
<div class="m_3066685629417750862WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">Hi Jorge,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">Most of that error message is the error printing function itself having trouble (I’ve just committed minor tweaks to the autosetup script to stop these messages
occurring). <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">The actual bit that is producing problems is this:
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal" style="text-indent:36.0pt"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"" lang="EN-US">Could not set database in MySQL connection - critical error!</span></b><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u><u></u></span></b></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">This is an error consequent on a simple call to the select_db method on the MySQL link. If the call returns false, this error is triggered.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">Perhaps the database name is wrong in the config file? (variable $mysql_schema ).<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">(Another possibility is that it is an error in my handling of the mysqli module, which is the interface used in PHP 7, but not in earlier PHP versions.)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">best<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">Andrew.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">PS. NB, v 3.2.27 is still not finished, but I hope it will be in the next day or two.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US"> <a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a> [mailto:<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.<wbr>unibo.it</a>]
<b>On Behalf Of </b>VIVALDI PALATRESI, JORGE<br>
<b>Sent:</b> 20 September 2017 10:53<br>
<b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> [CWB] CQPweb installation issue<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Dear all,<br>
I am encountering a serious problem trying to install an updated version of CQPweb. I have installed the following<u></u><u></u></p>
<ul type="disc">
<li class="MsoNormal">
CQPweb GUI version (3.3.27 revision 1001)<u></u><u></u></li><li class="MsoNormal">
php v 7.0 (+<span lang="EN-US"> php-mysql</span>, <span lang="EN-US">php7.0-zip</span> and<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"" lang="EN-US"> php7.0-gd). Change
</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"" lang="ES">php.ini as required.
</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"" lang="EN-US">Restart apache after installation.</span><u></u><u></u></li><li class="MsoNormal">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"" lang="EN-US">create a mysql database and cqpweb_user as required. Manually checked for access.</span><u></u><u></u></li><li class="MsoNormal">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"" lang="EN-US">Create the configuration file.</span><u></u><u></u></li><li class="MsoNormal">
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif"" lang="EN-US">Failed to completing the setup with the following error message:</span><u></u><u></u></li></ul>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"" lang="EN-US">jvivaldi@vivaldi:/var/www/<wbr>html/IulaCT/bin$ php autosetup.php<br>
<br>
Now finalising setup for this installation of CQPweb....<br>
PHP Notice: Undefined property: stdClass::$debug_messages_<wbr>textonly in /mnt/vmdata/vivaldi/var/www/<wbr>html/IulaCT/lib/exiterror.inc.<wbr>php on line 88<br>
PHP Notice: Undefined property: stdClass::$debug_messages_<wbr>textonly in /mnt/vmdata/vivaldi/var/www/<wbr>html/IulaCT/lib/exiterror.inc.<wbr>php on line 89<br>
PHP Notice: Undefined property: stdClass::$debug_messages_<wbr>textonly in /mnt/vmdata/vivaldi/var/www/<wbr>html/IulaCT/lib/exiterror.inc.<wbr>php on line 91<br>
<tr><td class="concorderror"><p>&nbsp;<wbr></p><p class="errormessage">Could not set database in MySQL connection - critical error!</p><p>&nbsp;</p></td></<wbr>tr><br>
<br>
PHP Notice: Undefined property: stdClass::$all_users_see_<wbr>backtrace in /mnt/vmdata/vivaldi/var/www/<wbr>html/IulaCT/lib/exiterror.inc.<wbr>php on line 113<br>
PHP Notice: Undefined property: stdClass::$debug_messages_<wbr>textonly in /mnt/vmdata/vivaldi/var/www/<wbr>html/IulaCT/lib/exiterror.inc.<wbr>php on line 140<br>
</table><br>
PHP Fatal error: Uncaught Error: Call to undefined function print_html_footer() in /mnt/vmdata/vivaldi/var/www/<wbr>html/IulaCT/lib/exiterror.inc.<wbr>php:159<br>
Stack trace:<br>
#0 /mnt/vmdata/vivaldi/var/www/<wbr>html/IulaCT/lib/exiterror.inc.<wbr>php(202): exiterror_endpage()<br>
#1 /mnt/vmdata/vivaldi/var/www/<wbr>html/IulaCT/lib/library.inc.<wbr>php(177): exiterror('Could not set d...')<br>
#2 /mnt/vmdata/vivaldi/var/www/<wbr>html/IulaCT/bin/autosetup.php(<wbr>71): connect_global_mysql()<br>
#3 {main}<br>
thrown in /mnt/vmdata/vivaldi/var/www/<wbr>html/IulaCT/lib/exiterror.inc.<wbr>php on line 159<br>
jvivaldi@vivaldi:/var/www/<wbr>html/IulaCT/bin$</span><u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"" lang="EN-US">Any suggestion is very welcomed</span><u></u><u></u></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"" lang="EN-US">Thank you in advance</span><u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"" lang="EN-US"><br>
Jorge</span><u></u><u></u></p>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"" lang="EN-US"><br>
<br>
</span>- <br>
<br clear="all">
<u></u><u></u></p>
<div>
<p class="MsoNormal"><br>
-- <u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Jorge Vivaldi Palatresi<br>
Institut Universitari de Lingüística Aplicada<br>
Universitat Pompeu Fabra<br>
C/ Roc Boronat, 138<br>
08018 Barcelona<br>
Espanya<br>
<br>
<a href="tel:+34%20935%2042%2023%2032" value="+34935422332" target="_blank">+34 93 542 2332</a><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>______________________________<wbr>_________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it">CWB@sslmit.unibo.it</a><br>
<a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" rel="noreferrer" target="_blank">http://liste.sslmit.unibo.it/<wbr>mailman/listinfo/cwb</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>Jorge Vivaldi Palatresi<br>Institut Universitari de Lingüística
Aplicada<br>Universitat Pompeu Fabra<br>C/ Roc Boronat, 138<br>08018
Barcelona<br>Espanya<br><br>+34 93 542 2332<br><br></div></div></div></div></div></div></div></div></div></div></div>
</div></div></div></div></div></div>