Hi,
After it insert few albums I see this error:
Error (ERROR_STORAGE_FAILURE) : Empty sequence id!
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 494 (gallerycoreapi::error)
* in modules/core/classes/GalleryStorage.class at line 1871 (gallerystorageextras::_getuniqueidwithconnection)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 446 (mysqlstorage::getuniqueid)
* in modules/core/classes/GalleryStorage.class at line 346 (gallerystorageextras::newentity)
* in modules/core/classes/GalleryEntity.class at line 168 (mysqlstorage::newentity)
* in modules/core/classes/GalleryChildEntity.class at line 69 (galleryentity::create)
* in modules/core/classes/GalleryFileSystemEntity.class at line 93 (gallerychildentity::create)
* in modules/core/classes/GalleryItem.class at line 192 (galleryfilesystementity::create)
* in modules/core/classes/GalleryAlbumItem.class at line 95 (galleryitem::create)
* in modules/core/classes/helpers/GalleryItemHelper_advanced.class at line 234 (galleryalbumitem::create)
* in modules/core/classes/GalleryCoreApi.class at line 1646 (galleryitemhelper_advanced::createalbum)
* in modules/itemadd/ItemAddFromServer.inc at line 351 (gallerycoreapi::createalbum)
* in modules/itemadd/ItemAddFromServer.inc at line 242 (itemaddfromserver::adddirectory)
* in modules/core/ItemAdd.inc at line 159 (itemaddfromserver::handlerequest)
* in ??? at line 0 (itemaddcontroller::handlerequestwithprogressbar)
* in modules/core/classes/GalleryTemplateAdapter.class at line 1092
* in g2data/smarty/templates_c/%%307764054/matrix/%%3A^3A8^3A818B59%%theme.tpl.php at line 75 (gallerytemplateadapter::trailer)
* in lib/smarty/Smarty.class.php at line 1255
* in modules/core/classes/GallerySmarty.class at line 61 (smarty::fetch)
* in modules/core/classes/GalleryTemplate.class at line 241 (gallerysmarty::fetch)
* in main.php at line 506 (gallerytemplate::display)
* in main.php at line 104
* in main.php at line 88
I have fresh installation of last version of gallery.
Posted: Wed, 2008-10-29 14:58
Posts: 16504
Please post your system info:
FAQ: What information is required when I ask for help in the forums?
Also put gallery into Debug mode, try to upload photos and on the page you get the error, copy and paste the debug output at the bottom of the page into a text file, zip it and attach to another post.
FAQ: How to set/use Gallery in debug mode?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 27
Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 4.4.9 apache
Webserver = Apache/1.3.41 (Unix) PHP/4.4.9 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.8b
Database = mysqlt 5.0.51a-community, lock.system=flock
Toolkits = Exif, Getid3, LinkItemToolkit, Thumbnail, Gd
Acceleration = none, none
Operating system = Linux server.fotoglasi.com 2.6.18-92.1.13.el5 #1 SMP Wed Sep 24 19:33:52 EDT 2008 i686
Default theme = matrix
gettext = enabled
Locale = en_GB
Browser = Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-GB; rv:1.9.0.2) Gecko/2008091618 Firefox/3.0.2
Rows in GalleryAccessMap table = 32
Rows in GalleryAccessSubscriberMap table = 3
Rows in GalleryUser table = 2
Rows in GalleryItem table = 1
Rows in GalleryAlbumItem table = 1
Rows in GalleryCacheMap table = 0
Posts: 16504
Looks like the connection to the database is getting lost:
You could try setting
$storeConfig['usePersistentConnections'] = false;to$storeConfig['usePersistentConnections'] = true;Don't know what else to say other than checking with your host or server config.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 27
Didn't help.
What should I tell to hosting support ?
Posts: 16504
I'd ask them what could be causing my database connection to fail and start from there. You could point them to the debug log and show them the
2006: MySQL server has gone awaymessage.____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 27
Support checked server and told everything is ok.
They told me: Typically, "MySQL has gone away" means that the the time between two queries exceeded one of the connection timeouts. It can sometimes be due to MySQL crashes, but the logs don't any.
Posts: 16504
Does it work when you upload a small number (like 1) image? Does it work through other methods? How big are these files?
Try disabling modules you are not using, Exif, getid3, etc. Even if you are using EXIF, I would try disabling it for a test.
I would also try a using a different image toolkit other than GD. Your server most likely had ImageMagick and/or NetPMB installed. Install those toolkits, test/configure them and disable GD. Then try it.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 15
Any other ideas for this guy? I'm having the exact same problem. Tried all the above suggestions and no help. Here's my info:
I read something online that said this:
"You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M) or via max_allowed_packet variable in your /etc/my.cnf file and restarting mysql after you edited your /etc/my.cnf file. The extra memory is allocated on demand, so mysqld will use more memory only when you issue a big query or when mysqld must return a big result row"
Could that have anything to do with it? I havent tried it since I dont have access to the file but might contact the server administrator.
I am able to upload files via the local server but have to do in small batches which is a pain. Before I updated to 2.3 I would have to do the same but instead got "HTTP Error 500 - Internal server error".
I looked at the FAQ and went through phpMyAdmin and looked at the id and tried that method but it didnt work either. Also, it doesnt appear I'm affected by sql limiting the amount of connections since I can do this multiple times in a row.
Any other ideas?
Posts: 16504
Doubt it's the same problem. Post a link to phpinfo and put gallery into debug mode (as described above) and try adding a larger number of files that will generate the error. For Error 500 messages you need take a look at the error logs on the server, check your control panel or contact your host for that info.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 15
I am no longer getting Error 500, that was pre v2.3. Here are the files:
http://www.aggiewhoop.com/gallery2/phpinfo.php
Error Log: http://www.aggiewhoop.com/errorlog.txt
Debug Console Log: http://www.aggiewhoop.com/debugconsole.txt
Posts: 16504
That debug info is from the Smarty Debug popup. There should be other debug output at the bottom of the page (not the popup). That's the debug info we need to look at.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 15
Look at the middle link. I think that was the one you need.
Posts: 16504
Sorry, didn't see/notice the debug output there before.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 15
Yeah I tried that awhile ago since I saw you post it. If you have any other ideas let me know. If I cant get this worked out I'll have to start transfering pictures 20 at a time like before.
Posts: 16504
The only other thing I can think of is to check with your host then.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here