[CWB] CQPweb: v 3.1.0 now usable, I think

Tue Jan 21 08:52:49 CET 2014

(1) Ach, that's a bug introduced by the previous bug fix! Changed & fixed in 508.

(2) This occurs, I think, because you are running the script on a half-upgraded database, so some of the changes it is trying to make have already been made.

Run this SQL command manually:

describe saved_dbs;

and look at the key status of the column "dbname". If it says "PRI", then you need to revert the DB by running the following:

alter table saved_dbs drop primary key; 
alter table saved_dbs add key `dbname` (`dbname`);

If that's the only thing that was "halfway", it will fix the problem. If other things were half-and-half, you'll get stuck at a later point in the script next time you run it.

One (slightly dangerous) way round that is to hack library.inc.php to comment out lines 222 and 223. Then, the script will trundle on even if one of the earlier commands does not run. That change would need to be reverted ASAP afterwards of course!

Andrew.

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Markus Killer
Sent: 21 January 2014 07:36
To: Open source development of the Corpus WorkBench
Subject: Re: [CWB] CQPweb: v 3.1.0 now usable, I think

*************
1) autosetup script (shorter and text-only version of error message to meet 40kb limit):
*************

@Rev507
[...] Database setup complete.

Now, we must set passwords for each user account specified as a superuser.
PHP Notice:  Trying to get property of non-object in /var/www/cqp-web-beta/lib/library.inc.php on line 893 [...] PHP Notice:  Trying to get property of non-object in /var/www/cqp-web-beta/lib/user-lib.inc.php on line 120-125 [..] PHP Notice:  Trying to get property of non-object in /var/www/cqp-web-beta/lib/exiterror.inc.php on lines 92, 93, 95

A mySQL query did not run successfully!
Original query: 

INSERT INTO user_info (
username,
realname,
email,
passhash, [...]

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 ' [...] line 38

****************
2) upgrade-database script still returns the same error as in rev504:
****************
mki at ubuntu:/var/www/cqp-web-beta/bin$ sudo php upgrade-database.php Database version is now at < 3.1.0. Database will now be upgraded to 3.1.0...
A mySQL query did not run successfully!

Original query: 

alter table saved_dbs drop key dbname

