I can't log in as admin. The error detail is as follows:
Error (ERROR_COLLISION)
* in modules/core/classes/GallerySession.class at line 702 (GalleryCoreApi::error)
* in modules/core/classes/GallerySession.class at line 305 (GallerySession::_acquireNewPersistentSession)
* in modules/core/classes/GallerySession.class at line 488 (GallerySession::start)
* in modules/core/classes/helpers/GalleryUserHelper_medium.class at line 327 (GallerySession::regenerate)
* in modules/core/classes/helpers/GalleryEventHelper_simple.class at line 117 (GalleryUserHelper_medium::handleEvent)
* in modules/core/classes/GalleryCoreApi.class at line 2132 (GalleryEventHelper_simple::postEvent)
* in modules/core/UserLogin.inc at line 143 (GalleryCoreApi::postEvent)
* in main.php at line 231 (UserLoginController::handleRequest)
* in main.php at line 94
* in main.php at line 83
Enabling debug in the config.php file resulted in the following MySQL error popping up:
getParameter id.anonymousUser for core plugin mysqlt error: [1016: Can't open file: 'g2_SessionMap.MYI'. (errno: 145)] in EXECUTE("INSERT INTO g2_SessionMap (g_id, g_userId, g_remoteIdentifier, g_creationTimestamp, g_modificationTimestamp, g_data) VALUES ('3f1c423d7c6bb8bee9cc6b248197fc3b',6,'a:2:{i:0;s:11:\"68.122.5.85\";i:1;s:32:\"ec12c264d66946946d3b7c4d427aac53\";}',1254419360,1254419360,'a:2:{s:13:\"core.language\";s:5:\"en_US\";s:15:\"core.navigation\";a:2:{s:9:\"x81b3833e\";a:2:{s:4:\"data\";a:3:{s:9:\"returnUrl\";s:18:\"/gallery/main.php?\";s:10:\"returnName\";s:0:\"\";s:11:\"returnNavId\";s:9:\"x4385df00\";}s:7:\"nextIds\";a:0:{}}s:9:\"x4385df00\";a:1:{s:7:\"nextIds\";a:1:{s:9:\"x81b3833e\";b:1;}}}}')")
So my guess is that there's something wrong with my SessionMap table -- perhaps a permissions issue? -- but I'm not familiar enough with mysql to know what to do to fix it. I logged into phpmyadmin, but didn't find any obvious problems.
Any assistance would be appreciated.
Thanks,
Frank
Gallery version (not just "2"): 2.2.1
PHP version (e.g. 5.1.6): 5.2.9 cgi-fcgi
PHPInfo Link (see FAQ):
Webserver (e.g. Apache 1.3.33): Apache/2.2.13 (Unix) mod_ssl/2.2.13 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Database (e.g. MySql 5.0.32): mysqlt 4.0.27-Max
Activated toolkits (e.g. NetPbm, GD): Thumbnail, SquareThumb, Gd
Operating system (e.g. Linux): Linux
Browser (e.g. Firefox 2.0): Firefox 3.5.3
Posted: Thu, 2009-10-01 18:11
Posts: 16503
I'd start with trying to clear the cache:
FAQ: How can I clear cached data?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 3
Thanks for the suggestion. Unfortunately, that didn't do the trick. I still get the same error.
I've attached a text file with the full debug output. If you see anything that jumps out at you, please let me know.
Frank
Posts: 16503
That has no debug output on it. But it does have your initial install password, so I've removed that text file.
It allowed me to get into your /lib/support. However, I wasn't able to login as admin with it so that's not the password set for your admin account
This probably isn't going to help either.
FAQ: I can't login anymore, what can I do now?
I've done a bit of searching and found these:
http://gallery.menalto.com/node/67320 < -- this one has a post about creating that table.
http://gallery.menalto.com/node/70181
So you could try dropping that table and recreating it.
BACKUP BACKUP BACKUP (You've been warned
)
I wish I could provide more guidance on mucking around in the DB, but I have to google anytime I want to do anything in there
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 3
OK, the last post on this page led me to the answer: http://gallery.menalto.com/node/70181
My SessionMap table was indeed messed up. Repairing it via PHPMyAdmin did the trick.
Thanks for all the help!
Frank