MySQL Error on 2.2.9 Install
Someone on the list recently asked me if I had any install errors with Version 2.2.9 - ?? I hope it's allright to post it here? (Ubuntu Feisty Apache2 and MySql 5.0 server) My question would be, what does this mean. How corrupt are my database tables? Is there anything that I need to do to stabilise the system? CREATING DATABASE Creating the MySQL database for Koha... DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid' at scripts/updater/updatedatabase line 1717. DBD::mysql::st execute failed: Invalid default value for 'id' at scripts/updater/updatedatabase line 1717. synch'ing borrowers creating column textmessaging creating column password creating column flags creating column userid creating column homezipcode creating column zipcode creating column sort1 creating column sort2 synch'ing items creating column itemcallnumber synch'ing biblio synch'ing biblioitems creating column place
Bo Schafers wrote:
Someone on the list recently asked me if I had any install errors with Version 2.2.9 - ?? I hope it's allright to post it here?
DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid' at scripts/updater/updatedatabase line 1717. DBD::mysql::st execute failed: Invalid default value for 'id' at scripts/updater/updatedatabase line 1717.
I have installed Koha 2.2.7 through 2.2.9 and that error always occurs. I think you can assume it is "mostly harmless" (see Hitchhikers Guide to the Galaxy for that reference!) cheers rickw -- _________________________________ Rick Welykochy || Praxis Services We should invade their countries, kill their leaders and convert them to Christianity. -- Anne Coulter of the "American Taliban"
Hi Rick, Bo, ----- "Rick Welykochy" <rick@praxis.com.au> wrote:
Bo Schafers wrote:
Someone on the list recently asked me if I had any install errors with Version 2.2.9 - ?? I hope it's allright to post it here? DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid' at scripts/updater/updatedatabase line 1717. DBD::mysql::st execute failed: Invalid default value for 'id' at scripts/updater/updatedatabase line 1717.
I have installed Koha 2.2.7 through 2.2.9 and that error always occurs. I think you can assume it is "mostly harmless" (see Hitchhikers Guide to the Galaxy for that reference!) Yep, 'mostly harmless', but it would be good to remove those errors to avoid confusion. Are those the only errors or are there more?
Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
participants (3)
-
Bo Schafers -
Joshua M. Ferraro -
Rick Welykochy