subject:"Re\: \[Koha\] Migration erros from 16.05 to 16.11"

Re: [Koha] Migration erros from 16.05 to 16.11

2016-12-19 Thread anjoze

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:
https://www.linuxbabe.com/linux-server/install-apache-mariadb-and-php7-lamp-stack-on-ubuntu-16-04-lts
on Step 3
But to make a migration like that *you really should have IT support* like
Zeno said because there is a lot of possible problems on migrations.



-
Koha version:   16.05.05
   - -
José Anjos
--
View this message in context: 
http://koha.1045719.n5.nabble.com/Migration-erros-from-16-05-to-16-11-tp5912344p5914554.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migration erros from 16.05 to 16.11

2016-12-18 Thread Zeno Tajoli

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 move from 14.04 to 16.04.
You need to ask to your IT support.

or:

Try to insert in your /etc/mysql/my.conf:

[mysqld]
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Source:
http://askubuntu.com/questions/811831/whats-the-correct-way-to-revert-mysql-5-7-strict-mode-back-to-how-it-was-in-5-6


But ATTENTION !! Be careful. I don't test those instructions.
so I don't know if they could create problems instead of resolve them.
An other user use them and he report an OK

Test them before in spare server.

Bye
Zeno Tajoli
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migration erros from 16.05 to 16.11

2016-12-18 Thread SATISH

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 is recommended.
https://wiki.koha-community.org/wiki/Koha_on_Debian

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 ?


with thanks
satish
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migration erros from 16.05 to 16.11

2016-12-17 Thread Tomas Cohen Arazi

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 choose to install MariaDB or MySQL. Both serve
the purpose and the 'koha-common' installer understands that it has the
right DB server (either will make virtual-mysql-server be marked as
installed).

So you need to:
$ sudo apt install mariadb-server
or
$ sudo apt install mysql-server

before installing the 'koha-common' package.

Regards

El sáb., 17 dic. 2016 a las 1:47, SATISH () escribió:

> 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 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 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 documentation and any help for upgrade of koha.
> I can only perform, the system upgrade from 12.04 to 14.04 or 16.0, but not
> sure, this will surely upgrade Koha.
> because, with Koha 16.05 installed by packages method which uses MySql.
> Now how to switch over to MariaDB from Mysql with the existing server.
>
> with thanks
> Satish MV
> Librarian, Govt. Engineering College, Hassan.
> Karnataka.
>
>
>
>
> On 16 December 2016 at 15:18, Tajoli Zeno  wrote:
>
> > Hi,
> >
> > Il 16/12/2016 10:29, anjoze ha scritto:
> >
> >> 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
> >>
> >
> > i confim, if you use Ubuntu 16.04 MariaDB is a good choice.
> >
> > Bye
> > Zeno Tajoli
> >
> >
> > --
> > Zeno Tajoli
> > /SVILUPPO PRODOTTI CINECA/ - Automazione Biblioteche
> > Email: z.taj...@cineca.it Fax: 051/6132198
> > *CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)
> >
> > ___
> > 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
>
> --
> Tomás Cohen Arazi
> Theke Solutions (https://theke.io )
> ✆ +54 9351 3513384 <+54%209%20351%20351-3384>
> GPG: B2F3C15F
>
>
>
>
> --
>
>
>
> --
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migration erros from 16.05 to 16.11

2016-12-16 Thread SATISH

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 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 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 documentation and any help for upgrade of koha.
>> I can only perform, the system upgrade from 12.04 to 14.04 or 16.0, but
>> not
>> sure, this will surely upgrade Koha.
>> because, with Koha 16.05 installed by packages method which uses MySql.
>> Now how to switch over to MariaDB from Mysql with the existing server.
>>
>> with thanks
>> Satish MV
>> Librarian, Govt. Engineering College, Hassan.
>> Karnataka.
>>
>>
>>
>>
>> On 16 December 2016 at 15:18, Tajoli Zeno  wrote:
>>
>> > Hi,
>> >
>> > Il 16/12/2016 10:29, anjoze ha scritto:
>> >
>> >> 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
>> >>
>> >
>> > i confim, if you use Ubuntu 16.04 MariaDB is a good choice.
>> >
>> > Bye
>> > Zeno Tajoli
>> >
>> >
>> > --
>> > Zeno Tajoli
>> > /SVILUPPO PRODOTTI CINECA/ - Automazione Biblioteche
>> > Email: z.taj...@cineca.it Fax: 051/6132198
>> > *CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)
>> >
>> > ___
>> > 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
>>
> --
> Tomás Cohen Arazi
> Theke Solutions (https://theke.io )
> ✆ +54 9351 3513384
> GPG: B2F3C15F
>



--
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migration erros from 16.05 to 16.11

2016-12-16 Thread Tomas Cohen Arazi

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 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 documentation and any help for upgrade of koha.
> I can only perform, the system upgrade from 12.04 to 14.04 or 16.0, but not
> sure, this will surely upgrade Koha.
> because, with Koha 16.05 installed by packages method which uses MySql.
> Now how to switch over to MariaDB from Mysql with the existing server.
>
> with thanks
> Satish MV
> Librarian, Govt. Engineering College, Hassan.
> Karnataka.
>
>
>
>
> On 16 December 2016 at 15:18, Tajoli Zeno  wrote:
>
> > Hi,
> >
> > Il 16/12/2016 10:29, anjoze ha scritto:
> >
> >> 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
> >>
> >
> > i confim, if you use Ubuntu 16.04 MariaDB is a good choice.
> >
> > Bye
> > Zeno Tajoli
> >
> >
> > --
> > Zeno Tajoli
> > /SVILUPPO PRODOTTI CINECA/ - Automazione Biblioteche
> > Email: z.taj...@cineca.it Fax: 051/6132198
> > *CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)
> >
> > ___
> > 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
>
-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migration erros from 16.05 to 16.11

