frontendusers module SQL syntax error

[biffze]

I've just installed the frontendusers module and I've got the following error message when I click on the "Users", "Admin" and "Preferences" tab:

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

[calguy1000]

This is fixed in svn.

and here's the fix for everybody till I can find time to cut releases of everything:

on or about line 4136
Change:

Code: Select all

$curlimit = $this->GetPreference('current_limit', -1);

to

Code: Select all

$curlimit = $this->GetPreference('current_limit', 100);

[sebi03]

thank you much for your fast response!

[greggyp]

I, too, would like to thank the author for his response, which, while fast, needn't have been to have helped me! And only on the 2nd page of the forum (which is convienient for everyone, since I'd have no doubt given up by then tenth page, and done what everyone else does and re-post the problem for no-doubt the 5-trillionth time).

So, in a convoluted way, thanks!