<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><div><div dir="ltr">(sorry for repost - used wrong sender email) - This time I managed to get a bit further, but still no successful install/upgrade possible:<div><br></div><div>autosetup on empty database:</div><div><br></div><div><div><font size="2">Updated to Revision 504.</font></div><div><font size="2">mki@ubuntu:/var/www/cqp-web-beta$ cd bin/</font></div><div><font size="2">mki@ubuntu:/var/www/cqp-web-beta/bin$ sudo php ./autosetup.php </font></div><div><font size="2">CQPweb has encountered an error!</font></div><div><font size="2">================================</font></div><div><font size="2"><br></font></div><div><font size="2"><span class="ecxApple-tab-span" style="white-space:pre;"> </span><table class="concordtable" width="100%"></font></div><div><font size="2"><span class="ecxApple-tab-span" style="white-space:pre;"> </span><tr></font></div><div><font size="2"><span class="ecxApple-tab-span" style="white-space:pre;"> </span><th class="concordtable">CQPweb encountered an error and could not continue.</th></font></div><div><font size="2"><span class="ecxApple-tab-span" style="white-space:pre;"> </span></tr></font></div><div><font size="2"><span class="ecxApple-tab-span" style="white-space:pre;"> </span>A mySQL query did not run successfully!</font></div><div><font size="2"><br></font></div><div><font size="2">Original query: </font></div><div><font size="2"><br></font></div><div><font size="2">update user_info set last_seen_time = CURRENT_TIMESTAMP where username='mkiller'</font></div><div><font size="2"><br></font></div><div><font size="2">Error # 1146: Table 'cqpwbeta.user_info' doesn't exist </font></div><div><br></div>or upgrade-database on v3.0.16 database (sql-import into empty database before running script):</div><div><br></div><div><div><font size="2">mki@ubuntu:/var/www/cqp-web-beta/bin$ sudo php ./upgrade-database.php </font></div><div><font size="2">Database version is now at < 3.1.0. Database will now be upgraded to 3.1.0...</font></div><div><font size="2">A mySQL query did not run successfully!</font></div><div><font size="2"><br></font></div><div><font size="2">Original query: </font></div><div><font size="2"><br></font></div><div><font size="2">alter table saved_dbs drop key dbname</font></div><div><font size="2"><br></font></div><div><font size="2"><br></font></div><div><font size="2"><br></font></div><div><font size="2">Error # 1091: Can't DROP 'dbname'; check that column/key exists </font></div></div><div><br></div><div>Best wishes,</div><div>Markus</div><div><br><div><hr id="ecxstopSpelling">From: a.hardie@lancaster.ac.uk<br>To: m.killer@outlook.com; cwb@sslmit.unibo.it<br>Date: Tue, 21 Jan 2014 04:12:06 +0000<br>Subject: Re: [CWB] CQPweb: v 3.1.0 now usable, I think<br><br>
<style><!--
.ExternalClass .ecxshape {
}
--></style><style><!--
.ExternalClass p.ecxMsoNormal, .ExternalClass li.ecxMsoNormal, .ExternalClass div.ecxMsoNormal {
font-size:12.0pt;
font-family:"Times New Roman","serif";
}
.ExternalClass h1 {
font-size:24.0pt;
font-family:"Times New Roman","serif";
font-weight:bold;
}
.ExternalClass a:link, .ExternalClass span.ecxMsoHyperlink {
color:blue;
text-decoration:underline;
}
.ExternalClass span.ecxMsoHyperlinkFollowed {
color:purple;
text-decoration:underline;
}
.ExternalClass p {
font-size:12.0pt;
font-family:"Times New Roman","serif";
}
.ExternalClass pre {
font-size:10.0pt;
font-family:"Courier New";
}
.ExternalClass span.ecxHeading1Char {
font-family:"Cambria","serif";
color:#365F91;
font-weight:bold;
}
.ExternalClass span.ecxHTMLPreformattedChar {
font-family:Consolas;
}
.ExternalClass span.ecxEmailStyle21 {
font-family:"Verdana","sans-serif";
color:#1F497D;
}
.ExternalClass .ecxMsoChpDefault {
font-size:10.0pt;
}
.ExternalClass div.ecxWordSection1 {
}
.ExternalClass ol {
}
.ExternalClass ul {
}
--></style>
<div class="ecxWordSection1">
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D;">Thanks for the bug report; sorry for delay responding. This turned out to be a lingering environment bug from a much earlier version that was newly exposed
by the new scripts. Now fixed in svn.</span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D;"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D;">best</span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D;"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D;">Andrew.</span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D;"> </span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm;">
<p class="ecxMsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";"> cwb-bounces@sslmit.unibo.it [mailto:cwb-bounces@sslmit.unibo.it]
<b>On Behalf Of </b>Markus Killer<br>
<b>Sent:</b> 20 January 2014 19:25<br>
<b>To:</b> cwb@sslmit.unibo.it<br>
<b>Subject:</b> Re: [CWB] CQPweb: v 3.1.0 now usable, I think</span></p>
</div>
</div>
<p class="ecxMsoNormal"> </p>
<div>
<pre><span style="font-size:12.0pt;font-family:"Times New Roman","serif";">Dear Andrew,</span></pre>
<pre style="white-space:pre-wrap;"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";"> </span></pre>
<pre><span style="font-size:12.0pt;font-family:"Times New Roman","serif";">Thanks a lot for the update to v3.1.0. Today, I've successfully installed and configured v3.0.16 on a Xubuntu 12.04 LTS (64-bit) system. However, I didn't manage to get v3.1.0 (svn rev 497) running. </span></pre>
<pre style="white-space:pre-wrap;"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";">When I try to run the autosetup script, I get the following php notices and a fatal error:</span></pre>
<pre><span style="font-size:13.5pt;">$php autosetup.php </span></pre>
<pre><span style="font-size:13.5pt;">PHP Notice: Undefined offset: 1 in /var/www/cqp-web-beta/lib/defaults.inc.php on line 446</span></pre>
<pre><span style="font-size:13.5pt;">PHP Notice: Undefined offset: 1 in /var/www/cqp-web-beta/lib/defaults.inc.php on line 446</span></pre>
<pre><span style="font-size:13.5pt;">PHP Fatal error: Call to a member function is_admin() on a non-object in /var/www/cqp-web-beta/lib/exiterror.inc.php on line 282</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";"></span></pre>
<div>
<pre style="white-space:pre-wrap;"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";">I then went on to try an upgrade from v3.0.16, but the update upgrade-database.php script terminates with the same php fatal error.</span></pre>
<pre style="white-space:pre-wrap;"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";">Best wishes,</span></pre>
<pre style="white-space:pre-wrap;"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";">Markus</span></pre>
</div>
<pre style="white-space:pre-wrap;"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";"> </span></pre>
<h1>[CWB] CQPweb: v 3.1.0 now usable, I think</h1>
<p class="ecxMsoNormal"><b><span style="font-size:13.5pt;">Hardie, Andrew</span></b> <span style="font-family:"Calibri","sans-serif";"><a href="mailto:cwb%40sslmit.unibo.it?Subject=Re:%20Re%3A%20%5BCWB%5D%20CQPweb%3A%20v%203.1.0%20now%20usable%2C%20I%20think&In-Reply-To=%3C28078EC3FBF1B940A3EF3D0D19BE351D2CC631%40EX-0-MB1.lancs.local%3E" title="[CWB] CQPweb: v 3.1.0 now usable, I think"><span style="font-size:13.5pt;font-family:"Times New Roman","serif";">a.hardie
at lancaster.ac.uk </span></a></span><span style="font-size:13.5pt;"><br>
<i>Mon Jan 20 09:19:41 CET 2014</i></span><span style="font-family:"Calibri","sans-serif";"></span></p>
<ul>
<li class="ecxMsoNormal" style="">
<span style="font-size:13.5pt;">Previous message: <a href="http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/001480.html" target="_blank">[CWB] [cwb:bugs] #60 CQPweb : metadata from XML, primary classification not set</a></span></li><li class="ecxMsoNormal" style="">
<span style="font-size:13.5pt;">Next message: <a href="http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/001482.html" target="_blank">[CWB] CQPweb: v 3.1.0 now usable, I think</a></span></li><li class="ecxMsoNormal" style="">
<b><span style="font-size:13.5pt;">Messages sorted by:</span></b><span style="font-size:13.5pt;"> <a href="http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/date.html#1481" target="_blank">[ date ]</a> <a href="http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/thread.html#1481" target="_blank">[
thread ]</a> <a href="http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/subject.html#1481" target="_blank">[ subject ]</a> <a href="http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/author.html#1481" target="_blank">[ author ]</a></span></li></ul>
<div class="ecxMsoNormal" align="center" style="text-align:center;"><span style="font-family:"Calibri","sans-serif";">
<hr size="2" width="100%" align="center">
</span></div>
<pre style="white-space:pre-wrap;">Hi all,</pre>
<pre> </pre>
<pre>My grand re-structuring of almost everything for CQPweb v 3.1.0 is now finished. </pre>
<pre> </pre>
<pre>There is not much visible difference, but a lot has changed under the bonnet, and this will hopefully make it quicker and easier to implement new features.</pre>
<pre> </pre>
<pre>If you are an adventurous sort, I think you can now safely upgrade to 3.1.0 (repo commit 497). There are probably bugs; reports very welcome.</pre>
<pre> </pre>
<pre>If you are less adventurous, you might want to stick with 3.0.16 a bit longer, until the worst problems are dealt with.</pre>
<pre> </pre>
<pre>Currently 3.1 runs nowhere but on my computer. Later today I hope to upgrade the Lancaster to 3.1, so those of you with accounts on that server can have a look at it later this week to see what has changed.</pre>
<pre> </pre>
<pre>One big change that you won't see from looking at a server is that I have completely revamped the sysadmin documentation. Previously this consisted of a series of HTML files - the maintenance of which has become increasingly hairy over the past couple of years. Now, I have shifted most of these over into a "CQPweb System Administrator's Manual" written in LaTeX and available within the usual documentation tree on the SourceForge repository. I hope that this new format will (a) make it more maintainable (b) make it easier for others to contribute patches. There are still a couple of HTML files to convert; these will be done as and when I find a moment.</pre>
<pre> </pre>
<pre>Like the CWB and CQP tutorials, the manual compiles to both PDF and HTML; the PDF is included with CQPweb and is also on the website here:</pre>
<pre> </pre>
<pre><a href="http://cwb.sourceforge.net/files/CQPwebAdminManual.pdf" target="_blank">http://cwb.sourceforge.net/files/CQPwebAdminManual.pdf</a> </pre>
<pre> </pre>
<pre>Crucially, it has a couple of sections that between them cover the process of upgrading from v 3.0.16 to 3.1.0, which, given all the changes I have made, is non-straightforward.</pre>
<pre> </pre>
<pre>That's all for now.</pre>
<pre> </pre>
<pre>best</pre>
<pre> </pre>
<pre>Andrew.</pre>
</div>
</div>
<br>_______________________________________________
CWB mailing list
CWB@sslmit.unibo.it
http://devel.sslmit.unibo.it/mailman/listinfo/cwb</div></div> </div></div><style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style> </div></body>
</html>