installation failed without creating database - please help

[roesti]

Hi all,

 

I am new to osCommerce and hardly a wiz with PHP.

 

I am trying to evaluate osCommerce for a potential client. I am trying to install it locally, but it has consistently failed and I need some help to get started. It's a frustrating point to be stuck at.

 

My test system is MacOS 10.6.2, with existing Apache 2.2.13, existing PHP 5.3.0, and a freshly-installed MySQL 5.1.39. I have a small test script that verifies that I can connect to MySQL with PHP just fine.

 

I downloaded osCommerce 2.2 RC2a and installed it in my home directory (~/Sites/.../catalog). The install script seems to work until the Finished page, which has an error message embedded in the top:

 

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in [...]/catalog/install/includes/functions/database.php on line 39

 

My guess is that the function is actually getting a null, but I'm not sure. The net result is that the database is not created. I have tried redoing the installation procedure with the database already created, but the database is not populated (SHOW TABLES returns the empty set).

 

I am still presented with the options of opening the Catalog or the Administration Tool. Clicking either of these buttons returns the following error message ("shopping" is the name of the database in MySQL):

 

1146 - Table 'shopping.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

I have tried to run the installation with "root" as the MySQL user, but with the same result.

 

Does anyone have any ideas what might be preventing the database from being created? I'd be happy to provide any other information that might help to troubleshoot the problem.

 

Thanks in advance,

 

Aaron

[Guest]

Aaron,

 

 

Did you create a blank database using myphpadmin BEFORE trying to run the install ? The install only verifies and imports data into the blank database, but the database needs to be created first.

 

Chris