Hi Liz That fixed bug 14952 and it works on a small test case I built using the default data. There were a number of differences in my database structure from the fresh created one, so I wrote a little perl program to fix them. My 'permissions' and 'userflags' tables had some differences in content which I changed. However, I'm still having the original problem of the people on the circulation desk being logged out when trying to check an item out. The item is checked out! Also if they look at the current books checked out, it comes up with a message saying "Loading. You may continue scanning" and never finds the items checked out. Any suggestions? On 10/06/2015 04:44 PM, Liz Rea wrote:
Hi Bob,
It's totally that "STRICT_TRANS_TABLES" that's doing this. I just tested on my MariaDB (same v. as yours) with that and I get the errors too now.
Cheers, Liz
On 07/10/15 02:06, Bob Ewart wrote:
Thanks Liz and Katrin
I'm beginning to think that it may be a problem with mariadb or something else that was updated recently.
I'm currently running openSUSE 13.2 with mariadb 10.0.21 with Koha 3.18.10 built from a tar ball.
I tried to setup 3.18.11 and selected "install all optional data" in the web installer for a test case. This generated two errors (see bug 14952 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14952> ) This was working when I created a test database on 3.18.09 last month for my Donor Tracking plugin. It's now failing even on 3.18.08.
I know there was a problem with changes made to mysql's STRICT_TRANS_TABLES variable reported in bug 13523 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13523> in January and am wondering if there are any other recent changes.
I'm setting up a couple of fresh installs of openSUSE 13.2 and will try to reproduce the problem.
I am also going to check my current database structure with the fresh installs. Our database was created somewhere around Koha 3.0 and has been upgraded skipping a few releases. It may be that some changes to the structure or system variables have not be made.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha