By wonder95 on

I am trying to get Drupal set up on two different local machines, and I think I'm running into every possible install issue. I've been searching through the forums and trying everything I can find, all to no avail.

Here's the setup:

Apache 2.2.4
PHP 5.2.1
MySQL 4.1.22
Drupal 5.1

First, no matter what I do, I still get the list of notices:

Notice: Trying to get property of non-object in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\directory\includes\form.inc on line 325

Notice: Undefined variable: redirect in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\directory\includes\form.inc on line 268

Notice: Undefined variable: base in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\directory\includes\form.inc on line 461

Notice: Undefined index: #value in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\directory\includes\form.inc on line 1041

Notice: Undefined index: #value in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\directory\includes\form.inc on line 1041

Notice: Undefined variable: no_module_preprocess in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\directory\includes\common.inc on line 1467

Notice: Undefined variable: no_theme_preprocess in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\directory\includes\common.inc on line 1488

I have set error_reporting to E_ALL & ~E_NOTICE, but to no avail. I have granted LOCK TABLE access to my user. I have created an empty database, and set up a user and password. However, whenever I try to run the install script, I get the following error:

We were unable to lock a test table on your MySQL database server. We tried locking a table with the command LOCK TABLES drupal_install_test WRITE and MySQL reported the following error: Access denied for user 'username@'localhost' to database 'database_name'.

I have double and triple checked that the user name and password are correct. For what it's worth, on one of the machines, I have a Drupal site running perfectly that uses 4.7.something, and it's using the same database user name and password. I got a second site running locally by installing it using Fantastico on my server (yeah, i know that's bad, but I didn't see that post until after I did it) and then copying everything down to my machine, including a database backup.

Any help would be appreciated before I pull out what is left of my hair. This new and "improved" install method isn't working at all for me.

Thanks.

Wonder95

⋅ Categories: Drupal 5.x

Comments

snvssk’s picture

snvssk commented

hey!!! u have created an empty DB, thats ok! but you need to grant all privileges to that database with a username through which u will be using the database in developing the site. then don't forget to flush privileges. ok!!

heres the command:

grant all privileges on databasename.* to username@hostname identified by 'password';

Note: type the password in single quotes.

and then:

flush privileges;

try this u'll definitely be able to run install script ok!!!

shishir12’s picture

shishir12 commented

that was real nice

picchodu

wonder95’s picture

wonder95 commented

I had actually done that (or at least I thought I had) through the GUI MySQL front end I was using. However, it turned out that the front end didn't handle all of the privileges needed. I went in manually using the command line and added the privileges, and everything worked fine.

Thanks.

Wonder95