Europa (117949)

Afrika (76)

Noord-Amerika (2202)

Zuid-Amerika (23)

Azië (104)

Australië (16)

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="2" 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="2" 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