I can't delete albums

[joerod]

Here is the error I get when I'm in debug mode. 

While executing query "DELETE FROM  WHERE filename='albums/userpics/10001/Dr_Jennifer.jpg' LIMIT 1" on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE filename='albums/userpics/10001/Dr_Jennifer.jpg' LIMIT 1'

can anyone help me w/ this problem.

[Joachim Müller]

Please describe what you actually did when this error message appeared, A link (and if necessary, a test user account without admin privileges) would come handy.

GauGau

[joerod]

I'm trying to remove an ablum and I get the error.  Could it be that I upgraded to 1.3?  When I press delete the images gets deleted but the link to it does not, it just shows up as a broken image

[Joachim Müller]

Please post a link and a test account (non-admin) with privileges to have personal galleries.

GauGau

[joerod]

http://www.joerod.com/pix

login: test
password: test1

thanx

[Nibbler]

That's the query to delete the exif info from the db, looks like $CONFIG['TABLE_EXIF'] is not set. Can you verify the line

Code Select Expand

$CONFIG['TABLE_EXIF']                = $CONFIG['TABLE_PREFIX']."exif"; appears in your include/init.inc.php ?

[joerod]

Error msg
"While executing query "DELETE FROM  WHERE filename='albums/userpics/10001/I_Want_a_Famous_Face-Sha.jpg' LIMIT 1" on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE filename='albums/userpics/10001/I_Want_a_Famous_Face-Sha."



File: /homepages/46/d93097928/htdocs/joerod/pix/include/functions.inc.php - Line: 105



Notice: Undefined index: user_lang in /homepages/46/d93097928/htdocs/joerod/pix/include/init.inc.php on line 233

Notice: Undefined index: memberlist_title in /homepages/46/d93097928/htdocs/joerod/pix/themes/gray_satin/theme.php on line 929

Notice: Undefined index: memberlist_lnk in /homepages/46/d93097928/htdocs/joerod/pix/themes/gray_satin/theme.php on line 930

Notice: Undefined index: faq_title in /homepages/46/d93097928/htdocs/joerod/pix/themes/gray_satin/theme.php on line 950

Notice: Undefined index: faq_lnk in /homepages/46/d93097928/htdocs/joerod/pix/themes/gray_satin/theme.php on line 951

Notice: Undefined index: db_ecard_lnk in /homepages/46/d93097928/htdocs/joerod/pix/themes/gray_satin/theme.php on line 991