error

WEBDosser · October 5th, 2008, 03:02 AM

Please help.. after upload of 1 picture i get this error..

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/adam/public_html/photopost/forums/threads7.php on line 155

Chuck S · October 5th, 2008, 04:13 PM

Try setting in global options your debug setting to display errors that way as admin you can post the true error here.

Chuck S · October 5th, 2008, 04:15 PM

http://www.photopost.com/forum/1220018-post2.html

let me know if that assists you.

WEBDosser · October 6th, 2008, 12:31 AM

excellent!.. was lowercase and now is UPPERCASE and works fine..

thankyou

Chuck S · October 6th, 2008, 05:32 AM

Interesting you must have been using an older download because the downloaded code I show is uppercase HMM at least in the 9-30-08 download which is our latest.

WEBDosser · October 6th, 2008, 09:56 AM

hmm.. o just downloaded again v6.2 and find that it is lowercase on lines 151 & 152.

Quote:

$results = ppmysql_query("SELECT u.USER_DISPLAY_NAME,p.USER_HOMEPAGE,p.USER_TOTAL_POSTS,p.USER_TITLE,u.USER_REGISTERED_ON,p.USER_LOCATION,USER_AVATAR,USER_SIGNATURE,USER_AVATAR_WIDTH,USER_AVATAR_HEIGHT FROM {$Globals['dprefix']}users u
LEFT JOIN {$Globals['dprefix']}user_profile p ON p.USER_ID=u.USER_ID

i changed the lower to upper and it works ok..