A PHP Error was encountered

Severity: Warning

Message: pg_query(): Query failed: ERROR: function st_geomfromtext(unknown) does not exist LINE 5: AND MBRContains(ST_GeomFromText('POLYGON((... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Filename: postgre/postgre_driver.php

Line Number: 241

Backtrace:

File: /var/www/ci3/application/models/Index_model.php
Line: 2360
Function: query

File: /var/www/ci3/application/models/Index_model.php
Line: 2398
Function: {closure:Index_model::search4SInRange():2358}

File: /var/www/ci3/application/models/Index_model.php
Line: 1996
Function: search4SInRange

File: /var/www/ci3/application/controllers/Index.php
Line: 4354
Function: result

File: /var/www/ci3/index.php
Line: 292
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /var/www/ci3/system/core/Exceptions.php:272)

Filename: core/Common.php

Line Number: 571

Backtrace:

File: /var/www/ci3/application/models/Index_model.php
Line: 2360
Function: query

File: /var/www/ci3/application/models/Index_model.php
Line: 2398
Function: {closure:Index_model::search4SInRange():2358}

File: /var/www/ci3/application/models/Index_model.php
Line: 1996
Function: search4SInRange

File: /var/www/ci3/application/controllers/Index.php
Line: 4354
Function: result

File: /var/www/ci3/index.php
Line: 292
Function: require_once

Database Error

A Database Error Occurred

Error Number:

ERROR: function st_geomfromtext(unknown) does not exist LINE 5: AND MBRContains(ST_GeomFromText('POLYGON((... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

SELECT id, brand, agentname, agentaddress, tel, city, address_lng, address_lat FROM `other4s` WHERE address_lng > 0 AND address_lat > 0 AND geo IS NOT NULL AND MBRContains(ST_GeomFromText('POLYGON((115.8118719986 39.46007235474, 116.9829840014 39.46007235474, 116.9829840014 40.35838764526, 115.8118719986 40.35838764526, 115.8118719986 39.46007235474))'), ST_GeomFromWKB(SUBSTRING(UNHEX(geo), 5)))

Filename: models/Index_model.php

Line Number: 2360