phpBB.de

Code: Alles auswählen

SQL ERROR [ mysqli ]

Unknown column 'pf_plz' in 'where clause' [1054]

SQL

SELECT COUNT(user_id) user_count FROM phpbb_profile_fields_data WHERE pf_plz != 0 AND pf_land != 0 AND user_id = 2

BACKTRACE

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

FILE: memberlist.php
LINE: 608
CALL: dbal_mysqli->sql_query()

Code: Alles auswählen

SQL ERROR [ mysqli ]

Unknown column 'pd.pf_plz' in 'field list' [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_users u INNER JOIN phpbb_profile_fields_data pd ON u.user_id = pd.user_id LEFT JOIN phpbb_groups g ON u.group_id = g.group_id LEFT JOIN phpbb_geo_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: 492
CALL: dbal_mysqli->sql_query()

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

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