FrontEndUsers SQL Syntax error

[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?

[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?

[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!

[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', '');

[gyszilagyi]

Thanks, this has helped (actually I had the -1 value in the $curlimit variable).

Have a nice day!