I could not log in to Gallery2 from either my account or the admin account. This is the error (only shown when logging in to admin):<\/p>\n
A little Googling turned up this error message with the cause being two user accounts with the same email address. To check, I logged in to the MySql server from the command line: show tables; No two users had the same email address. Another post mentioned a corrupt session map table. So:<\/p>\n Sure enough, MySql complained the table had been marked “crashed”. Next:<\/p>\n And that was it!<\/p>\n","protected":false},"excerpt":{"rendered":" I could not log in to Gallery2 from either my account or the admin account. This is the error (only shown when logging in to admin): Error (ERROR_COLLISION) in modules\/core\/classes\/GallerySession.class at line 712 (GalleryCoreApi::error) in modules\/core\/classes\/GallerySession.class at line 322 (GallerySession::_acquireNewPersistentSession) in modules\/core\/classes\/GallerySession.class at line 513 (GallerySession::start) in modules\/core\/classes\/helpers\/GalleryUserHelper_medium.class at line 362 (GallerySession::regenerate) in modules\/core\/classes\/helpers\/GalleryEventHelper_simple.class at […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1324","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1324"}],"version-history":[{"count":2,"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1324\/revisions"}],"predecessor-version":[{"id":1326,"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1324\/revisions\/1326"}],"wp:attachment":[{"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Error (ERROR_COLLISION)
\nin modules\/core\/classes\/GallerySession.class at line 712 (GalleryCoreApi::error)
\nin modules\/core\/classes\/GallerySession.class at line 322 (GallerySession::_acquireNewPersistentSession)
\nin modules\/core\/classes\/GallerySession.class at line 513 (GallerySession::start)
\nin modules\/core\/classes\/helpers\/GalleryUserHelper_medium.class at line 362 (GallerySession::regenerate)
\nin modules\/core\/classes\/helpers\/GalleryEventHelper_simple.class at line 59 (GalleryUserHelper_medium::handleEvent)
\nin modules\/core\/classes\/GalleryCoreApi.class at line 2238 (GalleryEventHelper_simple::postEvent)
\nin modules\/core\/UserLogin.inc at line 143 (GalleryCoreApi::postEvent)
\nin main.php at line 250 (UserLoginController::handleRequest)
\nin main.php at line 104
\nin main.php at line 88<\/code><\/p>\n
\nmysql -u {admin} -p -h mysql.{mysite}.com gallery2<\/p>\n
\nselect * from g2_user;<\/code><\/p>\nselect * from g2_SessionMap;<\/code><\/p>\ncheck table g2_SessionMap;
\nrepair table g2_SessionMap;<\/code><\/p>\n