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

eugenmayer’s picture

Status: Active » Needs work

Well 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.

eugenmayer’s picture

Category: bug » task
Priority: Normal » Minor

As its only in the very rarely used submodule i mark it as a task

eugenmayer’s picture

Status: Needs work » Fixed

fixed in 1.10

eugenmayer’s picture

Status: Fixed » Closed (fixed)

released in 6--1-10