Error & 1091: Can't DROP 'dbname'; check that column/key exists ________________________________
> From: a.hardie at lancaster.ac.uk
> To: m.killer at outlook.com; cwb at sslmit.unibo.it
> Date: Tue, 21 Jan 2014 06:31:33 +0000
> Subject: Re: [CWB] CQPweb: v 3.1.0 now usable, I think
> 
> 
> Fixed in 506, I think. 
> 
> 
> 
> Andrew. 
> 
> 
> 
> From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it]
> On Behalf Of Markus Killer
> Sent: 21 January 2014 06:28
> To: cwb at sslmit.unibo.it
> Subject: Re: [CWB] CQPweb: v 3.1.0 now usable, I think
> 
> 
> 
> (sorry for repost - used wrong sender email) - This time I managed to 
> get a bit further, but still no successful install/upgrade possible:
> 
> 
> 
> autosetup on empty database: 
> 
> 
> 
> Updated to Revision 504. 
> 
> mki at ubuntu:/var/www/cqp-web-beta$ cd bin/
> 
> mki at ubuntu:/var/www/cqp-web-beta/bin$ sudo php ./autosetup.php
> 
> CQPweb has encountered an error! 
> 
> ================================
> 
> 
> 
> <table class="concordtable" width="100%">
> 
> <tr>
> 
> <th
> class="concordtable">CQPweb encountered an error and could not 
> continue.</th>
> 
> </tr>
> 
> A mySQL query did not run successfully! 
> 
> 
> 
> Original query: 
> 
> 
> 
> update user_info set last_seen_time = CURRENT_TIMESTAMP where 
> username='mkiller'
> 
> 
> 
> Error & 1146: Table 'cqpwbeta.user_info' doesn't exist
> 
> 
> 
> or upgrade-database on v3.0.16 database (sql-import into empty 
> database before running script):
> 
> 
> 
> mki at ubuntu:/var/www/cqp-web-beta/bin$ sudo php ./upgrade-database.php
> 
> Database version is now at < 3.1.0. Database will now be upgraded to 3.1.0... 
> 
> A mySQL query did not run successfully! 
> 
> 
> 
> Original query: 
> 
> 
> 
> alter table saved_dbs drop key dbname
> 
> 
> 
> 
> 
> 
> 
> Error & 1091: Can't DROP 'dbname'; check that column/key exists
> 
> 
> 
> Best wishes,
> 
> Markus
> 
> 
> 
> ________________________________
> 
> From: a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>
> To: m.killer at outlook.com<mailto:m.killer at outlook.com>;
> cwb at sslmit.unibo.it<mailto:cwb at sslmit.unibo.it>
> Date: Tue, 21 Jan 2014 04:12:06 +0000
> Subject: Re: [CWB] CQPweb: v 3.1.0 now usable, I think
> 
> 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.
> 
> 
> 
> best
> 
> 
> 
> Andrew. 
> 
> 
> 
> From: cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it>
> [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Markus Killer
> Sent: 20 January 2014 19:25
> To: cwb at sslmit.unibo.it<mailto:cwb at sslmit.unibo.it>
> Subject: Re: [CWB] CQPweb: v 3.1.0 now usable, I think
> 
> 
> 
> Dear Andrew,
> 
> 
> 
> 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. 
> 
> When I try to run the autosetup script, I get the following php notices and a fatal error: 
> 
> $php autosetup.php
> 
> PHP Notice: Undefined offset: 1 in 
> /var/www/cqp-web-beta/lib/defaults.inc.php on line 446
> 
> PHP Notice: Undefined offset: 1 in 
> /var/www/cqp-web-beta/lib/defaults.inc.php on line 446
> 
> 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
> 
> 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. 
> 
> Best wishes,
> 
> Markus
> 
> 
> 
> [CWB] CQPweb: v 3.1.0 now usable, I think
> 
> Hardie, Andrew a.hardie at
> lancaster.ac.uk 
> <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=%3C28078EC3F
> BF1B940A3EF3D0D19BE351D2CC631%40EX-0-MB1.lancs.local%3E>
> Mon Jan 20 09:19:41 CET 2014
> 
> * Previous message: [CWB] [cwb:bugs] &60 CQPweb : metadata from XML, 
> primary classification not 
> set<http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/001480.htm
> l>
> * Next message: [CWB] CQPweb: v 3.1.0 now usable, I 
> think<http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/001482.h
> tml>
> * Messages sorted by: [ date
> ]<http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/date.html&14
> 81> [ thread 
> ]<http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/thread.html&
> 1481> [ subject 
> ]<http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/subject.html
> &1481> [ author 
> ]<http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/author.html&
> 1481>
> 
> ________________________________
> 
> Hi all,
> 
> 
> 
> My grand re-structuring of almost everything for CQPweb v 3.1.0 is now finished. 
> 
> 
> 
> 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. 
> 
> 
> 
> 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. 
> 
> 
> 
> If you are less adventurous, you might want to stick with 3.0.16 a bit longer, until the worst problems are dealt with. 
> 
> 
> 
> 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. 
> 
> 
> 
> 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. 
> 
> 
> 
> 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: 
> 
> 
> 
> http://cwb.sourceforge.net/files/CQPwebAdminManual.pdf
> 
> 
> 
> 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. 
> 
> 
> 
> That's all for now. 
> 
> 
> 
> best
> 
> 
> 
> Andrew. 
> 
> _______________________________________________ CWB mailing list 
> CWB at sslmit.unibo.it<mailto:CWB at sslmit.unibo.it>
> http://devel.sslmit.unibo.it/mailman/listinfo/cwb
> 
> _______________________________________________ CWB mailing list 
> CWB at sslmit.unibo.it http://devel.sslmit.unibo.it/mailman/listinfo/cwb 		 	   		  
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
http://devel.sslmit.unibo.it/mailman/listinfo/cwb