[CWB] Error updating cqpweb

[Jörg Knappen]

OK, that was too risky. I restored the old version of cqpweb on my test
server and tried an update within the 3.2-latest branch, leading to the
following error: 

sudo php upgrade-database.php
Current DB version is 3.2.31 ; target version is 3.2.40 . About to
upgrade.... 

An SQL query did not run successfully!
Original query: 

alter table `corpus_info` add column `sttr_1kw` float DEFAULT 0.0 after
`size_bytes_freq` 
/* from User: ??? | Function: upgrade_3_2_31() | 2020-Jan-09 21:21 */
Error # 1060: Duplicate column name 'sttr_1kw' 

Greetings from Saarbrücken, 

Jörg Knappen 

Am 2020-01-07 22:00, schrieb Hardie, Andrew:

>> 1406 was a commit to the trunk. The trunk is still thoroughly broken until v3.3.0 is finished! The 3.2 branch works. 
>> 
>> Andrew. 
>> 
>> -------------------------
>> 
>> From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> on behalf of Jörg Knappen <j.knappen at mx.uni-saarland.de>
>> Sent: Tuesday, 7 January 2020, 5:03 pm
>> To: cwb at sslmit.unibo.it
>> Subject: [CWB] Error updating cqpweb

> I tried to update our cqpweb installation to the most recent developer
> version (revision 1406) and got the following error:
> 
> sudo php bin/upgrade-database.php
> PHP Parse error:  syntax error, unexpected ']', expecting '-' or
> identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING)
> in /data2/htdocs/cqpweb/bin/upgrade-database.php on line 321
> 
> Trying to run it without database upgrade produced a similar runtime
> error from a different code location:
> 
> [Tue Jan 07 17:47:08.603359 2020] [php7:emerg] [pid 2503] [client
> xxx.yyy.zzz.aaa:49958] PHP Parse error:  syntax error, unexpected ''
> (T_ENCAPSED_AND_WHITESPACE), expecting '-' or identifier (T_STRING) or
> variable (T_VARIABLE) or number (T_NUM_STRING) in
> /data2/htdocs/cqpweb/lib/sql-lib.php on line 2128
> 
> --Jörg Knappen
> 
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&amp;data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7C31f839722e0d424c711508d793938773%7C9c9bcd11977a4e9ca9a0bc734090164a%7C1%7C1%7C637140134170197160&amp;sdata=LHgMxQmA3xxLLPI0OUMik1mys8zcPZr646YFbflo8xE%3D&amp;reserved=0 
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20200109/d05f5f5e/attachment.html>