[SOLVED] "Newest Album" question

edriss

Joined: 2004-07-19
Posts: 74

Posted: Mon, 2005-04-18 14:54

Hi,

I just upgraded to G2 Beta 2 from Gallery 1.5. My other setup is as follows:

Windows XP SP2
MySQL 5 beta (latest as of April 17th)
G2 Beta 2 (downloaded on April 17th from CVS)
[upgraded from Gallery 1.5]
Using ImageMagic latest version as of April 1st.

Everything has been imported properly, and things work as is except for one item which I'm sure is a data issue, but I don't know where to modify the value.

I have setup G2 so that the "Newest Album" is shown. The problem is that I have one album which is not the newest album, and it keeps getting chosen as "Newest".

Here are the approaches I took to fix this, none worked:
1) Imported all items from G1. Incorrect "Newest" was shown. Fixed "Show Album Date As" in the "Edit Album" property so that the date was set "back" to the correct date, and that the newer album had a more current date, however, the "incorrect" album was still selected.

2) Started Fresh. Reinstalled G2 (and MySQL actually), imported albums one at a time, ensuring that what I know is the "newest" album was imported LAST. The *same* incorrect album was selected as newest. Fixed dates again as before. This didn't fix the issue.

This is not a huge issue for me, but i would like to know what date is used to select the "newest album". If possible, let me know where in G2 (or even which table and field in the gallery2 database) I should look at to see the field that's being used.

Thanks for your help.

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Mon, 2005-04-18 15:21

it's based on the database table g2_entity field g_creationTimestamp.
When you change the g_creationTimestamp manually, you have to
1. deactivate
2. uninstall
3. install
4. activate
the image block module, because it caches a whole lot of data.
do also maintenance -> clear database cache.

why is it based on g_creationTimestamp? because the intepretation is "the newest item = item last added to the gallery" and not "newest item = item last taken with your camera".

edriss

Joined: 2004-07-19
Posts: 74

Posted: Mon, 2005-04-18 23:11

Thank you very much!
Ran an "UPDATE" statement on the database, uninstalled and reinstalled the module (and cleared cache), and all's well now.

Thank you very much.

edriss Joined: 2004-07-19 Posts: 74	Posted: Mon, 2005-04-18 14:54
	Hi, I just upgraded to G2 Beta 2 from Gallery 1.5. My other setup is as follows: Windows XP SP2 MySQL 5 beta (latest as of April 17th) G2 Beta 2 (downloaded on April 17th from CVS) [upgraded from Gallery 1.5] Using ImageMagic latest version as of April 1st. Everything has been imported properly, and things work as is except for one item which I'm sure is a data issue, but I don't know where to modify the value. I have setup G2 so that the "Newest Album" is shown. The problem is that I have one album which is not the newest album, and it keeps getting chosen as "Newest". Here are the approaches I took to fix this, none worked: 1) Imported all items from G1. Incorrect "Newest" was shown. Fixed "Show Album Date As" in the "Edit Album" property so that the date was set "back" to the correct date, and that the newer album had a more current date, however, the "incorrect" album was still selected. 2) Started Fresh. Reinstalled G2 (and MySQL actually), imported albums one at a time, ensuring that what I know is the "newest" album was imported LAST. The same incorrect album was selected as newest. Fixed dates again as before. This didn't fix the issue. This is not a huge issue for me, but i would like to know what date is used to select the "newest album". If possible, let me know where in G2 (or even which table and field in the gallery2 database) I should look at to see the field that's being used. Thanks for your help.
	XUser login Username: * Password: * Create new account Request new password
valiant Joined: 2003-01-04 Posts: 32509	Posted: Mon, 2005-04-18 15:21
	it's based on the database table g2_entity field g_creationTimestamp. When you change the g_creationTimestamp manually, you have to 1. deactivate 2. uninstall 3. install 4. activate the image block module, because it caches a whole lot of data. do also maintenance -> clear database cache. why is it based on g_creationTimestamp? because the intepretation is "the newest item = item last added to the gallery" and not "newest item = item last taken with your camera".

edriss Joined: 2004-07-19 Posts: 74	Posted: Mon, 2005-04-18 23:11
	Thank you very much! Ran an "UPDATE" statement on the database, uninstalled and reinstalled the module (and cleared cache), and all's well now. Thank you very much.

[SOLVED] "Newest Album" question

XUser login