Mysql Error

[skidpics]

Can anyone shed some light on this error?

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

It shows on uploadphoto.php

here is line 78:

while ( list( $userid, $username ) = mysql_fetch_row($queryv) ) {

[Chuck S]

Content visible to verified customers only.

Line 78 of Photopost.php file not uploadphoto.php. Add in bold as noted in that query.

[skidpics]

hmmm- that didn't resolve the issue.

[Chuck S]

Try reapplying it

[skidpics]

got it. thanks!

[Chuck S]

Not a problem glad to help

[skidpics]

tell me something. I switched hosting finally - not sure if you remember the previous discussions about yahoo hosting (yuck) - either way, I have the errors set to 'do nothing' in admin, but I still see them here and there. What is causing the display of the errors, as they were not being displayed with my yahoo hosting.

[Chuck S]

No idea the error your talking about here is going to show no matter what display errors would display the full error email error is gonna email the full error do nothing does nothing it does not mean its gonna keep you from seeing a line error when viewing the site if something is wrong

The issue you had above is endemic of 6.1 as It appears Michael changed by mistake that query leaving out the user on the field names.

[skidpics]

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/usr/local/bin/jpegtran) is not within the allowed path(s): ('.:/proc/uptime:/tmp:/home:/usr/local/lib/php:/usr/home:/usr/local/bin/') in /home/vande11/public_html/skidpics/image-inc.php on line 592


What is this? Duplicate File names?

[Chuck S]

open_basedir is set on your server you can not use jhead jpegtran or imagemagick.

remove the jpegtran path in admin global options and your fine.

[skidpics]

Originally Posted by Chuck S

open_basedir is set on your server you can not use jhead jpegtran or imagemagick.

remove the jpegtran path in admin global options and your fine.

What do you mean I cannot use Imagemagick? It is running fine.. well, unless those errors are being created by it?

[Chuck S]

I am just responding to the error. If you remove the jpegtran line does the error go away?

[skidpics]

removing those entried indeed seem to do the trick.

thank you very much..

[Chuck S]

Have a good weekend.