Hello,
I tried installing Drupal 6.8 in a Windows box. It is not a server, It is a PC. In the last step of the installation I get the following error message -
warning: array_fill() [function.array-fill]: Number of elements must be positive in D:\Work_Sector\Apache2.2\htdocs\drupal\includes\database.inc on line 241.
warning: implode() [function.implode]: Invalid arguments passed in D:\Work_Sector\Apache2.2\htdocs\drupal\includes\database.inc on line 241.
warning: array_keys() [function.array-keys]: The first argument should be an array in D:\Work_Sector\Apache2.2\htdocs\drupal\modules\user\user.module on line 500.
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 p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in D:\Work_Sector\Apache2.2\htdocs\drupal\modules\user\user.module on line 500.
warning: mail() [function.mail]: SMTP server response: 550 5.7.1 Unable to relay for ksivasenthil@gmail.com in D:\Work_Sector\Apache2.2\htdocs\drupal\includes\mail.inc on line 193.
Unable to send e-mail. Please contact the site admin, if the problem persists.
But at the bottom it also displays the message -
"Congratulations, Drupal has been successfully installed."
However, when I try accessing the home page of the fresh installation, I get the following error message -
Access denied
warning: array_fill() [function.array-fill]: Number of elements must be positive in D:\Work_Sector\Apache2.2\htdocs\drupal\includes\database.inc on line 241.
warning: implode() [function.implode]: Invalid arguments passed in D:\Work_Sector\Apache2.2\htdocs\drupal\includes\database.inc on line 241.
warning: array_keys() [function.array-keys]: The first argument should be an array in D:\Work_Sector\Apache2.2\htdocs\drupal\modules\user\user.module on line 500.
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 p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in D:\Work_Sector\Apache2.2\htdocs\drupal\modules\user\user.module on line 500.
warning: array_keys() [function.array-keys]: The first argument should be an array in D:\Work_Sector\Apache2.2\htdocs\drupal\modules\block\block.module on line 406.
warning: array_fill() [function.array-fill]: Number of elements must be positive in D:\Work_Sector\Apache2.2\htdocs\drupal\includes\database.inc on line 241.
warning: implode() [function.implode]: Invalid arguments passed in D:\Work_Sector\Apache2.2\htdocs\drupal\includes\database.inc on line 241.
warning: array_merge() [function.array-merge]: Argument #2 is not an array in D:\Work_Sector\Apache2.2\htdocs\drupal\modules\block\block.module on line 407.
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 line 1 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 = '' AND b.status = 1 AND (r.rid IN () OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in D:\Work_Sector\Apache2.2\htdocs\drupal\modules\block\block.module on line 407.
You are not authorized to access this page.
I do acknowledge that since this is a local PC, the SMTP server is not configured properly and it is the default SMTP server of IIS 5.
Should that be the problem for all??
However, I noticed in both last step of installation and post installation the last SQL query has no elements in the "IN ()". In MySQL that is the reason of the problem.
Can somebody please help in figuring out how to overcome this??
Anxiously waiting for help!!!
Comments
Could be many things
You're vague about your environment, as one can arbitrarily run a server off a PC.
You might get a better answer if you provide such important details as:
Just curious, are you running WAMP? My guess is its apache-server related-permissions issues, not being able to access those functions or read those files?
Details of the environment
Forgive for the vaguness, Here are the details -
Windows XP Pro with SP3
MySQL version is 5.0.51b-community-nt
Apache is 2.2.8
PHP is 5.2.6
I did tried finding out whether it was permission issues in terms of accessing or writing to a file. However, it was able to create a folder called "files" which drupal usually does.
On the MySQL side I checked with permissions, it had all grants. I was able to see all tables that the drupal created.
Apache error logs were of not much help as they had mostly HTTP 404 resource not found messages of different website which was not related to this.
I am not running WAMP. I have seperately installed Apache, PHP and MySQL.
Am I missing any other thing to check out.
Thanks for interest
Thanks figgles for your interest to such a silly problem.
I had an autostart flag for session set on request of a resource in PHP configuration.
I changed it to 0 and everything fell in their place.
Just a wild stab
That's good to know since google site:drupal.org +
is helped by this kind of back-and-forth. So, you're welcome!
hi senthil, i have got the
hi senthil,
i have got the same error u got like below
can u please explain me in detail what u did exactly for removing this error.
am using winXP, apache 2.2,mysql 5.0
thank you !