PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro Bug Reports

Photopost Pro Bug Reports Post post installation PhotoPost Pro problems here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old January 31st, 2010, 07:56 AM   #1 (permalink)
Junior Member
 
Join Date: Apr 2006
Posts: 14
MyQSL error

An error was encountered during execution of the query:

SELECT photo,comment FROM pp_comments WHERE userid= AND comment != '' ORDER BY date DESC LIMIT 1

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 comment != '' ORDER BY date DESC LIMIT 1' at line 1


any idea how to fix this error?

thanks
cookie is offline   Reply With Quote
Old January 31st, 2010, 08:41 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 68,070
Are you using the latest code. I dont see how you would recieve that error. that query is in member.php when viewing a users profile and $uid should not be empty.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old January 31st, 2010, 10:17 AM   #3 (permalink)
Junior Member
 
Join Date: Apr 2006
Posts: 14
well, i guess i have uploaded the last version. I will reload them and see if this problem stops.

thanks anyway for the fast support
cookie is offline   Reply With Quote
Old January 31st, 2010, 10:20 AM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 68,070
No problem let me know
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 11:05 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0