Hello, Backup database was still 16.05.
On Wed, Aug 9, 2017 at 11:37 AM, Katrin <[email protected]> wrote: > 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 > > 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 <[email protected]> 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_P >> ackages_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 >> >> 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 <[email protected]> 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 <[email protected]> >>>> Sent: 8/7/2017 19:20 >>>> To: Popoola <[email protected]> >>>> Cc: Comunidad Koha <[email protected]> >>>> Subject: RE: [Koha] How to return from version 17.05 to 16.05 >>>> >>>> Yes, I did. >>>> >>>> El 7 ago. 2017 2:16 PM, "Popoola" <[email protected]> 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 <[email protected]> >>>>> Sent: 8/7/2017 16:51 >>>>> To: Comunidad Koha <[email protected]> >>>>> 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 >>>>> [email protected] >>>>> https://lists.katipo.co.nz/mailman/listinfo/koha >>>>> >>>>> >>> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> [email protected] >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > > > -- > *Luis Moisés Rojas P.* > > > -- *Luis Moisés Rojas P.* _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
