Hi,
my gallery crashed and i don't know why.
Today a co-worker uploaded some new pictures into our database. Then he tried to delete one album but the script didn't go forward.
Since then the whole gallery seems to be away.
If go to the URL i only get a 404-Error.
The Gallery Files and all the images a still on the server. If i change die Database-Connection-Settings to something wrong i get an database error. But if they are back to normal the 404-Error appears.
I really don't know what's going on and where to look.
/var/logs puts this out:
...
2010-08-09 08:35:35 -07:00 --- error: Kohana_404_Exception [ 43 ]: The page you requested, , could not be found.
/kunden/000068_06114/beta3/modules/gallery/helpers/access.php [ 123 ]
#0 /kunden/000068_06114/beta3/modules/gallery/controllers/albums.php(32): access_Core::required('view', Object(Item_Model))
#1 /kunden/000068_06114/beta3/modules/gallery/controllers/albums.php(22): Albums_Controller->show(Object(Item_Model))
#2 [internal function]: Albums_Controller->index()
#3 /kunden/000068_06114/beta3/system/core/Kohana.php(331): ReflectionMethod->invokeArgs(Object(Albums_Controller), Array)
#4 [internal function]: Kohana_Core::instance(NULL)
#5 /kunden/000068_06114/beta3/system/core/Event.php(208): call_user_func_array(Array, Array)
#6 /kunden/000068_06114/beta3/application/Bootstrap.php(67): Event_Core::run('system.execute')
#7 /kunden/000068_06114/beta3/index.php(94): require('/kunden/000068_...')
#8 {main}
2010-08-09 08:35:35 -07:00 --- error: @todo MISSING_MODEL item:1
#0 /kunden/000068_06114/beta3/modules/gallery/helpers/item.php(209): model_cache_Core::get('item', 1)
#1 /kunden/000068_06114/beta3/themes/wind/views/page.html.php(83): item_Core::root()
#2 /kunden/000068_06114/beta3/system/libraries/View.php(318): include('/kunden/000068_...')
#3 /kunden/000068_06114/beta3/system/libraries/View.php(260): View_Core->load_view('/kunden/000068_...', Array)
#4 /kunden/000068_06114/beta3/modules/gallery/libraries/MY_View.php(69): View_Core->render(false, false, false)
#5 /kunden/000068_06114/beta3/system/libraries/View.php(226): View->render()
#6 /kunden/000068_06114/beta3/modules/gallery/views/kohana/error.php(37): View_Core->__toString()
#7 /kunden/000068_06114/beta3/system/core/Kohana_Exception.php(186): include('/kunden/000068_...')
#8 [internal function]: Kohana_Exception_Core::handle(Object(Kohana_404_Exception))
#9 {main}
it would be really cool if you could help me please.
thx!
Posted: Mon, 2010-08-09 15:39
Posts: 27300
Looks to me like the root album is gone from the DB.
Can you get to: gallery3/index.php/admin via your browser?
How many items in the gallery?
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 12
Thank you for writing.
if i go to domain.tld/index.php/admin it redirects to domain.tld/index.php/login but shows only a blank page. Source-Code of HTML is empty too.
Gallery has 115000 items.
Posts: 16504
Is this really Beta 3 you're still running? There have been many bugs fixed and enhancements since B3. Check to make sure that your images still exist under your gallery3/var/albums /var/resizes and /var/thumbs directories
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 12
no it's RC2 - fresh install.
its only the directory name on the server.
files in var/albums, thumbs and resizes are still there
Posts: 27300
If you use phpMyAdmin or similar DB tool... is there a row with id of 1 in the items table?
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 12
This seems to be the error. No id 1.
Posts: 12
I tried to create a new id 1. Page is still empty. Log says:
2010-08-10 00:35:02 -07:00 --- error: ORM Validation has failed for items model
#0 /kunden/000068_06114/beta3/system/libraries/ORM.php(755): ORM_Validation_Exception_Core::handle_validation('items', Object(Validation))
#1 /kunden/000068_06114/beta3/modules/gallery/models/item.php(774): ORM_Core->validate(NULL)
#2 /kunden/000068_06114/beta3/system/libraries/ORM.php(778): Item_Model->validate()
#3 /kunden/000068_06114/beta3/modules/gallery/libraries/MY_ORM.php(23): ORM_Core->save()
#4 /kunden/000068_06114/beta3/modules/gallery/libraries/ORM_MPTT.php(79): ORM->save()
#5 /kunden/000068_06114/beta3/modules/gallery/models/item.php(487): ORM_MPTT_Core->save()
#6 /kunden/000068_06114/beta3/modules/gallery/models/item.php(285): Item_Model->save()
#7 /kunden/000068_06114/beta3/modules/gallery/models/item.php(133): Item_Model->relative_url()
#8 /kunden/000068_06114/beta3/themes/wind/views/page.html.php(83): Item_Model->url()
#9 /kunden/000068_06114/beta3/system/libraries/View.php(318): include('/kunden/000068_...')
#10 /kunden/000068_06114/beta3/system/libraries/View.php(260): View_Core->load_view('/kunden/000068_...', Array)
#11 /kunden/000068_06114/beta3/modules/gallery/libraries/MY_View.php(69): View_Core->render(false, false, false)
#12 /kunden/000068_06114/beta3/system/libraries/View.php(226): View->render()
#13 /kunden/000068_06114/beta3/modules/gallery/controllers/albums.php(79): View_Core->__toString()
#14 /kunden/000068_06114/beta3/modules/gallery/controllers/albums.php(22): Albums_Controller->show(Object(Item_Model))
#15 [internal function]: Albums_Controller->index()
#16 /kunden/000068_06114/beta3/system/core/Kohana.php(331): ReflectionMethod->invokeArgs(Object(Albums_Controller), Array)
#17 [internal function]: Kohana_Core::instance(NULL)
#18 /kunden/000068_06114/beta3/system/core/Event.php(208): call_user_func_array(Array, Array)
#19 /kunden/000068_06114/beta3/application/Bootstrap.php(67): Event_Core::run('system.execute')
#20 /kunden/000068_06114/beta3/index.php(94): require('/kunden/000068_...')
#21 {main}
My id 1 has this Values:
id album_cover_item_id captured created description height left_ptr level mime_type name owner_id parent_id rand_key relative_path_cache relative_url_cache resize_dirty resize_height resize_width right_ptr slug sort_column sort_order thumb_dirty thumb_height thumb_width title type updated view_count weight width view_1 view_2 view_3 view_4
1 773 NULL 1146643100 TEST NULL 1 1 NULL TEST 460 0 0.123456 NULL NULL 1 NULL NULL 8419 NULL id ASC 0 150 200 TEST album 1278945088 38183 2 NULL 1 0 0 0
can someone please quote his id 1 values?
Thank you
Posts: 12
Great!
Changed
'relative_path_cache' and 'relative_url_cache'
from "null" to ""
Now everything is back normal! Thanks Dave for the hint!
Posts: 27300
Glad you got it sorted out. Would like to know the steps how it really happened so we can prevent this from happening in the future.
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 12
1. created new Album
2. uploaded pictures but something went wrong - only the names of the pictures appeared
3. went to parent-album an deleted the new album
4. screen faded out with the delete box. Waiting-Icon was running but nothing happend
5. went to the homepage of the gallery and got the 404 error
During the delete-process something must have touched the id 1 entry and deleted it.
Hope that helps.
Posts: 16504
That sounds like an old bug that was suppose to have been squashed. Just want to be clear here. This was a clean install of RC2 and not upgrade from a previous version?
See if you can replicate this with the current code, not RC2, but the code from here:
http://github.com/gallery/gallery3/zipball/master
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 12
It was rc1 and updated to rc2.
But never the beta-version.
I used the G2 importer to get my files from g2.
i rather would not try to replicate it because it's kind of a production enviroment the gallery runs on.
we hab problems with g2 so we choosed to go with g3rc2 because it can better handle the high amount of elements.
Posts: 27300
I can't reproduce so will just leave this until somebody can reproduce the issue.
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 12
Dave, I will try it at the Weekend to reproduce the issue.
Posts: 17
Hi I did reprocude the issue here.
unfortunately, i'm not able to fix it.
Gallery is accessible from external http://gallery.joebahr.org/
for u/p please contact me.
I have the same symptoms as Sewi, but i can't seem to find the solution based on what has been written in the thread.
any help will be welcome.
JoeBahr
Posts: 17
Sewi, where did you made those changes ?
Posts: 12
in the items table. At id = 1.
If there isn't a row with id 1 you have to create one.
Posts: 17
ok, i did use a old id 1 from another install of gallery and it made the tricks, however, i have no idea what this items is related to...
Also, i believe i did use some of the maintenance module...i'll try to digg a bit more...and get back to you guys if i find something.
Posts: 16504
id 1 is the main album
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 8
I had the same issue and used the insert line from the installation.sql
In phpmyadmin, click the sql tab and paste this code:
Posts: 105
Worked for me! Same problem just now after trying to delete a sub-album...though I had to change the item to g3_item to match my tables in the SQL.
Posts: 7994
Turns out this was a bug in the Kohana code.
http://sourceforge.net/apps/trac/gallery/ticket/1489
I've fixed it in the 3.0.x branch. Try the latest experimental version.
---
Problems? Check gallery3/var/logs
bugs/feature req's | upgrade to the latest code | use git