SQL error after 7.0 upgrade
 

I just upgraded from 5.3 to 7.0. PP is sending me emails with the following:

It looks like the userid is missing causing the SQL error, but I can't figure out what page this is on as from my quick look over my gallery frontend I don't see anything obviously missing or erroring.

well that url I would suspect is coming from a bot playing with urls. I dont see anywhere that we dont pass the userid called ppuser

You can post a url here and as well to diagnose this try turning your debug setting to display errors not email errors and click around your gallery and see if you can replicate where its happening.

Can you explain how to do this:

I don't see it in any documentation.

As for the URL its http://www.woodcarvingillustrated.com/gallery/

it is in your photopost admin panel under global options ;)

Aww the most obvious place...

I got that turned on, but I don't see any errors. Any way to easily change the debug routine to include some server vars?

$_SERVER['REMOTE_ADDR'] . $_SERVER['HTTP_USER_AGENT'] . $_SERVER['HTTP_REFERER'] . $_SERVER['REQUEST_URI']

would be mighty helpful.

no sorry none of those would be useful in any manner to our discussion.

Basically what I am saying is the only way this is going to happen is if a bot is playing with urls I would think. I dont see anywhere in the actual program we are passing an empty ppuser statement.

JacobG Gallery - Wood Carving Illustrated Photo Gallery

Thats a members gallery link in your program

- Wood Carving Illustrated Photo Gallery

I can do something like this and I dont see errors so the issue really is how is this error happening. The problem has to be generated someway through showgallery that much I know because that query is only issued one place and only if ppuser exists. Thats what I really mean by changing to display the error and not email it. You then can try and click links like that and see if you can replicate the issue.

I sure cant on your site.

ok, show errors is enabled.

Yep still dont see anywhere in the program clicking links to showgallery that one can get the error.

I think I fixed this. It looks like the error was coming from an old renamed script that was never removed from a previous upgrade. Sorry for the fuzz.

Thanks not a problem yeah no wonder we could not find the issue clicking through the normal files.

I'm having the same error. Could you let me know which script triggered the error?

His issue seems to be from some old custom script he was using.