Community & Support

Getting to MYSQL to fix issue in database?

Hi! I believe this is a bit outside of Drupal, but I was hoping someone could give me a quick answer. As I think I made changes in a module which makes any and all links to my site become "Page Not Found", I believe I need to modify the database to disable modules in order to get back in. I know Mysql and Drupal were automatically installed on my Provider's system by a one-click method, so I don't have a lot of info about the specifics. I can easily see folders via FTP, and they provide a web-based shell-command device, but I don't get any output like a prompt or error messages unles I type something I know will work like --help following various SQL commands. I'm not sure the command shell is really working, as I don't even seem to be able to CD to different directories. Is there another way to get to a shell prompt on the host system, assuming my provider allows it? It looks like Linux, but I'm not extremely experienced about that determination. They don't provide that info, and I haven't even been able to find contact info for them so far! Any help would be appreciated, and contact form would be fine if it is more appropriate to keep this possibly elementary discussion off the list. Thanks for putting up with this amature!

Comments

Simpler way

Just remove the module you changed. Drupal doesn't run code it can't find.

Unless it's a core module, in which case ... you now know the meaning of http://heyrocker.com/hack_core.jpg

.

The only other way to get shell access beside what your host provides is to upload a php shell script (you can find several with a google search). They will probably be worse than what you have, and also you may be unable to edit your files because php scripts use the webserver user account. About being unable to "cd", a shell will only let you go where you are allowed.

But I wonder what is it that you can't edit using FTP and need a shell.

Also, except if you know positively what is wrong, a description of "what you see when you do what" could get you some useful answers. (For example: "Browsing to http://example/user gives me a "page not found" but browsing to http://example.com/index.php?q=user works", or something like that.)

Advertising helps build a successful ecosystem around Drupal.