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
Changing a user to premium within the admin panel shows:
Query: INSERT INTO user_premium SET user_id = 4, start_date = '', end_date = '', credit = 0, 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
At which point all of my users disappear from http://domain.com/admin/index.php?q=user 's listing. I only see anonymous. EDIT: They are back. *shrug*. SQL error still exists.
I checked PHPMYADMIN and it shows the users still there and I can use them to log in to the site and admin panel.
Server version: 5.1.63-cll MySQL Community Server (GPL)
PHP 5.3.13 (cli) (built: Jun 30 2012 12:37:21)
Linux HOSTNAME 2.6.18-028stab070.14 #1 SMP Thu Nov 18 16:04:02 MSK 2010 x86_64 x86_64 x86_64 GNU/Linux
Last edited by Tenche (2012-07-01 14:07:02)
Offline
Itsa bug in 1.0RC4 and its fixed in 1.0. Remove LIMIT 1 from admin/modules/user/components/edit.php.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Awesome. Thanks.
Offline
Pages: 1