Changing description/summary so it's present in the edit photo

jlana

Joined: 2006-02-27
Posts: 3

Posted: Mon, 2006-02-27 10:24

That what I'm trying to do - doesn't seem to work if I just upload a new pic and then do a mysql query that changes the g2_Item.g_summary or .g_description from null to anything.
Doing it that way will change the field and if I change the summary to for example "foo" and then do a search with string "foo", it does find the picture - BUT when I click the photo and then Edit Photo from the menu, the summary/description is blank :O

ckdake

Joined: 2004-02-18
Posts: 2258

Posted: Mon, 2006-02-27 20:55

1. you shouldn't me manually manipulating the database.

2. if you do, you need to clear the database cache from site admin after every database change.

--
http://ckdake.com/

If you found my help useful, please consider donating to Gallery.

jlana

Joined: 2006-02-27
Posts: 3

Posted: Tue, 2006-02-28 08:59

1. Well yeah actually I do have to, since I'm just a web monkey doing the things the management wants ;)
We've got hundreds, maybe thousands of pics to import into gallery2 from just plain files around the server and I'm making a script that helps setting the keywords into the pictures (so it's not necessary to do it the hard way one by one), as well as adding the name of the photographer into the description field or the summary field.

2. Ok, that makes it work, great... have to figure out a way to automate that :P
Thnx

EDIT: yeah, on the same line where I change the description field I just use a recursive remove folder function (http://aidan.dotgeek.org/repos/v/function.rmdirr.php) to delete the cache-folder and everything works again, gg

ckdake

Joined: 2004-02-18
Posts: 2258

Posted: Tue, 2006-02-28 14:57

If you're doing lots of these at once and people aren't using the web interface, you don't _have_ to clear the cache after every item, just as long as you do it it before you come here complaning of weird error messages in the web browser

--
http://ckdake.com/

If you found my help useful, please consider donating to Gallery.

jlana Joined: 2006-02-27 Posts: 3	Posted: Mon, 2006-02-27 10:24
	That what I'm trying to do - doesn't seem to work if I just upload a new pic and then do a mysql query that changes the g2_Item.g_summary or .g_description from null to anything. Doing it that way will change the field and if I change the summary to for example "foo" and then do a search with string "foo", it does find the picture - BUT when I click the photo and then Edit Photo from the menu, the summary/description is blank :O
	XUser login Username: * Password: * Create new account Request new password
ckdake Joined: 2004-02-18 Posts: 2258	Posted: Mon, 2006-02-27 20:55
	1. you shouldn't me manually manipulating the database. 2. if you do, you need to clear the database cache from site admin after every database change. -- http://ckdake.com/ If you found my help useful, please consider donating to Gallery.

jlana Joined: 2006-02-27 Posts: 3	Posted: Tue, 2006-02-28 08:59
	1. Well yeah actually I do have to, since I'm just a web monkey doing the things the management wants ;) We've got hundreds, maybe thousands of pics to import into gallery2 from just plain files around the server and I'm making a script that helps setting the keywords into the pictures (so it's not necessary to do it the hard way one by one), as well as adding the name of the photographer into the description field or the summary field. 2. Ok, that makes it work, great... have to figure out a way to automate that :P Thnx EDIT: yeah, on the same line where I change the description field I just use a recursive remove folder function (http://aidan.dotgeek.org/repos/v/function.rmdirr.php) to delete the cache-folder and everything works again, gg

ckdake Joined: 2004-02-18 Posts: 2258	Posted: Tue, 2006-02-28 14:57
	If you're doing lots of these at once and people aren't using the web interface, you don't _have_ to clear the cache after every item, just as long as you do it it before you come here complaning of weird error messages in the web browser -- http://ckdake.com/ If you found my help useful, please consider donating to Gallery.

Changing description/summary so it's present in the edit photo

XUser login