2016-12-16 Thread SATISH

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 documentation and any help for upgrade of koha.
I can only perform, the system upgrade from 12.04 to 14.04 or 16.0, but not
sure, this will surely upgrade Koha.
because, with Koha 16.05 installed by packages method which uses MySql.
Now how to switch over to MariaDB from Mysql with the existing server.

with thanks
Satish MV
Librarian, Govt. Engineering College, Hassan.
Karnataka.

On 16 December 2016 at 15:18, Tajoli Zeno  wrote:

> Hi,
>
> Il 16/12/2016 10:29, anjoze ha scritto:
>
>> 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
>>
>
> i confim, if you use Ubuntu 16.04 MariaDB is a good choice.
>
> Bye
> Zeno Tajoli
>
>
> --
> Zeno Tajoli
> /SVILUPPO PRODOTTI CINECA/ - Automazione Biblioteche
> Email: z.taj...@cineca.it Fax: 051/6132198
> *CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)
>
> ___
> 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] Migration erros from 16.05 to 16.11

2016-12-16 Thread anjoze

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 in context: 
http://koha.1045719.n5.nabble.com/Migration-erros-from-16-05-to-16-11-tp5912344p5914362.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migration erros from 16.05 to 16.11

2016-12-16 Thread Zeno Tajoli

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: libgd-perl but it is not installable
   Depends: libpath-tiny-perl but it is not installable
   Depends: libsereal-decoder-perl but it is not installable
   Depends: libsereal-encoder-perl but it is not installable
>E: Unable to correct problems, you have held broken packages.

if fact those packages are not present in Ubuntu 12.04.
You can try to do the upgrade on a DIFFERENT server with Ubuntu 14.04 LTS ?

Please open a bug on bugzilla on this topic:
https://bugs.koha-community.org/bugzilla3/

Bye
Zeno Tajoli


___
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] Migration erros from 16.05 to 16.11

2016-12-15 Thread SATISH

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   |
+-+-+
| innodb_version  | 5.5.53  |
| protocol_version| 10|
| slave_type_conversions  | |
| version | 5.5.53-0ubuntu0.12.04.1 |
| version_comment | (Ubuntu)|
| version_compile_machine | i686|
| version_compile_os  | debian-linux-gnu|
+-+-

with following errors:

apt-get update and upgrade  are done.
--
root@shankara-Inspiron-N5010:/#

apt-get dist-upgrade

Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 koha-common : Depends: libarchive-extract-perl but it is not installable
   Depends: libgd-perl but it is not installable
   Depends: libpath-tiny-perl but it is not installable
   Depends: libsereal-decoder-perl but it is not installable
   Depends: libsereal-encoder-perl but it is not installable
E: Unable to correct problems, you have held broken packages.
root@shankara-Inspiron-N5010:/# apt-get dist-upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages have been kept back:
  koha-common
0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.

---
Can you please help me to upgrade  koha test system from 16.5 to 16. 11?

On 30 November 2016 at 22:51, Jonathan Druart <
jonathan.dru...@bugs.koha-community.org> wrote:

> 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:
>
> > 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:
> > http://koha.1045719.n5.nabble.com/Migration-erros-from-16-
> 05-to-16-11-tp5912344p5912444.html
> > Sent from the Koha-general mailing list archive at Nabble.com.
> > ___
> > 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
>

--
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migration erros from 16.05 to 16.11

2016-11-30 Thread Jonathan Druart

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:

> 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:
> http://koha.1045719.n5.nabble.com/Migration-erros-from-16-05-to-16-11-tp5912344p5912444.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> 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] Migration erros from 16.05 to 16.11

