Quick news

  • 2012-08-19: Working on the new Drupal 8 Entity system at Drupalcon Munich
  • 2012-06-15: Working on the new Drupal 8 Entity system at DrupalDevDays Barcelona
  • 2012-03-23: Working on the future Drupal Document Oriented Storage at DrupalCon Denver. D8 or later ? Bets are on.
  • 2011-09-01: Building an Unfuddle to Drupal Casetracker import module using Migrate
  • 2011-08-28: Back from DrupalCon London and its WSCCI code sprint. Wow.
  • 2009-11-29: mongodb_watchdog module created by dereine, ported to D7 by me in about half an hour, and migrated in a larger MongoDB project by damz before the hour ended. Wow...

Latest sites

Last code sprint before Drupal 8 code freeze

mysql

What to do when you can no longer login to your Drupal site

So the scenario is this: you notice that you are no longer able to login on your Drupal site:

  • the {users} table entry for your account looks just fine
  • the login and access timestamps on your account are just a few seconds old, matching your latest attempt to login
  • you reset your password in the DB, just in case, and it still does not work
  • the telltale is that Drupal will not even tell you your login failed: it actually works, as the {users} table shows, but yet you are not logged in

Can you guess what can have been going wrong and fix it ?

Counting MySQL tables from the shell

Tiny tip for the day: a one-liner to get the number of tables on a MySQL server across all databases:
mysql -BNe 'SELECT COUNT(*) FROM TABLES' information_schema
Syndicate content