SQL ERRORS in Upgrade from 5.5 to 5.6
 

Upgrade from 5.5 to 5.6

I am getting a ton of errors now.
When uploading an image I get this. . .


Warning: copy(/home/caliberf/public_html/PHOTOPOST/data/501/cal_003.jpg) [function.copy]: failed to open stream: No such file or directory in /PHOTOPOST/uploadphoto.php on line 679

Warning: getimagesize(/home/caliberf/public_html/PHOTOPOST/data/501/cal_003.jpg) [function.getimagesize]: failed to open stream: No such file or directory in /PHOTOPOST/image-inc.php on line 247

Warning: Division by zero in /PHOTOPOST/image-inc.php on line 292

Warning: getimagesize(/home/caliberf/public_html/PHOTOPOST/data/501/cal_003.jpg) [function.getimagesize]: failed to open stream: No such file or directory in /PHOTOPOST/image-inc.php on line 91

Warning: unlink(/home/caliberf/public_html/PHOTOPOST/data/501/cal_003.jpg) [function.unlink]: No such file or directory in /PHOTOPOST/image-inc.php on line 103

Then on the same page it says "Sorry, this image type () is not supported yet. "

Also, whenever I go to any page other than the index page, my header image gets lost in some screwed up funky url. . . jeez. . .:confused:

When once in a blue moon, an image actually uploads, this is displayed above the header.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /PHOTOPOST/showphoto.php on line 819

I don't know what happened here but it is obvious there has been no testing of this release. There are many customers reporting the very same errors. . .

It would also be nice to have prior releases listed in the download area so I could revert! Bah. . . I'm not a happy camper right now.

What were the SQL errors you got during the upgrade? Your photo gallery appears to be running fine.

You have got to be kidding me. . .

Anyway. When I turn off spider friendly URLS, the header logo doesn't get messed up. . .

http://www.caliberforumz.com/PHOTOPOST/index.php

dont see any errors either.

Now if you use spider urls you might want to make sure your vb header is not using relative image links. You need to edit that vb header and make sure they are full urls.

You don't see the errors if you are not logged in. . .
If you were, and tried to upload an image you would see what I am talking about.

good tip on the header image! Thanks!

You didn't say what the SQL errors were that you got - if your upgrade didn't complete, then that would be the first place I would start. The second would be making sure your paths are properly set since you are getting file not found errors.

I dont recall the errors I got in the upgrade. There were some though! Should I run the upgrade again?

Also, the tip for the header image worked perfectly. Now Spider Friendly URLS don't screw it up.

When I am logged in as Admin, this is constantly displayed above the header.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /PHOTOPOST/showphoto.php on line 819

Does your PhotoPost favorites (maybe pp_favorites?) table exist? It's just a simple query to see if the photo is in your favorites list.

nope it sure doesn't.

Well, that would be a problem. You can create it yourself; but the question is, what else didn't get created during your installation?

Assuming you are using the pp_ prefix:

I get this error upon running that query

SQL query:

CREATE TABLE IF NOT EXISTS pp_favorites(

id int( 12 ) NOT NULL AUTO_INCREMENT ,
userid int( 8 ) NOT NULL default '0',
photo int( 11 ) NOT NULL default '0',
PRIMARY KEY ( id ) ,
KEY parent( photo ) ,
KEY userid( userid ) TYPE = MYISAM

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 4

Here is a screen shot from phpmyadmin

SQL Server version: 4.1.21-standard

I manually added it via phpMyadmin but am unsure where to set these attributes. (I set the id field to parent. . .)

KEY parent (photo), KEY userid (userid) TYPE=MyISAM;

The table is of Type MyISAM.

I still get these errors right after uploading an image.


Warning: getimagesize(home/caliberf/public_html/caliber_watermark.png) [function.getimagesize]: failed to open stream: No such file or directory in /PHOTOPOST/image-inc.php on line 160

Warning: imagecreatefrompng(home/caliberf/public_html/caliber_watermark.png) [function.imagecreatefrompng]: failed to open stream: No such file or directory in /PHOTOPOST/image-inc.php on line 221

Warning: imagesx(): supplied argument is not a valid Image resource in /PHOTOPOST/image-inc.php on line 222

Warning: imagesy(): supplied argument is not a valid Image resource in /PHOTOPOST/image-inc.php on line 223

Warning: imagecopy(): supplied argument is not a valid Image resource in /PHOTOPOST/image-inc.php on line 225

Warning: imagedestroy(): supplied argument is not a valid Image resource in /PHOTOPOST/image-inc.php on line 229

I fixed all of those errors with a foward slash in the path to the watermark image that was missing. I just need to make sure I have constructed that favorites table correctly.