Upgraded to PHP 5.1 getting errors

[MrDaniel]

Hi! I upgraded to php 5.1 and am getting mysql errors. I use mysql 4.17 and IIS6..
(with the latest version of photopost)

This is one of the errors I get while trying to upload:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: uploadphoto

Query: INSERT INTO pp_photos (id,user,userid,cat,date,title,description,keywords,bigimage,width,height,filesize,medwidth,medheight,medsize,approved,lastpost, watermarked,allowprint,extra1,extra2,extra3,extra4,extra5,extra6,ipaddress) values(NULL,'Daniel', 1, 533, , 'PICT6875', '', '', 'PICT6875.JPG', 2304, 1704, 832178, 757, 560, 68605, 1, , 'no','no','','','','','','','')

Result: 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 ' 'PICT6875', '', '', 'PICT6875.JPG', 2304, 1704, 832178, 757, 560, 6' at line 3

Database handle: Resource id #6

When I go to the Admin panel I see this on the right window frame:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: adm-misc

Query: DELETE FROM pp_ecards WHERE (readdate > 0 AND readdate < ) OR date <

Result: 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 ') OR date <' at line 1

Database handle: Resource id #5

When trying to view a photo I get this:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: showphoto

Query: REPLACE INTO pp_laston VALUES('509',1,)

Result: 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 ')' at line 1

Database handle: Resource id #6

Any ideas?

[MrDaniel]

okay, I have identified a problem that has to do with the localtime(); php function.... it seems to me that the year value passed from localtime() gives number of years since 1900 but mktime doesn't seem to accept that anymore...

I could be wrong...

Well, the problem seemed to go away if I added this either before or after this entry:
$mon = $mon + 1;
adding the following:
$year = $year + 1900;

that seems to fix at least the showphoto problem....

[Chuck S]

Yes functions do change and it indeed looks like that has

[MrDaniel]

Indeed! Well, the solution I gave works for me. I just have to add $year = $year + 1900; wherever localtime(); is used, just like $mon = $mon + 1; is used... Works fine now!

[Chuck S]

Yes I have a user who just dared to install mysql 5 on there server and having issues installing on that platform. It is always something

[MrDaniel]

yeah, I wouldn't dare doing that yet. I use IPB and I've heard there are a few too many changes in mysql so one must give the script authors some time to catch up!

[Chuck S]

Exactly no host's even have it installed yet. We do not market that we are mysql 5 compatible nor does anyone else I know and from what I see at this point it would almost necessitate a whole separate version

[LLIFE]

Where do I add "$year = $year + 1900;"

[LLIFE]

Found it, thanks.

[Chuck S]

Yes for PHP 5.1x

[Pirotess]

Originally Posted by MrDaniel

Indeed! Well, the solution I gave works for me. I just have to add $year = $year + 1900; wherever localtime(); is used, just like $mon = $mon + 1; is used... Works fine now!

I scanned the 5.21 files and found that the following locations are missing the $year = $year +1900; line after $mon = $mon + 1;

comments.php Line 62
search.php Line 125
showphoto.php Line 218
showphoto.php Line 1035
showphoto.php Line 1068
forums\vb3.php Line 333

Maybe this will be useful to other folks having the problem.

[Chuck S]

Thanks will pass it along