search

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 ] #52

Closed sslorigin closed 3 years ago

sslorigin commented 3 years ago

Hi @AlexSheer

coud you take a look please. It appeared with phpBB 3.3.2 & STK 1.0.17-dev with list of profiles

Source : https://caforum.fr/forum/viewtopic.php?p=1708#p1708

General Error

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

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

SQL

SELECT COUNT(u.user_id) as cnt FROM lgdsfor_users u , lgdsfor_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_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: 194 CALL: phpbb\db\driver\factory->sql_query()

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

BACKTRACE

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: 194 CALL: phpbb\db\driver\factory->sql_query()

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

Best regards

AlexSheer commented 3 years ago

Fixed https://github.com/AlexSheer/phpBB3.2-STK/commit/d5e7e47ce1f174cc6c529f6068b06340e9c196ef#diff-e5697a32eb9144816aaa4d90a5fa9414dc715f11da71495d3ceec60a4a4dc9d3

sslorigin commented 3 years ago

Thanks Alex

Galixte commented 3 years ago

Thanks Alex

If it’s fixed, close your issue, please.