TOPIC: About build an record after doing Payment in PayPal

Hi All,

I have faced a question about creating an records after somebody registered one of the event and get to the PayPal to do the payment and there is no record built afterward.

As I found that the record will be created once the bill is paid successfully and return back to the website. I have done some setting on the Paypal side which turns on the auto return and try to force registrant to go back to the site but still happen that registrant record is built in Paypal but nothing in the dt register records, did anybody faced the same issue before and any solution suggest?

Hello. Our provided instructions for PayPal setup tell you to NOT turn on auto-return. That will make your records fail. Here is the setup you should have:

- IPN must be enabled in the PayPal account
- Sending of IPN messages must be enabled (in a personal paypal account)
- Auto-return must be turned OFF
- Permissions must be correct on your site... all directories 755 and files 644
- make sure no firewall settings are blocking IPN from communicating with your site.

Thank you for your help,

The reason of turning on the auto return at the beginning is that I follow the instruction as you mentioned to set up the environment, but it happen strangely that some of the registers has done the payment in the paypal side, and the paypal keep their payment records but there is no record in the dtregister admin panel, I also checked that the ipn history has been created and both are in sent status, the table "dt_register_session" also create some records with the form variable, As I am sure that if user went back to the main site by the "return" url set, the record must be created. So that's why I would like to turn it on for forcing register to go back to the site after the payment is done.

I have turned it off and just wonder is there anything also be awared or any suggestion whether I can test the IPN part run properly once the sandbox payment is done?

You must have misunderstood the instructions initially because all instructions say to turn Auto-Return OFF. Anyway, now with that off, as long as you have everything else set correctly, you should be fine.

The best test is to do a live transaction. Set the price to $0.30 or less... then you can refund it back without costing you any fees.

Cheers for your advice and I am now starting to do testing

Thanks

Sorry for troubling again,

I have got what's going on and getting struck in another issue is that, as my website is working dt register with another component "JoomFish", I found out that if the "paypal_ipn.php" can receive the notification properly but the code is blocked at the

$mainframe->triggerEvent('onAfterInitialise');
$mainframe->route();
$mainframe->triggerEvent('onAfterRoute');
$mainframe->triggerEvent('onAfterDispatch');

and error message comes out:

Class 'interceptDB' not found in /"MY SITE ROOT PATH"/plugins/system/jfdatabase/jfdatabase_inherit.php on line 57

Warning: include_once() [function.include]: Failed opening '"MY SITE ROOT PATH"/plugins/system/jfdatabase/intercept.database.php' for inclusion /"MY SITE ROOT PATH"/plugins/system/jfdatabase/jfdatabase_inherit.php on line 56

I checked that the JFactory::getDBO() in the file "jfdatabase_inherit.php" does not work properly after receiving the notification from PayPal but work fine in another page. the whole process is skipped and lead no records created in the backend. If I disable the jfdatabase plugin, it can work, but I can not do on this way as the site has to be multilingual.

Does any body face the same issue and get the solution?
My Joomla version is 1.5.14 and dtregister is 2.6.6d