paypal_transactions table

Are you responsible for making OCS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, michael, John

Forum rules
The Public Knowledge Project Support Forum is moving to

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
Posts: 266
Joined: Fri Nov 18, 2005 12:48 pm
Location: Hamilton, Ontario

paypal_transactions table

Postby tshore » Thu May 15, 2008 5:56 am

Just taking a look at this table as I was wanting to display the PayPal transaction ID on the printable receipt I've made up. I also wanted to add the ability to enter the PayPal transaction ID in the edit registration form (this is needed when payments don't get automatically posted, for whatever reason). However, it looks like there is no guaranteed link between this table and the user or registration tables? I was expecting to see a registration_id column in there, or perhaps a user_id column? Also, am I correct in saying that there is no way to access this table via the OCS admin system?

For anyone who is interested, here is screenshot of my receipt:


Posts: 158
Joined: Thu Jul 06, 2006 1:03 pm
Location: Buenos Aires

Re: paypal_transactions table

Postby jalperin » Wed May 21, 2008 4:46 pm


That receipt looks great!

In answer to your question, NO, the paypal_transactions table do not have a user_id or any registration_id field. This table is simply a log of all the transactions that come in to OCS from PayPal, containing only the information that is submitted to OCS by the PayPal IPN. OCS does not, at the moment, have any type of interface that lets you access this table. In the limited functionality of OCS' paypal, this table only serves as a log of received transactions for fraud prevention (from people sending fake payments using previously received transactions) and to help resolve any accounting discrepancies.

We implemented a completed_payments table in OJS, which is more what you are looking for. However, this has not made its way over to OCS yet. This table is NOT meant to be a record of all payments, only paypal ones. You cannot enter your own transaction or make up your own transaction id's, since these are both generated by paypal.

You can use the receiver_email from the transactions table and link this to your users table in order to figure out what user originally submitted the transaction. From this, you can find the corresponding registration_id.

Hope this helps. If you have any more questions, please ask.

I'd be curious to see how you've implemented the receipts, if you're keen on sharing the code. Thanks!

Return to “OCS Technical Support”

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest