<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi,<br>
Sometimes, the problem<br>
<br>
<pre wrap="">A mySQL query did not run successfully!
Error # 1146: Table 'cqp.corpus_metadata_fixed' doesn't exist
</pre>
is not about anything else but about the default search engine set
for MySQL. <small><br>
</small>If InnoDB is selected as default, then this error pops up.<small><br>
</small>To fix, it's enough to change GLOBAL SEARCH ENGINE to
MyISAM.<small><br>
</small>Then all will be solved.<br>
<br>
<br>
On 10/05/2012 05:18 PM, <a class="moz-txt-link-abbreviated" href="mailto:cwb-request@sslmit.unibo.it">cwb-request@sslmit.unibo.it</a> wrote:<br>
</div>
<blockquote
cite="mid:mailman.233.1349446689.2026.cwb@sslmit.unibo.it"
type="cite">
<pre wrap="">Send CWB mailing list submissions to
<a class="moz-txt-link-abbreviated" href="mailto:cwb@sslmit.unibo.it">cwb@sslmit.unibo.it</a>
To subscribe or unsubscribe via the World Wide Web, visit
<a class="moz-txt-link-freetext" href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a>
or, via email, send a message with subject or body 'help' to
<a class="moz-txt-link-abbreviated" href="mailto:cwb-request@sslmit.unibo.it">cwb-request@sslmit.unibo.it</a>
You can reach the person managing the list at
<a class="moz-txt-link-abbreviated" href="mailto:cwb-owner@sslmit.unibo.it">cwb-owner@sslmit.unibo.it</a>
When replying, please edit your Subject line so it is more specific
than "Re: Contents of CWB digest..."
Today's Topics:
1. Re: CQPweb (Hardie, Andrew)
2. Re: CQPweb (Andr?s Chand?a)
----------------------------------------------------------------------
Message: 1
Date: Fri, 5 Oct 2012 14:11:47 +0000
From: "Hardie, Andrew" <a class="moz-txt-link-rfc2396E" href="mailto:a.hardie@lancaster.ac.uk"><a.hardie@lancaster.ac.uk></a>
To: <a class="moz-txt-link-rfc2396E" href="mailto:andres@chandia.net">"andres@chandia.net"</a> <a class="moz-txt-link-rfc2396E" href="mailto:andres@chandia.net"><andres@chandia.net></a>
Cc: Open source development of the Corpus WorkBench
<a class="moz-txt-link-rfc2396E" href="mailto:cwb@sslmit.unibo.it"><cwb@sslmit.unibo.it></a>
Subject: Re: [CWB] CQPweb
Message-ID:
<a class="moz-txt-link-rfc2396E" href="mailto:28078EC3FBF1B940A3EF3D0D19BE351D0D0BC0@EX-0-MB1.lancs.local"><28078EC3FBF1B940A3EF3D0D19BE351D0D0BC0@EX-0-MB1.lancs.local></a>
Content-Type: text/plain; charset="iso-8859-1"
Is admin2 declared as a superuser in the config file?
$superuser_username = 'admin|admin2';
This is specified under the manual configuration section (adding new superusers must always be done manually, for security reasons).
best
Andrew.
From: "Andr?s Chand?a" [<a class="moz-txt-link-freetext" href="mailto:andres@chandia.net">mailto:andres@chandia.net</a>]
Sent: 05 October 2012 14:59
To: Hardie, Andrew
Cc: Open source development of the Corpus WorkBench
Subject: RE: [CWB] CQPweb
I have now some issues with the users created by htpasswd
file .htpasswd
admin:asjdkalsdkaIDAS
admin2:asdeAALQ393R
file .htgroup
superusers: admin admin2
file : .../cqp/adm/.htaccess
AuthUserFile .../cqp/users/.htpasswd
AuthGroupFile .../cqp/users/.htgroup
AuthName CQPweb
AuthType Basic
deny from all
require group superusers
satisfy any
the user admin has no problem but the user admin2, when log in it gets this at the web interface:
CQPweb encountered an error and could not continue.
You do not have permission to use this program.
You are logged in as user [admin2]
Did I do something wrong?
El Vie, 5 de Octubre de 2012, 13:45, Hardie, Andrew escribi?:
Hi Andria,
There is an additional step to carry out after running the auto config script.
As it says further down the installation instructions - under "Getting it up and running" - you need to first of all go into the Admin interface (<a class="moz-txt-link-freetext" href="http://yourserver.net/path/to/cqpweb/adm">http://yourserver.net/path/to/cqpweb/adm</a>) and use the tool to "Reset MySQL Database" via the menu option on the left-hand side.
best
Andrew.
From: <a class="moz-txt-link-abbreviated" href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a> [<a class="moz-txt-link-freetext" href="mailto:cwb-bounces@sslmit.unibo.it">mailto:cwb-bounces@sslmit.unibo.it</a>] On Behalf Of "Andr?s Chand?a"
Sent: 05 October 2012 12:24
To: <a class="moz-txt-link-abbreviated" href="mailto:cwb@sslmit.unibo.it">cwb@sslmit.unibo.it</a>
Subject: [CWB] CQPweb
Hi there
I'm following. "Some notes on how to set up CQPweb (v 3.0.0 or higher"
(<a class="moz-txt-link-freetext" href="http://cwb.svn.sourceforge.net/viewvc/cwb/gui/cqpweb/trunk/CQPweb-setup-manual.html">http://cwb.svn.sourceforge.net/viewvc/cwb/gui/cqpweb/trunk/CQPweb-setup-manual.html</a>)
And the problem that I have is about the creation of the database, these are not being created automatically,
I did it with the assigned db username and also with the db admin username but nothing happens, I mean.
I do create database "cqpwebdb"
on mysql: GRANT ALL ON cqpwebdb.* TO 'userofcqpdb'@'localhost' IDENTIFIED BY 'passwordofcqpdb';
then: php cqpweb-autoconfig.php
giving "cqpwebdb" and "passwordofcqpdb";
as this didn't work I did it wwith the root account of mysql but nothing, should I create manually the tables, or what should I do.
At the web:
A mySQL query did not run successfully!
Error # 1146: Table 'cqp.corpus_metadata_fixed' doesn't exist
_______________________
andr?s chand?a
[IMAGE REMOVED]<a class="moz-txt-link-rfc2396E" href="http://www.chandia.net"><http://www.chandia.net></a>
P No imprima innecesariamente. ?Cuide el medio ambiente!
_______________________
andr?s chand?a
[Image removed by sender. chandia.net]<a class="moz-txt-link-rfc2396E" href="http://www.chandia.net"><http://www.chandia.net></a>
P No imprima innecesariamente. ?Cuide el medio ambiente!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20121005/07983ec6/attachment-0001.html"><http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20121005/07983ec6/attachment-0001.html></a>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ~WRD367.jpg
Type: image/jpeg
Size: 823 bytes
Desc: ~WRD367.jpg
URL: <a class="moz-txt-link-rfc2396E" href="http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20121005/07983ec6/attachment-0001.jpg"><http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20121005/07983ec6/attachment-0001.jpg></a>
------------------------------
Message: 2
Date: Fri, 5 Oct 2012 16:18:21 +0200
From: "Andr?s Chand?a" <a class="moz-txt-link-rfc2396E" href="mailto:andres@chandia.net"><andres@chandia.net></a>
To: "Hardie, Andrew" <a class="moz-txt-link-rfc2396E" href="mailto:a.hardie@lancaster.ac.uk"><a.hardie@lancaster.ac.uk></a>
Cc: Open source development of the Corpus WorkBench
<a class="moz-txt-link-rfc2396E" href="mailto:cwb@sslmit.unibo.it"><cwb@sslmit.unibo.it></a>
Subject: Re: [CWB] CQPweb
Message-ID:
<a class="moz-txt-link-rfc2396E" href="mailto:3156fd711511afc45eb2526613eeeae6.squirrel@mail.chandia.net"><3156fd711511afc45eb2526613eeeae6.squirrel@mail.chandia.net></a>
Content-Type: text/plain; charset="iso-8859-1"
My fault again, sorry
El Vie, 5 de Octubre de 2012, 16:11, Hardie, Andrew
escribi?:
<style type="text/css">-></style>
Is
admin2 declared as a superuser in the config file?
$superuser_username = 'admin|admin2';
This
is specified under the manual configuration section (adding new superusers must always be done
manually, for security reasons).
best
Andrew.
From:
"Andr?s Chand?a" [<a class="moz-txt-link-freetext" href="mailto:andres@chandia.net">mailto:andres@chandia.net</a>]
Sent: 05 October 2012 14:59
To: Hardie, Andrew
Cc: Open source development of the Corpus WorkBench
Subject: RE: [CWB] CQPweb
I have now some issues with the users created by htpasswd
file .htpasswd
admin:asjdkalsdkaIDAS
admin2:asdeAALQ393R
file
.htgroup
superusers: admin admin2
file : .../cqp/adm/.htaccess
AuthUserFile .../cqp/users/.htpasswd
AuthGroupFile .../cqp/users/.htgroup
AuthName CQPweb
AuthType Basic
deny from all
require group superusers
satisfy any
the user admin has no
problem but the user admin2, when log in it gets this at the web interface:
CQPweb encountered an error and could not continue.
You do not have permission to
use this program.
You are logged in as user [admin2]
Did I do
something wrong?
El Vie, 5 de Octubre de 2012, 13:45,
Hardie, Andrew escribi?:
Hi
Andria,
There
is an additional step to carry out after running the auto config script.
As
it says further down the installation instructions &ndash; under &ldquo;Getting it up and
running&rdquo; &ndash; you need to first of all go into the Admin interface (<a class="moz-txt-link-freetext" href="http://yourserver.net/path/to/cqpweb/adm">http://yourserver.net/path/to/cqpweb/adm</a>)
and use the tool to &ldquo;Reset MySQL Database&rdquo; via the menu option on the left-hand
side.
best
Andrew.
From:
<a class="moz-txt-link-abbreviated" href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a> [<a class="moz-txt-link-freetext" href="mailto:cwb-bounces@sslmit.unibo.it">mailto:cwb-bounces@sslmit.unibo.it</a>] On Behalf Of
"Andr?s Chand?a"
Sent: 05 October
2012 12:24
To:
<a class="moz-txt-link-abbreviated" href="mailto:cwb@sslmit.unibo.it">cwb@sslmit.unibo.it</a>
Subject: [CWB]
CQPweb
Hi there
I'm following. "Some notes on how to set up CQPweb (v 3.0.0 or higher"
(<a class="moz-txt-link-freetext" href="http://cwb.svn.sourceforge.net/viewvc/cwb/gui/cqpweb/trunk/CQPweb-setup-manual.html">http://cwb.svn.sourceforge.net/viewvc/cwb/gui/cqpweb/trunk/CQPweb-setup-manual.html</a>)
And the problem that I have is about the creation of the database, these are not
being created automatically,
I did it with the assigned db username and also with the db
admin username but nothing happens, I mean.
I do create database "cqpwebdb"
on mysql: GRANT ALL ON cqpwebdb.* TO 'userofcqpdb'@'localhost' IDENTIFIED BY
'passwordofcqpdb';
then: php cqpweb-autoconfig.php
giving
"cqpwebdb" and "passwordofcqpdb";
as this didn't work I did
it wwith the root account of mysql but nothing, should I create manually the tables, or what
should I do.
At the web:
A mySQL query did not run successfully!
Error # 1146: Table 'cqp.corpus_metadata_fixed' doesn't exist
_______________________
andr?s chand?a
[IMAGE
REMOVED]
P
No
imprima innecesariamente. ?Cuide el medio ambiente!
_______________________
andr?s chand?a
P No
imprima innecesariamente. ?Cuide el medio ambiente!
_______________________
????????????andr?s
chand?a
P No imprima
innecesariamente. ?Cuide el medio ambiente!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20121005/a13d5889/attachment.html"><http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20121005/a13d5889/attachment.html></a>
------------------------------
_______________________________________________
CWB mailing list
<a class="moz-txt-link-abbreviated" href="mailto:CWB@sslmit.unibo.it">CWB@sslmit.unibo.it</a>
<a class="moz-txt-link-freetext" href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a>
End of CWB Digest, Vol 70, Issue 2
**********************************
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
TanerSezer
<a class="moz-txt-link-freetext" href="http://tanersezer.com">http://tanersezer.com</a>
<a class="moz-txt-link-freetext" href="http://tscorpus.com">http://tscorpus.com</a></pre>
</body>
</html>