[Koha] Upgrading Koha from 3.06 to 3.14

Dibyendra Hyoju dibyendra at gmail.com
Mon Mar 31 12:41:15 NZDT 2014


Thanks Chris and all! I dropped all the database tables and imported
the earlier 3.06 database and performed import and upgrade command and
it worked perfectly!

Regards,
Dibyendra

On 3/30/14, Chris Cormack <chris at bigballofwax.co.nz> wrote:
> On 30 March 2014 23:00, Dibyendra Hyoju <dibyendra at gmail.com> wrote:
>
>> Thank Robin and all for your response.
>>
>> I tried the way Robin suggested and it worked, however I got the
>> following error while issuing the koha-mysql  instancename < sqlfile
>> command:
>>
>> ERROR 1005 (HY000) at line 2752: Can't create table
>> 'koha_library.letter' (errno: 150)
>>
>> Also, I couldn't find the saved Koha reports after importing the
>> earlier Koha database. It is not a big issue as I can manually create
>> reports from the SQL.But I am wondering, why the saved reports were
>> not imported even after issuing koha-upgrade-schema command.
>>
>> Apart from these issue, I found catalogues, holdings info and patron
>> information imported correctly. I quickly checked the circulation info
>> and I think it has also been imported.
>>
>> You will have other hidden issues, it will have stopped at the letter
> table and not created tables after that (including the reports which you
> have noticed). You will to search what an error 150 is, and then try your
> import again fixing whatever you need to get the letter table to be
> created.
>
> Chris
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
Dibyendra Hyoju


More information about the Koha mailing list