<div dir="ltr"><div dir="ltr">Thanks to you, Andrew, for the quick response.<div>I fixed this error as instructed.</div><div>I'm getting more errors now.</div><div>Next was in line 407, sql-definitions, a comma was missing, I think.</div><div>autosetup.php is now complaining about Key column corpus doesn't exist in table.</div><div><br></div><div><p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">sudo php autosetup.php </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"></span><br></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">Now finalising setup for this installation of CQPweb....</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"></span><br></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">Installing database structure; please wait.</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><tr><td class="layout-contrast"></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><p class="errormessage">An SQL query did not run successfully!</p></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><p class="errormessage">Original query: </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>CREATE TABLE `saved_subcorpora` (</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>`id` bigint unsigned NOT NULL AUTO_INCREMENT,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>`corpus_id` int unsigned NOT NULL,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>`user_id` int unsigned NOT NULL,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>`savename` varchar(255) CHARSET utf8mb4 collate utf8mb4_0900_ai_ci default '',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>`date_of_user_save` timestamp NOT NULL default CURRENT_TIMESTAMP,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>`content` mediumtext CHARSET utf8mb4 collate utf8mb4_0900_bin,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>`n_items` int unsigned NOT NULL default 0,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>`n_tokens` bigint unsigned NOT NULL default 0,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>key (`corpus`, `user`), ## TODO, name it!</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>primary key (`id`)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>) ENGINE=InnoDB </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>/* from User: ??? | In file: /var/www/html/cqpweb/bin/autosetup.php @ line 103 | 2020-Apr-27 06:38 */</p></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><p class="errormessage">Error # 1072: Key column 'corpus' doesn't exist in table</p></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"></td></tr></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></table></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>PHP Notice: Undefined property: NotAFullUser::$logged_in in /var/www/html/cqpweb/lib/html-lib.php on line 817</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"></span><br></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span><footer></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span><hr></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span><table class="layout-frame fullwidth"></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span><tr></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span><td class="footbox algL" width="33%"></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>CQPweb v3.3.6 &#169; 2008-2020</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></td></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span><td class="footbox algC" width="33%"></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span><a class="copynote" href="help.php?ui=hello" target="cqpweb_help_browser">Help! on CQPweb</a></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></td></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span><td class="footbox algR" width="33%"></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>You are not logged in</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></td></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></tr></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></table></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></footer></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span><div id="templateForToolTip" class="floatingToolTip"></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span><table class="floatingToolTipFrame"></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span><tr></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span><td class="floatingToolTipTarget"></td></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></tr></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></table></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></div></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></body></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"></span><br></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"></html></span></p><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div>--</div><div><div>José Manuel Martínez Martínez</div><div><a href="https://chozelinek.github.io" target="_blank">https://chozelinek.github.io</a></div></div></div></div></div></div></div></div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Apr 24, 2020 at 8:24 PM Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div lang="EN-GB">
<div class="gmail-m_5625126268617957180WordSection1">
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">Error is here:<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" style="text-indent:36pt"><b><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">unique key (`corpus`, `handle`), ## TODO, name it!<u></u><u></u></span></b></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)">line 119 in lib/sql-definitions.php<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)">the 2nd comma shouldn’t be there (probably a leftover from deleting a line without removing the previous comma)<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)">Fix will also be in next commit. thanks for trying these things out.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">best<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">Andrew.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<div>
<div style="border-style:solid none none;border-top-width:1pt;border-top-color:rgb(225,225,225);padding:3pt 0cm 0cm">
<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>José Manuel Martínez Martínez<br>
<b>Sent:</b> 24 April 2020 17:11<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> [External] Re: [CWB] CQPweb error on fresh install<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p><strong><span style="font-family:Calibri,sans-serif;color:rgb(164,52,58)">This email originated outside the University. Check before clicking links or attachments.</span></strong><u></u><u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">Hi Andrew, <u></u><u></u></p>
<div>
<p class="MsoNormal">thanks for the quick reply! I removed the line and run it again. This time I'm getting a new error:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">sudo php autosetup.php<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;min-height:13px;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><u></u> <u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">Now finalising setup for this installation of CQPweb....<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;min-height:13px;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><u></u> <u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">Installing database structure; please wait.<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><tr><td class="layout-contrast"><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><p class="errormessage">An SQL query did not run successfully!</p><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><p class="errormessage">Original query: <u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">CREATE TABLE `annotation_info` (<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">`id` int unsigned NOT NULL AUTO_INCREMENT,<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">`corpus` varchar(20) CHARSET ascii COLLATE ascii_bin NOT NULL,<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">`order_of_att` smallint unsigned NOT NULL default 0,<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">`handle` varchar(20) CHARSET ascii COLLATE ascii_bin NOT NULL,<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">`description` varchar(255) CHARSET utf8mb4 collate utf8mb4_0900_ai_ci default '',<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">`ft_required` tinyint(1) NOT NULL default 1,<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"> </span><span class="gmail-m_5625126268617957180gmail-apple-tab-span"><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);background-position:initial initial;background-repeat:initial initial"><span style="font-size:8.5pt;font-family:Menlo,serif;color:white">`accent_sensitive` tinyint(1) NOT NULL default 1,</span><u></u><u></u></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">`case_sensitive` tinyint(1) NOT NULL default 1,<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">`is_feature_set` tinyint(1) NOT NULL default 0,<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">`tagset` varchar(255) CHARSET utf8mb4 collate utf8mb4_0900_ai_ci default '',<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">`external_url` varchar(255) CHARSET utf8mb4 collate utf8mb4_0900_ai_ci default '',<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">primary key (`id`),<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">unique key (`corpus`, `handle`), ## TODO, name it!<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">) ENGINE=InnoDB <u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">/* from User: ??? | In file: /var/www/html/cqpweb/bin/autosetup.php @ line 103 | 2020-Apr-24 16:07 */</p><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><p class="errormessage">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 ') ENGINE=InnoDB
<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">/* from User: ??? | In file: /var/www/html/cqpweb/bin/autoset' at line 15</p><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"></td></tr><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;min-height:13px;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"></table><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;min-height:13px;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">PHP Notice: Undefined property: NotAFullUser::$logged_in in /var/www/html/cqpweb/lib/html-lib.php on line 817<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;min-height:13px;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><u></u> <u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><footer><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><hr><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><table class="layout-frame fullwidth"><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><tr><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><td class="footbox algL" width="33%"><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">CQPweb v3.3.6 &#169; 2008-2020<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"></td><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><td class="footbox algC" width="33%"><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><a class="copynote" href="help.php?ui=hello" target="cqpweb_help_browser">Help! on CQPweb</a><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"></td><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><td class="footbox algR" width="33%"><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">You are not logged in<u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"></td><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"></tr><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"></table><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"></footer><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;min-height:13px;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><div id="templateForToolTip" class="floatingToolTip"><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><table class="floatingToolTipFrame"><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><tr><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><td class="floatingToolTipTarget"></td><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"></tr><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"></table><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"></div><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;min-height:13px;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"></body><u></u><u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;min-height:13px;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"><u></u> <u></u></span></p>
<p style="margin:0cm 0cm 0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white"></html><u></u><u></u></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">--<u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal">José Manuel Martínez Martínez<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><a href="https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fchozelinek.github.io%2F&data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7C78e47ae0c185414a820208d7e86a24e0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637233414901938290&sdata=HimgGxsBfvm1c%2BpthD49ixwsuOMnBUYtctbEv9C0nyI%3D&reserved=0" target="_blank">https://chozelinek.github.io</a><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Fri, Apr 24, 2020 at 5:53 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-style:none none none solid;border-left-width:1pt;border-left-color: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)">Hi José,</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)">Quick solution: delete that line!</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)">Alternatively fix will be in my next commit.</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>
<div>
<div style="border-style:solid none none;border-top-width:1pt;border-top-color:rgb(225,225,225);padding:3pt 0cm 0cm">
<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>José Manuel Martínez Martínez<br>
<b>Sent:</b> 24 April 2020 16:41<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 error on fresh install</span><u></u><u></u></p>
</div>
</div>
<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">
Hi 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">
I'm installing the trunk version of CQPweb on an Ubuntu 20.04.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:4.8pt">
<u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-left:4.8pt">
I'm getting an error message when running<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:4.8pt">
<u></u><u></u></p>
</div>
<div>
<p style="margin-right:0cm;margin-left:4.8pt;margin-bottom:0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">sudo php autosetup.php</span><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">
The error message is:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:4.8pt">
<u></u><u></u></p>
</div>
<div>
<p style="margin-right:0cm;margin-left:4.8pt;margin-bottom:0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">PHP Warning: require(../lib/admin-lib.php): failed to open stream: No such file or directory in /var/www/html/cqpweb/bin/autosetup.php on line 36</span><u></u><u></u></p>
<p style="margin-right:0cm;margin-left:4.8pt;margin-bottom:0.0001pt;background-color:rgb(34,79,188);font-stretch:normal;background-position:initial initial;background-repeat:initial initial">
<span style="font-size:8.5pt;font-family:Menlo,serif;color:white">PHP Fatal error: require(): Failed opening required '../lib/admin-lib.php' (include_path='.:/usr/share/php') in /var/www/html/cqpweb/bin/autosetup.php on line 36</span><u></u><u></u></p>
<div>
<div>
<div>
<div>
<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">
I've seen that the file does not exist in the ../lib folder.<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">
--<u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal" style="margin-left:4.8pt">
José Manuel Martínez Martínez<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><a href="https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fchozelinek.github.io%2F&data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7C78e47ae0c185414a820208d7e86a24e0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637233414901948285&sdata=toGHtn%2FxQoQcMfhcbPvH8mx9GJO%2FaJaq0g9%2BdHYVif0%3D&reserved=0" target="_blank">https://chozelinek.github.io</a><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:4.8pt">_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it" target="_blank">CWB@sslmit.unibo.it</a><br>
<a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7C78e47ae0c185414a820208d7e86a24e0%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637233414901948285&sdata=wnG%2FeBGZL8xOrIXtQUBhcd2jUCeMMvU%2BMFBkjmz2ecs%3D&reserved=0" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><u></u><u></u></p>
</blockquote>
</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>