Page 1 of 1

s2 member database problem

PostPosted: July 20th, 2011, 8:19 am
by rsengar
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

Re: s2 member database problem

PostPosted: July 20th, 2011, 6:36 pm
by Cristián Lávaque
I don't understand. What are you expecting to find in those? Are you having trouble with users not being upgraded after payment?

Re: s2 member database problem

PostPosted: July 21st, 2011, 12:25 am
by rsengar
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

Re: s2 member database problem

PostPosted: July 21st, 2011, 1:17 am
by Cristián Lávaque
I'm sorry, I still don't understand. s2Member doesn't store data in those tables.

Re: s2 member database problem

PostPosted: July 21st, 2011, 1:28 am
by rsengar
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.

Re: s2 member database problem

PostPosted: July 21st, 2011, 2:07 am
by Cristián Lávaque
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.

Re: s2 member database problem

PostPosted: July 21st, 2011, 3:48 am
by rsengar
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.?

Re: s2 member database problem

PostPosted: July 21st, 2011, 3:49 am
by rsengar
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.

Re: s2 member database problem

PostPosted: July 21st, 2011, 3:50 am
by rsengar
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.

Re: s2 member database problem

PostPosted: July 21st, 2011, 1:37 pm
by Cristián Lávaque
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.