[CWB] CQPweb upgrade to 3.2-latest upgrade-database fails

[Hardie, Andrew]

Hi Thilo,

The message “Table 'cqpweb_db.idlink_values' doesn't exist” indicates that something was amiss in your database setup already, as that table certainly should have  existed.

If you already have many corpora in your system, I suggest you create the table using the create statement on line 1015 of upgrade-database; then manually apply all statements from line 367 to line 596 to complete the upgrade (and then finally run  update system_info set value = '3.2.37' where setting_name = 'db_version';   )

If you don’t have many (or any!) corpora installed, or if your corpora use external CWB indexes, it may take less time to go the more radical route: delete your corpora,  nuke the entire DB and then run autosetup to reinstall the system, then re-index your corpora from scratch.

best

Andrew.

From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Thilo Wiertz
Sent: 12 July 2019 14:04
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: [CWB] CQPweb upgrade to 3.2-latest upgrade-database fails

Dear Andrew, dear all,

I just tried to upgrade my server to 3.2-latest after swichting to the new 3.2 branch. The upgrade-database.php script breaks with the following error:


An SQL query did not run successfully!
Original query:

alter table `idlink_values` modify column `corpus` varchar(20) CHARSET ascii COLLATE ascii_bin NOT NULL
                /* from User: ??? | Function: upgrade_3_2_36() | 2019-Jul-12 14:58 */
Error # 1146: Table 'cqpweb_db.idlink_values' doesn't exist

Thanks for your help!

Best,
Thilo


Am 04.07.2019 um 11:41 schrieb Hardie, Andrew <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>>:

Hi all,

I have branched off the 3.2.39+ line of CQPweb. Those of you who are running servers that follow the SVN dev version will probably want to flip over to the branch until further notice, as the trunk will be broken, starting today.

(SVN Command for this below.)

The 3.2 branch will continue to receive bug fixes indefinitely, and minor function updates until the trunk diverges enough to make doing so a pain. When it reaches a steady state, hopefully in no more than a month, I’ll export it as a new tarball and create a new CQPwebInABox image.

The trunk will go to version 3.2.999, just to keep everything numerical. Once I am reasonably happy that it is safe for people to switch live servers back to the trunk, I’ll announce it to the list and the version number will become 3.3.0.

The major change will be to enable full coverage of UTF-8 – as more and more people want to index texts that may contain emojis, using the stunted mysql 3-byte legacy version of UTF-8 is increasingly a showstopper.

After 3.3.0 arrives, I hope to take some time away from CQPweb dev work to focus on improving the manual, recording more tutorial videos, and possibly even some work on Ziggurat.

best

Andrew.

===================

To switch from the trunk to the 3.2 branch, cd to the root of your checkout, and run:

svn switch https://svn.code.sf.net/p/cwb/code/gui/cqpweb/branches/3.2-latest .

… note final dot.
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it<mailto: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/20190714/9b218a6c/attachment-0001.html>