By magependragon on
I tried to install Drupal for the first time yesterday as a friend recommended it to me but seem to have come unglued somehow. The install script runs fine and the db installs perfectly however when I click the link that should bring up the infamous "Create first user screen" all I get is an access denied screen with the following extra warnings:
warning: array_keys(): The first argument should be an array in D:\http\home\drupal-5.2\modules\user\user.module on line 368.
warning: implode(): Bad arguments. in D:\http\home\drupal-5.2\modules\user\user.module on line 368.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in D:\http\home\drupal-5.2\includes\database.mysql.inc on line 172.
warning: array_keys(): The first argument should be an array in D:\http\home\drupal-5.2\modules\block\block.module on line 644.
warning: implode(): Bad arguments. in D:\http\home\drupal-5.2\modules\block\block.module on line 644.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module' at li query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN () OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in D:\http\home\drupal-5.2\includes\database.mysql.inc on line 172.
I have done some debugging and found that this is happening because there is no UID 1.
The link I access on is http://home.saol.com/drupal-5.2/
Set up:
Druapl 5.2
IIS 6
Win Server 2003
MYSQL 4.1.12
I have searched high and low and hope that someone has an answer for me here as I haven't found one yet.
For clarity: I get these warnings BEFORE I have the option to create the first account.
Comments
Any ideas here?
Any ideas here?
Weird...
Well, it let me create a user (unfortunately, turned out to be your first user...). Still won't let me actually logon or anything.
Still looking into it...
Personal: justinstanley.net
Nerdly: nerdliness.com
So you managed to get past
So you managed to get past the screen with all the errors?
And of course that would be the first user as I hadn't managed to get past the errors to actually create a user.
I am still just getting the error page when I try the site.
using IE7 and the php is 4.4.?
I tried from home and also just got the error page - how did you bypass it? I can see the two users you created on the db though.
?q=user
I browsed directly to /?q=user on your machine. The errors still appeared, but it apparently allowed me to create the accounts. Still can't actually log on with either, though.
Not sure why that rid info is missing in the SQL query and causing things to error out...
Personal: justinstanley.net
Nerdly: nerdliness.com
Also...
You've got some PHP/Mail issues to fix:
warning: mail(): "sendmail_from" not set in php.ini or custom "From:" header missing in D:\http\home\drupal-5.2\includes\common.inc on line 1979.
Personal: justinstanley.net
Nerdly: nerdliness.com
...
It may be that you got a bad download or something. here are some old instructions I used to use on IIS sites.
You may want to wipe the site and download Drupal 5.2 from scratch. I don't currently have any IIS servers up that I can test on though.
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide