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 Classifieds Support > Classifieds Bug Reports

Classifieds Bug Reports Post any problems you may be having with Classifieds here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old December 18th, 2005, 12:35 PM   #1 (permalink)
Member
Verified Customer
 
Join Date: Nov 2005
Posts: 57
ClassifiedAdzS MySQL Error Report

I am getting the following email (3 at a time) several times a day:


SELECT id,catname,template FROM pp_categories WHERE id=last14?ABCDEFGH

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 '?ABCDEFGH' 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.
Johnbmtl is offline   Reply With Quote
Old December 18th, 2005, 05:24 PM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,802
Well I don't think it would be possible with what your showing. What version of classifieds you have. See that query is only in one spot in the program on line 159 of showcat.php

Code:
Content visible to verified customers only.
You error states the $cat variable is this last14?ABCDEFGH and the query there will only be executed if cat is a numeric variable and it is not in your example

I will do some more testing but looking at the code and the example since it is not a numeric variable that query would never be run.
__________________
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 December 18th, 2005, 05:39 PM   #3 (permalink)
Member
Verified Customer
 
Join Date: Nov 2005
Posts: 57
Quote:
Originally Posted by Chuck S
Well I don't think it would be possible with what your showing. What version of classifieds you have.
Are you saying that you don't think it is possible for me to receive these messages??? I get them at least once a day.

I have only been using the software for a few weeks, so I assume that I have the latest version.

Where do I find the version number?
Johnbmtl is offline   Reply With Quote
Old December 18th, 2005, 05:46 PM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,802
You can see the version number in admin

What I am saying is in PHP there are certain functions and we surround that query with a conditional statement meaning the query is only ran if the variable is numeric

elseif ( is_numeric($cat) ) {

I am not doubting you I am merely pointing out that this is not numeric at all

last14?ABCDEFGH

From a coding standpoint quite impossible to understand why the query would run. Hense my statement I would have to do some more testing
__________________
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 December 18th, 2005, 05:56 PM   #5 (permalink)
Member
Verified Customer
 
Join Date: Nov 2005
Posts: 57
Version 2.42.
Johnbmtl is offline   Reply With Quote
Old January 13th, 2006, 06:50 AM   #6 (permalink)
Member
Verified Customer
 
Join Date: Apr 2004
Location: Finland
Posts: 89
I'm having this same problem (I have v. 2.42)

-------------
An error was encountered during execution of the query:

SELECT id,catname,template FROM categories WHERE id=http:/www.bysimplicity.host.sk/cmd.gif?

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 ':/www.bysimplicity.host.sk/cmd.gif?' at line 1

--------

You are saying that you have this "elseif ( is_numeric($cat) ) " there to check if it's numeric.

Well, yes, but that mysql query is in line 159 and your is_numeric check is in line 254 so that mysql query runs before any checks are being made so this bug is real and is a security problem.
Mikan is offline   Reply With Quote
Old January 13th, 2006, 09:06 AM   #7 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,802
Check showcat.php and change this

Code:
Content visible to verified customers only.
to this

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 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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL error... Rich Z Photopost Pro Bug Reports 1 August 29th, 2005 10:29 PM
MySQL error... Rich Z Classifieds Bug Reports 28 April 27th, 2005 01:28 PM
Mysql error Reynaldo Installs and Upgrade - vBulletin 3.0.X 2 January 23rd, 2005 12:00 PM
mysql error? shamrox Photopost Pro Installation & Upgrades 1 June 27th, 2004 06:09 PM


All times are GMT -5. The time now is 01:26 PM.

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