[Koha] Fw: Re: Fw: Fwd: Re: Fw: Koha creating budget error

[Katrin Fischer]

Hi Asim,

did you notice the part about disabling strict mode with your version? 
This applies to both current versions of MySQL and MariaDB:

If using > MariaDB 10.2.3 you will need to look into disabling the 
strict mode <https://mariadb.com/kb/en/library/sql-mode/#strict-mode>. 
Related bug 17258 
<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258>

Katrin
On 21.03.2018 15:17, Asim Ullah wrote:
> I have also try koha 17.11.03 version with mysql, but i have got the problem of not creating the staff patron in it, then i have use koha with mariadb but unfortunately it has the problem of not adding the new budget.
>
>     ----- Forwarded Message ----- From: Katrin Fischer <katrin.fischer.83 at web.de>To: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>Sent: Wednesday, March 21, 2018, 11:37:45 AM GMT+5Subject: Re: [Koha] Fw: Fwd: Re: Fw: Koha creating budget error
>   Hi Asim,
>
> I have tested adding bugets on 17.11.03, but it worked without any
> problems for me. I am using MySQL, which might or might not make a
> difference.
>
> The wiki recommends disabling the strict mode with your MariaDB version,
> maybe this will help:
>
> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7
>
> Katrin
>
>
> On 20.03.2018 11:35, Asim Ullah wrote:
>
>> Subject:     Re: [Koha] Fw: Koha creating budget error
>> Date:     Tue, 20 Mar 2018 06:46:02 +0000 (UTC)
>> From:     Asim Ullah <asimullah at ymail.com>
>> To:     Katrin Fischer <katrin.fischer.83 at web.de>
>>
>>
>>
>> i am using
>> Koha version: 17.11.03.000
>> perl version: 5.026000
>> apache version server version: 2.5.27
>> MySQL version: mysql Ver 15.1 Distrib 10.2.13-MariaDB
>>
>>
>> On Monday, March 19, 2018, 11:36:41 AM GMT+5, Katrin Fischer
>> <katrin.fischer.83 at web.de> wrote:
>>
>>
>> Hi Asim,
>>
>> which is your exact version of Koha? You can find this information on
>> the About page.
>>
>> Katrin
>>
>>
>> On 19.03.2018 03:40, Asim Ullah wrote:
>>    > Hello!
>>    >                    i am using mariabd, while creating budget in koha
>> the browser give me this message
>> DBIx::Class::Storage::DBI::_dbh_execute(): Incorrect integer value: ''
>> for column 'budget_period_id' at row 1 at
>> /usr/share/koha/lib/C4/Budgets.pm line 137
>>    > How to fix this issue? please help. thank you in advance.
>>
>>    >
>>    >
>>    >
>>    > _______________________________________________
>>    > Koha mailing list http://koha-community.org
>>    > Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>>    > https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>> _______________________________________________
>> Koha mailing list http://koha-community.org
>> Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>      
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>    
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha