G2 Preinstaller fails during Extract step

natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Sun, 2009-07-05 04:05

Gallery version = 2.2.4 core 1.2.0.6
PHP version = 5.2.6 cgi-fcgi
PHPInfo Link = http://ws100.com/gallery2/phpinfo.php
Webserver = Apache/2.2.8 (Unix)
Database = mysqlt 5.0.75, lock.system=flock
Toolkits = NetPBM, ImageMagick, Exif, ArchiveUpload, Thumbnail, LinkItemToolkit
Operating system = Linux vux34 2.6.22.10-NETSOL #1 SMP Tue May 20 17:56:43 EDT 2008 i686
Browser = Firefox 3.0.11

Using G2 Pre-installer; downloaded as gallery2.tar.gz, but Extract .tar.gz with PHP function fails:

Warning: filesize() [function.filesize]: stat failed for ././gallery2/themes/classic/po/et.mo in /data/16/1/133/23/1459186/user/1568276/htdocs/preinstall.php on line 1847

Checked this location via FTP; no "et.mo" found. "././gallery2/..." looks a little odd.

There's something I'm missing here, but I don't know what.

I need to get this site back online. How do I restore from the backup .xml file?

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sun, 2009-07-05 06:41
Quote:
Using G2 Pre-installer;

So you are installing for the first time?

Quote:
Gallery version = 2.2.4 core 1.2.0.6

Why not a more recent version like G2.3?

Quote:
I need to get this site back online. How do I restore from the backup .xml file?

NOW I am confused.... are you installing or trying to restore a backup?

Dave

_____________________________________________
Blog & G2 || floridave - Gallery Team

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Sun, 2009-07-05 14:11

No, this is supposed to be an upgrade from 2.2.4.

Initially, the download and extract and install went fine, except that when I brought up the site all of the photos had the missing photo placeholder. I discovered that I had run the pre-installer from within my Gallery folder and that the install had created a new G2 folder inside the existing one.

After cleaning up that mess, I re-ran the pre-installer in the /htdocs folder, but now am getting the install error.

I either need to get it to work or I need to restore ASAP.

/richard

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sun, 2009-07-05 17:31

Restore your backup of 2.2.4. Make sure it is operational.

download G2.3 from the download page extract the files and perform the upgrade.
FAQ: How to upgrade Gallery2?

_____________________________________________
Blog & G2 || floridave - Gallery Team

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Sun, 2009-07-05 18:43

Ok, I'll check that out. Thanks.

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Sun, 2009-07-05 18:55

Stuck again. How do I execute the .xml backup file that was created in the albums/backups/ folder of my G2 data folder? I can't find anything in the FAQ pages (or anywhere else) that covers this process.

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sun, 2009-07-05 19:44

How did you create this .xml file for your backup?

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Sun, 2009-07-05 21:59

It was created in one of the steps when I was running the preinstall.php process, the time that it all ran Ok, but then turned out to be installed in the wrong location. As I recall, after the extraction step, the next step invoked the regular installation script, and it was actually as part of that script that I opted to have the backup made. At this point, I can't get back to that part of the scripting to identify it any better for you.

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sun, 2009-07-05 22:33

I am lost. I don't recall the preinstaller having a .xml backup step.
I don't know how to help further.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Sun, 2009-07-05 22:51

Well, as I said, it might well have been a step within the main installer, given that the pre-installer script switches over to that during the upgrade sequence. Here are the first few lines of the .xml file, in case that rings a bell...

<?xml version="1.0"?>
<export schema-version="1.1" tables="46" core-version="1.2.0.6" gallery-version="2.2.4">
<plugin-status-list>
<plugin-status id="archiveupload" required-core-api="7.4" required-api="3.0" version="1.0.6" active="1" type="module"/>
<plugin-status id="comment" required-core-api="7.5" required-api="3.0" version="1.1.3.2" active="0" type="module"/>
<plugin-status id="exif" required-core-api="7.10" required-api="3.0" version="1.1.0" active="1" type="module"/>
<plugin-status id="icons" required-core-api="7.4" required-api="3.0" version="1.1.2" active="1" type="module"/>
<plugin-status id="imageframe" required-core-api="7.4" required-api="3.2" version="1.0.5" active="1"

etc.

The file size is 5.8Mb.

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Mon, 2009-07-06 00:01

I am just guessing here....
Extract G2.3 to a folder on your server.
do you have a config.php file as well? if you do put it in there as well if not create a empty one.
browse to yoursite.com/gallery2/lib/support/
there is a .xml import tool there.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Mon, 2009-07-06 22:06

