ADODB_Exception Object
(
[dbms] => mysql
[fn] => EXECUTE
[sql] =>
SELECT s.name AS state, b.*, (MATCH (tx_fulltext_search) AGAINST ('White's Florist ')) AS Relevance, (
SELECT loc.tx_lat FROM lbb_location_info.loc_postcode_db loc
WHERE loc.nu_postcode = b.postcode
LIMIT 1
) AS "tx_lat",
(
SELECT loc2.tx_long FROM lbb_location_info.loc_postcode_db loc2
WHERE loc2.nu_postcode = b.postcode
LIMIT 1
) AS "tx_long",
(6378.137 * 2 * ASIN(SQRT(
POWER(SIN((-37.556958 - abs("tx_lat")) * pi()/180 / 2), 2) + COS(-37.556958 * pi()/180 )
* COS(abs("tx_lat") * pi()/180) * POWER(SIN((143.817225 - "tx_long") * pi()/180 / 2), 2) ))) as distance FROM business b, lbb_location_info.loc_states s
WHERE suspended IS NULL
AND s.id = b.state_id
AND da_rejected IS NULL
AND approved = "1"
AND ( MATCH (tx_fulltext_search) AGAINST ('+White's >Florist ' IN BOOLEAN MODE) AND b.id != "2600" )
ORDER BY b.nu_programme ASC, Relevance DESC,distance ASC
LIMIT 4
[params] =>
[host] => localhost
[database] => businesssearch
[message:protected] => mysql error: [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 's Florist ')) AS Relevance, (
SELECT loc.tx_lat FROM lbb_location_info.loc' at line 1] in EXECUTE("
SELECT s.name AS state, b.*, (MATCH (tx_fulltext_search) AGAINST ('White's Florist ')) AS Relevance, (
SELECT loc.tx_lat FROM lbb_location_info.loc_postcode_db loc
WHERE loc.nu_postcode = b.postcode
LIMIT 1
) AS "tx_lat",
(
SELECT loc2.tx_long FROM lbb_location_info.loc_postcode_db loc2
WHERE loc2.nu_postcode = b.postcode
LIMIT 1
) AS "tx_long",
(6378.137 * 2 * ASIN(SQRT(
POWER(SIN((-37.556958 - abs("tx_lat")) * pi()/180 / 2), 2) + COS(-37.556958 * pi()/180 )
* COS(abs("tx_lat") * pi()/180) * POWER(SIN((143.817225 - "tx_long") * pi()/180 / 2), 2) ))) as distance FROM business b, lbb_location_info.loc_states s
WHERE suspended IS NULL
AND s.id = b.state_id
AND da_rejected IS NULL
AND approved = "1"
AND ( MATCH (tx_fulltext_search) AGAINST ('+White's >Florist ' IN BOOLEAN MODE) AND b.id != "2600" )
ORDER BY b.nu_programme ASC, Relevance DESC,distance ASC
LIMIT 4")
[string:Exception:private] =>
[code:protected] => 1064
[file:protected] => /vhosts/businesssearch.com.au/htdocs/control_classes/adodb/adodb-exceptions.inc.php
[line:protected] => 78
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /vhosts/businesssearch.com.au/htdocs/control_classes/adodb/adodb.inc.php
[line] => 914
[function] => adodb_throw
[args] => Array
(
[0] => mysql
[1] => EXECUTE
[2] => 1064
[3] => 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 's Florist ')) AS Relevance, (
SELECT loc.tx_lat FROM lbb_location_info.loc' at line 1
[4] =>
SELECT s.name AS state, b.*, (MATCH (tx_fulltext_search) AGAINST ('White's Florist ')) AS Relevance, (
SELECT loc.tx_lat FROM lbb_location_info.loc_postcode_db loc
WHERE loc.nu_postcode = b.postcode
LIMIT 1
) AS "tx_lat",
(
SELECT loc2.tx_long FROM lbb_location_info.loc_postcode_db loc2
WHERE loc2.nu_postcode = b.postcode
LIMIT 1
) AS "tx_long",
(6378.137 * 2 * ASIN(SQRT(
POWER(SIN((-37.556958 - abs("tx_lat")) * pi()/180 / 2), 2) + COS(-37.556958 * pi()/180 )
* COS(abs("tx_lat") * pi()/180) * POWER(SIN((143.817225 - "tx_long") * pi()/180 / 2), 2) ))) as distance FROM business b, lbb_location_info.loc_states s
WHERE suspended IS NULL
AND s.id = b.state_id
AND da_rejected IS NULL
AND approved = "1"
AND ( MATCH (tx_fulltext_search) AGAINST ('+White's >Florist ' IN BOOLEAN MODE) AND b.id != "2600" )
ORDER BY b.nu_programme ASC, Relevance DESC,distance ASC
LIMIT 4
[5] =>
[6] => ADODB_mysql Object
(
[databaseType] => mysql
[dataProvider] => mysql
[hasInsertID] => 1
[hasAffectedRows] => 1
[metaTablesSQL] => SHOW TABLES
[metaColumnsSQL] => SHOW COLUMNS FROM `%s`
[fmtTimeStamp] => 'Y-m-d H:i:s'
[hasLimit] => 1
[hasMoveFirst] => 1
[hasGenID] => 1
[isoDates] => 1
[sysDate] => CURDATE()
[sysTimeStamp] => NOW()
[hasTransactions] =>
[forceNewConnect] =>
[poorAffectedRows] => 1
[clientFlags] => 0
[substr] => substring
[nameQuote] => `
[compat323] =>
[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
[_genSeqSQL] => create table %s (id int not null)
[_genSeq2SQL] => insert into %s values (%s)
[_dropSeqSQL] => drop table %s
[database] => businesssearch
[host] => localhost
[user] => websites
[password] => ddioww43
[debug] =>
[maxblobsize] => 262144
[concat_operator] => +
[length] => length
[random] => rand()
[upperCase] => upper
[fmtDate] => 'Y-m-d'
[true] => 1
[false] => 0
[replaceQuote] => \'
[charSet] =>
[metaDatabasesSQL] =>
[uniqueOrderBy] =>
[emptyDate] =>
[emptyTimeStamp] =>
[lastInsID] =>
[hasTop] =>
[readOnly] =>
[genID] => 0
[raiseErrorFn] => adodb_throw
[cacheSecs] => 3600
[memCache] =>
[memCacheHost] =>
[memCachePort] => 11211
[memCacheCompress] =>
[arrayClass] => ADORecordSet_array
[noNullStrings] =>
[numCacheHits] => 0
[numCacheMisses] => 0
[pageExecuteCountRows] => 1
[uniqueSort] =>
[leftOuter] =>
[rightOuter] =>
[ansiOuter] =>
[autoRollback] =>
[fnExecute] =>
[fnCacheExecute] =>
[blobEncodeType] =>
[rsPrefix] => ADORecordSet_
[autoCommit] => 1
[transOff] => 0
[transCnt] => 0
[fetchMode] =>
[null2null] => null
[_oldRaiseFn] =>
[_transOK] =>
[_connectionID] => Resource id #28
[_errorMsg] => 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 's Florist ')) AS Relevance, (
SELECT loc.tx_lat FROM lbb_location_info.loc' at line 1
[_errorCode] =>
[_queryID] =>
[_isPersistentConnection] =>
[_bindInputArray] =>
[_evalAll] =>
[_affected] =>
[_logsql] =>
[_transmode] =>
[databaseName] => businesssearch
)
)
)
[1] => Array
(
[file] => /vhosts/businesssearch.com.au/htdocs/control_classes/adodb/adodb.inc.php
[line] => 889
[function] => _Execute
[class] => ADOConnection
[type] => ->
[args] => Array
(
[0] =>
SELECT s.name AS state, b.*, (MATCH (tx_fulltext_search) AGAINST ('White's Florist ')) AS Relevance, (
SELECT loc.tx_lat FROM lbb_location_info.loc_postcode_db loc
WHERE loc.nu_postcode = b.postcode
LIMIT 1
) AS "tx_lat",
(
SELECT loc2.tx_long FROM lbb_location_info.loc_postcode_db loc2
WHERE loc2.nu_postcode = b.postcode
LIMIT 1
) AS "tx_long",
(6378.137 * 2 * ASIN(SQRT(
POWER(SIN((-37.556958 - abs("tx_lat")) * pi()/180 / 2), 2) + COS(-37.556958 * pi()/180 )
* COS(abs("tx_lat") * pi()/180) * POWER(SIN((143.817225 - "tx_long") * pi()/180 / 2), 2) ))) as distance FROM business b, lbb_location_info.loc_states s
WHERE suspended IS NULL
AND s.id = b.state_id
AND da_rejected IS NULL
AND approved = "1"
AND ( MATCH (tx_fulltext_search) AGAINST ('+White's >Florist ' IN BOOLEAN MODE) AND b.id != "2600" )
ORDER BY b.nu_programme ASC, Relevance DESC,distance ASC
LIMIT 4
[1] =>
)
)
[2] => Array
(
[file] => /vhosts/businesssearch.com.au/htdocs/control_classes/db.class.app
[line] => 56
[function] => Execute
[class] => ADOConnection
[type] => ->
[args] => Array
(
[0] =>
SELECT s.name AS state, b.*, (MATCH (tx_fulltext_search) AGAINST ('White's Florist ')) AS Relevance, (
SELECT loc.tx_lat FROM lbb_location_info.loc_postcode_db loc
WHERE loc.nu_postcode = b.postcode
LIMIT 1
) AS "tx_lat",
(
SELECT loc2.tx_long FROM lbb_location_info.loc_postcode_db loc2
WHERE loc2.nu_postcode = b.postcode
LIMIT 1
) AS "tx_long",
(6378.137 * 2 * ASIN(SQRT(
POWER(SIN((-37.556958 - abs("tx_lat")) * pi()/180 / 2), 2) + COS(-37.556958 * pi()/180 )
* COS(abs("tx_lat") * pi()/180) * POWER(SIN((143.817225 - "tx_long") * pi()/180 / 2), 2) ))) as distance FROM business b, lbb_location_info.loc_states s
WHERE suspended IS NULL
AND s.id = b.state_id
AND da_rejected IS NULL
AND approved = "1"
AND ( MATCH (tx_fulltext_search) AGAINST ('+White's >Florist ' IN BOOLEAN MODE) AND b.id != "2600" )
ORDER BY b.nu_programme ASC, Relevance DESC,distance ASC
LIMIT 4
)
)
[3] => Array
(
[file] => /vhosts/businesssearch.com.au/htdocs/qry/classes/search_queries.class.app
[line] => 145
[function] => db_query
[class] => db
[type] => ->
[args] => Array
(
[0] =>
SELECT s.name AS state, b.*, (MATCH (tx_fulltext_search) AGAINST ('White's Florist ')) AS Relevance, (
SELECT loc.tx_lat FROM lbb_location_info.loc_postcode_db loc
WHERE loc.nu_postcode = b.postcode
LIMIT 1
) AS "tx_lat",
(
SELECT loc2.tx_long FROM lbb_location_info.loc_postcode_db loc2
WHERE loc2.nu_postcode = b.postcode
LIMIT 1
) AS "tx_long",
(6378.137 * 2 * ASIN(SQRT(
POWER(SIN((-37.556958 - abs("tx_lat")) * pi()/180 / 2), 2) + COS(-37.556958 * pi()/180 )
* COS(abs("tx_lat") * pi()/180) * POWER(SIN((143.817225 - "tx_long") * pi()/180 / 2), 2) ))) as distance FROM business b, lbb_location_info.loc_states s
WHERE suspended IS NULL
AND s.id = b.state_id
AND da_rejected IS NULL
AND approved = "1"
AND ( MATCH (tx_fulltext_search) AGAINST ('+White's >Florist ' IN BOOLEAN MODE) AND b.id != "2600" )
ORDER BY b.nu_programme ASC, Relevance DESC,distance ASC
LIMIT 4
)
)
[4] => Array
(
[file] => /vhosts/businesssearch.com.au/htdocs/app/profile_common.inc
[line] => 161
[function] => search_mailSearch
[class] => search_queries
[type] => ->
[args] => Array
(
[0] => White's Florist
[1] =>
[2] =>
[3] => 4
[4] =>
[5] =>
[6] => -37.556958
[7] => 143.817225
[8] => 2600
)
)
[5] => Array
(
[file] => /vhosts/businesssearch.com.au/htdocs/app/home.inc
[line] => 5
[args] => Array
(
[0] => /vhosts/businesssearch.com.au/htdocs/app/profile_common.inc
)
[function] => include
)
[6] => Array
(
[file] => /vhosts/businesssearch.com.au/htdocs/index2.php
[line] => 69
[args] => Array
(
[0] => /vhosts/businesssearch.com.au/htdocs/app/home.inc
)
[function] => include
)
)
[previous:Exception:private] =>
[msg] => 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 's Florist ')) AS Relevance, (
SELECT loc.tx_lat FROM lbb_location_info.loc' at line 1
)
ADOConnection.Execute(
SELECT s.name AS state, b.*, (MATCH (tx_fulltext_search) AGAINST ('White's Florist ')) AS Relevance, (
SELECT loc.tx_l...) % line 56, file: db.class.app
db.db_query(
SELECT s.name AS state, b.*, (MATCH (tx_fulltext_search) AGAINST ('White's Florist ')) AS Relevance, (
SELECT loc.tx_l...) % line 145, file: search_queries.class.app
search_queries.search_mailSearch(White's Florist, , false, 4, , , -37.556958, 143.817225, 2600) % line 161, file: profile_common.inc
include(/vhosts/businesssearch.com.au/htdocs/app/profile_common.inc) % line 5, file: home.inc
include(/vhosts/businesssearch.com.au/htdocs/app/home.inc) % line 69, file: index2.php
Get Directions
Print Page