Installation Error | Sponsored by Endeavor Systems, Inc.

Fri, 2009-04-24 20:23

#1

jford

Offline

Joined: 2009-04-24

Posts: 10

RE: Installation Error

Larry,

We need a little more information about your situation such as what operating system you are using and what version of OpenFISMA.

"'Larry' pid='1' dateline='1240582869'" wrote:

I get this error during the database creation step:

Mysqli statement execute error : Table 'account_logs' already exists

But when I check the database, the table was created. It is like it is trying to create the table twice.

Any ideas?

Sat, 2009-04-25 06:21

#2

openfisma

Offline

Joined: 2009-08-12

Posts: 8

RE: Installation Error

I am running Apache on Windows 2003 Server. I have the latest version of OpenFISMA, 2.3.

"'jford' pid='2' dateline='1240622591'" wrote:

Larry,

We need a little more information about your situation such as what operating system you are using and what version of OpenFISMA.

"'Larry' pid='1' dateline='1240582869'" wrote:

I get this error during the database creation step:

Mysqli statement execute error : Table 'account_logs' already exists

But when I check the database, the table was created. It is like it is trying to create the table twice.

Any ideas?

Sat, 2009-04-25 11:53

#3

jford

Offline

Joined: 2009-04-24

Posts: 10

RE: Installation Error

Are you running any type of lamp package such as WAMP or XAMPP or have you installed the stand alone version of apache and mysql?

"'Larry' pid='3' dateline='1240658513'" wrote:

I am running Apache on Windows 2003 Server. I have the latest version of OpenFISMA, 2.3.

"'jford' pid='2' dateline='1240622591'" wrote:

Larry,

We need a little more information about your situation such as what operating system you are using and what version of OpenFISMA.

"'Larry' pid='1' dateline='1240582869'" wrote:

I get this error during the database creation step:

Mysqli statement execute error : Table 'account_logs' already exists

But when I check the database, the table was created. It is like it is trying to create the table twice.

Any ideas?

Sat, 2009-04-25 13:35

#4

openfisma

Offline

Joined: 2009-08-12

Posts: 8

RE: Installation Error

Standalone versions of Apache, PHP, MySQL. It seems like an issue with the SQL import because the table gets created, and then the installer seems to try to create the table a second time, hence the error.

Mon, 2009-04-27 21:55

#5

jford

Offline

Joined: 2009-04-24

Posts: 10

RE: Installation Error

This seems to be a bug that only effects versions installed on windows, we will have a technician try to reproduce on Windows.

"'Larry' pid='5' dateline='1240684527'" wrote:

Standalone versions of Apache, PHP, MySQL. It seems like an issue with the SQL import because the table gets created, and then the installer seems to try to create the table a second time, hence the error.

Tue, 2009-04-28 07:09

#6

openfisma

Offline

Joined: 2009-08-12

Posts: 8

RE: Installation Error

Great, thanks for looking into it.

Does the application require Perl? I see *.pl files but Perl isn't listed as a requirement.

Mon, 2009-05-04 13:32

#7

mruss

Offline

Joined: 2009-05-04

Posts: 3

RE: Installation Error

I had the same issue trying to install on Xampp on Windows XP. I worked around it by manually running the database install script ([openfisma-dir]\application\config\db\base.sql).

Then I edited [openfisma-dir]\application\controllers\InstallController.php so it wouldn't attempt to run the db script, by commenting out lines 248 and 250:

#if ($ret = $this->importSql($db, $initFiles)) {
$checklist['schema'] = 'ok';
#}

so, this unconditionally sets $checklist['schema'] to OK. That's an ugly workaround, but it should at least get you through the install.

OpenFISMA's a neat piece of software!

Mon, 2009-05-04 13:51

#8

openfisma

Offline

Joined: 2009-08-12

Posts: 8

RE: Installation Error

"'mruss' pid='10' dateline='1241461931'" wrote:

I had the same issue trying to install on Xampp on Windows XP. I worked around it by manually running the database install script ([openfisma-dir]\application\config\db\base.sql).

Then I edited [openfisma-dir]\application\controllers\InstallController.php so it wouldn't attempt to run the db script, by commenting out lines 248 and 250:

#if ($ret = $this->importSql($db, $initFiles)) {
$checklist['schema'] = 'ok';
#}

so, this unconditionally sets $checklist['schema'] to OK. That's an ugly workaround, but it should at least get you through the install.

OpenFISMA's a neat piece of software!

That did it! Thank you!

One note though, I had to disable strict mode in MySQL to get it to import the tables properly.