A PHP Error was encountered

Severity: Notice

Message: Undefined variable: tenID

Filename: models/searchlist_model.php

Line Number: 742

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/bonnerbb9838/public_html/system/core/Exceptions.php:185)

Filename: core/Common.php

Line Number: 438

Database Error

A Database Error Occurred

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 'group by t.tenID' at line 1

select * from tblTenant t left join tblProfile p on t.tenID = p.tenID left join tblLocation l on t.tenLocID = l.locID where t.tenID = group by t.tenID

Filename: /home/bonnerbb9838/public_html/models/searchlist_model.php

Line Number: 13