[Koha] How to return from version 17.05 to 16.05

[Katrin]

Hi Luis,

did you use the database that was updated to 17.05 before or a backup 
database that was still 16.05?

koha-upgrade-schema only works 'upwards', it won't be able to downgrade 
a database to the old structure. In 17.05 there was one major change in 
moving the marcxml from biblioitems to a new separate table. Other 
changes would also be problematic.  So using a 17.05 database with 16.05 
code WON'T WORK.

The init script and how to install it is described on the wiki page:

https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix 
<https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix>

If you can't use a database backup from before the attempted update to 
17.05, I strongly recommend returning ot 17.05 and trying to fix the 
errors you have seen there.

Katrin


On 09.08.2017 16:16, Luis Moises Rojas wrote:
> Hello,
>
> Finally we have reinstalled 16.05
> We ran:
> sudo koha-upgrade-schema libraryname
> sudo koha-rebuild-zebra -v -f libraryname
> sudo koha-rebuild-zebra -a -f  libraryname
>
> In sudo koha-upgrade-schema we have severals "Select" errors.
> When you try to find a BOOK it says: No found
> If we search an author says: IN REPOSITORY.
>
> Why?
>
> Maybe is because we have to do this: "You need to fix your data in 
> order to get around this and implement the init script"
>
> But where is init script and how to used it?
>
>
> On Mon, Aug 7, 2017 at 5:32 PM, Katrin <katrin.fischer.83 at web.de 
> <mailto:katrin.fischer.83 at web.de>> wrote:
>
>     Please note, that you will need to use your backup from before
>     updating to 17.05, because you can't undo the changes to the
>     database structure easily.
>
>     From reading one of your earlier emails - is it possible that you
>     are using MySQL 5.7  instead of MariaDB?
>
>     https://wiki.koha-community.org/wiki/Koha_on_Debian#Debian_Packages_on_Koha
>     <https://wiki.koha-community.org/wiki/Koha_on_Debian#Debian_Packages_on_Koha>
>
>     The problem with returning items will probably remain, as we have
>     implemented a block on returning items when the issue_id already
>     exists in old_issues in 17.05, 16.11, and 16.05. Please see here:
>
>     https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
>     <https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix>
>
>     You need to fix your data in order to get around this and
>     implement the init script.
>
>     Hope this helps,
>
>     Katrin
>
>
>     On 07.08.2017 20:50, Luis Moises Rojas wrote:
>
>         We are reinstalling previous version 16.05 with 17.05 is was
>         impossible to
>         work.
>         We can not return book.
>         All books where in Reserver
>         We can not Catalog.
>         And much more.
>
>
>         On Mon, Aug 7, 2017 at 2:25 PM, Popoola
>         <popoolasegun1 at gmail.com <mailto:popoolasegun1 at gmail.com>> wrote:
>
>             Did you have koha image of your previous version, i mean
>             your previous
>             installation version on your external hard drive or cloud
>             backup?
>             ------------------------------
>             From: Luis Moises Rojas <lmoisesrojas at gmail.com
>             <mailto:lmoisesrojas at gmail.com>>
>             Sent: ‎8/‎7/‎2017 19:20
>             To: Popoola <popoolasegun1 at gmail.com
>             <mailto:popoolasegun1 at gmail.com>>
>             Cc: Comunidad Koha <koha at lists.katipo.co.nz
>             <mailto:koha at lists.katipo.co.nz>>
>             Subject: RE: [Koha] How to return from version 17.05 to 16.05
>
>             Yes, I did.
>
>             El 7 ago. 2017 2:16 PM, "Popoola" <popoolasegun1 at gmail.com
>             <mailto:popoolasegun1 at gmail.com>> escribió:
>
>                 Hello Luis, when you are performing your upgrading did
>                 you backup your
>                 database? or did you export your bibliographic?.If you
>                 did any,you can
>                 restore your previous version. But the best practices
>                 is to figure out the
>                 error you encountered during the upgrade and post it
>                 to forum, so that
>                 members can shares their experience with you
>                 ------------------------------
>                 From: Luis Moises Rojas <lmoisesrojas at gmail.com
>                 <mailto:lmoisesrojas at gmail.com>>
>                 Sent: ‎8/‎7/‎2017 16:51
>                 To: Comunidad Koha <koha at lists.katipo.co.nz
>                 <mailto:koha at lists.katipo.co.nz>>
>                 Subject: [Koha] How to return from version 17.05 to 16.05
>
>                 Hello everybody,
>
>                 We upgrade from 16.05 to 17.05.
>                 Now we are having at lot of problems.
>                 We can not work at all.
>
>                 Is there is a way to get back?
>                 Previous version where everything was ok?
>
>                 Thanks
>
>                 --
>                 *Luis Moisés Rojas P.*
>                 _______________________________________________
>                 Koha mailing list http://koha-community.org
>                 Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>                 https://lists.katipo.co.nz/mailman/listinfo/koha
>                 <https://lists.katipo.co.nz/mailman/listinfo/koha>
>
>
>
>     _______________________________________________
>     Koha mailing list http://koha-community.org
>     Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>     https://lists.katipo.co.nz/mailman/listinfo/koha
>     <https://lists.katipo.co.nz/mailman/listinfo/koha>
>
>
>
>
> -- 
> /*Luis Moisés Rojas P.*/
> /*
> */