Due to some caching issues with a bridge, I thought it would be a good idea to empty the g2_User table. This has resulted in the gallery breaking. I have restores the guest and admin account in that area, but it's still not working.
This is the full error I get:
Quote:
Error
Item not found.
Back to the Gallery
Error Detail -
Error (ERROR_MISSING_OBJECT)
in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 167 (GalleryCoreApi::error)
in modules/core/classes/GalleryStorage.class at line 314 (GalleryStorageExtras::loadEntities)
in modules/core/classes/helpers/GalleryEntityHelper_simple.class at line 71 (GalleryStorage::loadEntities)
in modules/core/classes/GalleryCoreApi.class at line 2361 (GalleryEntityHelper_simple::loadEntitiesById)
in modules/core/classes/GalleryTheme.class at line 1291 (GalleryCoreApi::loadEntitiesById)
in themes/siriux/theme.inc at line 61 (GalleryTheme::loadCommonTemplateData)
in modules/core/classes/GalleryTheme.class at line 932 (SiriuxTheme::showAlbumPage)
in modules/core/classes/GalleryView.class at line 301 (GalleryTheme::loadTemplate)
in main.php at line 465 (GalleryView::doLoadTemplate)
in main.php at line 104
in main.php at line 88
Any help would be much appreciated
Posts: 8339
OUCH!
Got a recent-ish DB backup?
Which bridge?
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 39
Ran Integrity check and passed. Here is my info btw:
Gallery URL = http://www.metalinjection.net/gallery2/main.php
Gallery version = 2.3.1 core 1.3.0.1
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.3.2-1ubuntu4.5 apache2handler
Webserver = Apache/2.2.14 (Ubuntu)
Database = mysqli 5.1.41-3ubuntu12.8, lock.system=flock
Toolkits = Exif, Gd, SquareThumb
Acceleration = none, none
Operating system = Linux ip-10-80-190-33 2.6.32-305-ec2 #9-Ubuntu SMP Thu Apr 15 08:05:38 UTC 2010 x86_64
Default theme = siriux
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_1) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.186 Safari/535.1
Rows in GalleryAccessMap table = 389
Rows in GalleryAccessSubscriberMap table = 12082
Rows in GalleryUser table = 2
Rows in GalleryItem table = 12082
Rows in GalleryAlbumItem table = 588
Rows in GalleryCacheMap table = 0
Posts: 8339
when you upgraded to 2.3.1 gallery made a backup
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 39
WPG2.
I think I messed up my DB. Any help? I have like a 100 galleries, so I dont want to do a fresh install.
Posts: 39
I just updated, after it broke so the backup won't help
Posts: 8339
the best we might be able to do is remap all albums to a new owner, your new admin.
And when you say you have restored admin and guest accounts, how did you do it?
These users have specific entity ids.
I can get you the sql to fix those if you need.
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 39
I restored the admin user id (6) in the SQL database. The user is "admin"
How would I remap the albums?
Posts: 8339
use this sql to restore gallery's 2 most basic users, and use the recover password function to change your password(make sure to change the email above)
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 8339
table g2_item all g_ownerId would need to be 6
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 39
I have already restored the users, before posting here but still get this error.
http://snapplr.com/52wc
Posts: 39
Ok, I updated the owner ID and still getting the error it seems/
I really appreciate you helping me btw. thanks so much!
Posts: 8339
clear caches http://www.metalinjection.net/gallery2/lib/support/
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 39
BLESS YOUR HEART YOU DID IT!
Thanks so much!
Posts: 39
Ok the galleries show up, but now I am not seeing any images. When I try to rebuild the thumbnails I keep getting an error like this recursively:
And later stuff like this:
Should I just delete everything in cache folder?
Posts: 8339
Make sure the full sized images are ok in g2data/albums
then delete the entire cache and then try rebuilding one album at a time.
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 39
Ok, I just tried to rebuild thumbnails again after deleteing everything in my cache (albums are fine) and now I'm getting some other weird errors. Thanks again for all your help and patience.
Posts: 8339
does the squarethumb toolkit exist in that path?
is it installed?
are the directory permissions correct for that module?
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 39
Hmm, somehow it got deactivated. Getting closer. Some images are popping up, but it stops generating after like 200 images.
Here is the final error:
Posts: 8339
Gd cannot handle building square thumbs from larger images. IMHO square thumbs is a bad module.
If you have to have sq thumbs install a better graphics toolkit like imagemagick.
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 39
ImageMagick is in the modules directory right?
/gallery2/modules/imagemagick/ ??
When I go to configure the plugin and enter the path, it gives me not found errors
Any ideas?
Posts: 8339
nope, that's just gallery's files to communicate with the imageMagick binary installed on your server.
http://codex.gallery2.org/Gallery2:Installing_Modules_With_External_Dependencies
imageMagick is usually in /usr/bin or /usr/local/bin for *nix systems(if installed at all)
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 39
Alright, I got the thumbnails working.
Now I am having an issue adding new items.
This is the error I get:
Posts: 8339
these errors are printed in plain english.
does the itemAdd module exist, and is it installed?
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2