Closed (fixed)
Project:
Node Images
Version:
5.x-1.x-dev
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
17 Jun 2007 at 08:59 UTC
Updated:
1 Jan 2008 at 17:48 UTC
(1) Unable to change weight, description, I've gotten a SQL syntax error (with PostgreSQL).
WRONG: UPDATE node_images SET description=".....", weight=... WHERE ....
CORRECT: UPDATE node_images SET description='.....', weight=... WHERE ....
(string literal should be enclosed with single quotes according to SQL92 standard syntax, and PostgreSQL doesn't accept string literal enclosed with double quotes. MySQL accepts string literal enclosed with double quotes if ANSI_QUOTES SQL mode is disabled).
(2) filename, description may contain quote characters, so that they had better escaped with db_escape_string().
| Comment | File | Size | Author |
|---|---|---|---|
| 20070617-node-images.patch | 2.1 KB | takashi |
Comments
Comment #1
stefano73 commented