Ok, I see that other people have this working with version 6.x above 6.2. But I still need some magic here.
I can get 6.2 to work with the Fantastico install.
The settings.php shows:
$db_url = 'mysql://xxxxxxxx_xxxxxxx:email@example.com/xxxxxxxx_xxxxxxx'; (x's being values ive hidden here but correct in the file)
$db_prefix = 'drup_';
When I try to update to 6.4, by putting in all the 6.4 files into the public_html directory, with a settings.php (777 permissions) with the right data and running the update.php to update the database, this occurs:
Then the admin page will not open with this:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, firstname.lastname@example.org and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.
When I try to just manually install 6.4 (or 6.3) with a blank database, I enter the correct db name, password, host, port, and prefix (checked over twenty times) at the Database Configuration section of install.php it loops back, re-prompting me for db name, user, password, host, port, and prefix.
This is an important clue.
The looping back to re-promt me for db info ONLY occurs with the correct values, (I've check and checked and checked...they are correct.)
If I intentionally enter a bad db name or db user or db password, the install.php reports an error!
So I get diffrent
behavior with correct values than incorrect values, leading me to believe something else is wrong other than a user that doesn't know which end of a keyboard to type or paste in db names, users and passwords.
System logs don't work in Drupal. I'm assuming this is a webhost.com setting for security. When I try to enable logs in 6.2 it tells me logs are disabled for security reasons.
This is a free account.
Are you people out there that have this working using paid accounts?
If so maybe your database user has been Granted privileges to create tables and modify the database that a free user does not have.
This smells like a database permissions problem as the update.php would need to modify the database in cases of upgrade and the install.php would need to modify the database in cases of fresh install.
Does anyone know what the permissions for a free account are for the database user?
PS: I was trying Drupal because I was encountering problems with upgrading Joomla to latest release and didn't want to commit to a contact management system that would have such issues. On thinking back, database permissions could have also been my problem there.