The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!
You are not logged in.
Pages: 1
Hi Guys/Adrian,
I am trying to edit my current new user's profiles to give them a free 1 month of premo and i get this error even if i set the start date and other variables. Also is there a way to set when a new user signs up they get 1 month of free premo.
Cheers
Josh Moore
Query: INSERT INTO ASPuser_premium SET user_id = 20, start_date = '', end_date = '2012-01-25', credit = 1, status = '1' LIMIT 1
Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 7
Error Number: 1064
Offline
So if you set a correct start date for the premium membership it doesnt work? (or do you leave that field empty?)
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Oki. Will check and fix.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
i figured out what the problem was. the sql database freaked out because i gave premium access to just registered users and when i was trying to add time the variable must have already been there so it threw the error. so the fix was changing the access to premium access to premium users and then you can add subscription time to people.
Offline
Yes, but still its a bug and its fixed in the next version. I've added a lot of enhancements to the premium module in the next version.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
You edit templates/your-template/premium-upgrade.tpl.php
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Pages: 1