Text only | Text with Images

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upload => Topic started by: thoxic on December 17, 2005, 07:35:41 PM

Title: 'Position' in 'field list'??????????
Post by: thoxic on December 17, 2005, 07:35:41 PM
I got this error when i try to upload one picture:



There was an error while processing a database query.

Code Select
While executing query "INSERT INTO cpg_pictures (pid, aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '44', 'userpics/10001/', 'thi1-avat.jpg', '27811', '32512', '117', '148', '1134844193', '1', 'ThӸiC','', '', '', 'YES', '', '', '', '', '200.148.4.228', '200.148.4.228', '0')" on 0

mySQL error: Unknown column 'position' in 'field list'

File: /=/=/=/=/include/functions.inc.php - Line: 248

-----

Can someone help me?! CPG 1.4.2.
Title: Re: 'Position' in 'field list'??????????
Post by: Nibbler on December 17, 2005, 07:42:09 PM
Make sure you have run update.php and your db user has ALTER permissions.
Title: Re: 'Position' in 'field list'??????????
Post by: thoxic on December 17, 2005, 07:52:44 PM
Quote from: Nibbler on December 17, 2005, 07:42:09 PM
Make sure you have run update.php and your db user has ALTER permissions.

I´ve upgraded in cpanel with fantastico... and the user has "alter' permissions...
Title: Re: 'Position' in 'field list'??????????
Post by: Nibbler on December 17, 2005, 07:53:48 PM
Run update.php then, and avoid using fantastico.
Title: Re: 'Position' in 'field list'??????????
Post by: thoxic on December 17, 2005, 08:56:18 PM
Quote from: Nibbler on December 17, 2005, 07:53:48 PM
Run update.php then, and avoid using fantastico.

Thanks, I got it now! ;)
Text only | Text with Images