Mysql error

Hi there,

Can anyone help me on this as i dont really know whats going on here? ive being getting frequent bug reports on this and now have got around 700 email reports on errors such as this. The error code is below any help would be much appreciated. ive looked on the forums but cant find anything simular. There is some kind of adult content there that i dont really want anything to do with my site.

Query:

SELECT * from `Points`

WHERE MemberID=

Mysql error:

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 2

Found error in file /home/partywea/public_html/inc/profiles.inc.php

at line 1896. Called db_res function

with erroneous argument #0

Debug backtrace:

Array

(

[1] => Array

(

[file] => /home/partywea/public_html/inc/profiles.inc.php

[line] => 1896

[function] => db_res

[args] => Array

(

[0] => SELECT * from `Points`

WHERE MemberID=

)

)

[2] => Array

(

[file] => /home/partywea/public_html/guestbook.php

[line] => 676

[function] => assignPoints

[args] => Array

(

[0] =>

[1] => 11

)

)

[3] => Array

(

[file] => /home/partywea/public_html/guestbook.php

[line] => 211

[function] => AddRecord

[args] => Array

(

)

)

[4] => Array

(

[file] => /home/partywea/public_html/guestbook.php

[line] => 113

[function] => ThisPageMainCode

[args] => Array

(

)

)

)

Called script: /guestbook.php

Request parameters:

Array

(

[owner] => 23

[action] => new

[newrecord] => uwtp

car auctions online free

lesbian bottle sex

allies rub and tug

enclosed utility trailers florida

denzel washington contact information

political map of turkey

lyrics yoda weird al

nike swimwear for girls

custom 1911 grips

crimson pool table felt

[add] => Add record

)

--

Auto-report system

Quote · 27 Sep 2008

This could be something to do with Guestbook. There is a 'bot' program out there that injects code into your guestbook. I renamed my guestbook (both the .php file and the url in the 'Builders/Block')

Do a search on  here and you will find all the info you need to correct this problem.

Stuart

There are none so blind as those that will not see.
Quote · 27 Sep 2008

Destination of problem is:

SELECT * from `Points`

WHERE MemberID=

As you see,

where here  MemberID ?

why it ''  ?

so your mod works not fine, have errors.

And yes, this is just modification, just because table `Points` is non default table for dolphin

Quote · 29 Sep 2008

thanks for the replies i will check it out now....

Quote · 5 Oct 2008

It seems that your right stuart038 there is a bot out there that injects into your mysql. From looking at other forums all you need to do is rename your guestbook.php or delete it as the bot cannot find it then. i got mail every ten minutes now i aint getting none thanks god.... My inbox was getting hammered

Thanks for the support

Quote · 5 Oct 2008
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.