Re: [Koha] Migration erros from 16.05 to 16.11

I've tested that instructions and there was a lot of problems. It would be better to wait until Mysql 5.7 have fully support by Koha or install MariaDB To install MariaDB you can follow Instructions like these:

Re: [Koha] Migration erros from 16.05 to 16.11

Hi Satish >then I request community to suggest how to migrate existing data from MySQL >to MariaDB, if we plan to move from 14.04 to 16.04. Do I get any kind of >documentation ? in fact is impossiblte to give you specific info about migrate existing data from MySQL to MariaDB, if we plan to

Re: [Koha] Migration erros from 16.05 to 16.11

Hi Tomas, Thank you so much for the detailed reply. I understand now. we are using Koha 3.6 and upgraded till - 16.5 I faced problem only for upgrade from 16.5 to 16.11 on Ubunt 12.04/14.04 LTS At this stage, still I guess, upgrade should work. since, it is indicated only after 16.04 MariaDB

Re: [Koha] Migration erros from 16.05 to 16.11

The 'koha-common' package doesn't include MySQL or MariaDB. It requires a database server, and only suggests that you could install the 'mysql-server' package (or the 'virtual-mysql-server'). Our instructions tell you to install the database server BEFORE installing 'koha-common'. And you can

Re: [Koha] Migration erros from 16.05 to 16.11

Does Koha 16.11 koha-common packages also includes MariaDB?? -Satish Librarian, Govt. Eng. College, Hassan Karnataka. On 16 December 2016 at 17:12, Tomas Cohen Arazi wrote: > Ubuntu 14.04 is not fully supported by 16.05. And MariaDB gracefully > replaces the mysql

Re: [Koha] Migration erros from 16.05 to 16.11

Ubuntu 14.04 is not fully supported by 16.05. And MariaDB gracefully replaces the mysql package. El vie., 16 de dic. de 2016 8:21 AM, SATISH escribió: > Dear Koha Community, > > thank you for your reply. > > Regarding upgrade Koha from 16.05 to 16.11, > Since, I work as

Re: [Koha] Migration erros from 16.05 to 16.11

Dear Koha Community, thank you for your reply. Regarding upgrade Koha from 16.05 to 16.11, Since, I work as Librarian, I have limited knowledge of MariaDB and other OS upgrade. and we have 1000 + records and 1000+ active users, and do not want to take any kind of risk. can we get specific

Re: [Koha] Migration erros from 16.05 to 16.11

To solve all my problems I had to make a new machine with Ubuntu 16.04 and then import the backup. Be careful because Mysql 5.7 is not fully compatible and brings a lot of problems. I've used MariaDB and everything is OK - Koha version: 16.05.05 - - José Anjos -- View this message

Re: [Koha] Migration erros from 16.05 to 16.11

Hi Satish, >I am unable to upgrade from 16.05.01.000 to latest stable release 16.11. >Ubuntu and Mysql Details: >| version | 5.5.53-0ubuntu0.12.04.1 | >apt-get dist-upgrade koha-common : Depends: libarchive-extract-perl but it is not installable Depends:

Re: [Koha] Migration erros from 16.05 to 16.11

Hello, I am unable to upgrade from 16.05.01.000 to latest stable release 16.11. Ubuntu and Mysql Details: # mysql -u root -p -e 'SHOW VARIABLES LIKE "%version%";' +-+-+ | Variable_name | Value |

Re: [Koha] Migration erros from 16.05 to 16.11

No, I meant for the next upgrades:when something went wrong during the update process, don't close your eyes. If the table items_search_fields was missing you certainly got an error when you upgraded from a previous version. On Wed, 30 Nov 2016 at 18:03 anjoze wrote: >

Re: [Koha] Migration erros from 16.05 to 16.11

Well, my database is already upgraded. Do you mean from the old backup? I cant because I would lose too much information. How can I force upgrade it again? - Koha version: 16.05.05 - - José Anjos -- View this message in context:

Re: [Koha] Migration erros from 16.05 to 16.11

Yes, keep in mind to check the errors when you upgrade your database :) On Wed, 30 Nov 2016 at 17:19 anjoze wrote: > Ok, I've found the sql file on > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/kohastructure.sql > > I've executed: > CREATE TABLE IF NOT EXISTS

Re: [Koha] Migration erros from 16.05 to 16.11

Ok, I've found the sql file on /usr/share/koha/intranet/cgi-bin/installer/data/mysql/kohastructure.sql I've executed: CREATE TABLE IF NOT EXISTS items_search_fields ( name VARCHAR(255) NOT NULL, label VARCHAR(255) NOT NULL, tagfield CHAR(3) NOT NULL, tagsubfield CHAR(1) NULL DEFAULT NULL,

Re: [Koha] Migration erros from 16.05 to 16.11

Hi Jonathan I have experienced similar errors yesterday when updating from Koha 16.05.05 to 16.11.00 on Debian GNU/Linux 8 using MySQL 5.5: Upgrade to 16.06.00.001 done (Bug 16200 - 'Hold waiting too long' fee has a translation problem) DBD::mysql::db do failed: Duplicate column name

Re: [Koha] Migration erros from 16.05 to 16.11

The table items_search_fields does not exist whereas it has been created by 3.17.00.046. You should manually replay this update DB entry ("CREATE TABLE IF NOT EXISTS items_search_fields [...]") then redo the whole update process. On Wed, 30 Nov 2016 at 12:13 anjoze wrote: >