Text only | Text with Images

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: pixnj on July 11, 2006, 10:57:30 PM

Title: error processing database querry
Post by: pixnj on July 11, 2006, 10:57:30 PM
I upgraded and now I get this error when I try to upload a pic

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 ('', '32', 'userpics/10001/', 'pimphand~3.jpg', '43495', '83258', '444', '336', '1152650973', '1', 'djphilly','pimp', '', 'pimp', 'YES', '', '', '', '', '67.81.160.73', '67.81.160.73', '0')" on 0

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

File: /home/djphilly/public_html/creamy_images/include/functions.inc.php - Line: 248

how can I fix this. Thanks in advance.

Rob
Title: Re: error processing database querry
Post by: Nibbler on July 11, 2006, 11:03:43 PM
Did you run update.php ?
Title: Re: error processing database querry
Post by: smithmarcw on July 26, 2006, 12:10:44 AM
Sorry nub here... How do I run update.php. I'm having the same problem  ???
Title: Re: error processing database querry
Post by: Nibbler on July 26, 2006, 12:16:37 AM
Type in update.php at the end of your gallery url, eg http://yoursite.com/gallery/update.php
Title: Re: error processing database querry
Post by: smithmarcw on July 26, 2006, 12:24:44 AM
You the bomb! 8)  Thanks for the quick response and simple "noob" like explanation! :P IT WORKED!
Title: Re: error processing database querry
Post by: pixnj on August 01, 2006, 04:36:45 PM
I did that. Now I cant log into the site. It keeps saying ***couldnt log in. try again*** I checked the database and all the users still exist.
Text only | Text with Images