Error creating "default" data during fresh install
Hi all, I've installed a fresh Koha instance using the "oldstable" packages on Ubuntu 16.04 and MySQL. I've followed the process at https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Add_A_Koha_Co mmunity_Repository and the install goes fine until after I login to the web interface and try to create "default" data. The DB itself gets created successfully and says I have the permissions needed, but then fails with the following error when I try to create default/sample item types, patron categories, etc. (I just left the default choices selected): DBIx::Class::Storage::DBI::_dbh_execute(): Data truncated for column 'type' at row 1 at /usr/share/koha/lib/Koha/Objects.pm line 101 Anyone know what might be causing this and how to recover/move on? Thanks! Steve
Hi Steve,
I've installed a fresh Koha instance using the "oldstable" packages on Ubuntu 16.04 and MySQL.
Anyone know what might be causing this and how to recover/move on?
The real problem is your version of Mysql (5.7). Koha doesn't work with it. You can do this: 1)Drop the database created by install 2)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-... 3)Recreate the database (same user, same password, same database name) 4)Redo web install. I suggest you to do those operations with your IT support. 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
participants (2)
-
Steve Nickerson -
Zeno Tajoli