ads are not completing correctly after product is purchased

[badgerracing]

Hello,

My classifieds install is having an issue with certain members ads not completing correctly after the ad/product is purchased by not marking the ad as sold and it does not send out the message or emails since the ad was not marked as sold.

All my tests with my account and my test accounts work fine, all the ads that I purchased are marked as sold and the message/emails are sent out. The weird thing is that multiple members (with different user groups) are experiencing the problem with their ads not completing correctly as I stated above. I changed my test user to have all the same account settings as one of the users that was having the issue and my test user ads still work fine.

I also started getting the following DB errors recently:

An error was encountered during execution of the query:
--------------------------------------------------------------------------------------
INSERT INTO cp_messages (msgid,userid,datestamp,message,type,product) values(NULL, 1551, 1309329003, 'RCLargescale<dot>com Renewal Notice<br /><br />savagefan04, your ad on RCLargescale<dot>com for ATX rear tire carrier is going to expire in 0 days.

If you have not sold your product and wish to renew your ad for an additional 30 days, please click on the link below:

www<dot>rclargescale<dot>com/classifieds/editproduct.php?resell=60]Login - RCLargeScale Classifieds

If you have sold your item, please let us know by clicking on this link:

www<dot>rclargescale<dot>com/classifieds/editproduct.php?sold=60]Login - RCLargeScale Classifieds

Thank you!', 'm', )

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

An error was encountered during execution of the query:

INSERT INTO cp_messages (msgid,userid,datestamp,message,type,product) values(NULL, 6348, 1308637802, 'RCLargescale<dot>com Renewal Notice<br /><br />m3lov3r, your ad on RCLargescale<dot>com for HPI BAJA 5B SS 2011.RTR WITH MANY EXTRAS. Ultimate BAJA ********************** is going to expire in 3 days.

If you have not sold your product and wish to renew your ad for an additional 30 days, please click on the link below:

www<dot>rclargescale<dot>com/classifieds/editproduct.php?resell=59]Login - RCLargeScale Classifieds

If you have sold your item, please let us know by clicking on this link:

www<dot>rclargescale<dot>com/classifieds/editproduct.php?sold=59]Login - RCLargeScale Classifieds

Thank you!', 'm', )

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


My Server/env. details are:

