[Koha] How to return from version 17.05 to 16.05

[Luis Moises Rojas]

Now we are going to restore a new backup (two weeks ago)

El 9 ago. 2017 11:39 AM, "Luis Moises Rojas" <lmoisesrojas at gmail.com>
escribió:

> Hello,
>
> Backup database was still 16.05.
>
>
> On Wed, Aug 9, 2017 at 11:37 AM, Katrin <katrin.fischer.83 at web.de> 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 <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_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 <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>
>>>>> Sent: ‎8/‎7/‎2017 19:20
>>>>> To: Popoola <popoolasegun1 at gmail.com>
>>>>> Cc: Comunidad Koha <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> 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>
>>>>>> Sent: ‎8/‎7/‎2017 16:51
>>>>>> To: Comunidad Koha <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
>>>>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>>>
>>>>>>
>>>>
>>> _______________________________________________
>>> Koha mailing list  http://koha-community.org
>>> Koha at lists.katipo.co.nz
>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
>>
>>
>> --
>> *Luis Moisés Rojas P.*
>>
>>
>>
>
>
> --
> *Luis Moisés Rojas P.*
>
>