[CWB] CQPweb: v 3.1.0 now usable, I think
Markus Killer
markus.killer at uzh.ch
Tue Jan 21 09:50:45 CET 2014
(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
More information about the CWB
mailing list