A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/contractor.php

Line Number: 136

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/contractor.php

Line Number: 137

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/contractor.php

Line Number: 137

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/contractor.php

Line Number: 140

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/contractor.php

Line Number: 146

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/contractor.php

Line Number: 146

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: controllers/contractor.php

Line Number: 146

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/content/61/4819761/codeigniter_2.1.3/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 ') and u.user_type=2 and u.active=1 group by u.id order by c.company_name limit 1' at line 1

select u.id, u.user_type, u.profile_name, u.date_created, u.questions, u.answers, u.rate_up, u.rate_down, i.first_name, i.last_name, i.address1, i.address2, i.city, i.state, i.postal_code, i.email, c.company_name, c.contact1, c.contact2, c.address1 as c_address1, c.address2 as c_address2, c.city as c_city, c.state as c_state, c.postal_code as c_postal_code, c.email as c_email, c.url, c.phone_work, c.phone_work2, c.phone_fax, c.phone_mobile, c.category, c.contractor_number, group_concat(cu.category_id separator '|') as categories from user u left join user_info i on u.id=i.user_id left join user_contractor c on u.id=c.user_id left join category_to_user_map cu on u.id=cu.user_id where c.postal_code in () and u.user_type=2 and u.active=1 group by u.id order by c.company_name limit 100

Filename: /home/content/61/4819761/html/remodelqa.com/models/directory_model.php

Line Number: 7