Bug 8771 - Something wrong with databse update 3.09.00.044
Summary: Something wrong with databse update 3.09.00.044
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Galen Charlton
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-14 08:22 UTC by Katrin Fischer
Modified: 2014-05-26 21:04 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Katrin Fischer 2012-09-14 08:22:23 UTC
On a train today, so want to note this before I get disconnected or forget:

Output is missing the version number:
Upgrade done ( Added Collection Code to Statistics table. )


And there is a SQL error. I updated from .37 to .44:

[Fri Sep 14 09:55:19 2012] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'ccode' at /home/katrin/kohaclone/installer/data/mysql/updatedatabase.pl line 5774.
Comment 1 Magnus Enger 2012-09-14 08:30:19 UTC
I did an upgrade from .33 to .44 through the web installer earlier today and did not see this error:


    Upgrade to 3.09.00.033 done (Add OpacSuppressionByIPRange syspref)
    Upgrade to 3.09.00.034 done (Bug 8207: correct typo in authority types)
    Upgrade to 3.09.00.035 done (Adding PrefillItem and SubfieldsToUseWhenPrefill sysprefs)
    Upgrade to 3.09.00.036 done (Add colum agerestriction to biblioitems and deletedbiblioitems, add system preferences AgeRestrictionMarker and AgeRestrictionOverride)
    Upgrade to 3.09.00.037 done (creating `transport_cost` table; adding UseTransportCostMatrix systempref, in circulation)
    Upgrade to 3.09.00.038 done (Increase the maximum size of a borrower attribute value)
    Upgrade to 3.09.00.039 done (Add system preference DidYouMeanFromAuthorities)
    Upgrade to 3.09.00.040 done (Add IncludeSeeFromInSearches system preference)
    Upgrade to 3.09.00.041 done (Add system preference ExportRemoveFields)
    Upgrade to 3.09.00.042 done (Adds New System preference ExportWithCsvProfile)
    Upgrade to 3.09.00.043 done (Adding parent_ordernumber in aqorders)
    Upgrade done ( Added Collection Code to Statistics table. )

Everything went OK, update done.
Comment 2 Marc Véron 2012-09-24 20:47:54 UTC
Katrin,

I have this kind of errors if with columns I added before while developing.

Searched through updatedatabase.pl, there is only one place where colum ccode is added to table statistics (while updating to version '3.09.00.044')

I propose to set this bug to Resolved. Please reset it to NEW if you do not agree :-)

Marc
Comment 3 Katrin Fischer 2012-09-25 07:18:57 UTC
I am quite sure I never tested this specific development... but if noone else runs into this, it must be something in my database.
Comment 4 Marcel de Rooy 2013-06-12 14:30:07 UTC
Funny to stumble across this today. Had a problem with a patch in bug 8190 that unintentionally removed a line at 3.9.0.45 ...