forum.coppermine-gallery.net

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! ;)