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

[Jörg Knappen]

Hallo Andrew,

thanks, that worked and the update seems to run smoothly now.!


Thanks again for your help!

--Jörg

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

> 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
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://devel.sslmit.unibo.it/mailman/listinfo/cwb