Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-9378

SQL syntax error in update_foes()

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Trivial
    • Resolution: Duplicate
    • 3.0.x
    • None
    • Other
    • None
    • PHP Environment: 5.2.3
      Database: MySQL 5.0.16

    Description

      In includes/functions_admin.php on line 2607, the function update_foes() attempts to execute an invalid SQL query. This will trigger an error whenever the administrator updates a user account.

      The syntax error is a missing space after "DELETE FROM". See below:

      		if ($db->multi_table_deletion)
      		{
      			$sql = 'DELETE FROM' . ZEBRA_TABLE . ' z
      				USING ' . USER_GROUP_TABLE . ' ug
      				WHERE z.zebra_id = ug.user_id
      					AND z.foe = 1
      					AND ' . $db->sql_in_set('ug.group_id', $groups);
      			$db->sql_query($sql);

      Attachments

        Activity

          People

            naderman Nils Adermann
            arancaytar arancaytar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: