[Koha-bugs] [Bug 4323] Web Installer fails with table already exists and loops on step 3

[bugzilla-daemon at kohaorg.ec2.liblime.com]

http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4323





--- Comment #4 from Koustubha Kale <kmkale at 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.