By ericwoodford on

I've installed drupal on an IIS machine, and turned on CleanURLs thinking I had the ModRewrite configured correctly. Now, I can't get back into the site, to turn if off.

Is there any way to turn the function off without rebuilding my database?

Comments

chx’s picture

chx commented

First, instead of mysite/admin/settings try mysite/index.php?q=admin/settings

Second, if that does not work, go to your database and UPDATE `variable` SET `value` = 's:1:"0";' WHERE `name` = 'clean_url'

Hope this helps.

--
Drupal development: making the world better, one patch at a time. | A bedroom without a teddy is like a face without a smile.

javanaut’s picture

javanaut commented

you beat me to the punch :P

javanaut’s picture

javanaut commented

You can update your 'variable' table directly using the following query:

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

There may be a better way, but I would think this one would work (note, however, that I have not tested this, and you should backup your database before using it ;)

decibel.places’s picture

decibel.places commented

I think both chx and javanaut included an additional semicolon

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

did not work for me but

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

without the ; after s:1:"0" worked

~are you netsperienced?
♥ follow me @decibelplaces ∞

Anonymous’s picture

Anonymous (not verified) commented

Mysql -u root
connect drupal
update ...

1 found; 1 matching; 1 update

still returns short urls.
after reboot, same problem.

Is there a mod-rewrite value

javanaut’s picture

javanaut commented

It could be that your page is caching.

(again, after backing everything up, of course) Try:

DELETE * FROM cache;

Anonymous’s picture

Anonymous (not verified) commented

I just did a Mysqldump of the cache table and found the 'clean_url' option set to 1.

Anonymous’s picture

Anonymous (not verified) commented

Co-worker also running Drupal, pointed me in the right direction.

http://drupal.org/node/5590

I needed to add

$conf['clean_url'] = 0;

to my config.php file