[AA_]

Originally Posted by Delilahs

Error code when trying to allocate Icons to teams.

This was working until the latest update

PHP Code:

Database error in vBulletin 4.0.2:

Invalid SQL:

            UPDATE `soccer_league`
            SET `tabledata`=''
            WHERE `id` IN(
                SELECT league_id
                FROM `soccer_league`
                WHERE team_id=363);

MySQL Error   : Unknown column 'league_id' in 'field list'
Error Number  : 1054 


thnx and sorry

vbsoccer_admin.php (line 1415):

		$db->query_write("
			UPDATE `" . TABLE_PREFIX . "soccer_league`
			SET `tabledata`=''
			WHERE `id` IN(
				SELECT league_id
				FROM `" . TABLE_PREFIX . "soccer_league_team`
				WHERE team_id=" . $vbulletin->GPC['teamid'] . ")
			");