coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: tms_shan on March 06, 2007, 02:03:26 AM

Title: Cannot move image using EDITPICTURE
Post by: tms_shan on March 06, 2007, 02:03:26 AM
Hey i get an error when i try to edit image

Error:There was an error while processing a database query

can anyone help me?
Title: Re: Cannot move image using EDITPICTURE
Post by: Nibbler on March 06, 2007, 02:35:50 AM
Enable debug mode in config and post the mysql error message you get (not the entire debug output) when you replicate the error.
Title: Re: Cannot move image using EDITPICTURE
Post by: tms_shan on March 06, 2007, 02:42:26 AM
While executing query "UPDATE cpg1410_pictures SET aid = '30', title = 'Accepted', caption = 'Reject Rejection', keywords = '', user1 = 'Accepted', user2 = '', user3 = '', user4 = '2006', user5 = '', user6 = '', user7 = '', user8 = '', user9 = '', user10 = '', user11 = '', user12 = '', user13 = '', user14 = '', user15 = '', user16 = '', user17 = '', user18 = '', user19 = '', user20 = '' WHERE pid='413' LIMIT 1" on 0

mySQL error: Unknown column 'user5' in 'field list'
File: /home/desicov/public_html/upload/include/functions.inc.php - Line: 249


This one displayed at the bottom of the page:
/themes/chaoticsoul/theme.php

    * Notice line 34: Use of undefined constant album - assumed 'album'
    * Notice line 34: Undefined index: album

/editOnePic.php

    * Notice line 37: Undefined index: pwidth
    * Notice line 38: Undefined index: pheight
    * Notice line 46: Undefined index: user5
    * Notice line 47: Undefined index: user6
    * Notice line 48: Undefined index: user7
    * Notice line 49: Undefined index: user8
    * Notice line 50: Undefined index: user9
    * Notice line 51: Undefined index: user10
    * Notice line 52: Undefined index: user11
    * Notice line 53: Undefined index: user12
    * Notice line 54: Undefined index: user13
    * Notice line 55: Undefined index: user14
    * Notice line 56: Undefined index: user15
    * Notice line 57: Undefined index: user16
    * Notice line 58: Undefined index: user17
    * Notice line 59: Undefined index: user18
    * Notice line 60: Undefined index: user19
    * Notice line 61: Undefined index: user20
    * Notice line 63: Undefined index: galleryicon
    * Notice line 70: Undefined variable: delete
Title: Re: Cannot move image using EDITPICTURE
Post by: Nibbler on March 06, 2007, 03:09:51 AM
Review whatever mod you used to add those extra user fields.
Title: Re: Cannot move image using EDITPICTURE
Post by: tms_shan on March 06, 2007, 03:46:34 AM
works man, thanks alot:) hey one more question..is there a MOD to select images (multiple) and move them all at once to different sections?
Title: Re: Cannot move image using EDITPICTURE
Post by: Joachim Müller on March 06, 2007, 08:02:19 AM
We have a strict "one question per thread" policy that you agreed to respect when signing up. Locking.