Hi Jared,

At 10:41 AM 4/28/2013 -0400, you wrote:

Paul,

I've looked at the code in cleanup_database.pl (and 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

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/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 'updatedatabase .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) jcamins@cpbibliography.com
(web) http://www.cpbibliography.com/