g1->g2 import failed, now g2 gives errors on access. And a 2nd question on importing. (I followed the migration explicitly)
|
eDRoaCH
Joined: 2007-03-06
Posts: 19 |
Posted: Thu, 2007-03-08 18:20
|
|
Please fill out the following form and take a look at the linked pages. The more information you supply, the better we can help you. My G2 is currently not working, if you go to the url you will see the errors G1 URL (optional): http://edamamebeans.com/g1/ Gallery version 2.1.2 Last time my question went unanswered, I assume due to the fact I didnt have enough information. I have done my best to give you all the information possible. I have two questions related to this. The first and most obvious, my import failed. there is no continue button and no memory info near the top of the screen. The error says to enable debug mode and try again, but the gallery now doesnt load. (error on homepage) I did follow the http://codex.gallery2.org/Gallery2:migration implicitly. There were no users listed to import. problem 2. With the input wizard, I basically accepted the defaults. (except where the guide told me otherwise) I got a lot of the errors like below (before the total failure) Title was truncated for item 1977. This trip to japan was a special trip for me, and the reason I started using the gallery. I would like to keep all information. How can I fix this? I'm sure this is the easy one. I would very much appreciate any help you can give. I am very lucky to be able to be going back to Japan this summer, and I want to have a nice stable place to put my pictures. I do have rather large albums full of pictures and quicktime videos. |
|
Posts: 19
update: I was able to get into the gallery and I tried to delete the imported album to try to re-import it. IT once again crashed the database. Errors below. I am going to delete the entire gallery 2 install and start over, please give me any tips you can for successful import. I am going to try to import 1 album at a time.
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.class at line 476 (gallerycoreapi::error)
in modules/core/classes/Gallery.class at line 223 (mysqlstorage::search)
in modules/core/classes/helpers/GalleryPermissionHelper_simple.class at line 97 (gallery::search)
in modules/core/classes/GalleryCoreApi.class at line 445 (gallerypermissionhelper_simple::fetchaccesslistids)
in modules/core/classes/helpers/GalleryChildEntityHelper_simple.class at line 227 (gallerycoreapi::fetchaccesslistids)
in modules/core/classes/helpers/GalleryChildEntityHelper_simple.class at line 117 (gallerychildentityhelper_simple::_fetchchilditemids)
in modules/core/classes/GalleryCoreApi.class at line 2477 (gallerychildentityhelper_simple::fetchchilditemids)
in modules/core/classes/GalleryTheme.class at line 875 (gallerycoreapi::fetchchilditemids)
in modules/core/classes/GalleryView.class at line 325 (matrixtheme::loadtemplate)
in main.php at line 386 (showitemview::doloadtemplate)
in main.php at line 87
in main.php at line 80
System Information
Gallery version 2.1.2
PHP version 4.4.1 apache
Webserver Apache
Database mysql 4.0.16
Operating system FreeBSD host188.ipowerweb.com 4.9-RELEASE-p11 FreeBSD 4.9-RELEASE-p11 #0: Sat i386
Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727)
Posts: 19
doing it album by album with no thumbnails created and the caption becomes the description. Doesnt seem to like my very last file in album 12. Humg on
album12 100_1456.jpg
Nothing very special about the pic at all other than its the last one in a album. there were no orphans or problem albums before i started this. i would post the url to the pic but i am still holding out hope itll do it (10 mins on same pic)
memory says 0 used
Posts: 19
seems to have stuck on that file. finally tried to hit refresh and now I have nothing but an error. Help appreciated.
Posts: 19
ok, im uploading files for try 3 here, I would really appreciate some input...
Posts: 32509
> my import failed. there is no continue button
if the import fails like that, a php error (please check your webserver's error log) is likely the reason and it might have left your gallery in an inconsistent state.
which might explain the error you get when accessing your gallery or when trying to delete an album.
currently, your g2 is not installed. it shows the install wizard.
did you run the g1 integrity checks before starting the import? see docs -> installation -> migrate from gallery 1.
@truncation:
in the migration wizard, map g1 captions to g2 descriptions. only descriptions can hold really long text in g2.
--------------
Doumentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 19
I was working with someone in the chat last night, he said it seems like everything I am doing is right. The single problem image was opened in photoshop, saved, and re-uploaded just in case, but another file ended up failing.
as per his recomendations, I am going to try 2.2rc2. i went to sleep as it uploaded last night and hope to work on it today.
I figured out the captions->descriptions, and I am also skipping thumbnail creation to save system resources.
thanks for your help, I will let you know how it goes.
Posts: 19
usng 2.2RC2 and only netpdm because it said imagemagik was vulnerable, everything else still according to the migration faq.
I am importing album by album, which means first the master ablum then selecting each one below it to be put in the master album. no thumbnail creation, and for the 3 sets of radio buttons I use file name, none and caption.
album12 100_1280.jpg
Estimated time remaining: 1:59
Memory used: 0, total: 0
Error (ERROR_STORAGE_FAILURE)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1100 (gallerycoreapi::error)
* in modules/core/classes/GalleryStorage.class at line 517 (gallerystorageextras::removemapentry)
* in modules/core/classes/GalleryCoreApi.class at line 2815 (mysqlstorage::removemapentry)
* in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 853 (gallerycoreapi::removemapentry)
* in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 873 (galleryitemhelper_medium::invalidatedescendentcountcaches)
* in modules/core/classes/helpers/GalleryEventHelper_simple.class at line 117 (galleryitemhelper_medium::handleevent)
* in modules/core/classes/GalleryCoreApi.class at line 2132 (galleryeventhelper_simple::postevent)
* in modules/core/classes/GalleryItem.class at line 438 (gallerycoreapi::postevent)
* in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 183 (galleryphotoitem::save)
* in modules/core/classes/GalleryCoreApi.class at line 1575 (galleryitemhelper_medium::additemtoalbum)
* in modules/migrate/ConfirmImport.inc at line 904 (gallerycoreapi::additemtoalbum)
* in ??? at line 0 (confirmimportcontroller::performimport)
* in modules/core/classes/GalleryTemplateAdapter.class at line 914
* in g2data_345khl45kusd/smarty/templates_c/%%1724620407/%%3A^3A8^3A818B59%%theme.tpl.php at line 69 (gallerytemplateadapter::trailer)
* in lib/smarty/Smarty.class.php at line 1258
* in modules/core/classes/GallerySmarty.class at line 61 (smarty::fetch)
* in modules/core/classes/GalleryTemplate.class at line 209 (gallerysmarty::fetch)
* in main.php at line 473 (gallerytemplate::display)
* in main.php at line 94
* in main.php at line 83
going back to the gallery gives me
atabase 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.class at line 480 (gallerycoreapi::error)
* in modules/core/classes/Gallery.class at line 202 (mysqlstorage::search)
* in modules/core/classes/helpers/GalleryPermissionHelper_simple.class at line 85 (gallery::search)
* in modules/core/classes/GalleryCoreApi.class at line 428 (gallerypermissionhelper_simple::fetchaccesslistids)
* in modules/core/classes/helpers/GalleryChildEntityHelper_simple.class at line 189 (gallerycoreapi::fetchaccesslistids)
* in modules/core/classes/helpers/GalleryChildEntityHelper_simple.class at line 152 (gallerychildentityhelper_simple::builditemquery)
* in modules/core/classes/helpers/GalleryChildEntityHelper_simple.class at line 80 (gallerychildentityhelper_simple::_fetchchilditemids)
* in modules/core/classes/GalleryCoreApi.class at line 2336 (gallerychildentityhelper_simple::fetchchilditemids)
* in modules/core/classes/GalleryTheme.class at line 881 (gallerycoreapi::fetchchilditemids)
* in modules/core/classes/GalleryView.class at line 308 (matrixtheme::loadtemplate)
* in main.php at line 441 (showitemview::doloadtemplate)
* in main.php at line 94
* in main.php at line 83
System Information
Gallery version 2.2-rc-2
PHP version 4.4.1 apache
Webserver Apache
Database mysqlt 4.0.16
Operating system FreeBSD host188.ipowerweb.com 4.9-RELEASE-p11 FreeBSD 4.9-RELEASE-p11 #0: Sat i386
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.10) Gecko/20070216 Firefox/1.5.0.10
I am pretty much out of ideas....
Posts: 19
Some more hopefully useful info:
trying to clear the cache I get:
Error deleting page cache!
Deleting dir: /home/edamameb/public_html/gallery/g2data_345khl45kusd/cache/entity
Recreating dir: /home/edamameb/public_html/gallery/g2data_345khl45kusd/cache/entity
Deleting dir: /home/edamameb/public_html/gallery/g2data_345khl45kusd/cache/module
Recreating dir: /home/edamameb/public_html/gallery/g2data_345khl45kusd/cache/module
Deleting dir: /home/edamameb/public_html/gallery/g2data_345khl45kusd/cache/theme
Recreating dir: /home/edamameb/public_html/gallery/g2data_345khl45kusd/cache/theme
Deleting dir: /home/edamameb/public_html/gallery/g2data_345khl45kusd/smarty/templates_c
Recreating dir: /home/edamameb/public_html/gallery/g2data_345khl45kusd/smarty/templates_c
Deleting dir: /home/edamameb/public_html/gallery/g2data_345khl45kusd/tmp
Recreating dir: /home/edamameb/public_html/gallery/g2data_345khl45kusd/tmp
Deleting dir: /home/edamameb/public_html/gallery/g2data_345khl45kusd/cache/repository
Recreating dir: /home/edamameb/public_html/gallery/g2data_345khl45kusd/cache/repository
Which changes the main gllery error to:
Error
Error (ERROR_STORAGE_FAILURE) :
in modules/core/classes/GalleryStorage.class at line 480 (gallerycoreapi::error)
in modules/core/classes/Gallery.class at line 202 (mysqlstorage::search)
in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 317 (gallery::search)
in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 222 (gallerypluginhelper_simple::_fetchallparameters)
in modules/core/classes/GalleryCoreApi.class at line 238 (gallerypluginhelper_simple::getparameter)
in modules/core/classes/GallerySession.class at line 833 (gallerycoreapi::getpluginparameter)
in modules/core/classes/GallerySession.class at line 231 (gallerysession::_loadsessiondata)
in modules/core/classes/Gallery.class at line 287 (gallerysession::init)
in init.inc at line 118 (gallery::initsession)
in main.php at line 76
I hope some of this helps. I had to turn error logging on on my server, and its going to take 24 hrs to start, so thats not a resource for awhile.
Posts: 32509
i suggest you logout and login again. maybe your session data got too big.
--------------
Doumentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 19
valiant: thanks for the help, I came here to say I am totally out of ideas and as I was loading the browser I got an email notification from you ^^
Unfortunately, that didnt fix it. Not only did I re-log in, but I was gone over an hour after logging out. Still fails on album 12.
I am totally out of ideas, Joe has been helping me a bit on the chat, but this is really bumming me out. I very much want to upgrade to gallery2.
Help appreciated.
Posts: 32509
still the exact same error (ERROR_STORAGE_FAILURE) from loadSessiondata ?
--------------
Doumentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 19
yes, it looks to be. Im currently leaving the gallery broken so http://edamamebeans.com/gallery will show you some of the errors. As for the rest I am going to post the page because I can't say I'm much of a program debugger.
Error (ERROR_STORAGE_FAILURE)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1100 (gallerycoreapi::error)
* in modules/core/classes/GalleryStorage.class at line 517 (gallerystorageextras::removemapentry)
* in modules/core/classes/GalleryCoreApi.class at line 2815 (mysqlstorage::removemapentry)
* in modules/core/classes/GalleryDataCache.class at line 721 (gallerycoreapi::removemapentry)
* in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 1004 (gallerydatacache::removepagedata)
* in modules/core/classes/helpers/GalleryEventHelper_simple.class at line 117 (galleryitemhelper_medium::handleevent)
* in modules/core/classes/GalleryCoreApi.class at line 2132 (galleryeventhelper_simple::postevent)
* in modules/core/classes/GalleryEntity.class at line 285 (gallerycoreapi::postevent)
* in modules/core/classes/GalleryDerivative.class at line 240 (gallerychildentity::save)
* in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 493 (galleryderivativeimage::save)
* in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 246 (galleryitemhelper_medium::applyderivativepreferences)
* in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 188 (galleryitemhelper_medium::addexistingitemtoalbum)
* in modules/core/classes/GalleryCoreApi.class at line 1575 (galleryitemhelper_medium::additemtoalbum)
* in modules/migrate/ConfirmImport.inc at line 904 (gallerycoreapi::additemtoalbum)
* in ??? at line 0 (confirmimportcontroller::performimport)
* in modules/core/classes/GalleryTemplateAdapter.class at line 914
* in /home/edamameb/g2data_4VyCx6/smarty/templates_c/%%1724620407/%%3A^3A8^3A818B59%%theme.tpl.php at line 69 (gallerytemplateadapter::trailer)
* in lib/smarty/Smarty.class.php at line 1258
* in modules/core/classes/GallerySmarty.class at line 61 (smarty::fetch)
* in modules/core/classes/GalleryTemplate.class at line 209 (gallerysmarty::fetch)
* in main.php at line 473 (gallerytemplate::display)
* in main.php at line 94
* in main.php at line 83
Posts: 32509
your g2 works fine for me. no errors.
the error in your latest post is not the same error you posted earlier. this is not about the session data.
and it doesn't happen when showing normal gallery pages. the above error is from the g1 import wizard.
for storage errors, we need to see the actual mysql error which is only shown in buffered debug mode.
see:
FAQ: How to set/use Gallery in debug mode?
--------------
Doumentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
Posts: 19
very interesting. the album does now in fact work. however, just after the import fails i cannot get to the gallery at all. I wonder if this has to do with my session expiring or some other process on the server that cleans things up on a regular basis.
I do in fact know how to put gallery into debug mode. what I am unsure on is where the error will appear after that. in the same places I have been pasting from, or a new log file I do not yet know about?
I havent been trying on this for the past couple days because I was just plum out of ideas and more than a bit frustrated. I may not get a chance to do it today but I will try your suggestions.
Posts: 19
wow, amazing. on a lark I decided 'hey, since it works lets just try to re-upload.' Normally it was outright broken, so I didnt have the option. Album 12 went just fine. (Of course it is now Album12_0) Maybe it is session data or something similar, but I have waited a few hours before, which is longer than it took me to redo the install and add more pictures...
Anyway, I am thinking of just seeing how it goes from here. Thing is, I want to make sure I have a stable install for the future... any ideas on that?
Btw, as a feature idea, rather than rename the album, would it be possible to give the importer the option to just add non-existant files to the same album?
Posts: 19
I am back to the same old errors. I tried clearing the cache, and I am wondering if it will work in a couple days like last time.
In the mean time, I enabled debug mode. However it is all greek to me. I would appreciate some input.
errors here
http://edamamebeans.com/gallery/main.php
Posts: 19
amazing. I got brave and read the errors. seems my mysql user is exceeding the 'max_questions' limit of 50000.
I deleted the db user and recreated it. was then able to successfully import the rest of my data.
I want to verify the integrity of my albums and db as much as possible, any tips on this would be extreemly helpful
Posts: 32509
there are no good tools to verify the integrity yet.
there's a integrity module in the community repository, but it's very far from being mature.
a good check is deleting the db cache (site admin -> maintenance) and browsing your albums.
and the "build thumbs and resizes" task in site admin maintenance does a lot of db queries and cross checking as well.
--------------
Doumentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage