Print Page - I can't delete albums

Title: I can't delete albums
Post by: joerod on July 08, 2004, 04:26:29 PM

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.

Title: Re: I can't delete albums
Post by: Joachim Müller on July 09, 2004, 06:34:15 AM

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

Title: Re: I can't delete albums
Post by: joerod on July 19, 2004, 08:04:57 PM

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

Title: Re: I can't delete albums
Post by: Joachim Müller on July 19, 2004, 10:27:25 PM

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

GauGau

Title: Re: I can't delete albums
Post by: joerod on August 03, 2004, 08:34:29 PM

http://www.joerod.com/pix

login: test
password: test1

thanx

Title: Re: I can't delete albums
Post by: Nibbler on August 03, 2004, 08:57:34 PM

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

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

Title: Re: I can't delete albums
Post by: joerod on August 06, 2004, 05:02:02 PM

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

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: joerod on July 08, 2004, 04:26:29 PM