[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
Re: [Koha] How to return from version 17.05 to 16.05
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 -Original Message- From: "Luis Moises Rojas" Sent: 8/7/2017 16:51 To: "Comunidad Koha" 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
Re: [Koha] How to return from version 17.05 to 16.05
Yes, I did. El 7 ago. 2017 2:16 PM, "Popoola" 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 > Sent: 8/7/2017 16:51 > To: Comunidad Koha > 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
Re: [Koha] How to return from version 17.05 to 16.05
Did you have koha image of your previous version, i mean your previous installation version on your external hard drive or cloud backup? -Original Message- From: "Luis Moises Rojas" Sent: 8/7/2017 19:20 To: "Popoola" Cc: "Comunidad Koha" Subject: RE: [Koha] How to return from version 17.05 to 16.05 Yes, I did. El 7 ago. 2017 2:16 PM, "Popoola" 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 Sent: 8/7/2017 16:51 To: Comunidad Koha 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
Re: [Koha] How to return from version 17.05 to 16.05
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 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 > Sent: 8/7/2017 19:20 > To: Popoola > Cc: Comunidad Koha > Subject: RE: [Koha] How to return from version 17.05 to 16.05 > > Yes, I did. > > El 7 ago. 2017 2:16 PM, "Popoola" 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 >> Sent: 8/7/2017 16:51 >> To: Comunidad Koha >> 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 >> > -- *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
Re: [Koha] How to return from version 17.05 to 16.05
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 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 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 Sent: 8/7/2017 19:20 To: Popoola Cc: Comunidad Koha Subject: RE: [Koha] How to return from version 17.05 to 16.05 Yes, I did. El 7 ago. 2017 2:16 PM, "Popoola" 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 Sent: 8/7/2017 16:51 To: Comunidad Koha 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
Re: [Koha] How to return from version 17.05 to 16.05
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 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 > > 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 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 >>> Sent: 8/7/2017 19:20 >>> To: Popoola >>> Cc: Comunidad Koha >>> Subject: RE: [Koha] How to return from version 17.05 to 16.05 >>> >>> Yes, I did. >>> >>> El 7 ago. 2017 2:16 PM, "Popoola" 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 >>>> Sent: 8/7/2017 16:51 >>>> To: Comunidad Koha >>>> 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.* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to return from version 17.05 to 16.05
Hello, This is the error: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE biblionumber=? " with ParamValues: 0='27382'] at /usr/share/koha/lib/C4/Biblio.pm line 1327. Maybe is because the database is in one version and koha in other? On Wed, Aug 9, 2017 at 10:16 AM, 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 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 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 >>>> Sent: 8/7/2017 19:20 >>>> To: Popoola >>>> Cc: Comunidad Koha >>>> Subject: RE: [Koha] How to return from version 17.05 to 16.05 >>>> >>>> Yes, I did. >>>> >>>> El 7 ago. 2017 2:16 PM, "Popoola" 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 >>>>> Sent: 8/7/2017 16:51 >>>>> To: Comunidad Koha >>>>> 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.* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to return from version 17.05 to 16.05
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 <mailto:katrin.fischer...@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_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 mailto:popoolaseg...@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 mailto:lmoisesro...@gmail.com>> Sent: 8/7/2017 19:20 To: Popoola mailto:popoolaseg...@gmail.com>> Cc: Comunidad Koha mailto: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" mailto:popoolaseg...@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 mailto:lmoisesro...@gmail.com>> Sent: 8/7/2017 16:51 To: Comunidad Koha mailto: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 <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha <https://lists.katipo.co.nz/mailman/listinfo/koha>
Re: [Koha] How to return from version 17.05 to 16.05
Hello, Backup database was still 16.05. On Wed, Aug 9, 2017 at 11:37 AM, Katrin 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 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 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 >>>> Sent: 8/7/2017 19:20 >>>> To: Popoola >>>> Cc: Comunidad Koha >>>> Subject: RE: [Koha] How to return from version 17.05 to 16.05 >>>> >>>> Yes, I did. >>>> >>>> El 7 ago. 2017 2:16 PM, "Popoola" 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 >>>>> Sent: 8/7/2017 16:51 >>>>> To: Comunidad Koha >>>>> 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.* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to return from version 17.05 to 16.05
Now we are going to restore a new backup (two weeks ago) El 9 ago. 2017 11:39 AM, "Luis Moises Rojas" escribió: > Hello, > > Backup database was still 16.05. > > > On Wed, Aug 9, 2017 at 11:37 AM, Katrin 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 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 >>>> 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 >>>>> Sent: 8/7/2017 19:20 >>>>> To: Popoola >>>>> Cc: Comunidad Koha >>>>> Subject: RE: [Koha] How to return from version 17.05 to 16.05 >>>>> >>>>> Yes, I did. >>>>> >>>>> El 7 ago. 2017 2:16 PM, "Popoola" 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 >>>>>> Sent: 8/7/2017 16:51 >>>>>> To: Comunidad Koha >>>>>> 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.* > > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to return from version 17.05 to 16.05
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 wrote: > Now we are going to restore a new backup (two weeks ago) > > El 9 ago. 2017 11:39 AM, "Luis Moises Rojas" > escribió: > >> Hello, >> >> Backup database was still 16.05. >> >> >> On Wed, Aug 9, 2017 at 11:37 AM, Katrin 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 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 >>>>> 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 >>>>>> Sent: 8/7/2017 19:20 >>>>>> To: Popoola >>>>>> Cc: Comunidad Koha >>>>>> Subject: RE: [Koha] How to return from version 17.05 to 16.05 >>>>>> >>>>>> Yes, I did. >>>>>> >>>>>> El 7 ago. 2017 2:16 PM, "Popoola" escribió: >>>>>> >>>>>> Hello Luis, when you are performing your upgrading did you backup your >>>>>>> database? or did you export your biblio