coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upload => Topic started by: paperraven on April 10, 2006, 04:57:16 AM

Title: Mysteriously Can't Add Photos
Post by: paperraven on April 10, 2006, 04:57:16 AM
[Solved, thanks to Nibbler and kegobeer :D]

After taking a week-long trip to Colorado, I came back to try to upload some photos from said trip and my Coppermine was doing really odd things.  (I've NEVER had any problems with it up until this point, and I've got a lot of photos already on there.  Things had been working normally before I left.)  It's really strange - I get the file to upload, it gives me this message "1 uploads were successful."  So I click continue to add files to albums, which also goes normally.  I fill out all the fields and then click continue, and it gives me a "critical error":

There was an error while processing a database query

So the file uploads, I just can't get it to add it to the album.  Is this a script problem, or could it be my server, or even the database?  It's just so bizarre that the problem cropped up seemingly out of nowhere... can anyone help me?  I'd be very grateful :)

Title: Re: Mysteriously Can't Add Photos
Post by: kegobeer on April 10, 2006, 05:30:35 AM
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#upload_trouble
Title: Re: Mysteriously Can't Add Photos
Post by: paperraven on April 12, 2006, 03:58:46 AM
I've done everything that that told me to do.. and it didn't fix anything.  The debug did inform me that the actual MySQL error was:

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

Should I go into PHPMyAdmin and delete that column?  I've no idea what to do..
Title: Re: Mysteriously Can't Add Photos
Post by: Nibbler on April 12, 2006, 04:00:06 AM
Did you update from 1.3 ?
Title: Re: Mysteriously Can't Add Photos
Post by: paperraven on April 12, 2006, 04:14:43 AM
Yes, awhile ago.  Sorry that I didn't mention that before... but I could have sworn I'd uploaded photos after I upgraded, maybe I'm wrong.  Was there some problem with my upgrade?  I did it automatically through my Cpanel.
Title: Re: Mysteriously Can't Add Photos
Post by: Nibbler on April 12, 2006, 04:18:48 AM
Run update.php in your browser.
Title: Re: Mysteriously Can't Add Photos
Post by: paperraven on April 12, 2006, 04:30:52 AM
Thank you so much, I've got it working now :)  You guys are so helpful!!! ;D ;D ;D