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