velospace blog

velospace had a bought of unavailability the past few days. The Drupal database has been periodically corrupting itself, resulting in permissions based issues. The symptom is that users see white pages on the site and can’t access the Drupal versions of velospace, but can still access the forums (which are run on Vanilla software).

The fix is convoluted but follows these steps, posted here for posterity:

Step 1: reestablish baseline permissions in the corrupted tables
INSERT INTO users (uid, name, mail) VALUES ('0', '', '');
INSERT INTO users_roles (uid, rid) VALUES (0, 1);
INSERT INTO node_access VALUES (0, 0, 'all', 1, 0, 0);


Step 2: empty the cache and sessions tables

Step 3: clear out anonymous access rights in /admin/access

Step 4: reestablish anonymous access rights in /admin/access

Thanks for your patience - looks like we are back in business.

- Greg