Locked out of site . . .

Posted by Anonymous on April 25, 2013 at 2:26pm

Hi, I could use a little help. I just updated several modules on my site, along with the corresponding database updates & now I can't get back in. Everything went fine. No errors at all. With all the updates complete I could navigate throughout the site fine before I logged off. (I did update the modules without updating to the latest version of Drupal core for D7.)

Here is the error I'm getting:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cousins_centoannidb.botcha_points' doesn't exist: SELECT b.botcha_type AS botcha_type FROM {botcha_points} b WHERE (form_id = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => user_login ) in botcha_get_form_id_setting() (line 69 of /home/cousins/public_html/sites/all/modules/botcha/botcha.inc).

I tried getting in with mysite/user - same error. I also tried to get in using /update.php, but of course I'm not logged in so that didn't work.

Any thoughts? Am I hosed? Is there a way I can disable this module manually by moving files so I can get past the error?

Thanks for any help . . .

Tom

Comments

set system table status to 0

Posted by maryedith on April 25, 2013 at 6:31pm

Hi, Tom,

You can disable the module by setting its status to 0 in the system table. Go into the database with phpMyAdmin or another tool... find the system table, and just 0 out that module's status. We do it all the time!

Good luck,
Mary Edith

Hi Mary Edith, Thanks! I'll

Posted by dropmaker (not verified) on April 25, 2013 at 6:39pm

Hi Mary Edith,

Thanks! I'll try that out and see if I can get back in.

Cheers,
Tom

Hi Mary Edith, I gave it a

Posted by dropmaker (not verified) on April 25, 2013 at 7:00pm

Hi Mary Edith,

I gave it a try but I still get the error message & still locked out. :-(

Thanks for the suggestion. Any other ideas?

Tom

Make sure you removed all the

Posted by redndahead on April 25, 2013 at 6:57pm

Make sure you removed all the old files from the botcha_points module. http://drupal.org/node/1926354

Thanks for the link. I'll

Posted by dropmaker (not verified) on April 25, 2013 at 7:10pm

Thanks for the link. I'll try that too.

Should I delete all the MySQL tables related to this module? That's what it sounds like they did. As I've already disabled the module in the system table, do I still have to delete or move the module folder files, and if a move to where? Tom

What I would do is download

Posted by redndahead on April 25, 2013 at 7:24pm

What I would do is download the module. Then extract the files someplace else. Then go and verify that the only files in your botcha_points module directory are the ones that are in the module directory you just extracted. Anything else delete.

The other thing you can do is just delete the botcha_points module directory and extract that download into your modules directory.

that sounds right. The error

Posted by maryedith on April 25, 2013 at 8:30pm

that sounds right. The error message you receive is coming from a file that no longer exists in the most recent version of the module. The table referenced is deleted in the update to the latest version, as well.

Many thanks . . .

Posted by dropmaker (not verified) on April 25, 2013 at 10:13pm

I want to thank you both for helping me dig out of the ditch I fell in. I was able to delete the Botcha module and get back into the site. I had to delete & update the Botcha files manually, but finally got it reinstalled.

Now if I could just be sure that Botcha is working with the webforms I created with the webform module. It integrates nicely with regular Drupal forms that have a form ID, but doesn't have a clear indication of being "on" with webforms without a form ID that I can find, they are assigned NIDs in the database. (I've tried adding the Botcha administrative links to forms feature, it doesn't seem to work with webforms.)

Anyways . . . thanks again!