Symphony Fatal Database Error when accessing Members in backend
This is an open discussion with 4 replies, filed under Troubleshooting.
Search
ed.username asc LIMIT 0, 17
This in itself looks fine, but is missing the preceding ORDER BY
directive. This looks like it’s a bug with the Member field.
Take a look at field.member.php
and its buildSortingSQL
method:
$sort .= (strtolower($order) == 'random' ? 'RAND()' : "`$sort_field`.`username` $order");
This should be:
$sort .= 'ORDER BY ' . (strtolower($order) == 'random' ? 'RAND()' : "`$sort_field`.`username` $order");
This is what other fields seem to use, so looks like a typo.
I’m hanging on for Symphony 2.2 and Members, there’s too many bugs at the moment…
Thanks nickdunn,
this solved my problem perfectly! But I quiet don’t get it - why didn’t this error happen earlier, when I used the sort field?!
Cheers, Truck
I also encountered the same bug in field.memberrole.php. The buildSortingSQL method must be:
... $sort .= 'ORDER BY ' . (strtolower($order) == 'random' ? 'RAND()' : "`$sort_field`.`role_id` $order"); ...
Create an account or sign in to comment.
Hi guys,
everything was just fine until I used the “sort by name”-link in the section “Members”. I’m using Symphony 2.1.0 with the Members extension 1.2.1beta.
I now get this error when accessing Members in backend:
I see that the string
in the end of the statement is not correct - but I don’t know how to fix this. Can anybody please help?
Thanks!