Malformed SQL query in listview.

[pdh88x]

Hey there,

Recently purchased Sugar Pro (I understand this is the community forums), however I just noticed something interesting in this installation & figured I'd come here for help first...

Getting a malformed SQL query in my listview for a few modules, primarily admin > users and accounts.

The following is the query:

SELECT  users.id ,  as name, users.last_name , users.first_name , users.user_name , users.department , users.phone_work , users.status , users.is_admin , users.created_by  FROM users  where users.deleted=0 ORDER BY name ASC

The issue comes in directly after SELECT users.id; Should be as follows.

SELECT  users.id AS name, users.last_name , users.first_name , users.user_name , users.department , users.phone_work , users.status , users.is_admin , users.created_by  FROM users  where users.deleted=0 ORDER BY name ASC

This issue came about while moving our installation over from an older server to a newer one, direct file + DB copy.

Don't know where to edit this query; I may be being a bit dense...I've checked under Modules/Users/Listview.php and User.php

Any help would be very much appreciated.

EDIT:
Nevermind, figured it out! Was under config.php, apparently I had accidentally put in the following:

'db_type' => 'mysqli',

when it should have been

'db_type' => 'mysql',

Hopefully this can help someone else =)