Print

[PrinzII]

Coppermine version: 1.4.2

Whenever I upload pictures, I get the following critical error:

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 ('', '8', 'userpics/10001/', 'Moi2005smaller.JPG', '64045', '150445', '436', '290', '1139322740', '1', 'PrinzII','Pic of me taken circa December 2005', '', '', 'YES', '', '', '', '', '67.163.51.59', '67.163.51.59', '0')" on 0

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

File: /home/lawrence/public_html/gallery/include/functions.inc.php - Line: 248

The strange thing is it looks as if it is accepting the picture but when it gets to the point where I am selecting which category to place it in, that's when I get the above message.

I will also double check all settings per the sticky.

[Nibbler]

Verify your mysql user has the ALTER privilege and run the update.php script.

[Joachim Müller]

update from cpg1.4.2 to the most recent stable cpg1.4.3 as well.

[PrinzII]

Checked the My SQL User and it has Alter.

GauGau: I am going to update to 1.4.5 and see what happens.