By ohwr on
Hi all,
My drupal site was working well till my server had a crash due to /tmp folder full. So the database was not working. Now I cleared the folder and mysql service has been started. After that my drupal site is showing following error
Access denied
* warning: array_keys() [function.array-keys]: The first argument should be an array in /var/www/html/ohwr/modules/user.module on line 352.
* warning: implode() [function.implode]: Bad arguments. in /var/www/html/ohwr/modules/user.module on line 352.
* 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 /var/www/html/ohwr/includes/database.mysqli.inc on line 112.
* warning: Invalid argument supplied for foreach() in /var/www/html/ohwr/modules/filter.module on line 628.
* 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 format = 1' at line 1 query: SELECT * FROM filter_formats WHERE OR format = 1 in /var/www/html/ohwr/includes/database.mysqli.inc on line 112.This error is on homepage itself, it is not allowing to login also.
Here's my setup:
Drupal
Version 4.7.6
Sites directory default
Database prefix
Web Server
Type Apache
Version 2.0
PHP Interface CGI
PHP
Version 5.1.2
Magic Quotes GPC On
Magic Quotes Runtime Off
Memory Limit 40M
Register Globals Off
Safe Mode Off
Session Save Handler files
Upload Max Filesize 16M
Database
Type MySQL
Version 5.0.18-standard
Charset utf8
Collation utf8_general_ci
Permissions
Create Temporary Tables Allowed
Lock Tables Allowed
Mysqli is also enabled, and i have in settings.php mysqli as database.
Can anyone help me in this regard.
thanx in advance.
Comments
Same problem
I'm having the exact same problem. My site went **puff** with a RAID breakdown, managed to restore it (had db backup), new file installation.
The interesting thing is - it works fine on my localhost (php 5.2.1 and MySQL 5.0.38) but on the server I get the same error as described by ohwr above - the server is MySQL (server) 5.0.41 and (client) 5.0.37 - the server php is 5.2.3
-SOON
Getting closer to the problem?
...I've been messing around a lot with this - weird that my site should work fine on a Linux based installation with drupal 4.7.6, mysql 5 and php5 - but not on the company server ... I suspect it may be that the company MySQL server is windows based - check this link out http://drupal.org/node/43316
Another site (also 4.7.6 and the original database backup), running on the same server work fine though, suggesting it isn't actually the MySQL version!?
I've also tried a completely blank install of druapl 4.7.6 - same error!
I'm gonna have the server amin try out the work-arounds to see if it solves the problem.
How about you ohwr? Did you move between linux/windows based sites?
- SOON
I have got the solution. It
I have got the solution. It was given in http://drupal.org/node/121679
Thanx to the drupal community.