My head is starting to hurt.

I followed your suggestion and extracted to a new gallery2 folder. The config.php file is there. I browsed to the support folder, but it blocks me with a security page that says I need a config.php file and to go to the Installer to create one.

When I go to the installer and finish the Database Setup step it says I need a version.dat file...

"Gallery tables already exist in this database! But there is no 'versions.dat' file in your G2 storage directory which we interpret as a broken state of G2. Either create a versions.dat file with the correct format if you think your G2 should still work or select a clean install, which will erase all data in the database and in the storage directory."

I've tried each of several core and gallery version numbers in this file, but nothing works. I only get the message above. My presumption is that this file is supposed to refer to my existing 2.2 installation, not to the 2.3 one that is being installed. Right now it has: 1.2.0.6[newline]2.2.4

So now I appear to be stuck. I can't continue the upgrade using the newly-extracted copy, nor can I extract 2.3 into the original G2 folder (see quoted error message in my original post.) Nor can I get my recently running Gallery to come back up, apparently due to the failed attempt to extract 2.3 into it. It gives me the offline-for-maintenance message with the Admin signon link, but when I sign on, all I get is a blank page.

Is there any way to download a fresh copy of 2.2 so I can get back to a stable install?

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Tue, 2009-07-07 02:07
Quote:
Is there any way to download a fresh copy of 2.2 so I can get back to a stable install?

http://downloads.sourceforge.net/gallery/gallery-2.2-full.zip

Dave

_____________________________________________
Blog & G2 || floridave - Gallery Team

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2009-07-07 02:58

Dave, it looks like SF broke, removed, etc all of the old versions and only 2.3 and 2.2.6 are there for 2.x
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Tue, 2009-07-07 03:16

It worked for me few min ago. Let me see what I can find.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Tue, 2009-07-07 03:25

If I copy the above url to my FF browser I am prompted to save a file.
Interesting that clicking the link does not work. weird.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2009-07-07 03:29

Nice catch. Looks like someone will need to probably submit a ticket to sf. Unless they have some reasoning behind this. But that does help me with someone else in another thread (now to find it....)
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Wed, 2009-07-08 18:45

Regarding restoring from the .xml backup file, you said...

Quote:
browse to yoursite.com/gallery2/lib/support/
there is a .xml import tool there.

I don't see anything there that looks like an import tool. Here's what I see...
GallerySetupUtilities.class
cache.php
chmod.php
gd.php
index.php
phpinfo.php
security.inc
support.css
templates [folder]

FYI, the backup .xml file was created during execution of the gallery2/upgrade/ script.

I need exact info about how to restore from this file. I'm having no luck finding anything about how to do this by searching the G2 support, forums or FAQ info.

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Fri, 2009-07-10 17:59

Please let me know how to restore from the file created via the gallery2/upgrade/ process.
It is located on my server at [g2datafolder]/albums/backups/ws100gallery2_c76ba_2009_07_03_1741.xml
Thanks in advance for your help!

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Fri, 2009-07-10 18:10

You need to be on 2.3 to use that and so far in my testing I'm not sure if something is broken or what exactly that is suppose to restore.

Since you were trying to use the preinstaller have you gotten or even have a successful working install of Gallery that's in use with lots of photos?

If not, I'd just delete it all and start over with a fresh download of 2.3 and install it manually.

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Fri, 2009-07-10 20:11

Here is where (I think) I am:

Yes, I had a fully operational site with thousands of photos as of last Friday, 7/3/09. Gallery version = 2.2.4 core 1.2.0.6.

My intention at that point was to upgrade to 2.3, but when I loaded the pre-installer to my server, I mistakenly added it and ran it in my gallery2 folder. At the completion of that install, my site came up, but all the photo links were broken.

The installer had created a new gallery2 folder inside my existing gallery2. Realizing my mistake, I removed the new folder and proceeded to run the pre-installer again from my htdocs directory. This time, however, the script failed to extract properly, giving me the error,

Quote:
Warning: filesize() [function.filesize]: stat failed for ././gallery2/themes/classic/po/et.mo in /data/16/1/133/23/1459186/user/1568276/htdocs/preinstall.php on line 1847

Somewhere in my varied attempts to get the site back up, I tried using the gallery2/upgrade/ feature. During that process, at the point where the script is about to upgrade the core, it offered me the option to make a backup and I did so.

Now, what I have is a site that comes up, but the image links are still broken. Also, the Admin signon is not working.

After more searching around, it appears there may be a problem with my not having turned off URL-Rewrite before starting the upgrade. I found a link in the FAQ's that is supposed to go in and reset that value, but it doesn't seem to work...

