[SOLVED]How to make changes via PhpMyAdmin effective in albm

loconel

Joined: 2005-03-22
Posts: 3
Posted: Sat, 2005-04-02 09:31

Il like to make changes via PhpMyAdmin or Navicat to a g2_item field g2_description.
Changes are stored in the database but not updated in my album, so probably I have no write access from outside to the album.
How do I cange that

Thank you, Louis (a newcomer in the MySql environment)
 
fryfrog

Joined: 2002-10-30
Posts: 3236
Posted: Sat, 2005-04-02 09:49

Well, the best way is to do this through G2. You should have plenty of access. Though, maybe you want to make mass updates? In that case, I think what you need to do is clear some of G2's cache. You can use the tools to do this, I think in /lib/tools/tests or /setup/lib/tools/tests (I forget).
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Sat, 2005-04-02 16:17

lib/tools/test/index.php FlushCache
do this after any manual db updates to see the changes in G2.
we'll eventually move this capability into Site Admin.
 
loconel

Joined: 2005-03-22
Posts: 3
Posted: Sat, 2005-04-02 17:00

It works great!!!!!!!!!!!!!!! Problem solved

thank you, Louis
 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7985
Posted: Sat, 2005-04-02 22:48

FYI, I just added some code to allow you to flush the database caches. Get the next nightly build and go to Site Admin -> Maintenance and run the "Flush database cache" task.
 
loconel

Joined: 2005-03-22
Posts: 3
Posted: Sun, 2005-04-03 12:06

Hi,

Where can I find the update?
The last update is of 4 march 2005 on sourceforge
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2005-04-03 12:25

http://galleryupdates.jpmullan.com
(you find these links in the left side menu, downloads)