[Bug 4323] New: Web Installer fails with table already exists and loops on step 3
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4323 Summary: Web Installer fails with table already exists and loops on step 3 Product: Koha Version: HEAD Platform: PC OS/Version: All Status: NEW Severity: blocker Priority: P5 Component: Installation and upgrade (web-based installer) AssignedTo: henridamien@koha-fr.org ReportedBy: kmkale@anantcorp.com Estimated Hours: 0.0 Change sponsored?: --- Web Installer fails due to some missing "drop if exists.." ststements in kohastructure.sql. Also web installer loops in step 3 due to mysql "SHOW TABLES FROM " . $info{'dbname'}" Patch attached.. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4323 --- Comment #1 from Koustubha Kale <kmkale@anantcorp.com> 2010-03-19 07:41:12 --- Created an attachment (id=1748) --> (http://bugs.koha.org/cgi-bin/bugzilla3/attachment.cgi?id=1748) Patch -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4323 --- Comment #2 from Koustubha Kale <kmkale@anantcorp.com> 2010-03-19 08:16:29 --- Created an attachment (id=1749) --> (http://bugs.koha.org/cgi-bin/bugzilla3/attachment.cgi?id=1749) Patch 1 -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4323 Galen Charlton <gmcharlt@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |gmcharlt@gmail.com --- Comment #3 from Galen Charlton <gmcharlt@gmail.com> 2010-04-30 12:32:01 --- Please describe your circumstances in more detail - kohastructure.sql is to be used when installing to an *empty* database, and 'drop if exists' is unnecessary. If you were upgrading from 2.2 or the like, please list the steps you took. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4323 --- Comment #4 from Koustubha Kale <kmkale@anantcorp.com> 2010-05-01 06:18:47 --- (In reply to comment #3)
Please describe your circumstances in more detail - kohastructure.sql is to be used when installing to an *empty* database, and 'drop if exists' is unnecessary. If you were upgrading from 2.2 or the like, please list the steps you took.
I was doing a fresh "Standard" install from sources downloaded with git. I saw 'drop if exists' statements present for most of the tables but were missing for a few, on which the web installer was failing. Adding the statements resolved the problem. The second problem web installer loops in step 3 due to mysql "SHOW TABLES FROM " . $info{'dbname'}" led to the - if ( $info{dbms} eq 'mysql' ) { $rq = $dbh->prepare( "SHOW TABLES FROM " . $info{'dbname'} ); } + if ( $info{dbms} eq 'mysql' ) { $rq = $dbh->prepare( "SHOW TABLES" ); } which resolved the issue. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4323 Galen Charlton <gmcharlt@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED --- Comment #5 from Galen Charlton <gmcharlt@gmail.com> 2010-05-05 14:12:29 --- I've pushed the patches. Please test and close, although I note that it seems likely to me that you had been trying to do the install into a previously installed mysql database. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4323 Koustubha Kale <kmkale@anantcorp.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠kohaorg.ec2.liblime.com