can't access admin page after installed content access module
| Project: | Content Access |
| Version: | 6.x-1.0 |
| Component: | Code |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
I've installed a D6 multisite in my local machine, then installed content access, after installation, seems everything was fine, then I shut down the server, after I brought it back on, I couldn't find any longer the tab, but I still could access the admin page until yesterday, after I installed the following modules: pathauto, path, page_title, nodewords, after install everything seems fine, I could configure and admin was accessible, then I shut down the local server (apache, mysql and php), after I loaded wamp again, I couldn't get into admin page any longer, other pages seemed working fine, but when I tried to access admin page, I got the following error:
Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\includes\common.inc on line 501
this is what I got from mysql error log:
090221 13:23:52 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090221 13:23:52 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_Z
090221 13:23:52 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090221 13:23:52 [Note] wampmysqld: ready for connections.
Version: '5.1.30-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
and PHP error log showed the following errors:
[21-Feb-2009 13:23:49] PHP Notice: Undefined variable: mywampfp in C:\wamp\scripts\refresh.php on line 252
[21-Feb-2009 13:23:49] PHP Notice: Undefined variable: i in C:\wamp\scripts\refresh.php on line 252
[21-Feb-2009 13:23:49] PHP Notice: Undefined variable: mywampini in C:\wamp\scripts\refresh.php on line 252
[21-Feb-2009 13:23:49] PHP Notice: Undefined offset: 1 in C:\wamp\scripts\refresh.php on line 385
[21-Feb-2009 13:23:49] PHP Notice: Undefined offset: 1 in C:\wamp\scripts\refresh.php on line 385
[21-Feb-2009 13:23:49] PHP Notice: Undefined variable: list in C:\wamp\scripts\wampserver.lib.php on line 33
[21-Feb-2009 13:23:49] PHP Warning: Invalid argument supplied for foreach() in C:\wamp\scripts\refresh.php on line 497
[21-Feb-2009 13:24:51] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\includes\common.inc on line 501
Seems that a table is missing (mysql.servers), is it possible this table is causing all these problems? Is this a bug? How can I get my admin page back? After removing the content access module, then I could access admin page.
Thanks for your comment/suggestion,
Michael
#1
After further test, I've noticed the following:
- after removing content access module, the error still persists in MySQL error log, therefore this is not caused by content access module, but at least the admin page is back. So I proceed to uninstall and reinstall this module again, this time the Access control tab showed up, but I couldn't make it work, I wanted to restrict a page to be viewed only by certain role. For instance, I have a student and teacher roles, and student can fill in an assignment node, which can't be seen by other students and only teachers can see them. So I created a form using webform, after creating a form called assignment, I assigned a user with student role, but he can't see this form, so I can't test it to see if it's working. I'm not sure if I followed the right procedure to create the form. What I did is just create a form and checked the view right to teacher.
ps: after installing content access, it required building the permissions, I'm not sure if this is correct, I remember seeing somewhere that nothing has to be done after install, so I don't know if this permission building is expected or not. Where can I find doc about how to use/install this module?
Thanks for your comment/suggestions.
Michael
#2
Setting to support is ca is not the only module in question to cause that. Probably the php execution time out stopped the installation process before it was finished - so things broke.