Debug Output
getParameter permissions.file for core plugin file_exists(/www/s/schneidercc/htdocs/gallery/g2data/cache/module/core/0/0/0.inc) file_exists(/www/s/schneidercc/htdocs/gallery/g2data/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc) file_exists(/www/s/schneidercc/htdocs/gallery/modules/core/classes/helpers/../../../../modules/rewrite/classes/RewriteUrlGenerator.class)
(mysql): SELECT g2_RewriteMap.g_match, g2_RewriteMap.g_pattern FROM g2_RewriteMap WHERE g2_RewriteMap.g_match != ''
file_exists(/www/s/schneidercc/htdocs/gallery/g2data/sessions/686d2787b2dc6eeca650f4bedb4bdd74) getParameter session.lifetime for core plugin getParameter session.inactivityTimeout for core plugin stat(/www/s/schneidercc/htdocs/gallery/g2data/sessions/686d2787b2dc6eeca650f4bedb4bdd74) file_exists(/www/s/schneidercc/htdocs/gallery/g2data/sessions/686d2787b2dc6eeca650f4bedb4bdd74) getParameter cookie.domain for core plugin getParameter cookie.path for core plugin getParameter galleryLocation for rewrite plugin file_exists(/www/s/schneidercc/htdocs/gallery/g2data/cache/module/rewrite/0/0/0.inc) Loading plugin core Class not defined, trying to include it. file_exists(/www/s/schneidercc/htdocs/gallery/modules/core/classes/helpers/../../../../modules/core/module.inc) realpath(/www/s/schneidercc/htdocs/gallery/modules/core/classes/../../..) Binding text domain: modules_core -> /www/s/schneidercc/htdocs/gallery/modules/core/locale core plugin successfully instantiated file_exists(/www/s/schneidercc/htdocs/gallery/g2data/versions.dat) file(/www/s/schneidercc/htdocs/gallery/g2data/versions.dat, ) [1144018561] can't guarantee 5 -- extending! file_exists(/www/s/schneidercc/htdocs/gallery/g2data/cache/entity/0/0/6.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin file_exists(/www/s/schneidercc/htdocs/gallery/g2data/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the core plugin is ok file_exists(/www/s/schneidercc/htdocs/gallery/modules/core/classes/../../../modules/core/ItemAdd.inc) file_exists(/www/s/schneidercc/htdocs/gallery/g2data/cache/entity/0/0/7.inc) getParameter lock.system for core plugin fopen(/www/s/schneidercc/htdocs/gallery/g2data/locks/0/7/7, wb+, 0) flock(Resource id #69, 5, ) file_exists(/www/s/schneidercc/htdocs/gallery/modules/core/classes/helpers/../../../../modules/core/ItemAddFromBrowser.inc) file_exists(/www/s/schneidercc/htdocs/gallery/g2data/cache/module/_all/0/0/GalleryMimeTypeHelper_mimeData.inc) file_exists(/www/s/schneidercc/htdocs/gallery/modules/core/classes/helpers/../../../../modules/core/classes/GalleryUnknownItem.class) is_uploaded_file(/www/tmp/phpGKYIXa)
(mysql): SELECT COUNT(g2_ChildEntity.g_id) FROM g2_ChildEntity, g2_FileSystemEntity WHERE g2_ChildEntity.g_parentId = 7 AND g2_FileSystemEntity.g_pathComponent = '2005 Teams.pdf' AND g2_ChildEntity.g_id = g2_FileSystemEntity.g_id
(mysql): update g2_SequenceId set id=LAST_INSERT_ID(id+1);
copy(/www/tmp/phpGKYIXa, /www/s/schneidercc/htdocs/gallery/g2data/albums/2005 Teams.pdf) filesize(/www/s/schneidercc/htdocs/gallery/g2data/albums/2005 Teams.pdf)
(mysql): SELECT g2_TkPropertyMimeTypeMap.g_toolkitId FROM g2_TkPropertyMap, g2_TkPropertyMimeTypeMap WHERE g2_TkPropertyMap.g_name = g2_TkPropertyMimeTypeMap.g_propertyName AND g2_TkPropertyMimeTypeMap.g_mimeType = 'application/pdf' AND g2_TkPropertyMap.g_name = 'originationTimestamp'
mysql error: [1062: Duplicate entry '76' for key 1] in EXECUTE("INSERT INTO g2_AccessSubscriberMap (g_itemId, g_accessListId) VALUES (76,0)")
(mysql): INSERT INTO g2_AccessSubscriberMap (g_itemId, g_accessListId) VALUES (76,0)
1062: Duplicate entry '76' for key 1
adodb_mysql._execute(INSERT INTO g2_AccessSubscriberMap
(g_itemId, g_accessListId) VALUES (76,0)) % line 836, file: adodb.inc.php
adodb_mysql.execute(INSERT INTO
g2_AccessSubscriberMap (g_itemId, g_accessListId) VALUES (?,?),
Array[2]) % line 1235, file: DatabaseStorage.class
mysqldatabasestorage.addmapentry(GalleryAccessSubscriberMap,
Array[2]) % line 294, file: GalleryStorage.class
gallerystorage.addmapentry(GalleryAccessSubscriberMap,
Array[2]) % line 95, file: GalleryAccessSubscriberMap.inc
galleryaccesssubscribermap.addmapentry(Array[2]) % line 272, file: GalleryEntity.class
fclose(Resource id #69) file_exists(/www/s/schneidercc/htdocs/gallery/g2data/locks/0/7/7) unlink(/www/s/schneidercc/htdocs/gallery/g2data/locks/0/7/7) getParameter default.theme for core plugin Loading plugin matrix Class not defined, trying to include it. file_exists(/www/s/schneidercc/htdocs/gallery/modules/core/classes/helpers/../../../../themes/matrix/theme.inc) matrix plugin successfully instantiated Check the version of the matrix plugin file_exists(/www/s/schneidercc/htdocs/gallery/g2data/cache/theme/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the matrix plugin is ok Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok file_exists(/www/s/schneidercc/htdocs/gallery/modules/core/classes/../../../modules/core/ErrorPage.inc) getParameter id.adminGroup for core plugin
(mysql): SELECT g2_UserGroupMap.g_userId FROM g2_UserGroupMap WHERE g2_UserGroupMap.g_userId = 6 AND g2_UserGroupMap.g_groupId = '3' LIMIT 1
realpath(/www/s/schneidercc/htdocs/gallery/modules/core/classes/../../../)
(mysql): SELECT g2_TkOperatnMimeTypeMap.g_mimeType, g2_TkOperatnMimeTypeMap.g_toolkitId FROM g2_TkOperatnMimeTypeMap WHERE g2_TkOperatnMimeTypeMap.g_operationName = 'thumbnail' ORDER BY g2_TkOperatnMimeTypeMap.g_mimeType ASC, g2_TkOperatnMimeTypeMap.g_priority ASC
file_exists(/www/s/schneidercc/htdocs/gallery/modules/core/classes/../../../lib/javascript/local/BlockToggle.js) file_exists(/www/s/schneidercc/htdocs/gallery/g2data/smarty/templates_c/%%2949118716) is_dir(/www/s/schneidercc/htdocs/gallery/g2data/smarty/templates_c/%%2949118716) file_exists(/www/s/schneidercc/htdocs/gallery/g2data/smarty/templates_c/%%2949118716) is_writeable(/www/s/schneidercc/htdocs/gallery/g2data/smarty/templates_c/%%2949118716) file_exists(/www/s/schneidercc/htdocs/gallery/g2data/smarty/templates_c/%%2949118716/v_8) realpath(/www/s/schneidercc/htdocs/gallery/modules/core/classes/../../..) Binding text domain: themes_matrix -> /www/s/schneidercc/htdocs/gallery/themes/matrix/locale file_exists(/www/s/schneidercc/htdocs/gallery/modules/core/classes/../../../themes/matrix/local/theme.css)
Posted: Mon, 2006-04-03 00:26
Posts: 8601
try clearing the db cache in site admin / maintenance,
try adding back that row and clearing cache again,
try changing that row to 76, (some valid id in g2_AccessMap) instead of zero, clear cache again.
these are just guesses really, but hope it helps.
Posts: 30
I ran all of the Administrative programs and was then able to create an album. When I tried to upload a file, I received the following
Any help would be appreciated!
Posts: 5
I am having the exact same problem.
Posts: 30
Interestingly enough, I got an error while uploading two items but when I went back to the album they were there. I tried again and again to no avail. This is frustrating because I had everything working perfect and LOVED IT!
Please help with some correction ideas. Thanks!
Posts: 8601
- restore from most recent backup
- make a new G2 install and import your photos, manually readd any captions, etc
- make a new G2 install and write scripts to migrate data from the old one
- debug the problem and manually fix the database, or find someone who can..
Posts: 20
Mindless,
Is this the only solution? I am also having the same problem, but with an 86 instead of 76.
Attached is my debug output, here is my error message:
file_exists(D:\inetpub\wwwroot\g201data\cache\module/_all/0/0/GalleryStorage_describeMap.inc) mysql error: [1062: Duplicate entry '86' for key 1] in EXECUTE("INSERT INTO g2_AccessSubscriberMap (g_itemId, g_accessListId) VALUES (86,0)")
if anybody can help us with this problem we would GREATLY appreciate it! As TallPaul mentioned, everything was working fine and now we can't add photos.
Posts: 8601
if any of you want to PM me G2 site admin access and server ssh access (or ftp access + phpmyadmin access) I can look into it.
Posts: 20
I would be happy to do this but unfortunately I am behind a company firewall and you wouldn't be able to get to the server... (that's why I am anxious to get this problem resolved, we cannot add any photos to our gallery until this is fixed)
what about you TallPaul, can you hook Mindless up with access to your gallery?
Posts: 30
I have PM you mindless with details. Would really appreciate your help!
Posts: 5
Anyone get it to work?
Posts: 20
YES!! I believe I have found a solution!!! Here's what I did to fix it (I hope this works for you!!!) Please make sure you back up a copy of your database, I am not a MySQL expert but I figured this one out on my own. PLEASE BACK UP FIRST! P.S. I am using Gallery 2.1.
1. I recommend going into your g2data folder and removing any files that you have added that failed but do not show up in your gallery (just for posterity to clean out any orphan files). Sometimes they will still show up in the g2data folder even though the upload failed.
2. You need to change your g2_sequenceid to a different value. I chose a HUGE number like 3000 to avoid any conflicts with lower # g2_sequenceIDs. If you hover over your most recent photo in your gallery, you will see that the URL contains a g2_itemId. To do this, do the following:
Open MySQL command line client. I typed the following:
USE gallery2;
SELECT * FROM gallery2.g2_sequenceid;
note the id # listed. It will probably be the same # as the duplicate error ID you received in your error message. For instance, the example in the message above was 76. We're going to delete all of them and create a new g2_sequenceid.
DELETE FROM gallery2.g2_sequenceid where ID = 76;
repeat the process for all other sequenceIds in your table.
now, we need to create a NEW one... this is a trial and error process. Try to find out what your highest ID is and increase it by 100 or 200, or even 1000. I had problems when I used 2000 so I kicked it up to 3000 and have had no problems!
*EDIT* - per mindless on 4/6/06: If you don't have multiple rows in g2_SequenceId but just one bad value, then you can find the right value to add there as follows:
select max(g_id) from g2_Entity;
Put a value one higher than that into your g2_SequenceId table.
For instance, if your max(g_id) is 2999, you would next execute this line:
INSERT INTO gallery2.g2_sequenceid (id) values (3000);
3. The next step is to clear all the nastiness that resides in your cache. Go to http://yourgallerysite.com/gallery2/lib/support - then click on Cache Maintenance and click Clear cache (left the default boxes checked).
If you still get errors, try deleting the g2_sequenceid and create it again with a higher value.
This worked for me. I sincerely hope it helps all of the other 9 or 10 people in this forum experiencing the same problems. It would probably also be a good idea to delete template cache, db cache, and optimize your db in the Site Admin -> Maintenance area.
Good luck!
SoulCages
Posts: 8601
I took a look at MrTallPaul's site.. the problem is with the g2_SequenceId table. It should have only one row, but there were 5 rows in there. I removed all but the row with the LARGEST value and it seems ok now.
So, others with this problem please check your g2_SequenceId table. If the problem shows up again, please let us know what you did right before the problem appeared.. I don't know how those extra rows got there.
just before posting this I see SoulCages01's post..
If you don't have multiple rows in g2_SequenceId but just one bad value, then you can find the right value to add there as follows:
select max(g_id) from g2_Entity;
Put a value one higher than that into your g2_SequenceId table.
Posts: 20
Thanks mindless... I didn't know that parameter or else I would have provided that. Glad we have resolved this nasty problem!
Posts: 30
Mindless - Thanks for your help. I am still receiving one error though when I upload photos
The photo uploads, but it looks like it doesn't and is a pain. Any suggestions?
Posts: 20
TallPaul, did you try deleting your db cache at http://sitename.com/gallery2/lib/support ?
Good luck,
SoulCages
Posts: 30
I FOUND THE SOLUTION!!! Folders and Photos actually uploaded. Once I deleted the ones that didn't show on Gallery, it worked fine.
This whole issue started one day when an error occurred while uploading. It would seem that to fix one would first delete the file/folder, and then delete multiple Sequence ID values if necessary.
THANKS FOR EVERYONE'S HELP!
Posts: 2
I wanted to add to this since I just ran into this error also.
After uploading 2950 items to a Gallery 2.1 install I ran into the (Error_Storage_Failure) after running a "Optimize DB".
Before doing the optimization I was able to complete uploads using the browser interface and Remote 1.5.
It was at the point after running the optimize DB that I noticed that on the browser upload interface I was getting (Error_Storage_Failure) and on the Remote 1.5 upload I was receiving "Upload Failed ."
I checked the sequence_id table and it contained 3 rows. I backed up the entire DB. Did a select statement on the sequence_id table and found the 3 rows.
I kept the largest value in the id column and deleted the remaining 2. After completing this I was able to upload using the browser interface and Remote 1.5.
By the way, great troubleshooting on the person that found the issue.
Posts: 2
I ran into the issue after running an "Optimize Database" from the Site Admin side.
Posts: 13
You guys are awesome - I know there will be a lot of people happy to see this one resolved. I have no clue how this one was figured out - WAYYYY too technical for me.
Anyways - if I could just ask one last question - could someone please explain to me how to edit the sequence_id table? I'm in the phpMyAdmin interface for mySQL and I've found the sequence_id table, I just don't know what to do now. Any help is greatly appreciated.
Sincerely,
hh
UPDATE: Okay, I think I'm in deep do-do now....... Here's what my sequence_id table says
g2_SequenceId
Field Type Null Default
id int(11) No 0
Space usage: Type Usage
Data 15 Bytes
Index 1,024 Bytes
Total 1,039 Bytes
Row Statistics: Statements Value
Format fixed
Rows 3
Row length ø 5
Row size ø 346 Bytes
Creation Mar 09, 2006 at 09:29 AM
Last update Apr 07, 2006 at 07:16 AM
******it also has a warning that there is "no Index Defined". I assume I did something really wrong here..... anyone.....help......please......
Posts: 8601
in phpMyAdmin, find the g2_SequenceId table and click "browse" to see the rows.
if there are multiple rows click "delete" for each row except the one with the largest value.
if there is a single row then click the "sql" button in the very upper left.. in the popup window type
select max(g_id) from g2_Entityand click Go. Find the largest id in the query results. Now go back to "browse" for g2_SequenceId and click "edit" for the one row there. Change the value to be one larger than the maximum id reported in the query.
I'll add this info into the FAQ.
Posts: 2
This just popped up for me as well, but deleting the 'extra' row did the trick.
Not sure what led to it, but I was using the "Publish" method from XP with about 200 photos. 41 of them uploaded, or so it seemed. They all actually had, but they were not showing in the album. After a couple of reattemps, I deleted the the album on the page, then the files in FTP, and then could no longer create albums.
Thanks for the help.
Keith
Posts: 4
This is great!!! My gallery's a'work'n again!
John
http://fudaserve.net
Posts: 17
You guys ROCK!!! I can add Albums and Pics again :D
Posts: 12
I was having an issue with permissions on my g2data folder and I was unable to change them myself for some reason. I asked my web host to change them for me to 777. This resolved my permission problem and Gallery started to work again. Then I went and created an album with no problem but when I attempted to upload 4 pics using the "From Web Browser" upload feature I got the following error.
Platform Error
An error has occurred while interacting with the platform.
The exact nature of the platform error is unknown. A common cause are insufficient file system permissions. This can happen if you or your webhost changed something in the file system, e.g. by restoring data from a backup.
Back to the Gallery
Error Detail -
Error (ERROR_PLATFORM_FAILURE)
* in modules/core/classes/GalleryDerivative.class at line 346 (gallerycoreapi::error)
* in modules/core/classes/GalleryDerivativeImage.class at line 166 (galleryderivative::rebuildcache)
* in modules/core/classes/helpers/GalleryDerivativeHelper_advanced.class at line 742 (galleryderivativeimage::rebuildcache)
* in modules/core/classes/GalleryCoreApi.class at line 956 (galleryderivativehelper_advanced::rebuildcache)
* in modules/core/classes/helpers/GalleryDerivativeHelper_simple.class at line 66 (gallerycoreapi::rebuildderivativecache)
* in modules/core/classes/GalleryCoreApi.class at line 942 (galleryderivativehelper_simple::rebuildcacheifnotcurrent)
* in modules/core/CreateThumbnailOption.inc at line 77 (gallerycoreapi::rebuildderivativecacheifnotcurrent)
* in modules/core/ItemAdd.inc at line 151 (createthumbnailoption::handlerequestafteradd)
* in main.php at line 199 (itemaddcontroller::handlerequest)
* in main.php at line 87
* in modules/core/classes/GalleryEmbed.class at line 192
* in index.php at line 212 (galleryembed::handlerequest)
* in /home/steve/public_html/modules.php at line 49
System Information
Gallery version 2.1.1
PHP version 4.4.2 apache
Webserver Apache/1.3.34 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.2 FrontPage/5.0.2.2635 mod_ssl/2.8.25 OpenSSL/0.9.7a
Database mysql 4.1.18-standard
Toolkits Gd
Operating system Linux 4.com 2.4.21-40.ELsmp #1 SMP Wed Mar 15 14:44:44 EST 2006 i686
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.3) Gecko/20060426 Firefox/1.5.0.3
So I read this forum posting by SoulCages and decided give this solution a try. The only problem now is that when I tried step one I get an error in my FTP program that is telling me that I don't have permission to delete the images.
Is it possible that Gallery is changing the permission on the images so that I can not delete them or does this seem like the problem may be with my web hosting account?
Thanks in advance to any advice.
STEVE
"
Posts: 8601
the cleanup script can help you delete those files. they are created by your webserver/php user, so you may not have permission to delete them unless you use this script to change the permissions.
Posts: 14
Ok,
So I am going to try the above mentioned fixes.... but before i mess with the command line stuff.... I want to chekc with you guys that its OK! I really have NO PHP, SQL knowledge at all.
My Gallery is at:
http://www.jceez.com/photos/gallery2/main.php
Am I on the right track?
Thanks!
Database Error
An error has occurred while interacting with the database.
The exact nature of database errors is not captured unless Gallery debug mode is enabled in config.php. Before seeking support for this error please enable buffered debug output and retry the operation. Look near the bottom of the lengthy debug output to find error details.
Back to the Gallery
Error Detail -
Error (ERROR_STORAGE_FAILURE)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 988 (gallerycoreapi::error)
* in modules/core/classes/GalleryStorage.class at line 501 (gallerystorageextras::addmapentry)
* in modules/core/classes/GalleryCoreApi.class at line 2923 (mysqlstorage::addmapentry)
* in modules/core/classes/GalleryEntity.class at line 294 (gallerycoreapi::addmapentry)
* in modules/core/classes/GalleryItem.class at line 409 (galleryfilesystementity::save)
* in modules/core/classes/helpers/GalleryItemHelper_advanced.class at line 473 (galleryalbumitem::save)
* in modules/core/classes/GalleryCoreApi.class at line 1641 (galleryitemhelper_advanced::createalbum)
* in modules/core/ItemAddAlbum.inc at line 76 (gallerycoreapi::createalbum)
* in main.php at line 199 (itemaddalbumcontroller::handlerequest)
* in main.php at line 87
* in main.php at line 80
System Information
Gallery version 2.1.1
PHP version 4.3.11 cgi-fcgi
Webserver Apache
Database mysqlt 4.0.27-max-log
Toolkits Gd
Operating system Linux linhost148.prod.mesa1.secureserver.net 2.4.21-27.ELsmp #1 SMP Wed Dec 1 21:59:02 EST 2004 i686
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.4) Gecko/20060508 Firefox/1.5.0.4
Debug Output
file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/modules/core/classes/helpers/../../../../config.php) file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/modules/core/classes/helpers/../../../../plugins/index.modules) file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc) Unimplemented: GalleryUrlGenerator getParameter session.lifetime for core plugin file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/cache/module/core/0/0/0.inc) getParameter session.inactivityTimeout for core plugin (mysqlt): SELECT g2_SessionMap.g_id, g2_SessionMap.g_userId, g2_SessionMap.g_remoteIdentifier,g2_SessionMap.g_creationTimestamp, g2_SessionMap.g_modificationTimestamp, g2_SessionMap.g_data FROM g2_SessionMap WHERE g2_SessionMap.g_id = 'aa0e5f3103a37c07c2254848d1d80534' controller core.ItemAddAlbum, view Loading plugin core Class not defined, trying to include it. file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/modules/core/classes/helpers/../../../../modules/core/module.inc) core plugin successfully instantiated file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/versions.dat) file(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/versions.dat, ) [1149621230] can't guarantee 5 -- extending! file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/cache/entity/0/0/6.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the core plugin is ok file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/modules/core/classes/helpers/../../../../modules/core/ItemAddAlbum.inc) getParameter lock.system for core plugin fopen(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/locks/0/7/7, wb+, 0) flock(Resource id #49, 5, ) file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/cache/entity/0/0/7.inc) fopen(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/locks/0/7/7, wb+, 0) flock(Resource id #56, 5, ) file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/cache/module/_all/0/0/GalleryMimeTypeHelper_mimeData.inc) (mysqlt): SELECT COUNT(g2_ChildEntity.g_id) FROM g2_ChildEntity, g2_FileSystemEntity WHERE g2_ChildEntity.g_parentId = 7 AND g2_FileSystemEntity.g_pathComponent = 'Shanghai' AND g2_ChildEntity.g_id = g2_FileSystemEntity.g_id (mysqlt): update g2_SequenceId set id=LAST_INSERT_ID(id+1); file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/cache/module/_all/0/0/GalleryStorage_describeEntity.inc) (mysqlt): SELECT g2_DerivativePrefsMap.g_order, g2_DerivativePrefsMap.g_derivativeType, g2_DerivativePrefsMap.g_derivativeOperations FROM g2_DerivativePrefsMap WHERE g2_DerivativePrefsMap.g_itemId = 7 ORDER BY g2_DerivativePrefsMap.g_order ASC (mysqlt): SET AUTOCOMMIT=0 (mysqlt): BEGIN file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/cache/module/_all/0/0/GalleryStorage_describeMap.inc) (mysqlt): INSERT INTO g2_DerivativePrefsMap (g_itemId, g_order, g_derivativeType, g_derivativeOperations) VALUES (31,0,1,'thumbnail|100') file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/cache/module/_all/0/0/GalleryStorage_describeMap.inc) (mysqlt): INSERT INTO g2_DerivativePrefsMap (g_itemId, g_order, g_derivativeType, g_derivativeOperations) VALUES (31,0,2,'scale|640,640') file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/cache/module/_all/0/0/GalleryStorage_describeMap.inc) (mysqlt): INSERT INTO g2_DerivativePrefsMap (g_itemId, g_order, g_derivativeType, g_derivativeOperations) VALUES (31,1,2,'scale|800,800') file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/cache/module/_all/0/0/GalleryStorage_describeMap.inc) (mysqlt): INSERT INTO g2_DerivativePrefsMap (g_itemId, g_order, g_derivativeType, g_derivativeOperations) VALUES (31,2,2,'scale|1024,1024') getParameter default.newAlbumsUseDefaults for core plugin getParameter permissions.directory for core plugin file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/albums/Shanghai) mkdir(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/albums/Shanghai, 755) (mysqlt): SELECT g2_AccessSubscriberMap.g_accessListId FROM g2_AccessSubscriberMap WHERE g2_AccessSubscriberMap.g_itemId = 7 LIMIT 1 file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/cache/module/_all/0/0/GalleryStorage_describeMap.inc) mysqlt error: [1062: Duplicate entry '31' for key 1] in EXECUTE("INSERT INTO g2_AccessSubscriberMap (g_itemId, g_accessListId) VALUES (31,220)") (mysqlt): INSERT INTO g2_AccessSubscriberMap (g_itemId, g_accessListId) VALUES (31,220) 1062: Duplicate entry '31' for key 1
adodb_mysqlt._execute(INSERT INTO g2_AccessSubscriberMap
(g_itemId, g_accessListId) VALUES (31,220)) % line 836, file: adodb.inc.php
adodb_mysqlt.execute(INSERT INTO
g2_AccessSubscriberMap (g_itemId, g_accessListId) VALUES (?,?),
Array[2]) % line 985, file: GalleryStorageExtras.class
gallerystorageextras.addmapentry(GalleryAccessSubscriberMap,
Array[2]) % line 501, file: GalleryStorage.class
mysqlstorage.addmapentry(GalleryAccessSubscriberMap,
Array[2]) % line 2923, file: GalleryCoreApi.class
gallerycoreapi.addmapentry(GalleryAccessSubscriberMap,
Array[2]) % line 294, file: GalleryEntity.class
getParameter default.theme for core plugin Loading plugin splatbang Class not defined, trying to include it. file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/modules/core/classes/helpers/../../../../config.php) file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/modules/core/classes/helpers/../../../../plugins/index.themes) file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/modules/core/classes/helpers/../../../../themes/splatbang/theme.inc) splatbang plugin successfully instantiated Check the version of the splatbang plugin file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/cache/theme/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the splatbang plugin is ok Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/modules/core/classes/helpers/../../../../modules/core/ErrorPage.inc) getParameter id.adminGroup for core plugin (mysqlt): SELECT g2_UserGroupMap.g_userId FROM g2_UserGroupMap WHERE g2_UserGroupMap.g_userId = 6 AND g2_UserGroupMap.g_groupId = 3 LIMIT 1 realpath(/home/content/j/c/e/jceez/html/photos/gallery2/modules/core/classes/../../../) (mysqlt): SELECT g2_TkOperatnMimeTypeMap.g_mimeType, g2_TkOperatnMimeTypeMap.g_toolkitId FROM g2_TkOperatnMimeTypeMap WHERE g2_TkOperatnMimeTypeMap.g_operationName = 'thumbnail' ORDER BY g2_TkOperatnMimeTypeMap.g_mimeType ASC, g2_TkOperatnMimeTypeMap.g_priority ASC file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/smarty/templates_c/%%2060843497) is_dir(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/smarty/templates_c/%%2060843497) file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/smarty/templates_c/%%2060843497) is_writeable(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/smarty/templates_c/%%2060843497) file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/g2data/smarty/templates_c/%%2060843497/v_9) file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/modules/core/classes/../../../lib/javascript/local/BlockToggle.js) file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/modules/core/../../themes/splatbang/local/theme.css) file_exists(/home/content/j/c/e/jceez/html/photos/gallery2/modules/core/classes/../../../themes/splatbang/local/theme.css)
Posts: 49
My problem is similar to the above, but without the complexity. I don't see any duplicate info for MySQL runs- My debug output is below. What can I do to resolve my issue? The albums are viewing just fine, however, no-one can post pics. The Gallery Remote goes grey after you create an album and the website uploading version states a SQL connection issue.
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 988 (gallerycoreapi::error)
in modules/core/classes/GalleryStorage.class at line 501 (gallerystorageextras::addmapentry)
in modules/core/classes/GalleryCoreApi.class at line 2921 (mysqlstorage::addmapentry)
in modules/core/classes/helpers/MaintenanceHelper_simple.class at line 133 (gallerycoreapi::addmapentry)
in modules/core/AdminMaintenance.inc at line 104 (maintenancehelper_simple::addrun)
in modules/core/AdminMaintenance.inc at line 70 (adminmaintenancecontroller::runtask)
in main.php at line 199 (adminmaintenancecontroller::handlerequest)
in main.php at line 87
in main.php at line 80
System Information
Gallery version 2.1
PHP version 4.3.11 cgi-fcgi
Webserver Apache
Database mysql 4.0.27-max-log
Toolkits Gd
Operating system Linux linhost152.prod.mesa1.secureserver.net 2.4.21-27.ELsmp #1 SMP Wed Dec 1 21:59:02 EST 2004 i686
Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
have you been seen, lately...?
www.mycrazyfriends.com
www.mycrazyfriendsandfamily.com
Posts: 49
I also just noticed that the guy that posted before me is hosting with the same company but on a different web-server. Mere coincidence?
have you been seen, lately...?
www.mycrazyfriends.com
Posts: 49
Okay- I deleted the folders for the albums that failed, as per SoulCages01 stated (I went into the albums folder and looked for any folders with date stamps on them from the past few days and delted them via FTP client). I ran the Delete database cache, delete template cache, optimize database, and build all thumbnails and they all ran successfully. I went in and tried to create a new album via Gallery remote and it still greyed out as soon as it attempted to create the album. Am I working forwards or backwards?
How do I enable the buffered debug output? I'll search on this next to see if I can retrieve more debug info eventhough the others above are running with success.
have you been seen, lately...?
www.mycrazyfriends.com
Posts: 49
Ah...I'm starting to see the same errors now....
Here's my debug output. It looks like I have the same duplicate issue, but on line 11. I'll to weed through how to fix this, but I do believe I need the dummy version on how to fix this.
file_exists(/home/content/c/i/s/ciscojay/html/gallery/modules/core/classes/helpers/../../../../config.php) file_exists(/home/content/c/i/s/ciscojay/html/gallery/modules/core/classes/helpers/../../../../plugins/index.modules) file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc) Unimplemented: GalleryUrlGenerator getParameter session.lifetime for core plugin file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/cache/module/core/0/0/0.inc) getParameter session.inactivityTimeout for core plugin
--------------------------------------------------------------------------------
(mysql): SELECT g2_SessionMap.g_id, g2_SessionMap.g_userId, g2_SessionMap.g_remoteIdentifier,g2_SessionMap.g_creationTimestamp, g2_SessionMap.g_modificationTimestamp, g2_SessionMap.g_data FROM g2_SessionMap WHERE g2_SessionMap.g_id = '89875e97f14ea9f2f7f7e1fedc5a56f4'
--------------------------------------------------------------------------------
controller core.ItemAddAlbum, view Loading plugin core Class not defined, trying to include it. file_exists(/home/content/c/i/s/ciscojay/html/gallery/modules/core/classes/helpers/../../../../modules/core/module.inc) core plugin successfully instantiated file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/versions.dat) file(/home/content/c/i/s/ciscojay/html/gallery/g2data/versions.dat, ) [1152579082] can't guarantee 5 -- extending! file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/cache/entity/0/0/6.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the core plugin is ok file_exists(/home/content/c/i/s/ciscojay/html/gallery/modules/core/classes/helpers/../../../../modules/core/ItemAddAlbum.inc) getParameter lock.system for core plugin fopen(/home/content/c/i/s/ciscojay/html/gallery/g2data/locks/0/2/23, wb+, 0) flock(Resource id #48, 5, ) file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/cache/entity/0/2/23.inc) fopen(/home/content/c/i/s/ciscojay/html/gallery/g2data/locks/0/2/23, wb+, 0) flock(Resource id #55, 5, ) file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/cache/module/_all/0/0/GalleryMimeTypeHelper_mimeData.inc)
--------------------------------------------------------------------------------
(mysql): SELECT COUNT(g2_ChildEntity.g_id) FROM g2_ChildEntity, g2_FileSystemEntity WHERE g2_ChildEntity.g_parentId = 23 AND g2_FileSystemEntity.g_pathComponent = 'test2' AND g2_ChildEntity.g_id = g2_FileSystemEntity.g_id
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysql): update g2_SequenceId set id=LAST_INSERT_ID(id+1);
--------------------------------------------------------------------------------
file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/cache/module/_all/0/0/GalleryStorage_describeEntity.inc) file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/cache/entity/0/0/7.inc)
--------------------------------------------------------------------------------
(mysql): SELECT g2_DerivativePrefsMap.g_order, g2_DerivativePrefsMap.g_derivativeType, g2_DerivativePrefsMap.g_derivativeOperations FROM g2_DerivativePrefsMap WHERE g2_DerivativePrefsMap.g_itemId = 23 ORDER BY g2_DerivativePrefsMap.g_order ASC
--------------------------------------------------------------------------------
file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/cache/module/_all/0/0/GalleryStorage_describeMap.inc)
--------------------------------------------------------------------------------
(mysql): INSERT INTO g2_DerivativePrefsMap (g_itemId, g_order, g_derivativeType, g_derivativeOperations) VALUES (11,0,2,'scale|640,640')
--------------------------------------------------------------------------------
file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/cache/module/_all/0/0/GalleryStorage_describeMap.inc)
--------------------------------------------------------------------------------
(mysql): INSERT INTO g2_DerivativePrefsMap (g_itemId, g_order, g_derivativeType, g_derivativeOperations) VALUES (11,0,1,'thumbnail|150')
--------------------------------------------------------------------------------
getParameter default.newAlbumsUseDefaults for core plugin getParameter permissions.directory for core plugin file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/albums/jayandtracy/test2) mkdir(/home/content/c/i/s/ciscojay/html/gallery/g2data/albums/jayandtracy/test2, 755)
--------------------------------------------------------------------------------
(mysql): SELECT g2_AccessSubscriberMap.g_accessListId FROM g2_AccessSubscriberMap WHERE g2_AccessSubscriberMap.g_itemId = 23 LIMIT 1
--------------------------------------------------------------------------------
file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/cache/module/_all/0/0/GalleryStorage_describeMap.inc) mysql error: [1062: Duplicate entry '11' for key 1] in EXECUTE("INSERT INTO g2_AccessSubscriberMap (g_itemId, g_accessListId) VALUES (11,46)")
--------------------------------------------------------------------------------
(mysql): INSERT INTO g2_AccessSubscriberMap (g_itemId, g_accessListId) VALUES (11,46)
--------------------------------------------------------------------------------
1062: Duplicate entry '11' for key 1
adodb_mysql._execute(INSERT INTO g2_AccessSubscriberMap
(g_itemId, g_accessListId) VALUES (11,46)) % line 836, file: adodb.inc.php
adodb_mysql.execute(INSERT INTO
g2_AccessSubscriberMap (g_itemId, g_accessListId) VALUES (?,?),
Array[2]) % line 985, file: GalleryStorageExtras.class
gallerystorageextras.addmapentry(GalleryAccessSubscriberMap,
Array[2]) % line 501, file: GalleryStorage.class
mysqlstorage.addmapentry(GalleryAccessSubscriberMap,
Array[2]) % line 2921, file: GalleryCoreApi.class
gallerycoreapi.addmapentry(GalleryAccessSubscriberMap,
Array[2]) % line 294, file: GalleryEntity.class
fclose(Resource id #55) file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/locks/0/2/23) fclose(Resource id #48) file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/locks/0/2/23) unlink(/home/content/c/i/s/ciscojay/html/gallery/g2data/locks/0/2/23) getParameter default.theme for core plugin Loading plugin matrix Class not defined, trying to include it. file_exists(/home/content/c/i/s/ciscojay/html/gallery/modules/core/classes/helpers/../../../../config.php) file_exists(/home/content/c/i/s/ciscojay/html/gallery/modules/core/classes/helpers/../../../../plugins/index.themes) file_exists(/home/content/c/i/s/ciscojay/html/gallery/modules/core/classes/helpers/../../../../themes/matrix/theme.inc) matrix plugin successfully instantiated Check the version of the matrix plugin file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/cache/theme/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the matrix plugin is ok Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok file_exists(/home/content/c/i/s/ciscojay/html/gallery/modules/core/classes/helpers/../../../../modules/core/ErrorPage.inc) getParameter id.adminGroup for core plugin
--------------------------------------------------------------------------------
(mysql): SELECT g2_UserGroupMap.g_userId FROM g2_UserGroupMap WHERE g2_UserGroupMap.g_userId = 6 AND g2_UserGroupMap.g_groupId = 3 LIMIT 1
--------------------------------------------------------------------------------
realpath(/home/content/c/i/s/ciscojay/html/gallery/modules/core/classes/../../../)
--------------------------------------------------------------------------------
(mysql): SELECT g2_TkOperatnMimeTypeMap.g_mimeType, g2_TkOperatnMimeTypeMap.g_toolkitId FROM g2_TkOperatnMimeTypeMap WHERE g2_TkOperatnMimeTypeMap.g_operationName = 'thumbnail' ORDER BY g2_TkOperatnMimeTypeMap.g_mimeType ASC, g2_TkOperatnMimeTypeMap.g_priority ASC
--------------------------------------------------------------------------------
file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/smarty/templates_c/%%2259392217) is_dir(/home/content/c/i/s/ciscojay/html/gallery/g2data/smarty/templates_c/%%2259392217) file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/smarty/templates_c/%%2259392217) is_writeable(/home/content/c/i/s/ciscojay/html/gallery/g2data/smarty/templates_c/%%2259392217) file_exists(/home/content/c/i/s/ciscojay/html/gallery/g2data/smarty/templates_c/%%2259392217/v_9) file_exists(/home/content/c/i/s/ciscojay/html/gallery/modules/core/classes/../../../lib/javascript/local/BlockToggle.js) file_exists(/home/content/c/i/s/ciscojay/html/gallery/modules/core/../../themes/matrix/local/theme.css) file_exists(/home/content/c/i/s/ciscojay/html/gallery/modules/core/classes/../../../themes/matrix/local/theme.css)
Posts: 49
Just as an update, I did everything that everyone was recommending up above. A recap for those that are not SQL savy like myself.
I used phpmyadmin, clicked on g2_database, scrolled down to g2_sequenceid, and clicked on the search icon next to it. In the "where" field, I typed in any two digit number (e.g. 55). It then showed that I had 5 rows and their values. I clicked on the pencil to edit the HIGHEST value. I increased that value by 100 (mine was 6200 at the time). I then checked the box next to the other 4 values and clicked the red X to delete them. I then went and deleted the cache, template cache, and optimzed my database. I was then able to create new albums and add pictures.
This has been a one week long journey...whew!
Jay
www.mycrazyfriends.com/gallery
www.mycrazyfriends.com/gallery2
www.mycrazyfriendsandfamily.com/gallery
Posts: 18
I believe the problem is related to either a timeout or max post/upload size. fixing the php.ini helped avoid some of these problems, but now I upload anything over 10mb to my server and add it from there.
Posts: 19
Hi have received the same error as ciscojay...
I tried several or all of the fixes listed above and keep getting the same error. Also note that the cleanup.php didnt work. I am unable to delete the files from my album after doing the cleanup. Probably my issue here.
Error (ERROR_STORAGE_FAILURE)
* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1238 (gallerystatus::error)
* in modules/core/classes/GalleryStorage.class at line 294 (mysqldatabasestorage::addmapentry)
* in modules/core/classes/interfaces/GalleryAccessSubscriberMap.inc at line 95 (gallerystorage::addmapentry)
* in modules/core/classes/GalleryEntity.class at line 272 (galleryaccesssubscribermap::addmapentry)
* in modules/core/classes/GalleryItem.class at line 409 (galleryfilesystementity::save)
* in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 225 (galleryphotoitem::save)
* in modules/core/classes/GalleryCoreApi.class at line 1499 (galleryitemhelper_medium::additemtoalbum)
* in modules/core/ItemAddFromBrowser.inc at line 89 (gallerycoreapi::additemtoalbum)
* in modules/core/ItemAdd.inc at line 94 (itemaddfrombrowser::handlerequest)
* in main.php at line 174 (itemaddcontroller::handlerequest)
* in main.php at line 87
* in main.php at line 80
System Information
Gallery version 2.0.2
PHP version 4.4.4
Webserver Apache/1.3.37 (Unix)
Perl Version 5.8.5
Database mysql 4.1.21-standard
Toolkits ImageMagick, Gd
Operating system Linux
Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Any assist would be great as this is a minimal task for a different task. Turned into an entire new learning curve while trying to get images to post in a php nuke .
Please advise. thanks
Posts: 32509
shayluv4u
please create a new forum topic for your issue.
see: FAQ: How to set/use Gallery in debug mode?
and please upgrade to g2.1.2.
Posts: 8
I found 22 rows in there, 21 with values around 2000 and one with a value 15426. I changed that to 15427, deleted the other 21 rows and was able to add and album. Unfortunately it doesn't show up, so I can't add pictures.
I'm trying to delete the cache, but the server appears to have gone off into never-never land.
Where is the template cache?
I don't see a place in phpmyadmin for optimizing the database. Could you explain where that is?
Thanks,
Brandon