SQL ERRORS in Upgrade from 5.5 to 5.6

ESAD · November 26th, 2006, 09:11 PM

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. "

ESAD · November 26th, 2006, 09:14 PM

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

ESAD · November 26th, 2006, 09:25 PM

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

ESAD · November 26th, 2006, 09:55 PM

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.

Michael P · November 26th, 2006, 10:05 PM

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

ESAD · November 26th, 2006, 10:17 PM

You have got to be kidding me. . .

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

Chuck S · November 26th, 2006, 10:19 PM

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.

ESAD · November 26th, 2006, 10:20 PM

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.

ESAD · November 26th, 2006, 10:20 PM

good tip on the header image! Thanks!

Michael P · November 26th, 2006, 10:21 PM

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.

ESAD · November 26th, 2006, 10:23 PM

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.

ESAD · November 26th, 2006, 10:25 PM

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

Michael P · November 26th, 2006, 10:27 PM

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.

ESAD · November 26th, 2006, 10:31 PM

nope it sure doesn't.

Michael P · November 26th, 2006, 10:37 PM

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:

Code:

Content visible to verified customers only.

ESAD · November 26th, 2006, 10:47 PM

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

ESAD · November 26th, 2006, 10:53 PM

Here is a screen shot from phpmyadmin

SQL Server version: 4.1.21-standard

ESAD · November 26th, 2006, 11:38 PM

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.

ESAD · November 26th, 2006, 11:41 PM

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

ESAD · November 26th, 2006, 11:51 PM

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.