diff options
| author | Dries Buytaert <dries@buytaert.net> | 2005-04-08 12:28:14 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2005-04-08 12:28:14 +0000 |
| commit | 58b326a838dc98b97c64b9e21f5f634b2e419037 (patch) | |
| tree | ce5b46cb22f10a5a86436cfc68a3caf7af6bc6f9 /database | |
| parent | 67f7d6947ebe7dc3222f20058edccf60852286e7 (diff) | |
| download | brdo-58b326a838dc98b97c64b9e21f5f634b2e419037.tar.gz brdo-58b326a838dc98b97c64b9e21f5f634b2e419037.tar.bz2 | |
- Fixed bug #19432, modified patch from Junyor: database update fails when a name contains a quote.
Diffstat (limited to 'database')
| -rw-r--r-- | database/updates.inc | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/database/updates.inc b/database/updates.inc index 497e8d2d1..71cdd4294 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -2282,8 +2282,7 @@ function update_124() { $result = db_query("SELECT c.nid, c.timestamp, c.name, c.uid, COUNT(c.nid) as comment_count FROM {node} n LEFT JOIN {comments} c ON c.nid = n.nid WHERE c.status = 0 GROUP BY c.nid, c.timestamp, c.name, c.uid"); while ($comment_record = db_fetch_object($result)) { $count = db_result(db_query('SELECT COUNT(cid) FROM {comments} WHERE nid = %d AND status = 0', $comment_record->nid)); - $ret[] = update_sql("UPDATE {node_comment_statistics} SET comment_count = $count, last_comment_timestamp = $comment_record->timestamp, last_comment_name = '$comment_record->name', last_comment_uid = $comment_record->uid WHERE nid = $comment_record->nid"); - } + $ret[] = db_query("UPDATE {node_comment_statistics} SET comment_count = %d, last_comment_timestamp = %d, last_comment_name = '%s', last_comment_uid = %d WHERE nid = %d", $count, $comment_record->timestamp, $comment_record->name, $comment_record->uid, $comment_record->nid); return $ret; } |