I upgraded a gallery of mine from 1.4.27 to 1.5.8, and I'm getting the following error when trying to access one of the top categories (named Photos):
There was an error while processing a database query.
While executing query 'SELECT COUNT(*) FROM cpg14x_comments WHERE pid = ' in include/functions.inc.php on line 2436
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: /home/withholdingmyusername/public_html/gallery/include/functions.inc.php - Line: 263
Error URL: http://gallery.v-fans.net/index.php?cat=9
I have tried:
- reuploading freshly downloaded CPG 1.5.8 files via Filezilla and rerun update.php
- by uploading a zip and unzipping it with cpanel's file manager and rerun update.php
- deleted the cookies and cache of my browser to make sure I was seeing the current version of the page
- deleted all files except for the albums folder and include/config.inc.php, reuploaded 1.5.8 files and rerun update.php
The error persists. I searched the forum with various word combinations from the error, but couldn't find anything that matched my error situation (as far as I understand).
I have enabled debug for all users, and made a test account:
Test login account/password: vtestuser/psdEvuds7e34jvbsl
PHP version: 5.3.3
Apache version: 2.2.16
MySQL version: 5.0.91-community
Can you help? If you need more information, just let me know what.