can't login even through /?=user on off-line site
Hello,
Hosting is 1&1. I have a domain, and a drupal installation. This site is offline because I upgrade d from Drupal 4.7.6 to Drupal 6.0 by stages only to find out Mysql for that DB was outdated, and 1&1 doesn't upgrade old dbs.
So I made a new DB that's Mysql 5, a new subdomain, and directed it to a new dir. I I also migrated my main sql db backup (xxx.sql) to the new DB: I can see it in Phpmyadmin.
I edited the settings.php file so it refers to the new DB.
The new subdomain is ola.libre-zele.info
So I have two identical websites but he new subdomain has Mysql5.
I can't login on either even with /?user
Drupal handbook says, you can type this mysql command:
UPDATE variable SET value = 's:1:"0";' WHERE name= 'site_offline';
DELETE FROM cache WHERE cid = 'variables';What does this do exactly?
Your help would be much appreciated as I've been struggling, learning how to use mysql from a shell with OpenSSH (thank God for Linux!) and migrate the DB which was too big for PHPMyAdmin (I'll post a short howto as soon as I can see our silly website!
:-)
Same problem -> another way
Hi,
in a similar situation a few nights ago I got in by typing the url www.example.com/update.php. I had to put $access_check = FALSE; in the file update.php. I run the update script and could get to the administration page then. (I tried several things - I hope I remember it right ...)
By the way: Your database is OK. I see the 'Site hors ligne' when i go to your domain.
Greetings from Austria
anschinsan
Update should be a good idea
Hello anschinsan,
Many thanks for your swift reply which has reminded me my new subdomain Drupal is 6.1 while my imported DB is 6.0 so yes I should update. I hit upon that update tip while upgrading from one Drupal version to another, a few days ago. It worked fine.
Oh yes, what a lovely page! If I can get past it it'll be even lovelier! :-) -- and hopefully the DB's fine -- not sure until I run the update script.
I'll report back as soon as I can.
---
Libres-Ailé(e)s (Association for Linux and libre software) (France, Cévennes)
Updated DB, a few problems
Okay, now I've run the script some errors have appeared. The update failed if I understand right.
* warning: reset() [function.reset]: Passed variable is not an array or object in /homepages/xxx/update.php on line 315.
* warning: array_pop() [function.array-pop]: The argument should be an array in /homepages/xxx/update.php on line 315.
The update process was aborted prematurely while running update # in .module. All errors have been logged. You may need to check the watchdog database table manually.
I don't know what to do next. Perhaps I'd better start a new thread, to start with :-/
---
Libres-Ailé(e)s (Association for Linux and libre software) (France, Cévennes)
Language and accented characters
Got rid of these errors thanks to:
UPDATE variable SET value = 's:1:"0";' WHERE name= 'site_offline';DELETE FROM cache WHERE cid = 'variables';
In PhpMyAdmin if you've got that, click on your DB in the side panel, then click on the SQL tab in the main panel, then paste the command, and press the Okay or whtever button to launch the command.
I was then able to see the home page and login as usual. then I ran the update.php script: success.
Before that I was careful to set settings.php back to FALSE (see messages above).
Now I can see the subdomain drupal web site.
One remaining problem is : language and accented characters.
I uploaded all the "translations" dirs from the French pack fr-6.x-1.x-dev.tar.gz. Then I updated again.
French is a default language and I set it for the admin. Still, I get all those weird characters, and the interface has only bits of French in it. Quite eerie.
Any idea?
---
Libres-Ailé(e)s (Association for Linux and libre software) (France, Cévennes)