Change subscription start date (in the past)

#1

Hello

An user cancelled it subscription by a mistake.

He is going to subscribe again, but I’d like to set the starting dripping date at the old date, 2 months ago.

Anyone knows whether is this possible?

Thank you

#2

This is what I have done and it appears to work.

The idea is to cancel the cancelation and keep the original date of “LEVEL 2” subscription date.

From SQL Console I have done: SELECT * FROM xxxx_usermeta WHERE user_id=XXXX

I have found the register with meta_key= “xxxx_s2member_access_cap_times”

Original value:

a:11:{s:15:“1517509899.0001”;s:6:“level0”;s:15:“1517566757.0001”;s:16:“ccap_crd0ionline”;s:15:“1519902350.0001”;s:16:“ccap_50crd0a1809”;s:15:“1522082820.0001”;s:6:“level1”;s:15:“1522082820.0002”;s:6:“level2”;s:15:“1522082820.0003”;s:16:“ccap_fuepremiumg”;s:15:“1524657857.0001”;s:14:“ccap_evt180502”;s:15:“1526399622.0001”;s:14:“ccap_evt180516”;s:15:“1526886561.0001”;s:7:"-level2";s:15:“1526886561.0002”;s:14:“ccap_evt180522”;s:15:“1526982011.0001”;s:6:“level2”;}

I have demoved:

s:15:“1526886561.0001”;s:7:"-level2";

and

s:15:“1526982011.0001”;s:6:“level2”;

This is the final result I have updated:

a:7:{s:15:“1517509899.0001”;s:6:“level0”;s:15:“1517566757.0001”;s:16:“ccap_crd0ionline”;s:15:“1519902350.0001”;s:16:“ccap_50crd0a1809”;s:15:“1522082820.0001”;s:6:“level1”;s:15:“1522082820.0002”;s:6:“level2”;s:15:“1522082820.0003”;s:16:“ccap_fuepremiumg”;s:15:“1524657857.0001”;s:14:“ccap_evt180502”;s:15:“1526399622.0001”;s:14:“ccap_evt180516”;s:15:“1526886561.0002”;s:14:“ccap_evt180522”;}

It’s working fine until now…

1 Like