[Koha-devel] Major surprise - "automatic" upgrade

[Paul]

Hi Jared,

At 10:41 AM 4/28/2013 -0400, you wrote:
>Paul,
>
>I've looked at the code in <http://cleanup_database.pl>cleanup_database.pl 
>(and <http://search.pl>search.pl), and can't see any obvious reason to 
>"redirect to Installer."
>
>So -- what has happened? Â Can I dump the cleaned db back into production? 
>What are the specific changes 3.8.5 to 3.8.10 that required "updating"?
>
>
>The redirect is because you had a newer version of the code than the 
>database was run on.

Thanks for your reply, but this is worrisome. I had at {server}/ a tarred 
3.8.10.  I had at {server}/home/paul/ an untarred 3.8.10 (for .dif purposes.)

>Koha doesn't have any support for automatic upgrades, so I guess you must 
>have untarred 3.8.10 at some point.

[see above] O.K. it's not "automatic" but it did in fact run automatically 
without my permission. I ran:

      './cleanup_database.pl --zebraqueue -v'

and Koha *updated* from 3.8.5 to some variant of 3.8.10. Note the '-v' -- 
but it sat there running with nothing "verbose."

>You can take a look at the release notes for the versions between 3.8.5 
>and 3.8.10:Â 
><http://git.koha-community.org/gitweb/?p=koha.git;a=tree;f=misc/release_notes;h=fd4b7d4bf8f9d401c87878ec184593a078bb5a93;hb=3.8.x>http://git.koha-community.org/gitweb/?p=koha.git;a=tree;f=misc/release_notes;h=fd4b7d4bf8f9d401c87878ec184593a078bb5a93;hb=3.8.x

I can find no mention of 'db' or 'database'

>Based on the "Update report" you shared, it doesn't look like there were 
>any actual database changes in between versions 3.8.5 and 3.8.10, but I 
>couldn't say that with certainty without checking (you can take a look at 
>the release notes linked above, and by reviewing the 
>installer/data/mysql/<http://updatedatabase.pl>updatedatabase.pl file on 
>the 3.8.10 installation).

I have looked at it, but question why it would be triggered?

>The update is trigged whenever you have an older version of the database 
>than the code,

By what? And "the code" in what? The relevant code in cleanup_database.pl is

       "$sth2 = $dbh->prepare("DELETE FROM zebraqueue WHERE id=?");"

a simple MySQL directive. Why does 'cleanup_database.pl' even look for 
'<http://updatedatabase.pl>updatedatabase<http://updatedatabase.pl>.pl' 
and|or "other/more recent" versions of "the code"?

The bottom line is "why does a simple .pl using TRUNCATE lead to an upgrade"?

>Most likely downgrading to 3.8.5 would not cause any problems at all,

"Downgrading" is new to me.  Do you mean "restore system from backup"?

Best - Paul

>even if there were database changes, but it's always a good idea to check.
>
>Regards,
>Jared
>
>--
>Jared Camins-Esakov
>Bibliographer, C & P Bibliography Services, LLC
>(phone) +1 (917) 727-3445
>(e-mail) <mailto:jcamins at cpbibliography.com>jcamins at cpbibliography.com
>(web) <http://www.cpbibliography.com/>http://www.cpbibliography.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20130429/92b96e71/attachment.html>