Community Support Forums

Re: s2 member database problem

2011-07-21T13:37:48-05:00

I think it's all in wp_usermeta. Here are some constants and functions you can use:

Package s2Member\API_Constants
viewtopic.php?f=40&t=12450&src_doc_v=110710

Package s2Member\API_Functions
viewtopic.php?f=40&t=12455&src_doc_v=110710

Package s2Member\Utilities
viewtopic.php?f=40&t=12970&src_doc_v=110710

Package s2Member\User_Access
viewtopic.php?f=40&t=12916&src_doc_v=110710

I hope that helps you.

Statistics: Posted by Cristián Lávaque — July 21st, 2011, 1:37 pm

Re: s2 member database problem

2011-07-21T03:50:31-05:00

i am already getting all record p in log file which are paypa-ipn.log and paypal-rtn.log.

but i will need this all record in database.?

can you tell me in which table s2member store data.
i am getting data in wp_usermeta but it is not enough. and it is not storing all records.
and i need all records.?

please tell me the all log record of transaction which is stored in log file how can i get in database.

i don't want to write any query for this that i will read file and than store in database.

i think it is already store but there has some problem can you tell me that problem or any suggestion.?

please reply me soon this is very urgent ..

please reply me ASAP.

Statistics: Posted by rsengar — July 21st, 2011, 3:50 am

Re: s2 member database problem

2011-07-21T03:49:38-05:00

can you tell me where s2memeber store data in which table except wp_usermeta.
because i need all data for doing to my future experiment.

please reply me soon this urgent.

Statistics: Posted by rsengar — July 21st, 2011, 3:49 am

Re: s2 member database problem

2011-07-21T03:48:12-05:00

Statistics: Posted by rsengar — July 21st, 2011, 3:48 am

Re: s2 member database problem

2011-07-21T02:07:14-05:00

s2Member didn't create those tables, until now s2Member has only used WP's existing tables. Those were probably created and left there by another plugin you installed.

You may want to look at s2Member's Notifications API for those things you mentioned right when they happen.WP Admin -> s2Member -> API / Notifications

If you want more data for each transaction, look at the logs in /wp-content/plugins/s2member-logs/ created by s2Member when you have logging enabled. WP Admin -> s2Member -> PayPal Options -> Account Details -> Enable Logging Routines

I hope that helps.

Statistics: Posted by Cristián Lávaque — July 21st, 2011, 2:07 am

Re: s2 member database problem

2011-07-21T01:28:35-05:00

1 s2 memeber is stroing data in wp_usermeta.

2 if above tables is not going to use by s2member than why s2memeber is created this tables.??

and i have to get data after payapl payment that
how many amount payed by user.?
and till what is EOT of that amount?
and how can i get the all deatail of user which is completed signup on my page.

http://www.universalonehealing.com/signup/
my signup page

i want all the detail related transaction which is auto return by paypal and which is not storing in database?

please reply me soon this is urgent i am suffer from 5 days to this problem.

Statistics: Posted by rsengar — July 21st, 2011, 1:28 am

Re: s2 member database problem

2011-07-21T01:17:56-05:00

I'm sorry, I still don't understand. s2Member doesn't store data in those tables.

Statistics: Posted by Cristián Lávaque — July 21st, 2011, 1:17 am

Re: s2 member database problem

2011-07-21T00:25:10-05:00

Yes, user record not inserting in database .
i have manage lot of things after payment.

we have to check user is pay user or free user .
if pay user than whenever he has limit of time.
till when his expire of payment.
and that all record store in above tables.

Please reply soon its urgent

Statistics: Posted by rsengar — July 21st, 2011, 12:25 am

Re: s2 member database problem

2011-07-20T18:36:05-05:00

I don't understand. What are you expecting to find in those? Are you having trouble with users not being upgraded after payment?

Statistics: Posted by Cristián Lávaque — July 20th, 2011, 6:36 pm

s2 member database problem

2011-07-20T08:19:45-05:00

hi all
i have installed successfully s2memeber .
and it is working and doing proper express checkout.
i have s2memeber pro .

after checkout from paypal my record is storing in wp_usermet but not storing in below tabels
can i know why and how can i solve to this problem

wp_m_levelmeta
wp_m_membership_levels
wp_m_membership_news
wp_m_membership_relationships
wp_m_membership_rules
wp_m_member_payments
wp_m_pings
wp_m_ping_history
wp_m_subscriptionmeta
wp_m_subscriptions
wp_m_subscriptions_levels
wp_m_subscription_transaction

Statistics: Posted by rsengar — July 20th, 2011, 8:19 am