Your user id substitution isn't correct. You have [userid] and it needs to be [user_id]. You probably have a bunch of invalid subscription rows in your database too. You need to watch the subscriptions table to see if a row is inserted. I've no idea what [cb_date] is and it probably should be NOW() so the subscription starts the minute it was inserted. Below is an example from the information provided on page 1.

I don't know what the duration of your plan is so assumed it's 1 year. So have calculated the expiration date for 1 year from time of subscription. When you add a subscription through a query you must calculate everything manually; we really really do not recommend this approach and beyond this I can't help you any further.