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

Markus Killer markus.killer at uzh.ch
Tue Jan 21 11:48:21 CET 2014


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. 		 	   		  


More information about the CWB mailing list