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

[Scott Sadowsky]

Deleting that code gives me various syntax errors, likely because after
deletion a section now begins out of nowhere with 'alter table
`query_history` drop key `user`'.

Should the deletions not continue past ‘alter table `query_history` drop
key `corpus`’?,

Best,
Scott



On Fri, Jun 7, 2019 at 7:01 AM Hardie, Andrew <a.hardie at lancaster.ac.uk>
wrote:

> 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*
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190607/e0d85383/attachment-0001.html>