Error opgetreden
Er is een probleem opgetreden waardoor wij geen gegevens uit de database kunnen halen.
De mysql error is:Unknown column 'continent_id' in 'where clause'
Query: SELECT count(*) AS total, count(distinct(ads.id)) AS total FROM ads WHERE continent_id="6" AND status_id = 1
Application stack
#0 /home/tweedewoni/domains/tweedewoning.eu/public_html/app/base/db.php(58): DB->Query('SELECT count(*)...')
#1 /home/tweedewoni/domains/tweedewoning.eu/public_html/app/base/activerecord.php(225): DB->FetchInArray('SELECT count(*)...')
#2 /home/tweedewoni/domains/tweedewoning.eu/public_html/app/models/ad.php(9): ActiveRecord::find('Ad', 'ads', 3, Array)
#3 /home/tweedewoni/domains/tweedewoning.eu/public_html/app/controllers/woningen_controller.php(55): Ad::find(3, Array)
#4 /home/tweedewoni/domains/tweedewoning.eu/public_html/dispatcher.php(87): WoningenController->index()
#5 {main}
Database SQL stack
SELECT * FROM languages WHERE id = '1' AND 1 LIMIT 1
SELECT count(*) AS total, count(distinct(ads.id)) AS total FROM ads WHERE continent_id="6" AND status_id = 1
SELECT * FROM continents WHERE 1 ORDER BY id
SELECT *, (SELECT count(*) FROM ads WHERE country_id = countries.id AND status_id = 1) AS aantal FROM countries WHERE continent_id = 1 ORDER BY name
SELECT *, (SELECT count(*) FROM ads WHERE country_id = countries.id AND status_id = 1) AS aantal FROM countries WHERE continent_id = 2 ORDER BY name
SELECT *, (SELECT count(*) FROM ads WHERE country_id = countries.id AND status_id = 1) AS aantal FROM countries WHERE continent_id = 3 ORDER BY name
SELECT *, (SELECT count(*) FROM ads WHERE country_id = countries.id AND status_id = 1) AS aantal FROM countries WHERE continent_id = 4 ORDER BY name
SELECT *, (SELECT count(*) FROM ads WHERE country_id = countries.id AND status_id = 1) AS aantal FROM countries WHERE continent_id = 5 ORDER BY name
SELECT *, (SELECT count(*) FROM ads WHERE country_id = countries.id AND status_id = 1) AS aantal FROM countries WHERE continent_id = 6 ORDER BY name