Now we are going to restore a new backup (two weeks ago) El 9 ago. 2017 11:39 AM, "Luis Moises Rojas" <[email protected]> escribió:
> 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

