Receiving Critical Error on Site

[MaryFan72]

So the other day after I uploaded a photo to the gallery of my fansite, I was going to upload more photos but upon doing so, I received the following error:

Critical error

There was an error while processing a database query.

While executing query 'SELECT COUNT(*) FROM cpg_comments WHERE pid = ' in include/functions.inc.php on line 2445 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 1

File: /home2/misswin/public_html/gallery/include/functions.inc.php - Line: 270

How can I fix this in order to get my gallery back to normal and continue uploading photos without losing any files?

[Αndré]

Please post a link to your gallery and describe where that error message appears.

[MaryFan72]

Please post a link to your gallery and describe where that error message appears.

& just when you visit it, the message appears.

The link is miss-winstead.com/gallery & when you visit that area of the site is when the message appears.

The main homepage is fine though.

[Αndré]

Please have a look at the following threads:
- http://forum.coppermine-gallery.net/index.php/topic,68552.msg341706.html#msg341706
- http://forum.coppermine-gallery.net/index.php/topic,67596.msg335526.html#msg335526

and report if it works, when you disable 'Display number of comments below the thumbnail'.

[MaryFan72]

But nobody posts comments in the gallery in the first place so I don't think there's anything I'd need to uncheck..... 

[Αndré]

Do it anyway. Please read the threads to get an idea what may cause that issue.

[MaryFan72]

Site's all fixed! 

[lurkalot]

Site's all fixed! 

For the benefit of others who might run into the same problem, could you please tell us what you did to fix it. Please.

[MaryFan72]

For the benefit of others who might run into the same problem, could you please tell us what you did to fix it. Please.

The site owner was able to get in contact with someone who fixed the problem. I didn't ask for details though, sorry. However, site now has new problems, which I posted about here:  http://forum.coppermine-gallery.net/index.php/topic,73176.0.html.