[solved] Import error - no access back into gallery

My import stalled with an estimated 24 secs to go. and now I can not get back to the gallery page to do anything as the error page shows up.

Any ideas?

Thank you,
Keith

Error
An error has occurred.

Back to the Gallery

Error Detail -
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1166 (gallerystatus::error)
in modules/core/classes/GalleryStorage.class at line 245 (mysqldatabasestorage::search)
in modules/core/classes/Gallery.class at line 223 (gallerystorage::search)
in modules/core/classes/helpers/GalleryDerivativeHelper_medium.class at line 186 (gallery::search)
in modules/core/classes/helpers/GalleryDerivativeHelper_medium.class at line 56 (galleryderivativehelper_medium::_loadderivatives)
in modules/core/classes/GalleryCoreApi.class at line 897 (galleryderivativehelper_medium::fetchthumbnailsbyitemids)
in modules/core/ItemAdmin.inc at line 53 (gallerycoreapi::fetchthumbnailsbyitemids)
in modules/core/classes/GalleryTheme.class at line 688 (itemadminview::loadtemplate)
in modules/core/classes/GalleryView.class at line 285 (matrixtheme::loadtemplate)
in main.php at line 287 (itemadminview::doloadtemplate)
in main.php at line 87
in main.php at line 80

System Information
Gallery version 2.0
PHP version 4.3.11 apache
Webserver Apache/1.3.33 (Unix) mod_log_bytes/0.3 FrontPage/5.0.2.2635 PHP/4.3.11 mod_ssl/2.8.22 OpenSSL/0.9.7d
Database mysql 4.0.16
Operating system FreeBSD host310.ipowerweb.com 4.10-SATA-RELEASE FreeBSD 4.10-SATA-RELEASE #0: T i386
Browser Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) AppleWebKit/412.7 (KHTML, like Gecko) Safari/412.5

I have read the NOTES on the migrating page and have the following comments:
Notes:
You will likely need to increase the PHP memory size limit in order for the import to finish successfully. Setting memory_limit to 32M worked for a gallery with approximately 4000 images.
Where do you do this from??? I have about 1800 images

If you have any problems, please post any error given as text in a forum post in the gallery support forum with a title that includes one of these words: "import," "migrate", or "migration."

If the import fails during a particular album, please try importing that album by itself first. If the import fails on a particular image or movie, please make sure that the original version of the image or movie exists in your g1 first. If the image or movie exists, please download the original image or movie to your computer and upload it to g2 outside of the import process.

Can not tell what album / photo etc. it stalled on - it stalled with an estimated 24 secs to go.

Please make note of the memory display in the upper right (even if it is 0/0).
Do not see this on the page.

If you problem relates to incorrect non-ascii characters, please include the name of the character set from which you were importing. - do not think this is an issue
It is very helpful to have a link to your G1 and G2 installations.
www.webbsite.org/gallery = new gallery2
www.webbsite.org/g1 = gallery 1

If you do not get an error, but get a blank screen, a timeout, or some other non helpful thing, please check your apache error log if possible and check for a line like 'memory allocation error, tried to allocate x bytes.' If you get such a line, please let me know.

jmullan,

Thank you for the help. I seem to have fix a portion of the issue. It seems that I ran out of MySWL Data base hits = 50000. I went in to check the database end on my providers toolbox side of my account and I could not access the database and received and error that I exceeded "hits" on the database. I then proceeded to delete the database and create a new one. I then started to import albums one by one then two by two etc. And all seems to be working at this time. I have not loaded all the albums back in as I am afraid to get the error message again.

By chance do you know a timeframe of when the "hit counter" resets itself? 12 hours, 24 hours, etc.

I really like like the G2 interface much improved from G1.

Thank you for your help,
Keith

I am hosted on iPower. I talked to them today and they said there is a limit of 50000 hits per hours. So it resets after each hours. I am not a huge user of the database side so I do not know if this is a good thing or not.

We will see.

Thank you,
K