[Done v1.3.9] Bug in admin\sqlpatch.sql

[hem]

If you are using a DB_PREFIX, the following SQL will not run (and will return an error).

#NEXT_X_ROWS_AS_ONE_COMMAND:2
DELETE FROM `configuration_group` WHERE NOT IN (
SELECT `configuration_group_id` FROM `configuration` WHERE 1); 

The problem is on line 265:

case (substr($line_upper, 0, 8) == 'SELECT (' && substr_count($line,'FROM ')>0): 

change this to:

case (substr($line_upper, 0, 7) == 'SELECT ' && substr_count($line,'FROM ')>0):