Database Error...

maikj · July 11th, 2004, 08:05 PM

I have PP4.8d
PHP (4.3.4), MySQL (4.0.17-log), vB (3.0.3), vbP (3.0.0 Beta 2)
and i get this Error Message (Email)

An error was encountered during execution of the query:

SELECT id FROM photop_favorites WHERE photo= AND userid=175

The query returned with an errorcode of:

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 'AND userid=175' at line 1

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

Any ideas, whats wrong??
Thx
Maik

maikj · July 12th, 2004, 07:42 AM

And again every time somebody uploads a picture...
I will certainly provide any informations needed...

An error was encountered during execution of the query:

SELECT id,bigimage,cat,userid,approved,storecat FROM photop_photos WHERE cat='' AND userid= AND approved='1' ORDER BY disporder,lastpost DESC

The query returned with an errorcode of:

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 'AND approved='1' ORDER BY disporder,lastpost DESC' at line 1

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

maikj · July 12th, 2004, 08:37 PM

Well, a sign of recognition would already do some good. After all, this is a support (Bug Report) forum. I paid some good money and would like to know, why it gives me the error!!

Michael P · July 12th, 2004, 09:31 PM

I don't think this is an actual bug, it may be some kind of spider on your site which is causing the messages. Is anyone uploading images or is this for every upload attempt?

maikj · July 13th, 2004, 04:03 PM

I dont think so..
I am not the SQL specialist, but there are actually several different Messages, that i get every time i access the database, not just uploads.
And all of them refer to this:

The query returned with an errorcode of:

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 'AND userid=1' at line 1

I will be more then happy to provide you with admin rights per pm, so you can see for yourself.

maikj · July 14th, 2004, 01:57 PM

Well, it is now 3 days with a error referring to the sql syntax. The thread got moved and Michael P suggested it might be a spider, causing this issue.

A spider, causing sql syntax errors?? I checked logs, no spiders around, only a user browsing the pics.

I can tell you, the vbulletin support gets your problems fixed or at least responds adequately within max 2 hours.
The same with phpPortals. That is great Support! Two Thumbs up!

But the support here, for a commercial product?! It is very disappointing.

Michael P · July 14th, 2004, 02:02 PM

The SQL syntax may be being caused by something using PhotoPost outside of its normal use.

Can you replicate the error in your browser? If so, please provide a link to the page.

[5 minutes, how'z that? As you can see, this is a very active forum]

maikj · July 14th, 2004, 02:08 PM

It is not in the browser! I get the errror reports via email. There is no Error visible for the user! I sent you actually a PM yesterday with access infos to try it yourself. Just change the email temporarly and browse the gallery. You will see the emails coming in...

[busy, yes, but not as busy as the vb and phpportals forum, you still deserve your 5 mins]

Michael P · July 14th, 2004, 03:01 PM

If there are no errors in the browser and everything is operating as expected, I'm not sure what would be producing the errors except a spider of some sort.

I believe the only line that could produce the "id.bigimage.cat..." error would be in showphoto.php and the line doesn't match what is in my 4.8d as it would have quotes around the userid (are you sure your files are up to date?)

I believe the other error is also sent my showphoto.php; but I believe this may be a spider calling addfav.php without a variable as it is trying to spider the page.