<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:Cambria;
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Verdana;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Consolas;
        panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
h1
        {mso-style-priority:9;
        mso-style-link:"Heading 1 Char";
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:24.0pt;
        font-family:"Times New Roman","serif";
        font-weight:bold;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
        {mso-style-priority:99;
        mso-style-link:"Balloon Text Char";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:8.0pt;
        font-family:"Tahoma","sans-serif";}
span.ecxapple-tab-span
        {mso-style-name:ecxapple-tab-span;}
span.Heading1Char
        {mso-style-name:"Heading 1 Char";
        mso-style-priority:9;
        mso-style-link:"Heading 1";
        font-family:"Cambria","serif";
        color:#365F91;
        font-weight:bold;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:Consolas;}
p.ecxmsonormal, li.ecxmsonormal, div.ecxmsonormal
        {mso-style-name:ecxmsonormal;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
p.ecxmsochpdefault, li.ecxmsochpdefault, div.ecxmsochpdefault
        {mso-style-name:ecxmsochpdefault;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
span.ecxmsohyperlink
        {mso-style-name:ecxmsohyperlink;}
span.ecxmsohyperlinkfollowed
        {mso-style-name:ecxmsohyperlinkfollowed;}
span.ecxheading1char
        {mso-style-name:ecxheading1char;}
span.ecxhtmlpreformattedchar
        {mso-style-name:ecxhtmlpreformattedchar;}
span.ecxemailstyle21
        {mso-style-name:ecxemailstyle21;}
p.ecxmsonormal1, li.ecxmsonormal1, div.ecxmsonormal1
        {mso-style-name:ecxmsonormal1;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
span.ecxmsohyperlink1
        {mso-style-name:ecxmsohyperlink1;
        color:blue;
        text-decoration:underline;}
span.ecxmsohyperlinkfollowed1
        {mso-style-name:ecxmsohyperlinkfollowed1;
        color:purple;
        text-decoration:underline;}
span.ecxheading1char1
        {mso-style-name:ecxheading1char1;
        font-family:"Cambria","serif";
        color:#365F91;
        font-weight:bold;}
span.ecxhtmlpreformattedchar1
        {mso-style-name:ecxhtmlpreformattedchar1;
        font-family:Consolas;}
span.ecxemailstyle211
        {mso-style-name:ecxemailstyle211;
        font-family:"Verdana","sans-serif";
        color:#1F497D;}
p.ecxmsochpdefault1, li.ecxmsochpdefault1, div.ecxmsochpdefault1
        {mso-style-name:ecxmsochpdefault1;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:10.0pt;
        font-family:"Times New Roman","serif";}
p.ecxmsonormal2, li.ecxmsonormal2, div.ecxmsonormal2
        {mso-style-name:ecxmsonormal2;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
span.ecxmsohyperlink2
        {mso-style-name:ecxmsohyperlink2;
        color:blue;
        text-decoration:underline;}
span.ecxmsohyperlinkfollowed2
        {mso-style-name:ecxmsohyperlinkfollowed2;
        color:purple;
        text-decoration:underline;}
span.ecxheading1char2
        {mso-style-name:ecxheading1char2;
        font-family:"Cambria","serif";
        color:#365F91;
        font-weight:bold;}
span.ecxhtmlpreformattedchar2
        {mso-style-name:ecxhtmlpreformattedchar2;
        font-family:Consolas;}
span.ecxemailstyle212
        {mso-style-name:ecxemailstyle212;
        font-family:"Verdana","sans-serif";
        color:#1F497D;}
p.ecxmsochpdefault2, li.ecxmsochpdefault2, div.ecxmsochpdefault2
        {mso-style-name:ecxmsochpdefault2;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:10.0pt;
        font-family:"Times New Roman","serif";}
span.BalloonTextChar
        {mso-style-name:"Balloon Text Char";
        mso-style-priority:99;
        mso-style-link:"Balloon Text";
        font-family:"Tahoma","sans-serif";}
span.EmailStyle45
        {mso-style-type:personal-reply;
        font-family:"Verdana","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
/* List Definitions */
@list l0
        {mso-list-id:883757742;
        mso-list-template-ids:-1810301756;}
@list l0:level1
        {mso-level-number-format:bullet;
        mso-level-text:\F0B7;
        mso-level-tab-stop:36.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
@list l0:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:72.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:"Courier New";
        mso-bidi-font-family:"Times New Roman";}
@list l0:level3
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:108.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level4
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:144.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level5
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:180.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level6
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:216.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level7
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:252.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level8
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:288.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
@list l0:level9
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:324.0pt;
        mso-level-number-position:left;
        text-indent:-18.0pt;
        mso-ansi-font-size:10.0pt;
        font-family:Wingdings;}
ol
        {margin-bottom:0cm;}
ul
        {margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Fixed in 506, I think.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Andrew.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;"> cwb-bounces@sslmit.unibo.it [mailto:cwb-bounces@sslmit.unibo.it]
<b>On Behalf Of </b>Markus Killer<br>
<b>Sent:</b> 21 January 2014 06:28<br>
<b>To:</b> cwb@sslmit.unibo.it<br>
<b>Subject:</b> Re: [CWB] CQPweb: v 3.1.0 now usable, I think<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">(sorry for repost - used wrong sender email) - This time I managed to get a bit further, but still no successful install/upgrade possible:<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">autosetup on empty database:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">Updated to Revision 504.</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">mki@ubuntu:/var/www/cqp-web-beta$ cd bin/</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">mki@ubuntu:/var/www/cqp-web-beta/bin$ sudo php ./autosetup.php&nbsp;</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">CQPweb has encountered an error!</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">================================</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span class="ecxapple-tab-span"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">&lt;table class=&quot;concordtable&quot; width=&quot;100%&quot;&gt;</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span class="ecxapple-tab-span"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">&lt;tr&gt;</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span class="ecxapple-tab-span"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">&lt;th class=&quot;concordtable&quot;&gt;CQPweb encountered an error and could not continue.&lt;/th&gt;</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span class="ecxapple-tab-span"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">&lt;/tr&gt;</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span class="ecxapple-tab-span"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">A mySQL query did not run successfully!</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">Original query:&nbsp;</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">update user_info set last_seen_time = CURRENT_TIMESTAMP where username='mkiller'</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">Error # 1146: Table 'cqpwbeta.user_info' doesn't exist&nbsp;</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">or upgrade-database on v3.0.16 database (sql-import into empty database before running script):<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">mki@ubuntu:/var/www/cqp-web-beta/bin$ sudo php ./upgrade-database.php&nbsp;</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">Database version is now at &lt; 3.1.0. Database will now be upgraded to 3.1.0...</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">A mySQL query did not run successfully!</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">Original query:&nbsp;</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">alter table saved_dbs drop key dbname</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">Error # 1091: Can't DROP 'dbname'; check that column/key exists&nbsp;</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">Best wishes,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">Markus<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></p>
<div>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">
<hr size="2" width="100%" align="center" id="ecxstopSpelling">
</span></div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">From:
<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a><br>
To: <a href="mailto:m.killer@outlook.com">m.killer@outlook.com</a>; <a href="mailto:cwb@sslmit.unibo.it">
cwb@sslmit.unibo.it</a><br>
Date: Tue, 21 Jan 2014 04:12:06 &#43;0000<br>
Subject: Re: [CWB] CQPweb: v 3.1.0 now usable, I think<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;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><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">best</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">Andrew.</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,&quot;sans-serif&quot;;color:#1F497D">&nbsp;</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;">
<a href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a> [<a href="mailto:cwb-bounces@sslmit.unibo.it">mailto:cwb-bounces@sslmit.unibo.it</a>]
<b>On Behalf Of </b>Markus Killer<br>
<b>Sent:</b> 20 January 2014 19:25<br>
<b>To:</b> <a href="mailto:cwb@sslmit.unibo.it">cwb@sslmit.unibo.it</a><br>
<b>Subject:</b> Re: [CWB] CQPweb: v 3.1.0 now usable, I think</span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">&nbsp;<o:p></o:p></span></p>
<div>
<pre><span style="font-size:12.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">Dear Andrew,</span><o:p></o:p></pre>
<pre style="white-space:pre-wrap"><span style="font-size:12.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">&nbsp;</span><o:p></o:p></pre>
<pre><span style="font-size:12.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">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><o:p></o:p></pre>
<pre style="white-space:pre-wrap"><span style="font-size:12.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">When I try to run the autosetup script, I get the following php notices and a fatal error:</span><o:p></o:p></pre>
<pre><span style="font-size:13.5pt">$php autosetup.php </span><o:p></o:p></pre>
<pre><span style="font-size:13.5pt">PHP Notice:&nbsp; Undefined offset: 1 in /var/www/cqp-web-beta/lib/defaults.inc.php on line 446</span><o:p></o:p></pre>
<pre><span style="font-size:13.5pt">PHP Notice:&nbsp; Undefined offset: 1 in /var/www/cqp-web-beta/lib/defaults.inc.php on line 446</span><o:p></o:p></pre>
<pre><span style="font-size:13.5pt">PHP Fatal error:&nbsp; 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><o:p></o:p></pre>
<div>
<pre style="white-space:pre-wrap"><span style="font-size:12.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">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><o:p></o:p></pre>
<pre style="white-space:pre-wrap"><span style="font-size:12.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">Best wishes,</span><o:p></o:p></pre>
<pre style="white-space:pre-wrap"><span style="font-size:12.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">Markus</span><o:p></o:p></pre>
</div>
<pre style="white-space:pre-wrap"><span style="font-size:12.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">&nbsp;</span><o:p></o:p></pre>
<h1><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">[CWB] CQPweb: v 3.1.0 now usable, I think<o:p></o:p></span></h1>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">Hardie, Andrew</span></b><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">&nbsp;<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&amp;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:&quot;Times New Roman&quot;,&quot;serif&quot;">a.hardie
 at lancaster.ac.uk&nbsp;</span></a></span><span style="font-size:13.5pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><br>
<i>Mon Jan 20 09:19:41 CET 2014</i></span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></p>
<ul type="disc">
<li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
<span style="font-size:13.5pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">Previous message:&nbsp;<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><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
<span style="font-size:13.5pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">Next message:&nbsp;<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><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
<b><span style="font-size:13.5pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">Messages sorted by:</span></b><span style="font-size:13.5pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">&nbsp;<a href="http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/date.html#1481" target="_blank">[
 date ]</a>&nbsp;<a href="http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/thread.html#1481" target="_blank">[ thread ]</a>&nbsp;<a href="http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/subject.html#1481" target="_blank">[ subject ]</a>&nbsp;<a href="http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/author.html#1481" target="_blank">[
 author ]</a></span><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><o:p></o:p></span></li></ul>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">
<hr size="2" width="100%" align="center">
</span></div>
<pre style="white-space:pre-wrap">Hi all,<o:p></o:p></pre>
<pre>&nbsp;<o:p></o:p></pre>
<pre>My grand re-structuring of almost everything for CQPweb v 3.1.0 is now finished. <o:p></o:p></pre>
<pre>&nbsp;<o:p></o:p></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.<o:p></o:p></pre>
<pre>&nbsp;<o:p></o:p></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.<o:p></o:p></pre>
<pre>&nbsp;<o:p></o:p></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.<o:p></o:p></pre>
<pre>&nbsp;<o:p></o:p></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.<o:p></o:p></pre>
<pre>&nbsp;<o:p></o:p></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 &quot;CQPweb System Administrator's Manual&quot; 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.<o:p></o:p></pre>
<pre>&nbsp;<o:p></o:p></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:<o:p></o:p></pre>
<pre>&nbsp;<o:p></o:p></pre>
<pre><a href="http://cwb.sourceforge.net/files/CQPwebAdminManual.pdf" target="_blank">http://cwb.sourceforge.net/files/CQPwebAdminManual.pdf</a> <o:p></o:p></pre>
<pre>&nbsp;<o:p></o:p></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.<o:p></o:p></pre>
<pre>&nbsp;<o:p></o:p></pre>
<pre>That's all for now.<o:p></o:p></pre>
<pre>&nbsp;<o:p></o:p></pre>
<pre>best<o:p></o:p></pre>
<pre>&nbsp;<o:p></o:p></pre>
<pre>Andrew.<o:p></o:p></pre>
</div>
</div>
<p class="MsoNormal"><span style="font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;"><br>
_______________________________________________ CWB mailing list <a href="mailto:CWB@sslmit.unibo.it">
CWB@sslmit.unibo.it</a> <a href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb">
http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>