SELECT
F.*,
C.CountryCode,
C.CountryName,
A.*,
F.ZipCode as ZipCode,
FT.FirmTransactionId,
FJ.FirmJson,
FJ.MetaTitle,
FJ.MetaDescription,
FJ.Source,
FJ.FirmSlugUrl
FROM
Firm F
LEFT JOIN Country C ON F.CountryId=C.CountryId
LEFT JOIN Account A on F.AccountId=A.AccountId
LEFT JOIN FirmTransaction FT on FT.FirmId=F.FirmId
LEFT JOIN FirmJson FJ on FJ.FirmId=F.FirmId
WHERE
F.FirmId = 6422124 and F.LanguageCode= 'en'ErrorListException Object
(
[a_errors:protected] => Array
(
[0] => BackOfficeError Object
(
[s_code:protected] =>
[s_text:protected] => Unable to execute database query
[a_fields:protected] => Array
(
)
[s_category:protected] => backOffice
)
)
[message:protected] =>
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/Data/DataAccess.class
[line:protected] => 184
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/Data/DataAccess.class
[line] => 100
[function] => error
[class] => DataAccess
[type] => ->
[args] => Array
(
[0] => QUERY.FAILURE
)
)
[1] => Array
(
[file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/Data/Firm/FirmModel.class
[line] => 42
[function] => Query
[class] => DataAccess
[type] => ->
[args] => Array
(
[0] => SELECT
F.*,
C.CountryCode,
C.CountryName,
A.*,
F.ZipCode as ZipCode,
FT.FirmTransactionId,
FJ.FirmJson,
FJ.MetaTitle,
FJ.MetaDescription,
FJ.Source,
FJ.FirmSlugUrl
FROM
Firm F
LEFT JOIN Country C ON F.CountryId=C.CountryId
LEFT JOIN Account A on F.AccountId=A.AccountId
LEFT JOIN FirmTransaction FT on FT.FirmId=F.FirmId
LEFT JOIN FirmJson FJ on FJ.FirmId=F.FirmId
WHERE
F.FirmId = 6422124 and F.LanguageCode= 'en'
)
)
[2] => Array
(
[file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/Data/Firm/FirmSet.class
[line] => 17
[function] => SelectFirmDataByArgs
[class] => FirmModel
[type] => ->
[args] => Array
(
[0] => 6422124
[1] => en
)
)
[3] => Array
(
[file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/BizFirm/BizFirmMgr.class
[line] => 77
[function] => getFirmDataByArgs
[class] => FirmSet
[type] => ->
[args] => Array
(
[0] => 6422124
[1] => en
)
)
[4] => Array
(
[file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/BizFirm/BizFirmAction.class
[line] => 241
[function] => getFirmData
[class] => BizFirmMgr
[type] => ->
[args] => Array
(
[0] => 6422124
[1] => en
)
)
[5] => Array
(
[file] => /home/soadmin/domains/2findlocal.com/CodeBase/Classes/Actions/ActionBase.class
[line] => 56
[function] => execute
[class] => BizFirmAction
[type] => ->
[args] => Array
(
)
)
[6] => Array
(
[file] => /home/soadmin/domains/2findlocal.com/CodeBase/Modules/firm.php
[line] => 10
[function] => run
[class] => ActionBase
[type] => ->
[args] => Array
(
)
)
)
[previous:Exception:private] =>
)
ErrorListException