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

[Hardie, Andrew]

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">&nbsp;<BR><p class="errormessage">A mySQL query did not run successfully!</p>&nbsp;<BR></td></tr>

<tr><td class="concorderror">&nbsp;<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>&nbsp;<BR></td></tr>

<tr><td class="concorderror">&nbsp;<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>&nbsp;<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