Hello everybody, Everything was ok. We restore the database (of course, we were wrong, and we restore a 16.05 database) We are working again, after 4 days.
Thanks to all On Wed, Aug 9, 2017 at 11:54 AM, Luis Moises Rojas <[email protected]> wrote: > 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.* >> >> -- *Luis Moisés Rojas P.* _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
