[CWB] CQPweb: upgrade-database.php v3.0.16 > v3.1.0

[Hardie, Andrew]

Hi Markus,

I have been puzzling over this at great length and have got nowhere. 

(1) The old password column exists because I disabled its deletion to make rollback easier if needed. (There is an alert note in the printed output telling people to drop the password column manually after the fact).

But the old password going into the email column is something I just can't figure out. It's not happened on the system I upgraded (albeit that wasn't with 512 but an earlier version) and I can't find anything in the code of upgrade-database that ought to alter the contents of the email column in that way.

(2) Likewise this puzzles me, there WAS a bug that did this, but I thought I had fixed it in commit 502.

So, if you can add any further details related to this bug that might help me track it down, that would be very much appreciated....

best

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 13:10
To: Open source development of the Corpus WorkBench
Subject: Re: [CWB] CQPweb: upgrade-database.php v3.0.16 > v3.1.0

upgrade-database.php rev512 runs smoothly now, but there seem to be two more issues:

(1) - the old password is mapped into table:user_info column:password and accidentally, I think, into column:email as well

(2) - the password is not hashed (passhash: NULL) and, consequently, authentication fails.

--> not possible to login as superuser after running upgrade-database.php (unless you manually add passhash)


----------------------------------------
> From: a.hardie at lancaster.ac.uk
> To: m.killer at outlook.com; cwb at sslmit.unibo.it
> Date: Tue, 21 Jan 2014 12:50:34 +0000
> Subject: Re: [CWB] CQPweb: upgrade-database.php v3.0.16> v3.1.0
>
> Think I've squished that one in 512.
>
> 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 10:48
> To: Open source development of the Corpus WorkBench
> Subject: [CWB] CQPweb: upgrade-database.php v3.0.16> v3.1.0
>
> upgrade-database on exact copy of working v3.0.16 db:
>
> Revision 510.
> 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 system_messages alter column fromto set default NULL
>
> Error # 1067: Invalid default value for 'fromto'
>
> **************
> DESCRIBE - BEFORE SCRIPT:
>
> mysql> describe cqpwbeta.system_messages;
> +------------+--------------+------+-----+-------------------+-----------------------------+
> | Field | Type | Null | Key | Default | Extra |
> +------------+--------------+------+-----+-------------------+-----------------------------+
> | message_id | varchar(150) | NO | PRI | NULL | | timestamp | timestamp
> | | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | header |
> | varchar(150) | NO | | | | content | text | NO | | NULL | | fromto |
> | varchar(150) | NO | | | |
> +------------+--------------+------+-----+-------------------+-----------------------------+
> 5 rows in set (0.00 sec)
>
>
>
> ----------------------------------------
>> From: a.hardie at lancaster.ac.uk
>> To: cwb at sslmit.unibo.it; m.killer at outlook.com
>> Date: Tue, 21 Jan 2014 10:17:22 +0000
>> Subject: Re: [CWB] CQPweb: v 3.1.0 now usable, I think
>>
>> (For the benfit of the peanut gallery: Markus sent me the "describe.... off list, and it had this line:
>>
>> | dbname | varchar(200) | NO | PRI | NULL | |
>>
>> )
>>
>> So again, it's a case of rollback being needed so the script can run again.
>>
>> The next bug is a phasing issue, it looks as if some of the DB changes which I put in there for 3.0.16 are not in the right place, they should have been assigned to 3.0.15. Commit 510 has all of those that I can find fixed.
>>
>> best
>>
>> Andrew.
> _______________________________________________
> 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