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

Mon Jul 15 10:57:40 CEST 2019

Hi Thilo,

All except the first error are a result of you having SQL “strict mode” enabled. You should turn it off and try again.

Command is:

          set session sql_mode = '';

To explain: back in 2008, strict mode defaulted to off, so that’s what CQPweb assumed. Then, they changed it to default to on. CQPweb currently switches it off internally, but I’m working towards compliance with strict mode to make that unnecessary.

To make the third one work, you also need to prepare by setting the time zone:

          set time_zone = '+00:00';

As for the first… either someone was using the system when you were trying to upgrade, or there are old leaked values in the table. Either way it can be fixed hence:

delete from `system_longvalues`;

… before trying again.

best

Andrew.

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

Hi Andrew,

thanks so much! Since the server and its corpora are actively used I went through the SQL statements. It worked, meaning that the server is up and queries on corpora work. Still I got a few error messages while doing the SQL:

mysql> alter table `system_longvalues` modify column `id` int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ERROR 1366 (HY000): Incorrect integer value: 'g2srcd97b0' for column 'id' at row 1

mysql> alter table `user_info` modify column `linefeed` enum ("au", "a", "d", "da") NOT NULL;
ERROR 1067 (42000): Invalid default value for 'last_seen_time'

mysql> alter table `user_info` modify column `acct_create_time` timestamp NOT NULL default "1970-01-01 00:00:01";
ERROR 1067 (42000): Invalid default value for 'last_seen_time'

mysql> alter table `user_info` modify column `coll_statistic` tinyint(2) unsigned NOT NULL default 0;
ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_seen_time' at row 5

mysql> alter table `user_info` modify column `coll_freqtogether` smallint unsigned NOT NULL default 0 ;
ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_seen_time' at row 5

mysql> alter table `user_info` modify column `coll_freqtogether` smallint unsigned NOT NULL default 0 ;
ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_seen_time' at row 5

I guess this suggests that not all column type conversions were successful. Is this going to cause trouble (in the future)?

Best,
Thilo

Am 15.07.2019 um 00:32 schrieb Hardie, Andrew <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>>:

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 certainlyshould 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<mailto:cwb-bounces at sslmit.unibo.it> <cwb-bounces at sslmit.unibo.it<mailto: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<mailto: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

_______________________________________________
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/20190715/8b0b9a54/attachment-0001.html>