[Koha] How to return from version 17.05 to 16.05

[Luis Moises Rojas]

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