[phiscribe]

Anyone have an upgrade procedure to go from the Fantastico installed Drugal 6.2 to the latest 6.4?

When I try to upgrade it wrecks my installation.

When I try to manually install, I can never get past the database configuration. Purposely entering incorrect information produces errors, but entering the correct data loops the install back to the same screen infinitely.

Thanks

[webservant]

i tried myself the manual install of drupal 6 versions and i succeed. just make sure you put the correct info on MySQL Database, MySQL User, Password and the MySQL Host on advance settings. good luck

i personally use drupal 5 version simply because not all modules that i need are ready for DP6.

[phiscribe]

When Fantastico creates the installation, it gives you an option to add a default admin user to Drupal. I don't see how to do this when you manually install. Maybe it is later in the installation.

When I try manual, I'm using the same name for database and user (both prefixed with my account id, and the password I give it when I use Control Panel to make the database. I'm giving it the host name given CP reports back to me.

Stumped.

[webservant]

When Fantastico creates the installation, it gives you an option to add a default admin user to Drupal. I don't see how to do this when you manually install. Maybe it is later in the installation.

yes your right. using fantastico you are only asked to give your "admin account" info for your drupal. the database configuration is automatically made/manage by the fantastico installer itself.

however if install drupal manually, you configure your database first during the installation process by putting the right information about your mysql account that you "manually" made in the CP. when installation process succeed your new drupal site will now then be ready for you in making your "admin account" (first account of your drupal site).

i'm not a pro on this, but i hope to be of help in any way i can.

[Bad Karma[CORE]]

probably worth looking at this here:
http://badkarma.dotlayer.com/2008/08...ll-drupal-cms/

[phiscribe]

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:xxxxxxxxxxx@mysql3.000webhost.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:

An error occurred. http://sgeo.net84.net/update.php?id=4&op=do { "status": true, "percentage": 100, "message": "Remaining 0 of 0.\x3cbr/\x3e\x26nbsp" } <!-- www.000webhost.com Analytics Code --> <script type="text/javascript"> var websiteID='sgeo.net84.net'; </script> <script type="text/javascript" src="http://analytics.hosting24.com/s.php"></script> <noscript> <a href="http://www.hosting24.com/"><img src="http://analytics.hosting24.com/s.php?websiteID=sgeo.net84.net" alt="web hosting" /></a> </noscript> <!-- End Of Code -->

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, cpbackup@gmail.com 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.

[Bad Karma[CORE]]

just out of curiosity:
What happens if you delete the .htaccess file from the Drupal directory and then retry a clean install or upgrade ?

[phiscribe]

Ok, I removed the .htaccess file and tired a fresh install, same results.

I tired again, but this time after the first "loop" back to Database Configuration, I put the .htaccess file back in place. The install then went further, with some errors. I was so suprised to see something diffrent happen I forgot to copy the errors which may have been just warnings. I can now access the admin area and it reports 6.4.

When I look at the settings.php I think I see what was causing the problem.

Old Values: $db_url = 'mysql://---(more stuff)
New Values: $db_url = 'mysqli://---(more stuff)

Post Drupal 6.2 must be using mysqli not mysql. Or perhaps the Fantastico installer points to a diffrent database server with diffrent settings, (I'm fuzzy on this.)

No where in the install process do I see a way to specify mysqli instead of mysql.

However, the database is no longer blank, now having tables and structure. Somehow, adding the .htaccess back during the middle the install triggered something elese that allowed the install to continue, at least that's my theory.

So it now has a database and is functioning,

Thanks for the suggestion that lead me to find what seems to be a solution and gain the knowledge about the mysqli verses mysql requirements.

Now onward to phpBB, phpbbforum, and figuring out how translations work.

[quasihellfish]

@phiscribe

I'm was also having 500 errors problems when trying to upgrade from 6.2 to 6.4. Initially, I also had the same error that you were receiving during the update. If you look through the error garbage, you'll notice references to the Analytics code that 000webhost has been automatically adding to everyone's web pages. This creates the initial error during the Drupal upgrade. You can read the announcement how to disable it here:
Disabling analytics code

So, I disabled the analytics code, and no longer received the error during the update. That being said, I was still get the same 500 error after upgrading. The only way I fixed it was to upload my old .htaccess file from my backup. I really don't know the technical reason why this works, or if there are any repercussions from this, but that was the suggestion from someone on the Drupal forums, and it worked for me.
http://drupal.org/node/300450