Closed (fixed)
Project:
WYSIWYG image upload - Inline images for your WYSIWYG
Version:
6.x-1.9
Component:
Code
Priority:
Minor
Category:
Task
Assigned:
Unassigned
Reporter:
Created:
14 Apr 2010 at 00:43 UTC
Updated:
1 May 2010 at 11:11 UTC
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