Error:
Using localhost/xeropolis_facts as xeropolis_facts
SELECT *,DATE_FORMAT(start_date,'%b %D, %Y') AS
formatted_date,IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>129600,
IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>2626560,
IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>31557600,
CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/31557600,
0),'y'),
CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/2626560,
0),'m')), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/86400,
0),'d')), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/3600,
0),'h')) AS time_since FROM items ORDER BY start_date DESC
Unknown column 'start_date' in 'field list'
#0 Error::report(Using localhost/xeropolis_facts as xeropolis_facts
SELECT *,DATE_FORMAT(start_date,'%b %D, %Y') AS formatted_date,IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>129600, IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>2626560, IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>31557600, CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/31557600, 0),'y'), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/2626560, 0),'m')), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/86400, 0),'d')), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/3600, 0),'h')) AS time_since FROM items ORDER BY start_date DESC
Unknown column 'start_date' in 'field list') called at [/home/xeropolis/public_html/news/src/lib/base/database/db_connector.php:83]
#1 DatabaseConnector->query(DatabaseQuery Object ([command] => SELECT,[fields] => Array ([*] => 'NULL',[DATE_FORMAT(start_date,'%b %D, %Y') AS formatted_date] => 'NULL',[IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>129600, IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>2626560, IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>31557600, CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/31557600, 0),'y'), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/2626560, 0),'m')), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/86400, 0),'d')), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/3600, 0),'h')) AS time_since] => 'NULL'),[values] => ,[tables] => Array ([0] => items),[clauses] => ,[group_by] => ,[order_by] => Array ([0] => start_date DESC),[limit] => ,[sql] => ), DatabaseName Object ([host] => localhost,[name] => xeropolis_facts,[account] => xeropolis_facts,[password] => Qazwsx42)) called at [/home/xeropolis/public_html/news/src/lib/base/database/db_connector.php:34]
#2 DatabaseConnector->execute(DatabaseQuery Object ([command] => SELECT,[fields] => Array ([*] => 'NULL',[DATE_FORMAT(start_date,'%b %D, %Y') AS formatted_date] => 'NULL',[IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>129600, IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>2626560, IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>31557600, CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/31557600, 0),'y'), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/2626560, 0),'m')), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/86400, 0),'d')), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/3600, 0),'h')) AS time_since] => 'NULL'),[values] => ,[tables] => Array ([0] => items),[clauses] => ,[group_by] => ,[order_by] => Array ([0] => start_date DESC),[limit] => ,[sql] => ), 1) called at [/home/xeropolis/public_html/news/src/lib/base/table.php:121]
#3 Table->execute(DatabaseQuery Object ([command] => SELECT,[fields] => Array ([*] => 'NULL',[DATE_FORMAT(start_date,'%b %D, %Y') AS formatted_date] => 'NULL',[IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>129600, IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>2626560, IF(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date)>31557600, CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/31557600, 0),'y'), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/2626560, 0),'m')), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/86400, 0),'d')), CONCAT(ROUND((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(start_date))/3600, 0),'h')) AS time_since] => 'NULL'),[values] => ,[tables] => Array ([0] => items),[clauses] => ,[group_by] => ,[order_by] => Array ([0] => start_date DESC),[limit] => ,[sql] => )) called at [/home/xeropolis/public_html/news/src/model/items.php:59]
#4 Items->get_items() called at [/home/xeropolis/public_html/electionnightincanada.com/src/controller/enic_home_controller.php:182]
#5 EnicHomeController->get_page_data(electionnightincanada.com, Array ([PATH] => /bin:/usr/bin:/usr/local/bin,[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,[HTTP_ACCEPT_ENCODING] => gzip,[HTTP_CONNECTION] => Keep-Alive,[HTTP_HOST] => electionnightincanada.com,[HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/),[HTTP_IF_MODIFIED_SINCE] => Fri, 22 Jun 2018 03:31:19 GMT,[DOCUMENT_ROOT] => /home/xeropolis/public_html/electionnightincanada.com,[REMOTE_ADDR] => 54.198.96.198,[REMOTE_PORT] => 45202,[SERVER_ADDR] => 209.172.40.176,[SERVER_NAME] => electionnightincanada.com,[SERVER_ADMIN] => webmaster@electionnightincanada.xeropolis.com,[SERVER_PORT] => 80,[REQUEST_URI] => /42/1/,[REDIRECT_URL] => /42/1/,[REDIRECT_STATUS] => 200,[SCRIPT_FILENAME] => /home/xeropolis/public_html/electionnightincanada.com/index.php,[QUERY_STRING] => ,[SCRIPT_URI] => http://electionnightincanada.com/42/1/,[SCRIPT_URL] => /42/1/,[SCRIPT_NAME] => /index.php,[SERVER_PROTOCOL] => HTTP/1.1,[SERVER_SOFTWARE] => LiteSpeed,[REQUEST_METHOD] => GET,[PHP_SELF] => /index.php,[REQUEST_TIME_FLOAT] => 1534448936.261,[REQUEST_TIME] => 1534448936,[path_array] => Array ([0] => ,[1] => 42,[2] => 1,[3] => ))) called at [/home/xeropolis/public_html/electionnightincanada.com/src/enic_dispatch.php:182]
#6 EnicDispatch->go(electionnightincanada.com, 42, Array ([PATH] => /bin:/usr/bin:/usr/local/bin,[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,[HTTP_ACCEPT_ENCODING] => gzip,[HTTP_CONNECTION] => Keep-Alive,[HTTP_HOST] => electionnightincanada.com,[HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/),[HTTP_IF_MODIFIED_SINCE] => Fri, 22 Jun 2018 03:31:19 GMT,[DOCUMENT_ROOT] => /home/xeropolis/public_html/electionnightincanada.com,[REMOTE_ADDR] => 54.198.96.198,[REMOTE_PORT] => 45202,[SERVER_ADDR] => 209.172.40.176,[SERVER_NAME] => electionnightincanada.com,[SERVER_ADMIN] => webmaster@electionnightincanada.xeropolis.com,[SERVER_PORT] => 80,[REQUEST_URI] => /42/1/,[REDIRECT_URL] => /42/1/,[REDIRECT_STATUS] => 200,[SCRIPT_FILENAME] => /home/xeropolis/public_html/electionnightincanada.com/index.php,[QUERY_STRING] => ,[SCRIPT_URI] => http://electionnightincanada.com/42/1/,[SCRIPT_URL] => /42/1/,[SCRIPT_NAME] => /index.php,[SERVER_PROTOCOL] => HTTP/1.1,[SERVER_SOFTWARE] => LiteSpeed,[REQUEST_METHOD] => GET,[PHP_SELF] => /index.php,[REQUEST_TIME_FLOAT] => 1534448936.261,[REQUEST_TIME] => 1534448936,[path_array] => Array ([0] => ,[1] => 42,[2] => 1,[3] => ))) called at [/home/xeropolis/public_html/electionnightincanada.com/index.php:29]