Having not noticed any problems with site lately .... so all out of a sudden this morning

- site is reporting that it is in maintenance mode (i did not switch it into that mode)
- trying to resolve this discovering i cannot logg into the site any longer

http://sitename.xxx/user/login loads, but when entering user-id and password nothing happens, the same empty login-form does appear again

tried cleaning ALL caches and session tables in the database

also checked what the value in the VARIABLE table for the "site_offline" is and it says: s:1:"0";

s:1:"0"; i guess means that the site should be OUT of maintenance mode .. right? so site should NOT be in maintenance ....

HELP please !

Comments

VM’s picture

Is the DB server running properly?

bavarian’s picture

restarted mysql server

seems to be running ok. a regular website on same server (without db-backend) and another drupal-site on same server seem to be running fine ...

just my site acting upp. removed all extra module-files from /sites/all/modules/ and now at least can long in

but can switch site OUT of maintenance mode. even from within admin impossible. and everything completey sluggish. lots of stuff exceeding 120 maximum processing time and timing out...

VM’s picture

removing all modules from sites/all/modules likely wasn't the best thing to do. Those modules are still considered enabled in the DB. removing them one at a time may have been a better thing to do.

Anything in your logs?
the drupal watchdog table?

bavarian’s picture

Partially resolved "everything" ... thanks for you input Kenn_VM !

I could not figure out what was logging me out of my site, what put the site into maintainance mode and what hindered me from logging in, but I am suspecting 2 modules to be part of the problem.

- Rename Admin Paths (http://drupal.org/project/rename_admin_paths)
- Maintainance Countdown (http://drupal.org/project/mcd)

Not completetly sure about "Rename Admin Paths" but could be involved in the problems I experienced. The more sure about "Maintainance Countdown" module. After removing all modules from /sites/all/modules I could at least log into the site again. But could not get the site out of Maintainance mode. When reinstalling "Maintainance Countdown" module and enabling it, disabling it again and uninstalling it the correct way in the admin-section of my Drupal site allowed me to switch back into regular mode and F*I*N*A*L*L*Y get OUT of maintainance mode. But something weird remains. I cannot switch INTO maintaincance now, when everything else somehow seems to work to a certain degree again. I could try, and install the Maintainance Countdown module again, and leave it there, but as it seems rather buggy i rather stay away from it.

Yes, Kenn_VM, removing all modules from sites/all/modules likely wasn't the best thing to do. But at least I got back into my site again. After a long and exhaustive installation process of getting those modules back in place my site seems to work fine again - on the surface at least ....

Some problems remaining though ....

1 - can't switch site into maintainance mode as described above. no idea how to resolve this ...
Nothing in Recent log-messages for this ...

2 - trying to edit any content type by lets say /admin/structure/types/manage/news (but applies not only to the NEWS content type but to every content type)

Bringing upp a grey bar on top of page with "ERROR"
And a completely white page underneath that grey bar saying "The website encountered an unexpected error. Please try again later."
That problem was not existing before all this described in this thread happened.

Recent log-messages for this reads:

LOCATION	http://domainname.xx/admin/structure/types/manage/news
REFERRER	http://domainname.xx/admin/structure/types
MESSAGE	PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxx_yyyy.aggregator_category' doesn't exist: SELECT 1 FROM {aggregator_category} LIMIT 0, 1; Array ( ) in_aggregator_has_categories() (line 286 of /home/jadajadajada/public_html/blablabla/drupal7/modules/aggregator/aggregator.module).
SEVERITY	error
HOSTNAME	xx.xx.xx.xx
OPERATIONS

3 - trying to enable/unenable modules by /admin/modules

Pressing the button "save configuration" moves browser to /admin/modules/list/confirm but there same scenario as described above when trying to edit content types
Bringing upp a grey bar on top of page with "ERROR"
And completely white page underneath that grey bar saying "The website encountered an unexpected error. Please try again later."
Also that problem was not existing before all this described in this thread happened.

Here at least - I can see when reloading /admin/modules that the modules that were intended to be switched on/off also have reached the desired state.

Recent log-messages for this reads:

LOCATION	http://domainname.xx/admin/modules/list/confirm
REFERRER	http://domainname.xx/admin/modules
MESSAGE	PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxxx_yyyyy.aggregator_category' doesn't exist: SELECT cid, title FROM {aggregator_category} ORDER BY title; Array ( ) inaggregator_block_info() (line 347 of /home/jadajadajada/public_html/blablabla/drupal7/modules/aggregator/aggregator.module).
SEVERITY	error
HOSTNAME	xx.xx.xx.xx
OPERATIONS

Not the slightest idea how to resolve those "SQLSTATE" problems

VM’s picture

Looks like something to do with the aggregator.module, or a view that was created with it. If disabled, enable. if not uninstalled, disable, uninstall, reinstall to get the table back in the DB.

also clear the cache tables in the DB.

bavarian’s picture

problem 2 and 3 described above resolved with your help

problem 1 remains. quite badly. done an upgrade of a module, where site is put into maintenance mode automatically. now no luck getting out of maintenance mode, site is offline to visitors.

i made backup of database before performing this upgrade so i could switch back to that state (with preserved non-maintainance status) but i need to resolve this crazy issue sooner or later anyway ...

any advice how to look for errors?

dreamleader’s picture

Hi,
I would like to share this:
After every other log in attempts such as example.com/user or ?q=admin etc. failed. I realized I have to enter the little word 'site' into the url as well.
Like this:
www.example.com/sites/user This is if you have clean urls enabled.

I hope this helps others who have their site in maintenance mode and get a 404 site not found error.

VM’s picture

The above is only true if drupal is installed in a subdirectory named sites or the user path has been altered by the end user.

This can be tested right here on drupal.org. logout, use drupal.org/user which provides a login page. Though, I'd suggest using yoursite.com/user/login