[Koha] How to return from version 17.05 to 16.05

[Luis Moises Rojas]

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 <lmoisesrojas at gmail.com>
wrote:

> 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.*
>>
>>


-- 
*Luis Moisés Rojas P.*