By Anonymous (not verified) on

first a little background...
I upgraded my Suse install from 9.2 to 10.0 on the server running my drupal 4.6 install. Before the upgrade, clean urls worked fantastic. After the upgrade, I'm thinking it's not working correctly. When I visit my drupal site now I can NOT log in, even as administrator. It bounces me back to http://my.drupal.site/index.php with no administrator menu. It doesnt matter what node headline I click on it bounces me back to the index.php page. My apache error log is loaded with entries like "File does not exist: /srv/www/htdocs/drupal/node"

now the question...
without having access to the administration menu, how the $#@)%^ can I disable Clean Urls? I tried commenting out the lines referring to mod_rewrite in the .htaccess file, and I tried adding $conf['clean_url'] = 0; to the conf.php file to no avail. Is there an entry in the database I can change to disable Clean Urls?

Comments

Anonymous’s picture

Anonymous (not verified) commented

This from http://www.quillem.com/node/569

"If (like I was today) you're stuck with a Drupal site with Clean URLs enabled but mod_rewrite disabled, here's how you disable it via the database [Afaik there's no way to do this from Drupal itself, as you just can't login and navigate the site as all the URLs are clean URLs.. quite the catch-22 :P]:

Navigate to the variables table your DB, and view its contents sorted by the name field. The three rows that concern us are:
cache s:1:"1";
clean_url s:1:"1";
clean_url_ok i:1;

All three are stored in serialised form [as strings]. Cache will be set to 1 only if you have caching on, the same for clean_url. Edit each row so that the end result is as follows:
cache s:1:"0";
clean_url s:1:"0";
clean_url_ok i:0;

And that should be that :)"

Anonymous’s picture

Anonymous (not verified) commented

Ack...this did nothing to solve my problem :(

sepeck’s picture

sepeck commented

Troubleshooting >> Installation/Configuration >> How do I unset clean url's

http://drupal.org/node/5590

UPDATE variable SET value = 's:1:"0";' WHERE name = 'clean_url';
DELETE FROM cache;

-sp
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide

andre75’s picture

andre75 commented

I ran into the same problem recently ;-)
go here:
http://yoursite.com/?q=admin/settings
Uncheckmark Clean Urls there.

Then try to enable it again and you will see an error message telling you whats messed up.
My guess:
Need to load the modrewrite module for apache or change some small thing in .htaccess (maybe you are running apache2 instead of 1.3 per default)

Good Luck

update:
maybe you need to log in first:
http://yoursite.com/?q=user/1/login
(I am not sure this is the correct one, just try).

There is no need to mess around with the database. The conventional urls will work just fine.

Andre

-------------------------------------------------
http://www.opentravelinfo.com
http://www.aguntherphotography.com

andre75’s picture

andre75 commented

Well two exceptions to not messing with the db:
1.) backup the database
2.) clear the cache table
3.) clear the sessions table

Check your httpd.conf file and your php.ini file.
Check your .htaccess file (php4 or php5? apache1.3 or 2?)

Suse sometimes uses their own paths (meaning not everything is where it is supposed to be).

-------------------------------------------------
http://www.opentravelinfo.com
http://www.aguntherphotography.com