Gallery crashed after adding album photos

marcus.lim

Joined: 2014-06-10
Posts: 4
Posted: Tue, 2014-06-10 07:00

Hi guys, I need some help. I was adding some photographs to an album, which was overwriting some existing photographs in the album.

Once it was done, I logged out. When I tried to access the login page, I get the following message:

" Dang... Something went wrong!
We tried really hard, but it's broken.
Talk to your Gallery administrator for help fixing this!"

I really don't know where to start trying to solve this situation, and any help or pointers in the right direction would be very welcomed.

Thanks so much in advance!

Marcus
 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Tue, 2014-06-10 23:00

What does the gallery3/var/logs have to say?

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
 
marcus.lim

Joined: 2014-06-10
Posts: 4
Posted: Wed, 2014-06-11 03:53

Hi floridave,

There are two logs of interest. The latest one dated 06-10 is at this following address: http://pastebin.com/vuTLyE7n

The second one, which I noticed because it was over 1mb in size, is dated 06-08, around the time I was last uploading the photos, and the beginning portion is pasted at this address: http://pastebin.com/vuTLyE7n

Again, I really appreciate this help

 
marcus.lim

Joined: 2014-06-10
Posts: 4
Posted: Wed, 2014-06-11 03:55

Sorry, my bad. The 06-10 one is here instead:

<?php defined('SYSPATH') or die('No direct script access.'); ?>

2014-06-10 06:30:20 +00:00 --- error: Database_Exception [ 44 ]: #2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/mnt/Raid05_01/gallery_pictures/gallery3/system/libraries/Database_Mysqli.php [ 33 ]
#0 /mnt/Raid05_01/gallery_pictures/gallery3/system/libraries/Database_Mysqli.php(85): Database_Mysqli_Core->connect()
#1 /mnt/Raid05_01/gallery_pictures/gallery3/system/libraries/Database.php(429): Database_Mysqli_Core->escape('var_cache')
#2 [internal function]: Database_Core->quote('var_cache')
#3 /mnt/Raid05_01/gallery_pictures/gallery3/system/libraries/Database_Builder.php(764): array_map(Array, Array)
#4 /mnt/Raid05_01/gallery_pictures/gallery3/system/libraries/Database_Builder.php(1021): Database_Builder_Core->compile_conditions(Array)
#5 /mnt/Raid05_01/gallery_pictures/gallery3/modules/kohana23_compat/libraries/MY_Database_Builder.php(48): Database_Builder_Core->compile()
#6 /mnt/Raid05_01/gallery_pictures/gallery3/system/libraries/Database_Builder.php(957): Database_Builder->compile()
#7 /mnt/Raid05_01/gallery_pictures/gallery3/modules/gallery/libraries/drivers/Cache/Database.php(105): Database_Builder_Core->execute()
#8 /mnt/Raid05_01/gallery_pictures/gallery3/system/libraries/Cache.php(141): Cache_Database_Driver->get(Array, true)
#9 /mnt/Raid05_01/gallery_pictures/gallery3/modules/gallery/helpers/module.php(454): Cache_Core->get('var_cache')
#10 /mnt/Raid05_01/gallery_pictures/gallery3/modules/gallery/config/locale.php(36): module_Core::get_var('gallery', 'timezone', 'UTC')
#11 /mnt/Raid05_01/gallery_pictures/gallery3/system/libraries/drivers/Config/Array.php(70): require('/mnt/Raid05_01/...')
#12 /mnt/Raid05_01/gallery_pictures/gallery3/system/libraries/drivers/Config.php(111): Config_Array_Driver->load('locale', false)
#13 /mnt/Raid05_01/gallery_pictures/gallery3/system/core/Kohana_Config.php(121): Config_Driver->get('locale.language', false, false)
#14 /mnt/Raid05_01/gallery_pictures/gallery3/system/core/Kohana.php(385): Kohana_Config_Core->get('locale.language', false, false)
#15 /mnt/Raid05_01/gallery_pictures/gallery3/system/core/Kohana.php(150): Kohana_Core::config('locale.language')
#16 /mnt/Raid05_01/gallery_pictures/gallery3/application/Bootstrap.php(49): Kohana_Core::setup()
#17 /mnt/Raid05_01/gallery_pictures/gallery3/index.php(116): require('/mnt/Raid05_01/...')
#18 {main}
 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Wed, 2014-06-11 04:06
Quote:
#2002: Can't connect to local MySQL server through socket

The error message you're getting indicates that the MySQL hostname isn't set correctly. Do other DB driven applications on your host work?
Has your host made a change to the DB servers name from the one set in gallery3/var/database.php?
Ask your host why you get that error. Can you login to your DB admin tool your host recommends?

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
 
marcus.lim

Joined: 2014-06-10
Posts: 4
Posted: Wed, 2014-06-11 05:40

It's actually hosted on a physical server in my friend's house. I have remote access to it, and gallery is the only application running on the server. As far as I can tell, no one's touched the system apart from me. I'm not sure how to check if the DB servers' name has been changed.

Again, many apologies if I'm clueless about MySQL and databases, etc. I'm really trying to get up to speed here.

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Wed, 2014-06-11 13:46

I guess your friend is the best resource for seeing if the DB server is correct/working/password/name/hostname/ipaddress/etc...
Have him verify the info in the gallery3/var/database.php file.
Have him verify the operation of the DB with a DB admin tool like phpMyadmin.

Dave

_____________________________________________
Blog & G2 || floridave - Gallery Team
 
togumaqu

Joined: 2014-06-15
Posts: 1
Posted: Mon, 2014-06-16 03:24

I really don't know where to start trying to solve this situation, and any help or pointers in the right direction would be very welcomed.

Thanks so much in advance!
 
spags

Joined: 2010-03-26
Posts: 120
Posted: Mon, 2014-06-16 10:34

There is some relevant MySQL info in the thread at http://galleryproject.org/node/95317 that might give you a starting point. You should probably also remote into the server and see if you can access MySQL using the admin CLI (sorry the name escapes me at the moment - mysqladmin or something of that nature). See if you can see the Gallery database.