Blank Entries in the Gallery Tree

netspider

Joined: 2003-08-04
Posts: 5
Posted: Tue, 2005-02-08 02:33

Hello, I have a weird issue going on here with Gallery 2 / Gallery Remote.

Not all albums in the tree are displayed. Instead a white space is present, that doesn't respond to mouse. But if you navigate using cursor keys some sub-menu with normal albums appear.

Check the screen shot for better understanding.

Is there a way to re-initilize the database in Gallery 2 or something? Or is it a GR issue?

Thanks.

AttachmentSize
gr.problem.jpg33.68 KB
 
paour
paour's picture

Joined: 2002-08-14
Posts: 1479
Posted: Tue, 2005-02-08 07:58

Strange... can you attach the GR log?

FAQ Gallery Remote:3
 
netspider

Joined: 2003-08-04
Posts: 5
Posted: Wed, 2005-02-09 01:28
paour wrote:
Strange... can you attach the GR log?

FAQ Gallery Remote:3

Here's my log from a linux machine.
 
paour
paour's picture

Joined: 2002-08-14
Posts: 1479
Posted: Wed, 2005-02-09 07:56

The problem seems to be on the G2 side: a bunch of albums don't have titles. Look for "album.title.249" in the log. Some of these albums have a summary but no title, some have neither. You should be able to find out what's going on on the G2 side from this. Good luck.
 
netspider

Joined: 2003-08-04
Posts: 5
Posted: Sun, 2005-02-13 03:24
paour wrote:
The problem seems to be on the G2 side: a bunch of albums don't have titles. Look for "album.title.249" in the log. Some of these albums have a summary but no title, some have neither. You should be able to find out what's going on on the G2 side from this. Good luck.

Yep, it was exactly as you said.
I've made a simple query that displays names of all albums without title. Maybe somebody will find it useful.

select g_id,g_pathComponent from g2_FileSystemEntity where g_id in (SELECT g_id from g2_Item Where g_title is null and g_canContainChildren=1);

Oh, yeah, MySQL 4.1 only...

P.S.

It might be a good idea to use Path information in gallery remote if title is missing, because when people upload using the web page they might not enter the title there...