Quote:
Images don't show up and the album / photo links don't work, what can I do?

Possible reasons:

* G2's URL rewrite module is active but doesn't work correctly. Fîx:

1. Put G2 into maintenance mode
2. Browse to http://www.example.com/gallery/main.php?g2_view=core.PluginCallback&g2_pluginId=rewrite&g2_pluginType=module&g2_command=deactivate

I am hopeful at this point that, if I can reinstall the 2.2.4 version get the DB back to 1.2.0, I can somehow pick up the pieces.

But if, as you say, the backup only works with 2.3, that strategy may be unworkable.

If I load up with 2.3 in a new gallery2 folder, with an empty g2data folder and my DB as is, can I import my photos from a copy of the old g2data/albums folder? If so, will I still have the captions and album ownerships intact?

If not, what do you recommend...?

/richard

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Fri, 2009-07-10 20:40
Quote:
at the point where the script is about to upgrade the core, it offered me the option to make a backup and I did so

If that was an XML backup, that's only useful if running 2.3, and even then it appears to not function as intended.

Quote:
I am hopeful at this point that, if I can reinstall the 2.2.4 version get the DB back to 1.2.0, I can somehow pick up the pieces.

Not if the DB and g2data have already been updated, there is no going back unless you did a backup of both before you upgraded.

Quote:
If I load up with 2.3 in a new gallery2 folder, with an empty g2data folder and my DB as is, can I import my photos from a copy of the old g2data/albums folder? If so, will I still have the captions and album ownerships intact?

Well, it's probably not going to be what you want. You can do that, but you'll lose comments, view counts, descriptions, titles, keywords, etc.

Here's what I suggest from what you've described of what you've done so far. BACKUP, everything:
FAQ: How do I backup G2?

Read this:
FAQ: How to upgrade Gallery2?

I don't know exactly what state everything is in, but you might be able to recover by downloading a current version of G2.3 from here: http://codex.gallery2.org/Downloads unzipping it, transfer that to your server, overwriting your current gallery2 directory, then run the upgrader by going to www.example.com/gallery2/upgrade/

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Tue, 2009-07-14 00:34

Ok, we seem to be making progress, but not quite there yet.

I backed up as advised. Using the preinstaller, I downloaded 2.3 again and extracted into my gallery2 folder. I used the upgrader, but it found problems with several of the addon's. I ended up bypassing the update of the addon's and brought up the site. Things seem to be working (sort of), except all the thumbnails are square and the images are distorted. The Admin signon is working. So far so good.

One thing I noticed is that the upgrader, when it ran, was ver 2.2, not 2.3. Also, the problem with the addon's seems to be that the versions that it wants to install are earlier than the ones that are already there. Here's what I'm seeing (editied) for the ones that are a problem...

__Name_____________Current_New
HTTP Auth__________1.0.3___1.0.0
Image Block________1.1.9___1.1.0
Comments___________1.1.14__1.1.3.2
EXIF/IPTC__________1.2.5___1.1.0
Color Packs________1.0.7___1.0.5
______Icons________1.1.5___1.1.2
Thumbnail Manager__1.0.14__1.0.9.1
Watermark__________1.1.7___1.1.0
Captcha____________1.1.7___1.1.4.
URL Rewrite________1.1.18__1.1.13.4

The upgrader seems to be self-adapting. On this go 'round, it has updated the core from 2.2.4 to 2.2.6. I've backed up the DB again in prospect of moving on.

Is there some way to move on to 2.3 so that the addons will start working from the installed versions? What do you suggest?

/richard

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2009-07-14 04:56
Quote:
Using the preinstaller,

Why? I'm pretty sure I said

nivekiam wrote:
you might be able to recover by downloading a current version of G2.3 from here: http://codex.gallery2.org/Downloads unzipping it, transfer that to your server, overwriting your current gallery2 directory, then run the upgrader by going to www.example.com/gallery2/upgrade/

Quote:
I downloaded 2.3 again

Nope, I don't know why or how, but you have G2.2.6 files.

Quote:
What do you suggest?

Go to Site Admin > Maintenance click Run Now for the System Information task. Copy and paste that info here. Let's see where you are right now.

Where is your g2data directory located? Below or above your gallery2 directory?

Also, zip and attach your upgrade logs, all of them. They are located in your g2data directory.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Tue, 2009-07-14 16:33

Correction to my prior, most of the thumbs are displaying normally. Only those that were created/updated recently are displaying in the square format. I have not attempted to regenerate them or do anything else that might bump up against the add-on's that have problems.

