Page 1 of 1
FrontEndUsers SQL Syntax error
Posted: Thu Mar 23, 2006 11:26 am
by gyszilagyi
I have installed the FroteEndUsers module (as well as CMSMailer). In the "Frontend User Management" screen if I click the "Users" or "Admin" tab I get the following 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 '-1' at line 1
I have MySQL 4.1.9 and PHP 5.05 installed. I'm running CMSMS 0.11.2, FrontEndUsers 1.0.0 and CMSMailer 1.73.9.
Does anybody have any ideas what went wrong?
Re: FrontEndUsers SQL Syntax error
Posted: Thu Mar 23, 2006 2:28 pm
by calguy1000
is this the latest version of FrontendUsers? because I'm fairly sure I fixed this little issue months ago. Which version of feusers is it?
Re: FrontEndUsers SQL Syntax error
Posted: Thu Mar 23, 2006 3:18 pm
by gyszilagyi
It's version 1.0.0, i.e. not the latest version. The reason is that I think the latest version requires CMSMS 0.12 and I'm running 0.11.2 (I had trouble installing 0.12 as for whatever reason the FCK editor was not working, so I decided to stay with 0.11.2 for the time being). I could of course try upgrading to CMSMS 0.12 again but ifthere was a quick fix to the Syntax error issue I'd prefer that...
Thanks for taking the time to reply, I appreciate it!
Re: FrontEndUsers SQL Syntax error
Posted: Thu Mar 23, 2006 3:25 pm
by calguy1000
Okay, in the function _DisplayAdminUsersTab in FrontEndUsers.module.php
change this line
Code: Select all
$cursort = $this->GetPreference('current_sort', -1);
to
Code: Select all
$cursort = $this->GetPreference('current_sort', '');
Re: FrontEndUsers SQL Syntax error
Posted: Thu Mar 23, 2006 4:22 pm
by gyszilagyi
Thanks, this has helped (actually I had the -1 value in the $curlimit variable).
Have a nice day!