table prefix treatment {...} seems to be missing from some of the queries
new versions below seem to work fine:
for wysiwyg_imageupload_migration.module
$result = db_query('select nid from {node}');
for wysiwyg_imageupload.module
$result = db_query('SELECT {f.*},{w.nid} as parent_nid,{w.vid} FROM {files} as {f} RIGHT JOIN {wysiwyg_imageupload} AS {w} on {w.fid} = {f.fid} WHERE {f.uid} = %d ORDER BY {f.timestamp} DESC'.$limit,$uid);
and
$result = db_query('SELECT {w.*},{f.*} FROM {files} as {f} INNER JOIN {wysiwyg_imageupload} AS {w} on {w.fid} = {f.fid} GROUP BY {w.nid} ORDER BY {f.timestamp} DESC'.$limit);
Comments
Comment #1
eugenmayer commentedWell both fixes for the modulle are not the way they should be, you dont surround fields at all. the fix for the migration query is a need though, will correct this.
Comment #2
eugenmayer commentedAs its only in the very rarely used submodule i mark it as a task
Comment #3
eugenmayer commentedfixed in 1.10
Comment #4
eugenmayer commentedreleased in 6--1-10