Closed (fixed)
Project:
FeedAPI
Version:
6.x-1.x-dev
Component:
Code feedapi (core module)
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
12 Aug 2009 at 18:30 UTC
Updated:
18 Aug 2009 at 08:00 UTC
Seems when you have a drupal prefix ($db_prefix) the new update fails.
line 196-201
if ($db_type == 'mysql' || $db_type == 'mysqli') {
$ret[] = update_sql("UPDATE {feedapi} f, node n SET f.vid = n.vid WHERE n.nid = f.nid");
}
else {
$ret[] = update_sql("UPDATE {feedapi} SET vid = n.vid FROM (SELECT vid, nid FROM node n) n WHERE n.nid = feedapi.nid");
}
I believe should be
if ($db_type == 'mysql' || $db_type == 'mysqli') {
$ret[] = update_sql("UPDATE {feedapi} f, {node} n SET f.vid = n.vid WHERE n.nid = f.nid");
}
else {
$ret[] = update_sql("UPDATE {feedapi} SET vid = n.vid FROM (SELECT vid, nid FROM {node} n) n WHERE n.nid = feedapi.nid");
}
Comments
Comment #1
ericdee commentedComment #2
aron novakThank you, fixed.
Comment #3
aron novak