[SOLVED] Stecke im Wartungsmodus fest / Stuck in maintenance mode

PROBLEM GELÖST!!!
Lösungsweg unter dem ursprünglichen Beitrag.

Moin,

gestern Abend habe ich Gallery 2.3.2 mit 200 Bildern zur Verarbeitung beschäftigt und wie immer vorher auf der SideAdmin\Wartung die Seite für Besucher in den Wartungsmodus versetzt.
Als ich mal für wenige Minuten draußen, war um frische Luft zu schnappen, viel der Strom aus, der Rechner wurde herunter gefahren (USV).
Nach dem ich den Rechner dann wieder hoch fahren konnte, wollte ich die Zeile,

$gallery->setConfig('mode.maintenance', false);

ändern, so sie dann überhaupt auf $gallery->setConfig('mode.maintenance', url '/maintenance_url.php' ); steht. Dies ist nun nicht der Fall gewesen.

Gibt es eine andere Möglichkeit die Gallery 2.3.2 aus dem Wartungsmodus zu bekommen, als über die config.php?
Wenn ja, wie lautet diese?
Wenn nein, wird da bereits an einer Lösung des Problems gearbeitet?

Grüße,
Jessi'

PROBLEM SOLVED!!!
Approach under this thread.

Hi,

yesterday evening I've upload 200 images to Gallery 2.3.2. I've set the side on admin pages to maintenance mode, that the server is able to process the pictures faster.
I was for a few minutes outside, same time the computer was shut down in case of power fail.
Power comes back, but my access to the side is now impossible.
In config.php the "$ gallery-> setConfig ('mode.maintenance', false);" is correct, no URL is set.

Is there any other way to set the maintenance off?

If yes, what is this?
If not, is there already working on a solution to the problem?

regards,
Jessi '

Approach from Dayo that works on my problem:

Moin,

danke für die schnelle Antwort, doch so 100% verstehe ich die Information jetzt nicht.
Füge ich es einfach in der Zeile darunter ein?

(Ich werde es versuchen, vermute aber das das wohl nicht gemeint war)

Grüße,
Jess'

Und?

Wird es noch einen brauchbaren Lösungsansatz geben, welcher den Wartungsmodus in der MySQL-Datenbank oder wo auch immer der Wartungsmodus über die Adminoberfläche ausgelöst und eingetragen wird?

Grüße,
Jess'

My config.php @line 159/195 since beginning of this thread:
$gallery->setConfig('mode.maintenance', false);
Effect: http://photos.jessika-katharina.net/ nothing...

Gibt es noch einen anderen Lösungsansatz?
Wie bereits geschrieben, ich habe die Seite über den Adminbereich in den Wartungsmodus mit URL gesetzt und mein Browser ist, bevor ich diesen dort wieder beenden konnte, abgestürzt. Seit dem hängt die Seite im Wartungsmodus fest.
Ich habe nie etwas in der config.php geändert und Veränderungen diese sind effektlos.

Is there a different approach?
As already written, I've set the page in the Admin area to maintenance mode with URL and my browser, before I could finish it there again, crashed. Since the site is stuck in maintenance mode.
I have never changed anything in the config.php and changes at this file didn't show any effects.

Thanks,

inside the config.php or which other file or command-line? "Replace" the other line or added (before~after)?

Jk

run: UPDATE g2_PluginParameterMap SET g_parameterValue='' WHERE g_parameterName='mode.maintenance.lastUrl';
Error: #1146 - Table '[Username]_[Tablename].g2_PluginParameterMap' doesn't exist
But a table without .g2 exists.