I used the preinstaller because I was working under the (perhaps mistaken) impression that it copies the latest G2 version directly to my server and unpacks it. If I download and unpack it on my local machine and then try to FTP it to my server, it takes all day (literally!) and fails repeatedly on timeouts, socket errors, etc.

Current System Info...

Gallery version = 2.2.6 core 1.2.0.8
PHP version = 5.2.6 cgi-fcgi
Webserver = Apache/2.2.8 (Unix) FrontPage/5.0.2.2635
Database = mysqlt 5.0.75, lock.system=flock
Toolkits = LinkItemToolkit, NetPBM, ImageMagick, ArchiveUpload, SquareThumb
Acceleration = full/21600, none/0
Operating system = Linux vux51 2.6.22.10-NETSOL #1 SMP Mon Jul 14 16:26:14 EDT 2008 i686
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.11) Gecko/2009060215 Firefox/3.0.11 (.NET CLR 3.5.30729)
Rows in GalleryAccessMap table = 259
Rows in GalleryAccessSubscriberMap table = 4367
Rows in GalleryUser table = 55
Rows in GalleryItem table = 4353
Rows in GalleryAlbumItem table = 78
Rows in GalleryCacheMap table = 22

The g2data folder is at a peer level with the gallery2 folder, each is directly under /htdocs.

/richard

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2009-07-14 17:11

You're thumbs are square because you have the SquareThumb plugin installed. Go to Site Admin > Plugins to uninstall that.

Quote:
I used the preinstaller because I was working under the (perhaps mistaken) impression that it copies the latest G2 version directly to my server and unpacks it. If I download and unpack it on my local machine and then try to FTP it to my server, it takes all day (literally!) and fails repeatedly on timeouts, socket errors, etc.

You're right, that's the way it's suppose to work. But I can't understand why it didn't download the latest version unless your webserver doesn't have permission to overwrite the files.

Personally, that's why I will only use a host that has SSH access so I can do that stuff from the webserver directly :)

Looking at the most recent upgrade log (looks like you had issues last year too) Not surprising at Network Solutions.

Quote:
PHP memory limit: 16M

That's going to cause problems. You should have that set to at least 32MB. That's very likely what caused the errors when trying to upgrade the plugins.

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Wed, 2009-07-15 04:57

My site is sorta working now. I raised the PHP memory to 32M and got rid of the square thumbs. I have a number of add-ons that it says need to be upgraded, but it won't let me do it because of the Gallery 2.3 versions that were added back when this whole mess started. Here's an example of what I get when I click "upgrade" on the Plugins page...

Error Detail -
Error (ERROR_BAD_PLUGIN) : Unknown module version 1.1.7

* in modules/captcha/module.inc at line 106 (GalleryCoreApi::error)
* in modules/core/classes/GalleryModule.class at line 160 (CaptchaModule::upgrade)
* in modules/core/PluginCallback.inc at line 236 (GalleryModule::installOrUpgrade)
* in modules/core/PluginCallback.inc at line 73 (PluginCallbackView::handleCallback)
* in main.php at line 433 (PluginCallbackView::renderImmediate)
* in main.php at line 94
* in main.php at line 83

System Information
Gallery version 2.2.6
PHP version 5.2.6 cgi-fcgi
Webserver Apache/2.2.8 (Unix) FrontPage/5.0.2.2635
Database mysqlt 5.0.75
Toolkits ImageMagick
Operating system Linux vux9 2.6.22.10-NETSOL #1 SMP Mon Jul 14 16:26:14 EDT 2008 i686
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.11) Gecko/2009060215 Firefox/3.0.11 (.NET CLR 3.5.30729)

No option is offered to delete/deactivate/uninstall the plugin, and it does no good for me to remove it from the /modules folder.

As before, the installer and upgrader scripts refuse to process a move from Gallery 2.2.6 to 2.3. I downloaded and unpacked a copy of 2.3 into a new gallery2 folder, but now the installer refuses to accept the authentication string. Very weird.

So, I have a "running" gallery2, but can't use several of the add-ons. And, I can't find a way to upgrade. I'm reluctant to put what I have back into production.

I really regret having made such a muck of this. Is there any way to go forward...?

/richard

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2009-07-15 16:34

You should be able to manually deactivate a plugin using the method described here:
FAQ: How can I deactivate a module when I am unable to login?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Wed, 2009-07-15 20:06

I got a little further this AM: I've managed to upgrade to Gallery 2.3 after doing battle with the Upgrader.

