Unknown column ‘user_pass’ in ‘field list’ [1054]

  • Resolved psychosoundwave

    (@psychosoundwave)


    2 years, 3 months ago

    Hi there,

    I am using the wp-w3all-phpbb-integration extension in phpBB3.
    Whenever I attempt to change my password in phpBB3 (in the User Control Panel), I get a “General Error” page. Here are the details:

    SQL ERROR [ mysqli ]

Unknown column 'user_pass' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

BACKTRACE

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

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

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

FILE: [ROOT]/ext/w3all/phpbbwordpressintegration/event/main_listener.php
LINE: 181
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 214
CALL: w3all\phpbbwordpressintegration\event\main_listener->ucp_profile_reg_details_validate()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 44
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 62
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/includes/ucp/ucp_profile.php
LINE: 126
CALL: phpbb\event\dispatcher->trigger_event()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: ucp_profile->main()

FILE: [ROOT]/ucp.php
LINE: 440
CALL: p_master->load_active()
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author axew3

    (@axewww)

    Hello!
    Which version?
    And strange, the user_pass column, of course should exist into the user’s table.
    So it is strange you get this error.
    1.0.0, 1.0.1 or 1.0.2?

    The new phpBB wordpress extension is coming, with acp settings (instead of config file) and fixed under many aspects

    • This reply was modified 2 years, 3 months ago by axew3.
    Thread Starter psychosoundwave

    (@psychosoundwave)

    Hello!

    Please disregard. I figured it out. I was using the wrong table prefix in the phpBB3 extension. I couldn’t find how to delete this post.
    Great news about the ACP functionality!
    Apologies for wasting your time and thank you so much for such an invaluable plugin!

    Will be donating via PayPal. I hope you get lots of other donations. A lot of work went into these plugins/extensions.

    Thanks!!

    Plugin Author axew3

    (@axewww)

    Ok fine!
    All work ok into all extensions, but if you activate redirect to WP onlogin, the extension, you’ll note, sometime will redirect users into WP also when should not, for example when a new session is set for the user in phpBB, but the user do not logged in, but phpBB update the user’s session, and it cause the redirect because the redirect is hooked into a session listener.
    SO if you note this behavior sometime (that do not will happen ever, but when session renewed on phpBB) you know that it is due the above and it is resolved into next coming!
    If anything else just let know

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Unknown column ‘user_pass’ in ‘field list’ [1054]’ is closed to new replies.