[CWB] updata-database.php: PHP Fatal error: Call to undefined function upgrade_()

[Hardie, Andrew]

Hi Jörg,

Well, if it is *just* an issue of that version-log being missing, you can simply insert it:

   insert into system_info (setting_name, value) VALUES ('db_version',  '3.1.4');

HOWEVER, it's possible that its absence reflects an earlier upgrade not having run properly to completion. In which case, your database might be in a between-versions state, which would be a very difficult thing to solve.

Can I suggest you run the following:

   describe `user_captchas`;
   describe `annotation_template_info`;

If you get a description of a table with 3 columns for the former, and a description of a table with 2 columns for the latter, then you probably have a system safely at v 3.1.4, and you can use the insert statement above.

If not, some database archaeology on your earlier upgrades may be necessary....

best

Andrew.

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Jörg Knappen
Sent: 15 February 2016 15:38
To: cwb at sslmit.unibo.it
Subject: Re: [CWB] updata-database.php: PHP Fatal error: Call to undefined function upgrade_()


Hallo Andrew,

Eek, it is empty in the database:

mysql> select * from system_info;
Empty set (0.00 sec)

--Jörg Knappen

Zitat von "Hardie, Andrew" <a.hardie at lancaster.ac.uk>:

> The empty old version is the problem - it looks like it has tried to  
> get the old version from the database (which monitors its own  
> version internally), but failed.
>
> I'm not sure why it failed, however. Let me suggest some steps to  
> check it out.
>
> Can you run the following query in the MySQL client:
>
>       select * from system_info;
>
> I would expect to see the following:
>
> +--------------+------------------+
> | setting_name | value            |
> +--------------+------------------+
> | db_version   | 3.1.4            |
> +--------------+------------------+
>
> Let me know what you see!
>
> best
>
> Andrew.
>
>
> -----Original Message-----
> From: cwb-bounces at sslmit.unibo.it  
> [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Jörg Knappen
> Sent: 15 February 2016 15:07
> To: Open source development of the Corpus WorkBench
> Subject: Re: [CWB] updata-database.php: PHP Fatal error: Call to  
> undefined function upgrade_()
>
> Sigh, there was a typo in the starting version number, it should read
> 3.1.4 (not 3.2.4).
>
>
> --Jörg Knappen
>
> Zitat von Jörg Knappen <j.knappen at mx.uni-saarland.de>:
>
>> I want to update a cqpweb installation from version 3.2.4 to 3.2.6.
>>
>> I installed the updated php files, copied back my old configuration
>> file lib/config.inc.php and try to run
>>
>> $ php upgrade-database.php
>>
>> Unfortunately, I get the following error:
>>
>> Current DB version is ; target version is 3.2.6 .  About to upgrade....
>> PHP Fatal error:  Call to undefined function upgrade_() in
>> /data2/htdocs/cqpweb/bin/upgrade-database.php on line 158
>>
>>
>> Note the empty old version. What's going wrong here? How can I proceed?
>>
>>
>> --Jörg Knappen
>>
>> _______________________________________________
>> CWB mailing list
>> CWB at sslmit.unibo.it
>> http://devel.sslmit.unibo.it/mailman/listinfo/cwb
>
>
>
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://devel.sslmit.unibo.it/mailman/listinfo/cwb
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://devel.sslmit.unibo.it/mailman/listinfo/cwb



_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
http://devel.sslmit.unibo.it/mailman/listinfo/cwb