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
<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]
<mailto:[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_Packages_on_Koha
<https://wiki.koha-community.org/wiki/Koha_on_Debian#Debian_Packages_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
<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] <mailto:[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]
<mailto:[email protected]>>
Sent: 8/7/2017 19:20
To: Popoola <[email protected]
<mailto:[email protected]>>
Cc: Comunidad Koha <[email protected]
<mailto:[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]
<mailto:[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]
<mailto:[email protected]>>
Sent: 8/7/2017 16:51
To: Comunidad Koha <[email protected]
<mailto:[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] <mailto:[email protected]>
https://lists.katipo.co.nz/mailman/listinfo/koha
<https://lists.katipo.co.nz/mailman/listinfo/koha>
_______________________________________________
Koha mailing list http://koha-community.org
[email protected] <mailto:[email protected]>
https://lists.katipo.co.nz/mailman/listinfo/koha
<https://lists.katipo.co.nz/mailman/listinfo/koha>
--
/*Luis Moisés Rojas P.*/
/*
*/
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
