database error after install, problem caused by catalog\install\includes\functions\database.php on line 39

[xanadu1984]

I`ve spent literally hours and hours trying to get to the bottom of this, trawling through forums etc. During installation, it says database imported fine, but then produces this error after the install and the database still has no tables! Seems like the sql query threw up an error:

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

 

in catalog\install\includes\functions\database.php on line 39

 

and while trying to go to admin:

 

1046 - No database selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

Now, someone said this was to do with the version of php, and they are different on our db server and on our web server, as it happens. The web server is on 5, apparently Somebody said you need to have php_value register_long_arrays=1 included in the .htaccess file, presumably the one closest to the includes folder, but it still doesn`t seem to work, returning the same error.

 

Any ideas?

 

Going quietly insane here :-(

[♥geoffreywalton]

Have you checked the db credentials in your configuration files are correct?

 

/admin/includes/configure.php

/includes/configure.php

[Guest]

This may help you figure it out:

 

http://www.oscommerce.com/forums/index.php?sho...186&hl=1046

 

Chelle

[Guest]

It is assumed that you created the database in mysql before you started the installation.