[watermark] still begging for help: centering the mark gives a mysql-error

cadeira Joined: 2007-05-15 Posts: 21	Posted: Tue, 2007-05-22 22:35
	hi folks, i am refering to this thread: http://gallery.menalto.com/node/62767 after trying to tweak thy database i get the following eror: Error Detail - Error (ERROR_MISSING_OBJECT) : Missing object for 113 * in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1887 (gallerycoreapi::error) * in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 98 (gallerystorageextras::_identifyentities) * in modules/core/classes/GalleryStorage.class at line 298 (gallerystorageextras::loadentities) * in modules/core/classes/helpers/GalleryEntityHelper_simple.class at line 71 (mysqlstorage::loadentities) * in modules/core/classes/GalleryCoreApi.class at line 2251 (galleryentityhelper_simple::loadentitiesbyid) * in modules/watermark/WatermarkOption.inc at line 96 (gallerycoreapi::loadentitiesbyid) * in modules/core/ItemAdd.inc at line 146 (watermarkoption::handlerequestafteradd) * in main.php at line 231 (itemaddcontroller::handlerequest) * in main.php at line 94 * in main.php at line 83 System Information Gallery version 2.2.1 PHP version 4.4.6 apache Webserver Apache Database mysqlt 4.1.21-standard-log Toolkits ImageMagick Operating system Linux goofy.cirtexhosting.com 2.6.9-55.ELsmp #1 SMP Wed May 2 14:28:44 EDT 2007 i686 Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3 obviously the only thing that happens, is that no watermarks are applied at all anymore. but i cannot interprete what the error code says. if anybody can, i would be very pleased if he or she lets me know how to get the watermarks back. also tell me if you need further information. thanks!
	XUser login Username: * Password: * Create new account Request new password
cadeira Joined: 2007-05-15 Posts: 21	Posted: Wed, 2007-05-23 18:42
	if this is the wrong place or I didn´t see an important faq entry i´m sorry but i really do not know how to solve it on my own without screwing up the db. anne

cadeira Joined: 2007-05-15 Posts: 21	Posted: Fri, 2007-05-25 19:22
	update: nothing new, just my resignation is rising. i don´t want to bother anyone but i dont get the error... in the faq i found the thing about debug mode. here´s the link to the text-file i created: http://goofy.cirtexhosting.com/~qualsde/gallery2/debug_result.txt

valiant Joined: 2003-01-04 Posts: 32509	Posted: Fri, 2007-05-25 20:07
	Error (ERROR_MISSING_OBJECT) : Missing object for 113 canned response: DATA INTEGRITY: Error (ERROR_MISSING_OBJECT) : Missing object for ... some part of your g2 database isn't 100% ok, the data integrity is a little corrupted. reason: unknown. fix: it's not easy, but you can fix the database manually, someone else had the same problem and i gave a few instructions: http://gallery.menalto.com/node/57319#comment-209935 http://gallery.menalto.com/node/32741 http://gallery.menalto.com/node/38916

cadeira Joined: 2007-05-15 Posts: 21	Posted: Sat, 2007-05-26 09:50
	thanks for your answer, i already read in some of the threads and i´m about to work on it. the first thing i noticed was something in phpmyadmin internface: in table g2_AccessMap Indexes: Documentation Keyname Type Cardinality Action Field PRIMARY PRIMARY 60 Edit Drop g_accessListId g_userOrGroupId g2_AccessMap_83732 INDEX 30 Edit Drop g_accessListId g2_AccessMap_48775 INDEX 4 Edit Drop g_userOrGroupId g2_AccessMap_18058 INDEX 5 Edit Drop g_permission PRIMARY and INDEX keys should not both be set for column `g_accessListId` and then in table g2_FactoryMap No index defined! in table g2_NotificationSubscriptions More than one INDEX key was created for column `g_eventClass` in table g2_PluginParameterMap UNIQUE and INDEX keys should not both be set for column `g_pluginType` and More than one INDEX key was created for column `g_pluginType` in table g2_RatingMap More than one INDEX key was created for column `g_itemId` in table g2_SequenceId No index defined! in table g2_SequenceLock No index defined! in table g2_TkPropertyMap No index defined! and in table g2_WebDavLockMap also No index defined! i have the feeling it might be something with the indexes?! although i have no idea in which way... because i have no items in my database. i´m trying to set up everything, so there´s only one photo with which i´m trying out everything. it mus be something with the watermark table, because before i changed manually everthing worked out fine. i´ve created another debug output file which was created when i tried to upload the pic, the watermark should have been created but wasn´t. the pic itself is intact. http://goofy.cirtexhosting.com/~qualsde/gallery2/debug_result_upload.txt

