Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: I can't delete albums  (Read 5203 times)

0 Members and 1 Guest are viewing this topic.

joerod

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 12
    • JoeRod.com
I can't delete albums
« 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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: I can't delete albums
« Reply #1 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
Logged

joerod

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 12
    • JoeRod.com
Re: I can't delete albums
« Reply #2 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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: I can't delete albums
« Reply #3 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
Logged

joerod

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 12
    • JoeRod.com
Re: I can't delete albums
« Reply #4 on: August 03, 2004, 08:34:29 pm »
http://www.joerod.com/pix

login: test
password: test1

thanx
Logged

Nibbler

  • Guest
Re: I can't delete albums
« Reply #5 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 ?
Logged

joerod

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 12
    • JoeRod.com
Re: I can't delete albums
« Reply #6 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
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.014 seconds with 15 queries.