A PHP Error was encountered

Severity: Notice

Message: Trying to get property 'PROPERTY_ID' of non-object

Filename: controllers/Validate.php

Line Number: 331

Backtrace:

File: /home/realstar/public_html/agent/application/controllers/Validate.php
Line: 331
Function: _error_handler

File: /home/realstar/public_html/agent/index.php
Line: 298
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Trying to get property 'AGENT_ID' of non-object

Filename: controllers/Validate.php

Line Number: 332

Backtrace:

File: /home/realstar/public_html/agent/application/controllers/Validate.php
Line: 332
Function: _error_handler

File: /home/realstar/public_html/agent/index.php
Line: 298
Function: require_once

A PHP Error was encountered

Severity: Warning

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

Filename: core/Common.php

Line Number: 568

Backtrace:

File: /home/realstar/public_html/agent/application/helpers/website_helper.php
Line: 225
Function: get

File: /home/realstar/public_html/agent/application/controllers/Validate.php
Line: 341
Function: getDetails

File: /home/realstar/public_html/agent/index.php
Line: 298
Function: require_once

A Database Error Occurred

Error Number: 42000/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 `t_website_listings_by_agent`.`f_userid` IS NULL' at line 12

SELECT `t_website_listings_by_agent`.`f_id` as `ID`, `t_website_listings_by_agent`.`f_slug` as `SLUG`, `t_property_specs`.`f_propid` as `PROPERTY_ID`, `f_rent_sale` as `SALE_OR_RENT`, IF(f_main_image = '' or ISNULL(f_main_image), 'https://realstarpremier.com/crm/uploads/property_photos/noimage.jpg', CONCAT('https://realstarpremier.com/crm/uploads/property_photos/', f_main_image) ) as PROFILE_IMAGE_URL, `t_property_type`.`f_description` as `PROPERTY_TYPE`, `f_district` as `DISTRICT`, ( select f_areas from t_sector_area where f_district = DISTRICT ) as AREA, `f_sector` as `SECTOR`, TRIM(f_storey)+0 as STOREY, `f_tenure` as `TENURE`, IF(f_TOP = '', '', f_TOP) as TOP, `f_zone_area` as `ZONE_AREA`, CONCAT('S$ ', FORMAT(ROUND(ROUND(f_selling_price, 3) * 1000000), 0)) as SELLING_PRICE, FORMAT(ROUND(t_property_specs.f_land_size, 0), 0) as LANDSIZE_SQFT, FORMAT(ROUND(t_property_specs.f_build_up_size, 0), 0) as BUILD_UP_SQFT, CONCAT('S$ ', FORMAT(ROUND(f_selling_price * 1000000)/ f_land_size, 0)) as PSF, SUBSTRING_INDEX(f_room, '+', 1)as ROOMS, `f_carpark` as `PARKING_SPACE`, IF(f_facing = '' or LENGTH(f_facing) = 0, '', f_facing) as FACING, IF(f_pool = 1, 'YES', 'NO') as POOL, IF(f_lift = 1, 'YES', 'NO') as LIFT, `f_condition` as `CONDITION`, `f_video_link` as `VIDEO_URL`, `f_userid` as `AGENT_ID`, `f_display_name` as `CONTACT_AGENT`, CONCAT('+65', TRIM(t_hr_employees.f_mobileno)) as CONTACT_NUMBER, LCASE(TRIM(t_hr_employees.f_work_email)) as CONTACT_EMAIL, IF(LENGTH(f_website_title_agent) > 0, `f_website_title_agent`, '') as HEADER_TITLE, IF(LENGTH(f_website_description_agent) > 0, `f_website_description_agent`, '') as DESCRIPTION, 'Disclaimer:
The information provided on this website or any other source regarding real estate properties is for general informational purposes only and may not be accurate, complete or up-to-date. All information is subject to errors / omissions prior /sale rental change in price or withdrawal without notice.' as DISCLAIMER, `f_publish_timestamp` as `PUBLISHED_AT`, `f_lat` as `LAT`, `f_lng` as `LNG` FROM `t_property_main` INNER JOIN `t_property_link_history` ON `t_property_main`.`f_unique_id` = `t_property_link_history`.`f_unique_id` INNER JOIN `t_property_specs` ON `t_property_link_history`.`f_propid` = `t_property_specs`.`f_propid` INNER JOIN `t_property_type` ON `t_property_specs`.`f_property_type` = `t_property_type`.`f_property_type` RIGHT JOIN `t_website_listings_by_agent` ON `t_property_link_history`.`f_propid` = `t_website_listings_by_agent`.`f_propid` INNER JOIN `t_hr_employees` ON `t_website_listings_by_agent`.`f_userid` = `t_hr_employees`.`f_id` INNER JOIN `t_users_new` ON `t_hr_employees`.`f_id` = `t_users_new`.`f_id` WHERE `t_website_listings_by_agent`.`f_propid` = and `t_website_listings_by_agent`.`f_userid` IS NULL

Filename: helpers/website_helper.php

Line Number: 225