valiant Joined: 2003-01-04 Posts: 32509	Posted: Sat, 2007-05-26 11:19
	> i have the feeling it might be something with the indexes?! no. (the warnings about missing and duplicate indexes by phpmyadmin can be ignored) -------------- Documentation: Support / Troubleshooting \| Installation, Upgrade, Configuration and Usage

cadeira Joined: 2007-05-15 Posts: 21	Posted: Sat, 2007-05-26 11:58
	okay, this is good to know. i mean there can be no problem with derivates or items for i have none of them. where then shall i search for the mistake? the thumbnails are created but not the watermarks, so this is very strange. after deleting the cache i get this: [...] readdir(Resource id #113) is_dir(/home/qualsde/public_html/gallery2/g2data/cache/module/watermark) recursiveRmdir(/home/qualsde/public_html/gallery2/g2data/cache/module/watermark) opendir(/home/qualsde/public_html/gallery2/g2data/cache/module/watermark/) [...] systeminformation this: Quote: (mysqlt): UPDATE g2_SessionMap SET g_userId=6, g_remoteIdentifier='a:2:{i:0;s:10:\"89.56.41.1\";i:1;s:32:\"7bfbd9032c0f48cadec38da37e2e0890\";}', g_creationTimestamp=1179781352, g_modificationTimestamp=1180180235, g_data='a:11:{s:13:\"core.language\";s:5:\"de_DE\";s:15:\"core.navigation\";a:10:{s:9:\"xc4528249\";a:2:{s:4:\"data\";a:2:{s:9:\"returnUrl\";s:27:\"/~qualsde/gallery2/main.php\";s:10:\"returnName\";s:5:\"Album\";}s:7:\"nextIds\";a:0:{}}s:9:\"xf0ee2fac\";a:2:{s:4:\"data\";a:2:{s:9:\"returnUrl\";s:41:\"/~qualsde/gallery2/main.php?g2_itemId=123\";s:10:\"returnName\";s:5:\"Photo\";}s:7:\"nextIds\";a:1:{s:9:\"x878a0658\";b:1;}}s:9:\"x878a0658\";a:2:{s:4:\"data\";a:3:{s:9:\"returnUrl\";s:89:\"/~qualsde/gallery2/main.php?g2_itemId=31&g2_statusId=xe118e787&g2_navId=xf0ee2fac\";s:10:\"returnName\";s:5:\"Album\";s:11:\"returnNavId\";s:9:\"xf0ee2fac\";}s:7:\"nextIds\";a:0:{}}s:9:\"xed21b54c\";a:1:{s:7:\"nextIds\";a:1:{s:9:\"x7d36e8d0\";b:1;}}s:9:\"x7d36e8d0\";a:2:{s:4:\"data\";a:3:{s:9:\"returnUrl\";s:64:\"/~qualsde/gallery2/main.php?g2_itemId=135&g2_navId=xed21b54c\";s:10:\"returnName\";s:5:\"Photo\";s:11:\"returnNavId\";s:9:\"xed21b54c\";}s:7:\"nextIds\";a:0:{}}s:9:\"x1021e0e3\";a:2:{s:4:\"data\";a:2:{s:9:\"returnUrl\";s:121:\"/~qualsde/gallery2/main.php?g2_view=core.SiteAdmin&g2_subView=watermark.WatermarkSiteAdminEdit&g2_watermarkId=132\";s:10:\"returnName\";s:10:\"site admin\";}s:7:\"nextIds\";a:0:{}}s:9:\"x49ead43c\";a:2:{s:4:\"data\";a:3:{s:9:\"returnUrl\";s:63:\"/~qualsde/gallery2/main.php?g2_itemId=31&g2_navId=x9aaeab39\";s:10:\"returnName\";s:5:\"Album\";s:11:\"returnNavId\";s:9:\"x9aaeab39\";}s:7:\"nextIds\";a:0:{}}s:9:\"x9aaeab39\";a:1:{s:7:\"nextIds\";a:1:{s:9:\"x49ead43c\";b:1;}}s:9:\"x2b03f5cd\";a:2:{s:4:\"data\";a:2:{s:9:\"returnUrl\";s:40:\"/~qualsde/gallery2/main.php?g2_itemId=31\";s:10:\"returnName\";s:5:\"Album\";}s:7:\"nextIds\";a:0:{}}s:9:\"x8ad3bb97\";a:2:{s:4:\"data\";a:2:{s:9:\"returnUrl\";s:27:\"/~qualsde/gallery2/main.php\";s:10:\"returnName\";s:5:\"Album\";}s:7:\"nextIds\";a:0:{}}}s:11:\"captcha.key\";s:6:\"289735\";s:15:\"permissionCache\";a:6:{i:0;a:19:{s:11:\"comment.add\";a:1:{i:7;i:1;}s:11:\"comment.all\";a:1:{i:7;i:1;}s:14:\"comment.delete\";a:1:{i:7;i:1;}s:12:\"comment.edit\";a:1:{i:7;i:1;}s:12:\"comment.view\";a:1:{i:7;i:1;}s:17:\"core.addAlbumItem\";a:1:{i:7;i:1;}s:16:\"core.addDataItem\";a:1:{i:7;i:1;}s:8:\"core.all\";a:1:{i:7;i:1;}s:22:\"core.changePermissions\";a:1:{i:7;i:1;}s:11:\"core.delete\";a:1:{i:7;i:1;}s:9:\"core.edit\";a:1:{i:7;i:1;}s:9:\"core.view\";a:1:{i:7;i:1;}s:12:\"core.viewAll\";a:1:{i:7;i:1;}s:16:\"core.viewResizes\";a:1:{i:7;i:1;}s:15:\"core.viewSource\";a:1:{i:7;i:1;}s:10:\"rating.add\";a:1:{i:7;i:1;}s:10:\"rating.all\";a:1:{i:7;i:1;}s:11:\"rating.view\";a:1:{i:7;i:1;}s:8:\"cart.add\";a:1:{i:7;i:1;}}i:1;a:19:{s:11:\"comment.add\";a:1:{i:7;i:1;}s:11:\"comment.all\";a:1:{i:7;i:1;}s:14:\"comment.delete\";a:1:{i:7;i:1;}s:12:\"comment.edit\";a:1:{i:7;i:1;}s:12:\"comment.view\";a:1:{i:7;i:1;}s:17:\"core.addAlbumItem\";a:1:{i:7;i:1;}s:16:\"core.addDataItem\";a:1:{i:7;i:1;}s:8:\"core.all\";a:1:{i:7;i:1;}s:22:\"core.changePermissions\";a:1:{i:7;i:1;}s:11:\"core.delete\";a:1:{i:7;i:1;}s:9:\"core.edit\";a:1:{i:7;i:1;}s:9:\"core.view\";a:1:{i:7;i:1;}s:12:\"core.viewAll\";a:1:{i:7;i:1;}s:16:\"core.viewResizes\";a:1:{i:7;i:1;}s:15:\"core.viewSource\";a:1:{i:7;i:1;}s:10:\"rating.add\";a:1:{i:7;i:1;}s:10:\"rating.all\";a:1:{i:7;i:1;}s:11:\"rating.view\";a:1:{i:7;i:1;}s:8:\"cart.add\";a:1:{i:7;i:1;}}i:2;a:19:{s:11:\"comment.add\";a:1:{i:7;i:1;}s:11:\"comment.all\";a:1:{i:7;i:1;}s:14:\"comment.delete\";a:1:{i:7;i:1;}s:12:\"comment.edit\";a:1:{i:7;i:1;}s:12:\"comment.view\";a:1:{i:7;i:1;}s:17:\"core.addAlbumItem\";a:1:{i:7;i:1;}s:16:\"core.addDataItem\";a:1:{i:7;i:1;}s:8:\"core.all\";a:1:{i:7;i:1;}s:22:\"core.changePermissions\";a:1:{i:7;i:1;}s:11:\"core.delete\";a:1:{i:7;i:1;}s:9:\"core.edit\";a:1:{i:7;i:1;}s:9:\"core.view\";a:1:{i:7;i:1;}s:12:\"core.viewAll\";a:1:{i:7;i:1;}s:16:\"core.viewResizes\";a:1:{i:7;i:1;}s:15:\"core.viewSource\";a:1:{i:7;i:1;}s:10:\"rating.add\";a:1:{i:7;i:1;}s:10:\"rating.all\";a:1:{i:7;i:1;}s:11:\"rating.view\";a:1:{i:7;i:1;}s:8:\"cart.add\";a:1:{i:7;i:1;}}i:3;a:19:{s:11:\"comment.add\";a:1:{i:7;i:1;}s:11:\"comment.all\";a:1:{i:7;i:1;}s:14:\"comment.delete\";a:1:{i:7;i:1;}s:12:\"comment.edit\";a:1:{i:7;i:1;}s:12:\"comment.view\";a:1:{i:7;i:1;}s:17:\"core.addAlbumItem\";a:1:{i:7;i:1;}s:16:\"core.addDataItem\";a:1:{i:7;i:1;}s:8:\"core.all\";a:1:{i:7;i:1;}s:22:\"core.changePermissions\";a:1:{i:7;i:1;}s:11:\"core.delete\";a:1:{i:7;i:1;}s:9:\"core.edit\";a:1:{i:7;i:1;}s:9:\"core.view\";a:1:{i:7;i:1;}s:12:\"core.viewAll\";a:1:{i:7;i:1;}s:16:\"core.viewResizes\";a:1:{i:7;i:1;}s:15:\"core.viewSource\";a:1:{i:7;i:1;}s:10:\"rating.add\";a:1:{i:7;i:1;}s:10:\"rating.all\";a:1:{i:7;i:1;}s:11:\"rating.view\";a:1:{i:7;i:1;}s:8:\"cart.add\";a:1:{i:7;i:1;}}i:4;a:19:{s:11:\"comment.add\";a:3:{i:15;i:1;i:17;i:1;i:19;i:1;}s:11:\"comment.all\";a:3:{i:15;i:1;i:17;i:1;i:19;i:1;}s:14:\"comment.delete\";a:2:{i:15;i:1;i:17;i:1;}s:12:\"comment.edit\";a:2:{i:15;i:1;i:17;i:1;}s:12:\"comment.view\";a:2:{i:15;i:1;i:17;i:1;}s:17:\"core.addAlbumItem\";a:2:{i:15;i:1;i:17;i:1;}s:16:\"core.addDataItem\";a:2:{i:15;i:1;i:17;i:1;}s:8:\"core.all\";a:2:{i:15;i:1;i:17;i:1;}s:22:\"core.changePermissions\";a:2:{i:15;i:1;i:17;i:1;}s:11:\"core.delete\";a:2:{i:15;i:1;i:17;i:1;}s:9:\"core.edit\";a:2:{i:15;i:1;i:17;i:1;}s:9:\"core.view\";a:2:{i:15;i:1;i:17;i:1;}s:12:\"core.viewAll\";a:2:{i:15;i:1;i:17;i:1;}s:16:\"core.viewResizes\";a:2:{i:15;i:1;i:17;i:1;}s:15:\"core.viewSource\";a:2:{i:15;i:1;i:17;i:1;}s:10:\"rating.add\";a:2:{i:15;i:1;i:17;i:1;}s:10:\"rating.all\";a:2:{i:15;i:1;i:17;i:1;}s:11:\"rating.view\";a:2:{i:15;i:1;i:17;i:1;}s:8:\"cart.add\";a:2:{i:15;i:1;i:17;i:1;}}i:5;a:19:{s:11:\"comment.add\";a:3:{i:7;i:1;i:15;i:1;i:30;i:1;}s:11:\"comment.all\";a:3:{i:7;i:1;i:15;i:1;i:30;i:1;}s:14:\"comment.delete\";a:2:{i:7;i:1;i:15;i:1;}s:12:\"comment.edit\";a:2:{i:7;i:1;i:15;i:1;}s:12:\"comment.view\";a:2:{i:7;i:1;i:15;i:1;}s:17:\"core.addAlbumItem\";a:2:{i:7;i:1;i:15;i:1;}s:16:\"core.addDataItem\";a:2:{i:7;i:1;i:15;i:1;}s:8:\"core.all\";a:2:{i:7;i:1;i:15;i:1;}s:22:\"core.changePermissions\";a:2:{i:7;i:1;i:15;i:1;}s:11:\"core.delete\";a:2:{i:7;i:1;i:15;i:1;}s:9:\"core.edit\";a:2:{i:7;i:1;i:15;i:1;}s:9:\"core.view\";a:2:{i:7;i:1;i:15;i:1;}s:12:\"core.viewAll\";a:2:{i:7;i:1;i:15;i:1;}s:16:\"core.viewResizes\";a:2:{i:7;i:1;i:15;i:1;}s:15:\"core.viewSource\";a:2:{i:7;i:1;i:15;i:1;}s:10:\"rating.add\";a:2:{i:7;i:1;i:15;i:1;}s:10:\"rating.all\";a:2:{i:7;i:1;i:15;i:1;}s:11:\"rating.view\";a:2:{i:7;i:1;i:15;i:1;}s:8:\"cart.add\";a:2:{i:7;i:1;i:15;i:1;}}}s:14:\"core.authToken\";s:12:\"d82b8f2e7e2e\";s:15:\"core.lastViewed\";a:15:{i:7;i:339149;i:91;i:49964;i:82;i:50189;i:75;i:50200;i:28;i:50422;i:15;i:388728;i:30;i:388732;i:31;i:388735;i:97;i:54836;i:123;i:55381;i:126;i:55416;i:135;i:91119;i:150;i:91751;i:157;i:92640;i:164;i:390594;}s:22:\"theme.guestPreviewMode\";i:0;s:11:\"core.status\";a:5:{s:9:\"x15480026\";a:1:{s:3:\"run\";a:2:{s:7:\"success\";b:1;s:6:\"taskId\";s:20:\"OptimizeDatabaseTask\";}}s:9:\"xba45f4e7\";a:1:{s:3:\"run\";a:2:{s:7:\"success\";b:1;s:6:\"taskId\";s:18:\"FlushTemplatesTask\";}}s:9:\"x442a7d1c\";a:1:{s:3:\"run\";a:2:{s:7:\"success\";b:1;s:6:\"taskId\";s:22:\"FlushDatabaseCacheTask\";}}s:9:\"x638c2329\";a:1:{s:3:\"run\";a:2:{s:7:\"success\";b:1;s:6:\"taskId\";s:14:\"SystemInfoTask\";}}s:9:\"xf81c03e8\";a:1:{s:3:\"run\";a:2:{s:6:\"taskId\";s:14:\"SystemInfoTask\";s:7:\"success\";b:1;}}}s:46:\"core.view.ItemEdit.editPlugin.galleryalbumitem\";s:13:\"ItemEditTheme\";s:44:\"core.view.ItemAdd.addPlugin.galleryalbumitem\";s:18:\"ItemAddFromBrowser\";s:29:\"exif.module.LoadExifInfo.mode\";s:7:\"summary\";}' WHERE g_id='6342a168e843fa727cf61fae4d5f3105' integrity check this: Quote: Checked 37 entities Orphaned data in table AccessSubscriberMap with no row in Item table; ids: 132 Orphaned data in table AccessMap with no row in AccessSubscriberMap table; ids: 8, 9, 9, 11, 11, 13, 13, 16, 16, 16, 18, 18, 18, 20, 20, 20, 22, 22, 22, 24, 24, 24, 26, 26, 26, 92, 92, 92, 95, 96, 96, 114, 115, 115, 130, 131, 131, 133 Orphaned data in table PluginParameterMap with no row in PluginMap table; ids: module/core, module/multiroot, module/rewrite what does that mean no row? can insert something to fix it?

valiant Joined: 2003-01-04 Posts: 32509	Posted: Sat, 2007-05-26 12:12
	look in these tables for g_id = 113 g2_Entity g2_ChildEntity g2_WatermarkImage g2_Derivative g2_DerivativeImage and also for derivativeSourceId 113 in g2_Derivative and parentId = 113 in g2_ChildEntity and ownerId = 113 in g2_Item i guess you'll find something in either g2_Entity or in WatermarkImage. -------------- Documentation: Support / Troubleshooting \| Installation, Upgrade, Configuration and Usage

cadeira Joined: 2007-05-15 Posts: 21	Posted: Sat, 2007-05-26 12:32
	ok and if i find, what do i do then? also, i have another problem: only if you have time can you have a look at my page and tell me what this is: http://goofy.cirtexhosting.com/~qualsde/gallery2/main.php if i scroll down the page it seems endless and there are lines across the screen, wit FF and IE both the same or shall i make a new thread for this one?

valiant Joined: 2003-01-04 Posts: 32509	Posted: Sat, 2007-05-26 15:15
	> ok and if i find, what do i do then? depends on what you find. repair the entity. @endless page: it's black text on black background, thus you don^t see it. but the debug output is there. anyhow, please take a look at the above canned response / try to find where the entity with id 113 is coming from and what's wrong with it. -------------- Documentation: Support / Troubleshooting \| Installation, Upgrade, Configuration and Usage

cadeira Joined: 2007-05-15 Posts: 21	Posted: Wed, 2007-06-06 20:20
	i just wanted to say that i don´t have the problem anymore although i don´t know what it was about. i think i have to learn more about mysql because searching didn´t work the way i thought it would. thanks a lot anyway!!

[watermark] still begging for help: centering the mark gives a mysql-error

XUser login