URL - www<dot>rclargescale<dot>com / classifieds (Can't post my exact URL because of this stupid rule "You are only allowed to post URLs to other sites after you have made 15 posts or more.")

PP Classifieds version 4.2

CentOS release 5.5 (Final)
Apache/2.2.3
MySQL 5.0.77
PHP Version 5.1.6
GD 2.0.28

safe_mode Off Off
Sockets Support enabled

[Chuck S]

well I use the option of mail and message both in my setup and have never seen an issue. The problem is because your sender userid or product field is empty.

As I see it since the email your referring to is only used by the cron tasks either through the footer cron.php or the server sendnotice.php script which ever your using does not matter but we grab the admin userid based off your admin email when your using the messaging system. We have a function that even does it look here.

Content visible to verified customers only.

Based on what I am seeing your entering an admin email for the system that does not actually correspond to the admin on the site so no userid can be returned.

[badgerracing]

Originally Posted by Chuck S

well I use the option of mail and message both in my setup and have never seen an issue. The problem is because your sender userid or product field is empty.

As I see it since the email your referring to is only used by the cron tasks either through the footer cron.php or the server sendnotice.php script which ever your using does not matter but we grab the admin userid based off your admin email when your using the messaging system. We have a function that even does it look here.

Content visible to verified customers only.

Based on what I am seeing your entering an admin email for the system that does not actually correspond to the admin on the site so no userid can be returned.

I am also using the mail and message option. I think you are missing the key part of my post that ads are not being marked as sold for most members. If an ad is not marked as sold then it seems to me that the classifieds system would not trigger any mail or messages to be sent.

Also, the mail and message system is working fine, when I created test ads and used another user account to purchase the products/ads the ads were marked as sold and both the mail and messages were sent out.

I do have an admin account which is "admin" and the email address on that account was sales@rccrawler.com and is now sales@rclargescale.com. Either way the admin email address that your classifieds system got should have corresponded to the admin account.

www<dot>rclargescale<dot>com/forum/member.php?u=1

[Chuck S]

Your error is telling me the ads are getting marked sold if your running the cron task. You need to be running that to expire. The email error your referring to is showing me you are running the cron. The error is because as I have stated your admin email in the program must be set to whatever email your admin user in vbulletin is set to. If that happens your error disappears.

Our classifieds system if your using messaging yes you need to set the email to match that of the admin user because thats how private messaging thing. A private message is sent from a userid to a userid. I wrote a little function to grab the userid but since that varies by site userid wise you have to grab the userid by something so we use email. It is a messaging thing. You do not have to set your admin email to your forum admin email if you do not use messaging only if you do.

Ads are expired using the cron as follows any ads older than when the script is ran are expired.

Content visible to verified customers only.

[badgerracing]

Originally Posted by Chuck S

Your error is telling me the ads are getting marked sold if your running the cron task. You need to be running that to expire. The email error your referring to is showing me you are running the cron. The error is because as I have stated your admin email in the program must be set to whatever email your admin user in vbulletin is set to. If that happens your error disappears.

Our classifieds system if your using messaging yes you need to set the email to match that of the admin user because thats how private messaging thing. A private message is sent from a userid to a userid. I wrote a little function to grab the userid but since that varies by site userid wise you have to grab the userid by something so we use email. It is a messaging thing. You do not have to set your admin email to your forum admin email if you do not use messaging only if you do.

Ads are expired using the cron as follows any ads older than when the script is ran are expired.

Content visible to verified customers only.

OK, so I have changed the admin email in the classifieds to match the admin email in the forum, so that should fix the email errors as you mentioned.

I am not running the cron task in the classifieds system because that did not work when I had it enabled so I have a cron job on the server set.

#classifieds daily cron
30 2 * * * /usr/bin/wget -q -O /var/log/classifiedslog <mywebsite (still can't post links)>/classifieds/sendnotice.php

After I corrected the email address issue, I relisted a members ad to test again if when I purchase the product the ad would be marked as sold, and again it did not work. I received an email from Paypal regarding my payment but no email (watching the server mail log) was sent out.

I then manually ran the cron job to see if that would mark the ad as sold and it did not. However, when I create ads using any of my accounts and purchase them the ads are immediately marked as sold after the payment process if completed.

Here is the ad that I just relisted and purchased as a test.

www<dot>rclargescale<dot>com/classifieds/showproduct.php?product=57&title=test-2a-2a-2atwo-tone-black-and-silver-team-chase-roll-cage-2a-2a-2atest-do-not-buy-21&cat=47#

[Chuck S]

well two separate things here the cron has nothing to do with payment.

If you are using paypal to pay for an ad you did set in your IPN settings in paypal account your full url to your payment_verification.php script so that paypal can bounce back the proper stuff to your classifieds so the ad is marked as sold.

Any ads which are not verified through the IPN scripting you can view under your approve ads que in admin under the payment pending que and you can mark them paid as needed.

[badgerracing]

Originally Posted by Chuck S

well two separate things here the cron has nothing to do with payment.

If you are using paypal to pay for an ad you did set in your IPN settings in paypal account your full url to your payment_verification.php script so that paypal can bounce back the proper stuff to your classifieds so the ad is marked as sold.

Any ads which are not verified through the IPN scripting you can view under your approve ads que in admin under the payment pending que and you can mark them paid as needed.

Just so were clear, I'm not talking about paying to create an ad, I am referring to an ad that is posted and purchased using the buy it now function using paypal.

Yes my paypal account has the IPN set to <http : // >www<dot>rclargescale<dot>com/classifieds/payment_verification.php

Also, I have no ads in the payment pending queue (or any queue for that matter).

[Chuck S]

That would be extremely strange because very simply when you hit buy it now in our application and you go back to the payment verification we set the status to the time right then so the system knows the ad is sold.

Content visible to verified customers only.

An ad that is not sold has a status of 0

[badgerracing]

Originally Posted by Chuck S

That would be extremely strange because very simply when you hit buy it now in our application and you go back to the payment verification we set the status to the time right then so the system knows the ad is sold.

Content visible to verified customers only.

An ad that is not sold has a status of 0

I agree it's strange, that is why I created this thread.

For some reason, any ads I create with either my account or my test accounts all work fine, but most of my members are experiencing the problem that I am describing in this thread.

I have that exact code in my payment_verification.php file which has 644 permissions (-rw-r--r--) on it.

Yes, the ad that I linked to earlier that I purchased as a test has a status of 0 in the DB even after I purchased it this morning.

So how do I fix this?

[Chuck S]

So just like me you try and replicate the issue you can't.

I honestly do not know anything that would cause issue by a user. For the buy it now to even appear the seller has to have entered there paypal email and everything else to my knowledge happens based on the actual ad id. Userid of the user buying has like to relation to the buying process.

I will look at your files if you want me to but without you or I being able to replicate the issue more info would be needed from a reliable user.

[badgerracing]

Originally Posted by Chuck S

So just like me you try and replicate the issue you can't.

I honestly do not know anything that would cause issue by a user. For the buy it now to even appear the seller has to have entered there paypal email and everything else to my knowledge happens based on the actual ad id. Userid of the user buying has like to relation to the buying process.

I will look at your files if you want me to but without you or I being able to replicate the issue more info would be needed from a reliable user.

One of the members that has the issue let me change their password and use their account to test with so I can replicate the issue with their account, I just can't with my accounts.

If you can look at my files or something that would be great. If I can't get this fixed then I will need to get rid of the classifieds as it is not working as expected. Also, I'm using this install/site as a test before I purchase two more copies of the classifieds software for my two larger sites, but if I can't get it to work on this site then I'm not going to waste my time with my other sites.

Thanks.

[Chuck S]

well it does work I know this. There has to be something that would explain it.

You would have to send all pertinent information to look at things to the contact us link in our header.

[badgerracing]

Originally Posted by Chuck S

well it does work I know this. There has to be something that would explain it.

You would have to send all pertinent information to look at things to the contact us link in our header.

What is all the pertinent info you need?

Website
admin user name / password

[Chuck S]

website url

ftp info

admin username password

problem user login

remember we are trying to replicate this.

[badgerracing]

So I've done more testing and have narrowed down the problem a little more.

1. When the user "TGNSales" creates an ad with buy it now using their "sales@tgnxxxxxx.com" email (same email that is in their forum account), then I purchase the ad using another users account and pay via paypal, when I am returned back to my classifieds after paying the ad is not marked as "sold" and no emails were sent out.

2. Same scenario as #1 only the TGNSales user uses one of their other email addresses associated with their paypal account as the buy it now paypal address then their forum account has. I then purchase the ad as before and the ad is not marked as "sold" after the payment process from paypal (just as in #1).

3. Same scenario as #1 only the TGNSales user uses one of my email accounts linked to one of my paypal accounts. I purchase the ad as before (using a account with a different email then the buy it now email) and everything works fine, I return to the classifieds after payment is made and the ad IS marked as sold and emails were sent out.

There are 5 ads in their section, 3 ads are marked as sold and two not marked as sold even though all 5 ads have been purchased.

I'll send you over the details so you can log in and troubleshoot.

Thanks.

[Chuck S]

I am reading your results and really am not understand as your not showing any pattern that I am seeing.

The only pattern I am seeing is there might be a problem with those one users paypal account. That is your constant.

I do testing my paypal works fine. You do testing your paypal works fine. Everything is centered around this one guy. I do not see how that could be an issue with our code. I have two separate paypal accounts which is how I did the testing. I can use either. There is no requirement to use a specific email. The only requirement I know if is the seller has to put the email to there paypal account. This makes sure they get payment. If a buy does not have a paypal account then they are given the option to register one. Of course the user buying can not be the seller also because you need to use two separate emails.

You can send info to test with if you want. I just do not see anything that has to be user specific when doing this. It just requires the seller to have a valid paypal account.