2016-11-30 Thread anjoze

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: 
http://koha.1045719.n5.nabble.com/Migration-erros-from-16-05-to-16-11-tp5912344p5912444.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migration erros from 16.05 to 16.11

2016-11-30 Thread Jonathan Druart

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 items_search_fields (
> name VARCHAR(255) NOT NULL,
> label VARCHAR(255) NOT NULL,
> tagfield CHAR(3) NOT NULL,
> tagsubfield CHAR(1) NULL DEFAULT NULL,
> authorised_values_category VARCHAR(32) NULL DEFAULT NULL,
> PRIMARY KEY(name),
> CONSTRAINT items_search_fields_authorised_values_category
> FOREIGN KEY (authorised_values_category) REFERENCES
> authorised_value_categories (category_name)
> ON DELETE SET NULL ON UPDATE CASCADE)
> ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>
> Then checked if was created: select * from information_schema.columns where
> table_name='items_search_fields';
> Everything ok.
>
> Then executed: koha-upgrade-schema
> It looks that nothing happened...
> Do I have to make something else?
> Thanks
>
>
>
> -
> Koha version:   16.05.05
>- -
> José Anjos
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/Migration-erros-from-16-05-to-16-11-tp5912344p5912431.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> 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] Migration erros from 16.05 to 16.11

2016-11-30 Thread anjoze

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,
authorised_values_category VARCHAR(32) NULL DEFAULT NULL,
PRIMARY KEY(name),
CONSTRAINT items_search_fields_authorised_values_category
FOREIGN KEY (authorised_values_category) REFERENCES
authorised_value_categories (category_name)
ON DELETE SET NULL ON UPDATE CASCADE)
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Then checked if was created: select * from information_schema.columns where
table_name='items_search_fields';
Everything ok.

Then executed: koha-upgrade-schema
It looks that nothing happened...
Do I have to make something else?
Thanks 



-
Koha version:   16.05.05
   - -
José Anjos
--
View this message in context: 
http://koha.1045719.n5.nabble.com/Migration-erros-from-16-05-to-16-11-tp5912344p5912431.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migration erros from 16.05 to 16.11

2016-11-30 Thread Michael Kuhn


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 'updated_on' [for 
Statement "

ALTER TABLE borrowers
ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP
AFTER privacy_guarantor_checkouts;
"] at 
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl 
line 12626.
DBD::mysql::db do failed: Duplicate column name 'updated_on' [for 
Statement "

ALTER TABLE deletedborrowers
ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP
AFTER privacy_guarantor_checkouts;
"] at 
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl 
line 12632.

Upgrade to 16.06.00.002 done (Bug 10459 - borrowers should have a timestamp)


For the case of José Anjos you wrote:

Am 30.11.2016 um 12:29 schrieb Jonathan Druart:

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.



Is there something else to do in my case?

As I understand José Anjos would have to do the following. Is this correct?

1. Restore the old Koha 16.05.05 database using "koha-restore"

2. Execute "CREATE TABLE IF NOT EXISTS items_search_fields [...]" in the 
database. What is the complete SQL command?


3. Execute "sudo apt-get install koha-common" again.


Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migration erros from 16.05 to 16.11

2016-11-30 Thread Jonathan Druart

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:

> Just to leave some feedback.
>
> *Migration from*
> Koha 16.05
> OS: Ubuntu 16.04 64bits
> Mysql 5.7 with:
>
> sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
>
> *To:*
> Koha 16.11
> OS Ubuntu 16.04 64bits
> MariaDB
>
> First I've tried to upgrade on the same machine and had tons of problems
> maybe because Mysql 5.7
> Then on a new VM machine with MariaDB I've imported the sql backup and had
> this erros:
>
> DBD::mysql::db do failed: Table 'koha_koha.items_search_fields' doesn't
> exist [for Statement "
> ALTER TABLE items_search_fields
> DROP FOREIGN KEY items_search_fields_authorised_values_category;
> "] at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line
> 13152.
> DBD::mysql::db do failed: Table 'koha_koha.items_search_fields' doesn't
> exist [for Statement "
> ALTER TABLE items_search_fields
> ADD CONSTRAINT `items_search_fields_authorised_values_category` FOREIGN
> KEY (`authorised_values_category`) REFERENCES `authorised_value_categories`
> (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE;
> "] at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line
> 13157.
>
> Until now everything look ok...
>
>
>
> -
> Koha version:   16.05.05
>- -
> José Anjos
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/Migration-erros-from-16-05-to-16-11-tp5912344.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> 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] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

Re: [Koha] Migration erros from 16.05 to 16.11

16 matches

Site Navigation

Mail list logo

Footer information