5.5 to 5.6 - error uploading

starman · November 27th, 2006, 11:37 AM

Upgraded from 5.5. to 5.6
VB3 3.5.7

When users try to upload they receive the follow error.

"There was an error uploading this photo. Please report to System Administrator."

I tested uploading one as Admin and received the same error. File and directory permissions look ok. The file did make it into the upload directory.

Any help would be greatly appreciated.

www.scrollsawer.com/gallery/

starman · November 27th, 2006, 04:57 PM

I just saw the 5.61 update. I'm assuming I should run the new upgrade script to see if this flushes out my troubles...

Chuck S · November 27th, 2006, 05:05 PM

Yes there is a new update and you can run the upgrade script for that.

starman · November 27th, 2006, 11:24 PM

Ran the upgrade and now get the following errors...

When trying to view a photo...
"Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /www/woodcarvingillustrated.com/htdocs/gallery/showphoto.php on line 83"

When I upload an image I still receive...
There was an error uploading this photo. Please report to System Administrator.

Michael P · November 28th, 2006, 07:48 AM

It would appear that you didn't run all the upgrades? Did you run the 5.5 -> 5.6 and 5.6 -> 5.61 upgrades?

starman · November 28th, 2006, 08:52 AM

Yes I ran all the upgrades... First 5.5 to 5.6. 5.6 threw the erro describe in the first post. Then ran 5.6 to 5.61 and receive the new errors.

starman · November 28th, 2006, 09:47 AM

Should I reupload the files and run the script again? Help would be greatly appreciated

Chuck S · November 28th, 2006, 09:47 AM

It would appear as Michael states you have not ran all the upgrades you need to run

There are several upgrades that alter the photos table. What version did you have?. You can try running 5.2 upgrades forward incase you has 5.2 and not 5.3

starman · November 28th, 2006, 10:01 AM

I was running 5.3 without any issues.

starman · November 28th, 2006, 10:09 AM

I had a couple errors but it seems to be fixed now... Are any of the errors of any worry...

5.3x to 5.5

No errors

5.5 to 5.6

Preparing to update database...
Error performing MySQL command: ALTER TABLE pp_users ADD lastphoto INT( 12 ) NOT NULL DEFAULT '0', ADD lastdate INT( 15 ) NOT NULL DEFAULT '0'
Error: Duplicate column name 'lastphoto'

Error performing MySQL command: INSERT INTO pp_settings VALUES (221,'Require users to be registered to use search?','searchreg','','no',1,14)
Error: Duplicate entry '221' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (222,'Maximium number of search results to return?','searchmax','On larger sites, the less the better.','500',2,14)
Error: Duplicate entry '222' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (223,'Number of seconds between searches?','searchto','The number of seconds a user must wait between searches.','30',3,14)
Error: Duplicate entry '223' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (224,'Number of days to hold search results?','searchhold','','7',5,14)
Error: Duplicate entry '224' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (225,'Display who is viewing a category?','catonline','This option adds a query to the Show Gallery page.','yes',5,4)
Error: Duplicate entry '225' for key 1

5.6 to 5.61
Error performing MySQL command: RENAME TABLE pp_search TO pp_searchids
Error: Table 'pp_searchids' already exists

Chuck S · November 28th, 2006, 10:12 AM

That just means you already ran those upgrades your issue was you had initially not ran the 5.3 upgrade which is evident by you not getting the duplicate errors as you did with the later upgrades

which is why I had suggested to run the 5.2 forward since there where other upgrades besides the 5.5 that altered your photos table.

starman · November 28th, 2006, 10:14 AM

Thanks much for the help! As always it is greatly appreciated...