[CWB] CQPweb: v 3.1.0 now usable, I think
Hardie, Andrew
a.hardie at lancaster.ac.uk
Tue Jan 21 13:28:06 CET 2014
This one puzzled me mightily for a while, but I think I have now fixed it.
best
Andrew.
PS Apologies if I have missed responding to any problems, am working through them as quickly as I can, but my normal work stuff has been intruding a bit!
-----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 08:51
To: Open source development of the Corpus WorkBench
Subject: Re: [CWB] CQPweb: v 3.1.0 now usable, I think
(1) - now I get the following warning @rev509 (autosetup on empty db - complete msg below):
Updated to Revision 509.
mki at ubuntu:/var/www/cqp-web-beta/bin$ sudo php autosetup.php
Now finalising setup for this installation of CQPweb....
Installing database structure; please wait.
Database setup complete.
PHP Warning: mysql_close(): 13 is not a valid MySQL-Link resource in /var/www/cqp-web-beta/lib/library.inc.php on line 152 Invalid user name specified at database level: mkiller
*****************************
mysql> describe cqpwbeta.user_info;
+---------------------------+------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default
| | Extra |
+---------------------------+------------------+------+-----+---------------------+----------------+
| id | int(11) | NO | PRI | NULL
| | auto_increment | username | varchar(20) | NO
| | UNI | NULL | | password
| | varchar(20) | YES | | NULL |
| | realname | varchar(255) | YES | | NULL
| | | email | varchar(255) | YES
| | | NULL | | affiliation
| | varchar(255) | YES | | NULL |
| | country | char(2) | YES | | 00
| | | passhash | char(61) | YES
| | | NULL | | acct_status
| | tinyint(1) | NO | | 0 |
| | verify_key | varchar(32) | YES | | NULL
| | | expiry_time | int(10) unsigned | NO
| | | 0 | | password_expiry_time
| | int(10) unsigned | NO | | 0 |
| | last_seen_time | timestamp | NO | |
| 0000-00-00 00:00:00 | | acct_create_time |
| timestamp | NO | | CURRENT_TIMESTAMP | |
| conc_kwicview | tinyint(1) | YES | | NULL
| | | conc_corpus_order | tinyint(1) | YES
| | | NULL | | cqp_syntax
| | tinyint(1) | YES | | NULL |
| | context_with_tags | tinyint(1) | YES | | NULL
| | | use_tooltips | tinyint(1) | YES
| | | NULL | |
| thin_default_reproducible | tinyint(1) | YES | | NULL
| | | coll_statistic | tinyint(4) | YES
| | | NULL | | coll_freqtogether
| | int(11) | YES | | NULL |
| | coll_freqalone | int(11) | YES | | NULL
| | | coll_from | tinyint(4) | YES
| | | NULL | | coll_to
| | tinyint(4) | YES | | NULL |
| | max_dbsize | int(10) unsigned | YES | | NULL
| | | linefeed | char(2) | YES
| | | NULL | |
+---------------------------+------------------+------+-----+---------------------+----------------+
27 rows in set (0.00 sec)
----------------------------------------
> From: a.hardie at lancaster.ac.uk
> To: m.killer at outlook.com; cwb at sslmit.unibo.it
> Date: Tue, 21 Jan 2014 08:09:52 +0000
> Subject: Re: [CWB] CQPweb: v 3.1.0 now usable, I think
>
> I've taken another crack at it in 509...
>
> A
>
> -----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 08:04
> To: Open source development of the Corpus WorkBench
> Subject: Re: [CWB] CQPweb: v 3.1.0 now usable, I think
>
> (1) - still receiving the same error @rev508 (autosetup on empty db - complete msg below):
>
> Revision 508.
> mki at ubuntu:/var/www/cqp-web-beta/bin$ sudo php autosetup.php
>
> Now finalising setup for this installation of CQPweb....
>
> Installing database structure; please wait.
>
> Database setup complete.
>
> Now, we must set passwords for each user account specified as a superuser.
> Please enter a password for user ``mkiller'':
>
> ***
>
>
> You entered [***], are you happy with this?
>
> Enter [Y]es or [N]:y
> PHP Notice: Trying to get property of non-object in
> /var/www/cqp-web-beta/lib/user-lib.inc.php on line 120 PHP Notice:
> Trying to get property of non-object in
> /var/www/cqp-web-beta/lib/user-lib.inc.php on line 121 PHP Notice:
> Trying to get property of non-object in
> /var/www/cqp-web-beta/lib/user-lib.inc.php on line 122 PHP Notice:
> Trying to get property of non-object in
> /var/www/cqp-web-beta/lib/user-lib.inc.php on line 123 PHP Notice:
> Trying to get property of non-object in
> /var/www/cqp-web-beta/lib/user-lib.inc.php on line 124 PHP Notice:
> Trying to get property of non-object in
> /var/www/cqp-web-beta/lib/user-lib.inc.php on line 125 PHP Notice:
> Trying to get property of non-object in
> /var/www/cqp-web-beta/lib/exiterror.inc.php on line 92 PHP Notice:
> Trying to get property of non-object in
> /var/www/cqp-web-beta/lib/exiterror.inc.php on line 93 PHP Notice:
> Trying to get property of non-object in
> /var/www/cqp-web-beta/lib/exiterror.inc.php on line 95 <tr><td
> class="concorderror"> <BR><p class="errormessage">A mySQL query
> did not run successfully!</p> <BR></td></tr>
>
> <tr><td class="concorderror"> <BR><p class="errormessage">Original query:
>
> INSERT INTO user_info (
> username,
> realname,
> email,
> passhash,
> acct_status,
> expiry_time,
> acct_create_time,
> conc_kwicview,
> conc_corpus_order,
> cqp_syntax,
> context_with_tags,
> use_tooltips,
> thin_default_reproducible,
> coll_statistic,
> coll_freqtogether,
> coll_freqalone,
> coll_from,
> coll_to,
> max_dbsize,
> linefeed
> )
> VALUES
> (
> 'mkiller',
> 'unknown person',
> 'not-specified at nowhere.net',
> '$2a$10$38GdRfa/1ZOmvYpbXZ4tYOH.FzUfJd552ne8fw0wbCZWuDMg2qedq',
> 1,
> 0,
> CURRENT_TIMESTAMP,
> 1,
> 1,
> 0,
> 0,
> 1,
> 1,
> ,
> ,
> ,
> 2,
> -2,
> ,
> 'au'
> )
>
> </p> <BR></td></tr>
>
> <tr><td class="concorderror"> <BR><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 '
> ,
> ,
> 2,
> -2,
> ,
> 'au'
> )' at line 38 </p> <BR></td></tr>
>
>
>
> ----------------------------------------
>> From: a.hardie at lancaster.ac.uk
>> To: m.killer at outlook.com; cwb at sslmit.unibo.it
>> Date: Tue, 21 Jan 2014 07:52:49 +0000
>> Subject: Re: [CWB] CQPweb: v 3.1.0 now usable, I think
>>
>> (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.
> _______________________________________________
> 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
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
http://devel.sslmit.unibo.it/mailman/listinfo/cwb
More information about the CWB
mailing list