Alle Zahlen rot

Bei mir sind alle zahlen rot,
also alle speicher voll, dabei hab ich auf einem nur 10k ressis von allen, sind aber trotzdem rot...

und wenn ich die wirtschaft neu berechnen will kommt folgendes:

Zitat

Bei Ihrer Datenbankabfrage trat ein Fehler auf!

MySQL-Meldung: Unbekanntes Tabellenfeld 'buildings.buildlist_current_level' in field list

Originalabfrage:
SELECT
buildings.building_prod_metal,
buildings.building_prod_crystal,
buildings.building_prod_plastic,
buildings.building_prod_fuel,
buildings.building_prod_food,
buildings.building_prod_power,
buildings.building_production_factor,
buildings.buildlist_current_level,
buildings.building_power_use,
buildlist.buildlist_prod_percent
FROM
buildings,
buildlist
WHERE
buildings.building_id=buildlist.buildlist_building_id
AND buildlist.buildlist_planet_id=2455
AND buildlist.buildlist_current_level>0
AND (buildings.building_prod_metal>0
OR buildings.building_prod_crystal>0
OR buildings.building_prod_plastic>0
OR buildings.building_prod_fuel>0
OR buildings.building_prod_food>0
OR buildings.building_prod_power>0
OR buildings.building_power_use>0)
ORDER BY
buildings.building_type_id,
buildings.building_order;

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/round1.etoa.net/htdocs/classes/planets.php on line 375

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/round1.etoa.net/htdocs/classes/planets.php on line 506

Alles anzeigen