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

[Hardie, Andrew]

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