New Error in 3.0

scalemotorcars · March 29th, 2008, 06:59 PM

My members are starting to use the 3.0 system but I got two more errors. Can you help me with these Chuck. Thanks...

Quote:

An error was encountered during execution of the query:

SELECT paypal FROM cp_users WHERE userid=

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

Quote:

An error was encountered during execution of the query:

SELECT id,user,userid,title,price,reserve,isauction,quantity,duration
FROM cp_products 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

Chuck S · March 29th, 2008, 08:22 PM

what are you doing when you get these errors? I dont see why your userid would be empty or why a product id would be empty as well.

scalemotorcars · March 30th, 2008, 09:07 AM

I didnt do anything. I think it was a member posting an Ad.

Chuck S · March 30th, 2008, 12:04 PM

I would not worry its a bot but you can add this so the queries are not ran where noted in buy.php.

Code:

Content visible to verified customers only.

scalemotorcars · March 30th, 2008, 02:21 PM

Add/Replace?? or just add to the queries? Got a line #? Thanks again Chuck.

Chuck S · March 30th, 2008, 05:01 PM

Just add the code in bold where noted

scalemotorcars · April 3rd, 2008, 11:25 AM

Got 4 more error messages. They look the same but figured I post each just in case.

Code:

Content visible to verified customers only.

Code:

Content visible to verified customers only.

Code:

Content visible to verified customers only.

Code:

Content visible to verified customers only.

I added the code in bold after

Code:

Content visible to verified customers only.

I hope that was right.

Chuck S · April 3rd, 2008, 12:57 PM

yeah not a problem though they may be delayed. The code I told ya to ad should stop them dead.

scalemotorcars · April 3rd, 2008, 04:03 PM

OK bud.

Thanks again. I love your product and totally realize this was a early release.

Keep up the great work.

Chuck S · April 3rd, 2008, 04:30 PM

Your issue would be before applying that think a regular user is not going to get any error thats a bot calling a script without the variables. Hense the addition of the diewell to kill the script if not called right

scalemotorcars · April 12th, 2008, 10:37 AM

Chuck I got about 25 errors this morning all look the same to me and look allot like the one's above except for the user id changing.

Quote:

An error was encountered during execution of the query:

SELECT id,bigimage,cat,userid,approved FROM cp_products WHERE cat=
AND userid=51 AND approved=1 ORDER BY date ASC

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 userid=51 AND approved=1 ORDER BY date ASC' 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

Is this something to worry about and if not is there a way to stop the script from sending reports for this issue and still get reports for others? Thanks

One more thing. Ive got, the 3.0 classifieds, photopost, and reviewpost. How to I know for sure what script its coming from?

Chuck S · April 12th, 2008, 10:44 AM

Its classifieds this line in showproduct.php change $dbcat to $cat in this query

Code:

Content visible to verified customers only.

scalemotorcars · April 12th, 2008, 11:41 AM

Got it. I noticed the line below was already edited to $cat. Ill let you know if it sends anything else.

Thanks again for your help.

Daniel

Chuck S · April 12th, 2008, 11:43 AM

Not a problem.

scalemotorcars · April 14th, 2008, 09:09 AM

I'm putting this here so we can keep things straight with prior changes.

I added the Stats & Most Viewed to the Home sidebar but its not entering any info.
http://www.scalemotorcars.com/classifieds/index.php

But if i set it globally it works but still not on the home page.

http://www.scalemotorcars.com/classi...hp/product/125

Also noticed that sold items are not being marked as sold automatically. Both for single and multiple items. Sold 4 items this morning and all were still showing as active ads. I had to end them manually.

The product above was one of those.

This item had a quantity of 8 to start and I sold 2. Shouldn't it now read 6 left.
http://www.scalemotorcars.com/classi...hp/product/126

Thanks Chuck

One last thing I noticed sold ads are staying on the index and ad.php indefinitely. I looked on the PP board for the answer and came up with a Cron issue but I'm not sure how to set Cron jobs with my host. Do you still have the info I send you on my host?

scalemotorcars · April 14th, 2008, 09:18 AM

Well never mind on the first 2 issues.

I guess it was a matter of it propagating the info.

BUT... I still have the last problem. Sold items are not being marked as sold or changing the quantity sold.

And if I can bug you on one other issue and I know its a mod issue but is there a way to overlay a "Sold" watermark once the item sales. Maybe add it to the above issue. And can it be applied to both the ad and the ad.php for the forumhome? Maybe add it to a future relase of Classifieds as a built in option. Thanks

Chuck S · April 14th, 2008, 01:48 PM

sold ads would only be marked sold automatically if you run your sendnotice.php cron task. You can look in the sticky in the how do I forum on instructions for setting that up

As far as the next maybe a future suggestion sure.

scalemotorcars · March 1st, 2009, 01:33 PM

Chuck I'm still having this problem. I had to shut down the classifieds because of all the database errors I was getting and I just now turned it back on after all this time.

The new error I'm getting.

Quote:

An error was encountered during execution of the query:

SELECT id,bigimage,cat,userid,approved FROM cp_products WHERE cat=
AND approved=1 ORDER BY disporder,date DESC

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 approved=1 ORDER BY disporder,date DESC' at line 1

Another error is that the Value of an item is NOT carried to Paypal checkout. Say I have an item for $40.00 and the buyer clicks Buy It Now. They go to the precheckout page and the first line read the value but the 2nd is left black. The value must be entered manually then updated

Also I'm a verified Customer but I cant see all the content. Do I need to pay $39.00 more just to fix code I already payed for. ????

Edit. I see now after making this post that Ive been moved to just Member. No longer Verified ????

Chuck S · March 1st, 2009, 02:44 PM

PhotoPost Community - Announcements in Forum : PhotoPost Announcements

This should explain how to become verified.

Any discussion here has long since resulted in releases being released to fix any open issues mainly 3.01,3.02,3.03,3.04,3.05 and now we are on 3.1 which is in beta

My suggestion is always to download the latest code and replace files to make sure you get any fixes.

scalemotorcars · March 1st, 2009, 03:00 PM

To do that I need to pay $39.00 to extend my license. I'm sorry its just that the original code isn't working correctly and now to fix the problem I have a to pay the fee.

I payed for a working version and thats not exactly what I got. Don't get me wrong I know you need to make a living but it would have been nice to have the 3.0 version bug free like I payed for.

Tough times for many so another expense isn't very welcome. I guess I have no choice if I want it to work.

By the way Ive purchased three products from you. Photopost, PP classifieds and review post. Do I have to pay $39.00 for each or is one license good enough to fix this.