Within.
Otherwise: #1046 - No database selected
{I think my prefix is photos_. I'll try it to change it.}
UPDATE photos_PluginParameterMap SET g_parameterValue='' WHERE g_parameterName='mode.maintenance.lastUrl'
Was executed, but no effect to the maintenance-mode.

http://photos.jessika-katharina.net/config.php:

<?php
@ini_set('display_errors', 0);
if (!isset($gallery) || !method_exists($gallery, 'setConfig')) {
    exit;
}
$gallery->setConfig('setup.password', '*');
$gallery->setConfig('data.gallery.base', '/home/photos-data');
$storeConfig['type'] = 'mysqli';
$storeConfig['hostname'] = 'localhost';
$storeConfig['database'] = '*';
$storeConfig['username'] = '*';
$storeConfig['password'] = '*';
$storeConfig['schema'] = '';
$storeConfig['tablePrefix'] = 'photos_';
$storeConfig['columnPrefix'] = 'g_';
$storeConfig['usePersistentConnections'] = false;
$gallery->setConfig('storage.config', $storeConfig);
$gallery->setDebug(false);
$gallery->setProfile(false);
$gallery->setConfig('mode.maintenance', false);
$gallery->setConfig('mode.embed.only', false);
$gallery->setConfig('allowSessionAccess', false);
$gallery->setConfig('galleryBaseUrl', '');
$gallery->setConfig('baseUri', 'http://photos.jessika-katharina.net/main.php');
?>

phpMyAdmin -> photos_PluginParameterMap:module core 0 mode.maintenance.lastUrl
http://photos.jessika-katharina.net/lib/support/:

Successfully deleted page cache
Deleting dir: /home/photos-data/cache/entity
Recreating dir: /home/photos-data/cache/entity
Deleting dir: /home/photos-data/cache/module
Recreating dir: /home/photos-data/cache/module
Deleting dir: /home/photos-data/cache/theme
Recreating dir: /home/photos-data/cache/theme
Deleting dir: /home/photos-data/smarty/templates_c
Recreating dir: /home/photos-data/smarty/templates_c
Deleting dir: /home/photos-data/tmp
Recreating dir: /home/photos-data/tmp
Deleting dir: /home/photos-data/cache/repository
Recreating dir: /home/photos-data/cache/repository
Removed 0 install/upgrade log files
Deleting dir: /home/photos-data/cache/derivative
Recreating dir: /home/photos-data/cache/derivative

.htaccess:

RewriteEngine on
#{gallerySection}
RewriteCond %{HTTP_REFERER} !^http://photos.jessika-katharina.net/.*$      [NC]
RewriteCond %{HTTP_REFERER} !^http://photos.jessika-katharina.net$      [NC]
RewriteCond %{HTTP_REFERER} !^http://www.photos.jessika-katharina.net/.*$      [NC]
RewriteCond %{HTTP_REFERER} !^http://www.photos.jessika-katharina.net$      [NC]

Done... This is extremely screwed.

The only other thing I can think of is something more server related like apache or DNS redirect.
I'll ping Dayo and see if he has any ideas.

-s
________________________________
All New jQuery Minislideshow for G2/G3

Hi,

Dont understand the first few posts in German but from google translate, it seems you had it in maintenance mode, lost power and it is now stuck in maintenance? Is that the case?

--
dakanji.com

Thanks for the translation. Need to brush up on my German!

There isnt any other way to switch maintenance on or off.

One thing is unclear from what you wrote about power going off.
Are you hosting the website at home? That is, is the actual computer at your home the one serving the website or do you have an account with a web host?
--
dakanji.com

Ok.

Let us focus on your server as your home machine does not display your site.

Can't you edit the config.php on the web server ... the same way you did to put it to maintenance mode?

Alternatively, you can bypass the maintenance mode as admin by using this url:

(replace "secret" with your own password)
(replace admin with your admin username)
--
dakanji.com

WOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOW!!!!!

THAT WAS IT!!!

Thank's you a lot!!!

WOW!!!

For all others, they stucked in maintenance mode, try this workaround:

Dayo, thank U very much!!! It works!!!
Yes, I'm able to edit the config.php, but I'm not use this way to enter maintenance mode.
But the "Alternative"-Way is working!!! You can verifying it. :D
WOW, I'm very happy!

Und nun noch mal das ganze auf Deutsch:

Du steckst im Wartungsmodus fest? Ein Ändern der config.php und der SQL Werte nichts gebracht hat, versucht den Lösungsweg von Dayo, der funktioniert auf jeden Fall!!!

Great news.

To others coming across this, if you can post in english on the main boards, pls do.
I dont think we have any German speaking regular contributors anymore.

--
dakanji.com

I'd be interested in knowing which DB field is changed in maintenance mode. I had tried a direct admin url and was redirected. I had also searched the DB for any maintenance reference to no avail.

-s
________________________________
All New jQuery Minislideshow for G2/G3

@suprsidr thank U, but I think my grammatic is not so fine. :D

I'll try to contribute sometimes, but it's hard to follow every thing in this forum.

But now I know, who I can ask in case of a problem, I'm not able to solved by my self.