AlexSheer / phpBB3.2-STK

Support ToolKit For phpBB3.2.x
https://www.phpbbguru.net/community/viewtopic.php?f=64&t=42862
15 stars 13 forks source link

[phpBB Debug] PHP : in file [ROOT]/phpbb/db/driver/driver.php on line 1023: SQL ERROR [ mysqli ] #49

Closed Galixte closed 4 years ago

Galixte commented 4 years ago

Hi @AlexSheer

coud you take a look please. It appeared with phpBB 3.3.1 & STK 1.0.15.

Source: https://www.ezcom-fr.com/viewtopic.php?p=5891#p5891.

General Error

[phpBB Debug] PHP : in file [ROOT]/phpbb/db/driver/driver.php on line 1023: SQL ERROR [ mysqli ]

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

SQL

SELECT COUNT(u.user_id) as cnt FROM phpbb_users u , phpbb_profile_fields_data p WHERE u.user_type <> 2 AND (pf_phpbb_icq <> '' OR pf_phpbb_aol <> '' OR pf_phpbb_skype <> '' OR pf_phpbb_facebook <> '' OR pf_phpbb_googleplus <> '' OR pf_phpbb_twitter <> '' OR pf_phpbb_yahoo <> '' OR pf_phpbb_youtube <> '' OR user_jabber <> '' OR pf_phpbb_website <> '' OR pf_phpbb_occupation <> '' OR pf_phpbb_interests <> '' OR pf_phpbb_location <> '' OR user_sig <> '' ) AND u.user_id = p.user_id

FILE: (not given by php)
LINE: (not given by php)
CALL: stk_msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 195
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/stk/tools/admin/profile_list.php
LINE: 188
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/stk/index.php
LINE: 301
CALL: profile_list->display_options()

Regards.

Galixte commented 4 years ago

@AlexSheer bump, please.