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

[Markus Killer]

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