On the setting -> application tab returns an error

PDOException: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near '@P1'.: SELECT * FROM {fb_application} WHERE status & :is_enabled; Array ( [:is_enabled] => 1 ) in fb_admin_all_apps() (line 1203 of D:\home\site\wwwroot\sites\all\modules\fb\fb.admin.inc).

WHERE status & :is_enabled

Changed the & to an = and it worked fine.

Using SQL server as db on azure.

Comments

Dave Cohen’s picture

Dave Cohen commented

That's meant to be an &. A logical AND.

I figured all databases would support that. But of course there's always microsoft.

I'm not sure mysql or other database do that query efficiently anyway. So it's a reasonable candidate to be refactored. I will think on this and come up with something. Suggestions are welcome.