Error: Internal error
-------- debug -----------
[3-]uStep_function::get() php_include:uWork3-pre/apps/cmslet/cmsletprovider.php?cmsletprovider::getPage
[3-]uStep_function::get() php_include:uWork3-pre/apps/cmslet/cmsletprovider.php?cmsletprovider::getPage *
[3-]ustep_cmslet_getheaddata::get() *
[3-]uStep_headdatacollector::get() *
[3-]uStep_headrenderer::get() *
[3-]uStep_function::get() php_include:uWork3-pre/apps/cmslet/cmsletprovider.php?cmsletprovider::getPage
[3-]uStep_function::get() php_include:uWork3-pre/apps/cmslet/cmsletprovider.php?cmsletprovider::preparePageForRender *
[3-]uStep_function::get() php_include:uWork3-pre/apps/cmslet/cmsletprovider.php?cmsletprovider::getPage
[3-]uStep_function::get() php_include:uWork3-pre/apps/cmslet/cmsletprovider.php?cmsletprovider::getArticles *
[3-]uStep_function::get() php_include:uWork3-pre/apps/cmslet/cmsletprovider.php?cmsletprovider::preparePageForRender
[3-]uStep_function::get() php_include:uWork3-pre/apps/cmslet/cmsletprovider.php?cmsletprovider::prepareArticlesForRender *
[3-]uStep_cmslet_renderer_uWorkCS01::get() *
[3-](sqlhelper->get_query(): generated SQL:
SELECT
p.ID,
p.FirstName,
p.LastName,
p.Company,
p.CompanyURL,
p.Country AS Country1,
Country.EnglishName AS Country2,
hc.Company AS hc_Company,
hc.CompanyURL AS hc_Company_URL,
hc.Country AS hc_Country1,
hc_Country.EnglishName AS hc_Country2
FROM Person p,
Presence prs,
MasterEvent me
LEFT JOIN HistoryCompany hc ON prs.HistoryCompany_ID=hc.ID
LEFT JOIN Country ON p.Country_Code=Country.Code
LEFT JOIN Country hc_Country ON hc.Country_Code=hc_Country.Code
WHERE p.ID=prs.Person_ID AND
prs.Status='active' AND
prs.MasterEvent_Code = me.Code AND
me.Owner_Code IN ('IP', 'ContWS')
GROUP BY p.ID
ORDER BY p.FirstName
)
[3-]Database error: Invalid SQL: SELECT
p.ID,
p.FirstName,
p.LastName,
p.Company,
p.CompanyURL,
p.Country AS Country1,
Country.EnglishName AS Country2,
hc.Company AS hc_Company,
hc.CompanyURL AS hc_Company_URL,
hc.Country AS hc_Country1,
hc_Country.EnglishName AS hc_Country2
FROM Person p,
Presence prs,
MasterEvent me
LEFT JOIN HistoryCompany hc ON prs.HistoryCompany_ID=hc.ID
LEFT JOIN Country ON p.Country_Code=Country.Code
LEFT JOIN Country hc_Country ON hc.Country_Code=hc_Country.Code
WHERE p.ID=prs.Person_ID AND
prs.Status='active' AND
prs.MasterEvent_Code = me.Code AND
me.Owner_Code IN ('IP', 'ContWS')
GROUP BY p.ID
ORDER BY p.FirstName
[3-]MySQL Error: 1054 (Unknown column 'prs.HistoryCompany_ID' in 'on clause')