By cnemo on

Hello
I've been using drupal for some time but still I didn;t find a good answer to a problem. I have downloaded the html of the sire + made a copy of the database and tried to run it on my local WAMP server. But when I try to log in, I get redirected to a blank page with text "index.php". So I guess this is because in the databse there is the mydomain.com instead localhost/mydrupalfolder So I tried to replace the mydomain.com with the localhost using SQL, ie:
update accesslog set url = replace(url, 'mydomain.com', 'localhost/localdrupal');

But I get mysql error such as
"DATE cache_block SET cid = replace( cid, 'mydomain.com', 'localhost/localdrupal' ) ;

MySQL [error in my language]
#1062 - Duplicate entry 'profile:0:greenNblack:pl:r.1:http://localhost/localdrupal/' for key 1"

Is there a script that would automatically fix the domains/addresses ?

⋅ Categories: Drupal 6.x

Comments

matt_harrold’s picture

matt_harrold commented

I think you're having problems because the remote site wasn't in a subfolder.

In your settings.php ... scroll to (approx) line 106 and read the section that covers base_url.

You may also need to adjust your .htaccess file if you want to use Clean URLs.

BTW: you indicated you tried some SQL wizardry ... I suggest you reverse all that or re-download the database.

cnemo’s picture

cnemo commented

I forgot about the base_url but it didn't work. Take a look at the screenshot.
http://picasaweb.google.pl/bsnemo/Picasa?authkey=Gv1sRgCJ-U0MO0guLd3AE#5...
The whole page is blank.

Which .htaccess settings should I check??

matt_harrold’s picture

matt_harrold commented

Around line 100 in your .htaccess file is an option to change the rewrite base.

I'm starting to think your issue is more fundamental.

Can you temporarily remove all files from your site, create a blank index.php file ... with 


phpinfo();

then navigate to http://localhost/yoursitefolder/index.php

If you still see a blank page then your server set up isn't interpreting PHP correctly.

cnemo’s picture

cnemo commented

Hmm I turned of the rewrite and still the same thing.
When I search for the fraze mydomain.com in phpmyadmin (in database) I find quite a lot of entries. I found a good script to SMF forum engine which takes care of this issue http://download.simplemachines.org/?tools "Repair settings". It's supposed to repair automatically the mydomain.com for localhost/mysmf - is there a smililar tool for drupal? If no then there should be.

Oh and the SQL wizardry is just a simple SQL query which replaces A to B string in XXX field in the KKK table.
update KKK set XXX = replace(XXX, 'A', 'B');

ps: phpinfo() site displays all the settings corectlly.