can't delete an album with an apostrophy (')

cdike

Joined: 2005-04-18
Posts: 5
Posted: Mon, 2005-04-18 22:08

I was being rediculous and created an album in Gallery remote with an apostrophy. Now i cant delete or do anything with the album. The picture are in it, but its not kosher. You can check out the gallery there is one that was uploaded and created properly and another that used the apostrophy and all the thumbnails are screwed. how can i delete the entire album?
----
The following information is required to get an answer:
Get this information from the PHP diagnostic (in the configuration wizard).
Gallery URL (optional but very useful): http://pages.uindy.edu/~dikeca/gallery2/
Gallery version:
Apache version: dk
PHP version (don't just say PHP 4, please): dk
Graphics Toolkit:
Operating system: xp
Web browser/version (if applicable): firefox

 
JustinHoMi

Joined: 2002-08-17
Posts: 42
Posted: Mon, 2005-04-18 22:11

Hmm, is magic quotes on or off?

 
cdike

Joined: 2005-04-18
Posts: 5
Posted: Mon, 2005-04-18 22:13

where can i turn that on?

 
cdike

Joined: 2005-04-18
Posts: 5
Posted: Mon, 2005-04-18 22:18

i created the Name with an apostrophy in it (even though it told me not to...it was an accident). The title i can use apostrophies just fine

 
cdike

Joined: 2005-04-18
Posts: 5
Posted: Mon, 2005-04-18 22:38

new developments. I used the cleanup.php program, and then tried to delete the file. It gave me a weird error output screen. Here is a link to it below:

http://pages.uindy.edu/~dikeca/error.html

 
h0bbel
h0bbel's picture

Joined: 2002-07-28
Posts: 13451
Posted: Mon, 2005-04-18 22:55

[Moved to G2 Support]

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Thu, 2005-04-21 05:32

I'm not sure which album is the busted one from looking at your gallery. How did you manage to create it that way? We should fix that bug, certainly.

You can fix this problem by editing the g2_filesystementity table to remove the offending apostrophe, then renaming the album on disk to match. Then go to Site Admin -> Maintenance and do the "Flush Database Cache" task.

 
cdike

Joined: 2005-04-18
Posts: 5
Posted: Wed, 2005-05-18 17:11

the busted one is the album in the middle and i cant find the Maintenance option within the Site Admin screen. also i found the g2-filesystementity table but my mysql skillz are not that great so i am unsure how to do this

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Thu, 2005-05-19 05:09

Install phpMyAdmin and use its web interface to edit the database...