[CWB] CQPweb: v 3.1.0 now usable, I think
Markus Killer
markus.killer at uzh.ch
Tue Jan 21 08:36:13 CET 2014
*************
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=%3C28078EC3FBF1B940A3EF3D0D19BE351D2CC631%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.html>
> * Next message: [CWB] CQPweb: v 3.1.0 now usable, I
> think<http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/001482.html>
> * Messages sorted by: [ date
> ]<http://devel.sslmit.unibo.it/pipermail/cwb/2014-January/date.html&1481> [
> 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
More information about the CWB
mailing list