phpBB.de

Code: Alles auswählen

SQL ERROR [ mysqli ]

Unknown column 'g.geo_hide' in 'where clause' [1054]

SQL

SELECT u.user_id, u.username, u.user_from, u.user_colour, u.username_clean, u.group_id, g.group_name, g.group_colour, pd.pf_plz, pd.pf_land, gp.breite, gp.laenge, gp.ort FROM phpbb_1users u INNER JOIN phpbb_1profile_fields_data pd ON u.user_id = pd.user_id LEFT JOIN phpbb_1groups g ON u.group_id = g.group_id LEFT JOIN phpbb_1geo_plz gp ON ( pd.pf_plz = gp.plz AND pd.pf_land = gp.land ) WHERE pd.pf_plz IS NOT NULL AND gp.breite IS NOT NULL AND g.group_name = 'REGISTERED' AND g.geo_hide = 0 ORDER BY gp.breite, gp.laenge

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_geomap.php
LINE: 496
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_geomap.php
LINE: 523
CALL: geomap->getGeoUsers()

FILE: geomap.php
LINE: 97
CALL: geomap->createGeomap()