For some reason, the 2.3 Upgrader acts like it has a timeout that is set at about 5 or 10 seconds. If I even took the time to read what was on the page it would throw me back to Step 1 when I clicked to move to the next step. After several retries, I managed to get all the way through to the "finish."

However, even though the Gallery comes up, I cannot login as admin. When I attempt to log in, it gives me a rather unhelpful error message...

Quote:
Error
An error has occurred.
Back to the Gallery

I've tried the password recovery but I get the same error. Tried the Emergency Admin PW Recovery, same result.

I've searched the FAQ and Forum info, but can find no remedy for this situation.

Does this look at all familiar...?

/richard

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2009-07-16 05:10

Please post a phpinfo link again.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Thu, 2009-07-16 17:58
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2009-07-16 20:31

session.save_path has no value. That probably need to have a path like /tmp or some place your webserver can write to
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Wed, 2009-07-22 18:44

Ok, I've updated the PHP session parms: http://ws100.com/phpinfo.php

The admin logon is still not working, though. Do I need to re-run the Updater...?

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2009-07-22 18:55

Are you getting any error message? When I go to your gallery, I get an "error has occurred" when trying to enter in fake credentials. You should get a somewhat friendly message stating that the password or username is incorrect.

Try enabling debug mode and trying to login.
FAQ: How to set/use Gallery in debug mode?

Try logging in manually:
FAQ: = How to manually login
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Wed, 2009-07-22 19:45

No, I get the same "error has occurred" response.

With debug enabled, I click login link and get a goodly amount of debug output on the login page, but nothing that jumps out at me as an error situation. I've attached it all as a file called login-debug.htm inside the login.zip.

When I attempt to log in as admin with my (supposed) correct password, I get what I've attached as login-failed.htm in the same zip file. In that case, the Error Detail expands to read:

Quote:
Error (ERROR_MISSING_VALUE) : Undefined map: FailedLoginsMap

* in modules/core/classes/GalleryStorage.class at line 1256 (GalleryCoreApi::error)
* in modules/core/classes/GalleryStorage.class at line 1248 (GalleryStorage::describeMap)
* in modules/core/classes/GalleryStorage.class at line 571 (GalleryStorage::describeMap)
* in modules/core/classes/GalleryCoreApi.class at line 2912 (GalleryStorage::getMapEntry)
* in modules/core/classes/helpers/GalleryUserHelper_medium.class at line 425 (GalleryCoreApi::getMapEntry)
* in modules/core/classes/GalleryCoreApi.class at line 3182 (GalleryUserHelper_medium::isDisabledUsername)
* in modules/core/UserLogin.inc at line 74 (GalleryCoreApi::isDisabledUsername)
* in main.php at line 250 (UserLoginController::handleRequest)
* in main.php at line 104
* in main.php at line 88

/richard

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Wed, 2009-07-22 19:53

I tried the "manual login" and got identical results.

I should add that when I tried using the Password Recovery feature, G2 sent me a recovery link at my correct email address. That would seem to indicate that the userID tables are intact and accessible.

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Wed, 2009-07-22 21:45

Looks like your database is messed up a little bit. Before you do anything BACKUP:

FAQ: How do I backup G2?

There, you've been warned :)

You can try running the upgrader again. I also found these threads:
http://gallery.menalto.com/node/84150
http://gallery.menalto.com/node/80011

http://www.google.com/search?q=Undefined+map%3A+FailedLoginsMap

I don't know if those will help or not, but there does appear to be something not right or missing in the DB:

Quote:
Error (ERROR_MISSING_VALUE) : Undefined map: FailedLoginsMap

I do see that you do have the G2.3 files on the server.

____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Thu, 2009-07-23 03:55

The Upgrader ran Ok, but didn't make any difference.

I applied the direct SQL update as shown in http://gallery.menalto.com/node/84150 and, yes, I can now login as admin!

I promptly did some testing, waded through all of the add-on's that I normally use. All works well, but when I tried to add an album (as mentioned in the http://gallery.menalto.com/node/80011 thread, it choked. I applied the direct fix mentioned there (had to change g_ to g2_) and got an error on a duplicate entry, but whatever part of it "took" seems to have turned the trick.

Unless something else pops up out of the woodwork, we can close this one out.

Thanks for all your help! Much appreciated.

/richard

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2009-07-23 04:42

Get on a backup schedule with MySQL dumps and test them to make sure you have good, useful backups. :)
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
natbarn
natbarn's picture

Joined: 2005-02-09
Posts: 26
Posted: Thu, 2009-07-23 04:54

Agree. It's in place. Thanks again. Mucho.