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 <ch...@bigballofwax.co.nz> wrote: > On 30 March 2014 23:00, Dibyendra Hyoju <dibyen...@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@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Dibyendra Hyoju _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha