Users disappearing from list in user management

HI ,

I'm haing a problem with the users in the user managemnt disappearing when I extend the view from 100 to xxx. I get a blank page with a 500 error.

JDatabaseMySQL::query: 1064 - 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 '' at line 1 SQL=SELECT user_id AS `value`, datum_ontvangen AS `text`, user_id AS id FROM jos_ec_billing WHERE user_id =

A screenprint is attached...

Can anybody please help me?

Tom

FROM jos_ec_billing

It's not coming from CB. Perhaps you've some sort of 3rd party CB plugin installed that's trying to query the above database table?

[EDIT]: Confirmed it is, look at the callstack in the image you provided and it's coming from a plugin called "dropdownfrommysqlquery".

Hi krileon,

Thanks for your answer. I found the plugin but I have no idea what to do now or where to find the query.
Can you point me into a direction?

Tom

I guess disable the plugin or contact its developer. As we didn't develop it there's nothing more I can advise other then uninstall it.