[CWB] [CQPweb r1236] SQL error when updating DB

[Hardie, Andrew]

Delete the line

‘alter table `query_history` drop key `corpus`’,

and everything before it right back to the bit that asks “Do you wish to continue running the uipgrade now?”

from upgrade-database.php

Then run again.

This happened because your original DB setup was between 3.2.36 and 3.2.37

best

Andrew.

From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Scott Sadowsky
Sent: 07 June 2019 11:36
To: Open source development of the Corpus WorkBench <CWB at liste.sslmit.unibo.it>
Subject: [CWB] [CQPweb r1236] SQL error when updating DB

Sorry for the flood of messages, folks! When I update to r1236 and try to update the DB, I get the following error:

Current DB version is 3.2.36 ; target version is 3.2.37 .  About to upgrade....
===========================================================================
Please note, some of the operations in this upgrade are time-consuming
(especially if your installation has a long history).
It is recommended that you run this upgrade in a quiet period, and
(ideally) with CQPweb in "switched-off" mode if it is accessible to
users other than you.
===========================================================================
Do you wish to continue running the uipgrade now?
Enter [Y]es or [N]:y
An SQL query did not run successfully!
Original query:
alter table `query_history` drop key `corpus`
/* from User: ??? | Function: upgrade_3_2_36() | 2019-Jun-07 07:35 */
Error # 1091: Can't DROP 'corpus'; check that column/key exists


Cheers,
Scott
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190607/8ba74a09/attachment.html>