latest stable versions: v150827 (changelog)
top⇑

Old Forums (READ-ONLY): The community now lives at WP Sharks™. If you have an s2Member® Pro question, please use our new Support System.

Home › Forums › David Holland

About: David Holland

Sorry, I've not written a description yet. I'll get to it soon!

Topics I'm Subscribed To

Viewing 2 topics - 1 through 2 (of 2 total)
Topic Count Last Reply
Restore or recover s2member after deactivated

By:  David Holland in: Community Forum

voices: 4
replies: 11

4 years, 3 months ago  Raam Dev

No Profile Fields (safeguard active)

By:  David Holland in: Community Forum

voices: 2
replies: 1

4 years, 3 months ago  Cristián Lávaque

Viewing 2 topics - 1 through 2 (of 2 total)

Topics I've Started

Viewing 2 topics - 1 through 2 (of 2 total)
Topic Count Last Reply
Restore or recover s2member after deactivated

By:  David Holland in: Community Forum

voices: 4
replies: 11

4 years, 3 months ago  Raam Dev

No Profile Fields (safeguard active)

By:  David Holland in: Community Forum

voices: 2
replies: 1

4 years, 3 months ago  Cristián Lávaque

Viewing 2 topics - 1 through 2 (of 2 total)

My Latest Replies (From Various Topics)

Viewing 5 replies - 1 through 5 (of 5 total)
Author Replies
Author Replies
Posted: Thursday Oct 4th, 2012 at 7:15 pm #27507
David Holland
Username: dwdutch

Problem resolved.

To close the loop… I did know how to find entries (i had already done a search on “s2” in the table)… what I wasn’t clear about was which one of the many s2member records I found would be most germane to my problem. I eventually figured out that it was the record for “ws_plugin__s2member_options”.

So, the whole source of the problem was that that particular field contained truncated/incomplete data. As it turns out, the source of the problem was neither a human nor an s2member error. Instead, there was a problem on the server in the IMPORT process for the database. Once that could be circumvented and the full record restored then everything worked well.
Posted: Wednesday Oct 3rd, 2012 at 12:52 pm #27346
David Holland
Username: dwdutch

Progress this morning…
1) I set-up a completely fresh installation of WP
2) I imported the wp_options, wp_users & wp_usermeta table from the backup-version of the previous WP
3) I ensured siteURL=correct_address and set theme to be Twenty11

Still, I can not see the Custom Profile Fields in the s2member General Options tab. It seems that the data is in the database tables but not being displayed/accessed appropriately

Any next suggestion?

Also, At this point, I’m even willing to manually re-create ALL of the Custom fields to see if they will then appear in the member records IF ONLY i can translate from the existing data in s2member records to know how each one was originally defined.

* In what field of the wp_options table should I be looking to know how a specific Custom Field is defined?
Posted: Tuesday Oct 2nd, 2012 at 1:42 am #27174
David Holland
Username: dwdutch

Okay.. i restored software back to the day before I de-activated the re-actived S2member AND i restored database to the day before I I de-activated the re-actived S2member.

I’ve made some progress… now, when I look at a user record, I can see basic s2member data (e.g. Paid Subscription ID, Automatic EOT Time). However, I still cannot see any of the Custom Profile Fields listed in S2member General Options nor in an individual user record.

If I look in database tables themselves, I see s2member records per user in wp_usermeta table that include data such wp_s2member_custom_fields — complete with relevant data. Sooo, the data is in the table, it’s simply NOT be shown in WP.

Since it’s not visible in WP, I don’t know if it makes any sense to try the Export/Import trick.

Please offer any advice on next step.

(BTW… I’d even consider a for-pay option to try to get this data restored and back to a manageable model. Does s2member offer any additional custom support option… if so, send me an email).
Posted: Sunday Sep 30th, 2012 at 11:08 am #27014
David Holland
Username: dwdutch

Thanks for the info, Christian. The reason for my questions… I had reset my wp-config file to simply point to the backup of my database; however, the s2member data was still blank.

When I compare the wp_options and the wp_usermeta table for my current database vs. my backup database, i can see that my backup database has a lot more s2member-related data. So, maybe you’re correct and I had the safeguard set incorrectly (although, i sure thought i did have it correct) but, I could be wrong.

Still, I had expected that simply pointing back to the backup database would have been sufficient. Soooo… I can see that data exists in the tables, I simply can’t access them. I’m racking my brain for ideas…

* I always try to stay current with updates but maybe, I updated s2member software AFTER my backup. Could that be a problem? Is there a way to tell from the database info which version of s2member was active at the time?

* is there any other tool/trick that can extract the s2member data from a database so it can be re-imported into the correct database?

I am so desperate now that later today I may try to create a whole new WP installation with only s2member as a plug-in then import the wp_users, wp_options and wp_usermeta tables — hopefully, i can then try the IMPORT/EXPORT of s2member data that you suggested in the related post: http://www.s2member.com/forums/topic/no-profile-fields-safeguard-active/#26943

Alas… today’s is my birthday so I am going to try to enjoy some of it then spend another few hours to try to track this down this evening. Unfortunately, starting tomorrow, I have to work back-to-back 10-hour days at my real job then I can turn my attention back to this problem in 3 days.

Of course, I’ll post an update if I solve it before then but i still welcome ANY thoughts you or others might have so I can try them when I can.

Thanks, in advance, for your thoughts.
Posted: Friday Sep 28th, 2012 at 2:45 pm #26881
David Holland
Username: dwdutch

Thanks for the input… as it turns out, i did/do have that value turned on.

However, after re-activation, none of my previous Custom Profile Fields exist. They don’t exist in the user records nor do they exist at Dashboard -› s2Member® -› General Options -› Registration/Profile Fields & Options

Perhaps, the question I should ask is WHERE are the definition of these fields stored and is there a way to re-populate them?
Viewing 5 replies - 1 through 5 (of 5 total)

Old Forums (READ-ONLY): The community now lives at WP Sharks™. If you have an s2Member® Pro question, please use our new Support System.

Contacting s2Member: Please use our Support Center for bug reports, pre-sale questions & technical assistance.