PhotoPost Community - database query error in 6.1

PhotoPost Community (http://www.photopost.com/forum/)

- Photopost Pro Installation & Upgrades (http://www.photopost.com/forum/photopost-pro-installation-upgrades/)

- - database query error in 6.1 (http://www.photopost.com/forum/photopost-pro-installation-upgrades/136665-database-query-error-6-1-a.html)

ncangler

May 19th, 2008 07:31 PM

database query error in 6.1

I have upgraded Photopost, Classifieds and Reviewpost so I'm not sure which one is causing this error, but any help is most appreciated.

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: Photopost Pro Bug Reports - PhotoPost Community

To turn off these emails, set $debug=0 in your config-inc.php file.

Chuck S

May 19th, 2008 09:05 PM

I suggest you look at which product has a prefix of pp_

I would think Photopost your bulkupload.php file and my main question would be why is your defcat variable empty as that should never happen but you can encapsulate the variable in that query to stop that error

Code:

Content visible to verified customers only.

ncangler

May 19th, 2008 10:35 PM

The "pp_" prefix would be a giveaway wouldn't it. :) Looks like the ' before $ was missing for some reason. id='$defcat'",

Thanks Chuck!

Chuck S

May 20th, 2008 06:55 AM

No it was not missing the single quotes around that variable is something I added just for you. Really what I was saying outloud here is I would have no idea why your defcat variable would be empty since thats passed on the natural progression from the upload script.

aberg

May 24th, 2008 12:41 PM

Quote:

Originally Posted by ncangler (Post 1224738)

The "pp_" prefix would be a giveaway wouldn't it. :) Looks like the ' before $ was missing for some reason. id='$defcat'",

Thanks Chuck!

Again thanks Chuck!
Same error here and same solution don't know why I also missing the ' before and after $defcat

All times are GMT -5. The time now is 08:17 AM.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97