Fatal error: Uncaught mysqli_sql_exception: Unknown column 'datum' in 'field list' in /var/www/system/inc/db.php:105
Stack trace:
#0 /var/www/system/inc/db.php(105): mysqli_prepare(Object(mysqli), 'SELECT *,\ndatum...')
#1 /var/www/system/inc/db.php(70): DB->execPrepared('SELECT *,\ndatum...', Array, true)
#2 /var/www/system/inc/db-helpers.php(13): DB->fetch('SELECT *,\ndatum...')
#3 /var/www/system/applications/index/models/articles.php(103): DBHelpers::fetch('SELECT *,\ndatum...')
#4 /var/www/system/applications/index/controllers/actueel.php(36): ArticlesModel->get(Array, Array)
#5 /var/www/system/applications/index/controllers/actueel.php(9): Actueel->url()
#6 /var/www/system/inc/fc.php(238): Actueel->_remap()
#7 /var/www/public_html/index.php(34): require('/var/www/system...')
#8 {main}
Next Exception: DB Error (execPrepared): Unknown column 'datum' in 'field list' :: SELECT *,
datum
FROM (
(
SELECT
interview_article.id,
introtekst,
publicatiedatum,
online_only,
interview_article_content.titel as titel,
'interview' as type,
interview_article_content.url,
'https://scopemedia-production.ams3.cdn.digitaloceanspaces.com/images/interview_article/thumb' as $thumb_prefix,
thumb,
'https://scopemedia-production.ams3.cdn.digitaloceanspaces.com/images/interview_article/image' as $image_prefix,
image,
lang,
legacy_url,
datum
FROM interview_article interview_article
INNER JOIN interview_article_content
ON interview_article_content.interview_article_id = interview_article.id
WHERE lang='nl' AND actueel_id=2
ORDER BY datum DESC
)
UNION
( SELECT
opinie_article.id,
introtekst,
publicatiedatum,
online_only,
opinie_article_content.titel as titel,
'opinie' as type,
opinie_article_content.url,
'https://scopemedia-production.ams3.cdn.digitaloceanspaces.com/images/opinie_article/thumb' as $thumb_prefix,
thumb,
'https://scopemedia-production.ams3.cdn.digitaloceanspaces.com/images/opinie_article/image' as $image_prefix,
image,
lang,
0 as legacy_url,
datum
FROM opinie_article opinie_article
INNER JOIN opinie_article_content
ON opinie_article_content.opinie_article_id = opinie_article.id
WHERE lang='nl' AND actueel_id=2
ORDER BY datum DESC
)
) as u
ORDER BY datum DESC
in /var/www/system/inc/db.php:148
Stack trace:
#0 /var/www/system/inc/db.php(70): DB->execPrepared('SELECT *,\ndatum...', Array, true)
#1 /var/www/system/inc/db-helpers.php(13): DB->fetch('SELECT *,\ndatum...')
#2 /var/www/system/applications/index/models/articles.php(103): DBHelpers::fetch('SELECT *,\ndatum...')
#3 /var/www/system/applications/index/controllers/actueel.php(36): ArticlesModel->get(Array, Array)
#4 /var/www/system/applications/index/controllers/actueel.php(9): Actueel->url()
#5 /var/www/system/inc/fc.php(238): Actueel->_remap()
#6 /var/www/public_html/index.php(34): require('/var/www/system...')
#7 {main}
Next Exception: DB Error (fetch): DB Error (execPrepared): Unknown column 'datum' in 'field list' :: SELECT *,
datum
FROM (
(
SELECT
interview_article.id,
introtekst,
publicatiedatum,
online_only,
interview_article_content.titel as titel,
'interview' as type,
interview_article_content.url,
'https://scopemedia-production.ams3.cdn.digitaloceanspaces.com/images/interview_article/thumb' as $thumb_prefix,
thumb,
'https://scopemedia-production.ams3.cdn.digitaloceanspaces.com/images/interview_article/image' as $image_prefix,
image,
lang,
legacy_url,
datum
FROM interview_article interview_article
INNER JOIN interview_article_content
ON interview_article_content.interview_article_id = interview_article.id
WHERE lang='nl' AND actueel_id=2
ORDER BY datum DESC
)
UNION
( SELECT
opinie_article.id,
introtekst,
publicatiedatum,
online_only,
opinie_article_content.titel as titel,
'opinie' as type,
opinie_article_content.url,
'https://scopemedia-production.ams3.cdn.digitaloceanspaces.com/images/opinie_article/thumb' as $thumb_prefix,
thumb,
'https://scopemedia-production.ams3.cdn.digitaloceanspaces.com/images/opinie_article/image' as $image_prefix,
image,
lang,
0 as legacy_url,
datum
FROM opinie_article opinie_article
INNER JOIN opinie_article_content
ON opinie_article_content.opinie_article_id = opinie_article.id
WHERE lang='nl' AND actueel_id=2
ORDER BY datum DESC
)
) as u
ORDER BY datum DESC
:: SELECT *,
datum
FROM (
(
SELECT
interview_article.id,
introtekst,
publicatiedatum,
online_only,
interview_article_content.titel as titel,
'interview' as type,
interview_article_content.url,
'https://scopemedia-production.ams3.cdn.digitaloceanspaces.com/images/interview_article/thumb' as $thumb_prefix,
thumb,
'https://scopemedia-production.ams3.cdn.digitaloceanspaces.com/images/interview_article/image' as $image_prefix,
image,
lang,
legacy_url,
datum
FROM interview_article interview_article
INNER JOIN interview_article_content
ON interview_article_content.interview_article_id = interview_article.id
WHERE lang='nl' AND actueel_id=2
ORDER BY datum DESC
)
UNION
( SELECT
opinie_article.id,
introtekst,
publicatiedatum,
online_only,
opinie_article_content.titel as titel,
'opinie' as type,
opinie_article_content.url,
'https://scopemedia-production.ams3.cdn.digitaloceanspaces.com/images/opinie_article/thumb' as $thumb_prefix,
thumb,
'https://scopemedia-production.ams3.cdn.digitaloceanspaces.com/images/opinie_article/image' as $image_prefix,
image,
lang,
0 as legacy_url,
datum
FROM opinie_article opinie_article
INNER JOIN opinie_article_content
ON opinie_article_content.opinie_article_id = opinie_article.id
WHERE lang='nl' AND actueel_id=2
ORDER BY datum DESC
)
) as u
ORDER BY datum DESC
in /var/www/system/inc/db.php:77
Stack trace:
#0 /var/www/system/inc/db-helpers.php(13): DB->fetch('SELECT *,\ndatum...')
#1 /var/www/system/applications/index/models/articles.php(103): DBHelpers::fetch('SELECT *,\ndatum...')
#2 /var/www/system/applications/index/controllers/actueel.php(36): ArticlesModel->get(Array, Array)
#3 /var/www/system/applications/index/controllers/actueel.php(9): Actueel->url()
#4 /var/www/system/inc/fc.php(238): Actueel->_remap()
#5 /var/www/public_html/index.php(34): require('/var/www/system...')
#6 {main}
thrown in /var/www/system/inc/db.php on line 77