postgres doesn't understand "INSERT INTO {table} SET field=value......
postgres doesn't like the 'SET' part
the simple fix is removing this:
db_query("INSERT INTO {bot_factoid} SET subject = '%s', is_are = '%s', statement = '%s'", $subject, $is_are, $statement);
and replacing it with this:
db_query("INSERT INTO {bot_factoid} (subject, is_are, statement) VALUES ('%s','%s', '%s')", $subject, $is_are, $statement);
attached is patch.
| Comment | File | Size | Author |
|---|---|---|---|
| bot_factoid.module.patch | 414 bytes | josh waihi |
Comments
Comment #1
josh waihi commentedComment #2
josh waihi commentedcould someone please review this?
Comment #3
morbus iffI've no problem with it. It'll go in when I have a chance.
Comment #4
morbus iffActually, closing this - it'd be covered under http://drupal.org/node/274888.