Adult Script Pro Community Forums

THS

Member

Registered: 2012-02-02

Posts: 313

Website

[FIXED] Error on updating user

Query: INSERT INTO THS_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

Last edited by THS (2012-02-21 06:21:59)

---

- The best FREE Porn videos are yours!  www.TheHiddenShelf.com

symtab

Administrator

Registered: 2010-08-23

Posts: 7,501

Website

Re: [FIXED] Error on updating user

Fixed in next version.

---

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

GetWicked

Member

Registered: 2012-02-25

Posts: 23

Re: [FIXED] Error on updating user

Getting the following SQL error:

Query: INSERT INTO as1user_premium SET user_id = 3, 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

When I attempted to change the user's group from registered to admin.

is a fix laying around anywhere?

Thanks..

symtab

Administrator

Registered: 2010-08-23

Posts: 7,501

Website

Re: [FIXED] Error on updating user

Edit admin/modules/user/components/edit.php and find the line in your error and remove:

LIMIT 1

---

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds