Database prefix error

[NJseo]

Database prefix error

When I set the database file with the dbprefix and modified the sql files to include those prefixes, I would have expected it to work. But it did not

Error Number: 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 '.*, (SELECT GROUP_CONCAT(DISTINCT groups.name) FROM groups LEFT JOIN users_group' at line 1

SELECT crm3_users.*, (SELECT GROUP_CONCAT(DISTINCT groups.name) FROM groups LEFT JOIN users_groups ON users_groups.group_id = groups.id WHERE users_groups.user_id = users.id GROUP BY users_groups.user_id) AS groups FROM crm3_users LIMIT 10

Filename: third_party/grocery_crud/models/Grocery_crud_model.php

Line Number: 87