SQL Error when setting a user as "founder"

Events happening in the community are now at Drupal community events on www.drupal.org.
archard-gdo's picture

I'm using the latest phpbb 3.0 module with Drupal 5.2. Both Drupal and phpbb are running on mysqli. I logged into the phpbb superuser account (phpbb/bypass) and tried setting user myself as "founder" and this error came up on a nice neat phpbb generated page:

General Error
SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE uid = 1001' at line 1 [1064]

SQL

UPDATE drupal_users SET WHERE uid = 1001

BACKTRACE

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

FILE: includes/functions_drupal.php
LINE: 69
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_users.php
LINE: 766
CALL: update_drupal()

FILE: includes/functions_module.php
LINE: 463
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

I noticed the error occured in the drupal database, otherwise I would've consulted the phpbb support forums. I did go back into the admin control panel and saw that the user did in fact get changed to "founder" despite the error. But still this is something worth fixing it looks like.

Comments

Thanks, fixed

arkepp's picture

Thanks, please download the beta again. The only thing you need to do is overwrite [phpBB3]/includes/functions_drupal.php with the new version, nothing else has changed.

phpbb

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week