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...@web.de <mailto:katrin.fischer...@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
        <popoolaseg...@gmail.com <mailto:popoolaseg...@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 <lmoisesro...@gmail.com
            <mailto:lmoisesro...@gmail.com>>
            Sent: ‎8/‎7/‎2017 19:20
            To: Popoola <popoolaseg...@gmail.com
            <mailto:popoolaseg...@gmail.com>>
            Cc: Comunidad Koha <koha@lists.katipo.co.nz
            <mailto:koha@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" <popoolaseg...@gmail.com
            <mailto:popoolaseg...@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 <lmoisesro...@gmail.com
                <mailto:lmoisesro...@gmail.com>>
                Sent: ‎8/‎7/‎2017 16:51
                To: Comunidad Koha <koha@lists.katipo.co.nz
                <mailto:koha@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@lists.katipo.co.nz <mailto:Koha@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@lists.katipo.co.nz <mailto:Koha@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.*/
/*
*/

_______________________________________________
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to