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 July 13th, 2008, 08:48 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Dec 2006
Location: Chicago
Posts: 64
sql query bug

Chuck,

I received the following email from the system:

Quote:

An error was encountered during execution of the query:

SELECT catname,extra1,extra2,extra3,extra4,extra5,extra6,numextra FROM pp_categories WHERE id=

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 '' 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.

ChefTalk is offline   Reply With Quote
Old July 13th, 2008, 09:25 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,703
Well I can tell you it is not happening from normal operation of the program.

Most likely a spider bot running random things because we would always pass a defcat variable to bulkupload.

You can silence the error by encapsulating the $defcat variable on that line like so

Code:
Content visible to verified customers only.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old July 13th, 2008, 09:42 AM   #3 (permalink)
Member
Verified Customer
 
Join Date: Dec 2006
Location: Chicago
Posts: 64
Chuck how do I get to this code?

Thanks.
ChefTalk is offline   Reply With Quote
Old July 13th, 2008, 10:20 AM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,703
In bulkupload.php line 538. Sorry should have been alot clearer there.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bug in Add Category Query [added 2.4] tmhall Bugs - vBulletin 3.6x 3 November 8th, 2007 01:37 AM
Since last visit SQL query John_770 Photopost Pro How Do I...? 2 June 6th, 2007 06:23 AM
pp 5.1 sql error (not a bug) filipv Photopost Pro Bug Reports 11 June 5th, 2005 07:22 AM
SQL Bug - Installer mr.gamesbay Installs and Upgrade - vBulletin 3.0.X 3 March 2nd, 2005 12:41 PM
Problem with sql query in contact.php h2ojunkie Classifieds Bug Reports 2 February 26th, 2005 06:48 AM


All times are GMT -5. The time now is 05:15 PM.

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