Jump to:
| Project: | Feed field (CCK module) |
| Version: | 6.x-1.9 |
| Component: | Code |
| Category: | bug report |
| Priority: | major |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
I get a set of these errors for each feed_field on every page viewing:
warning: pg_query(): Query failed: ERROR: syntax error at or near "SET" at character 44 in /var/www/people/includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO itservices_feed_field_settings SET url='[feed url]', nid=151, modified='1305315525', delta=0 in /var/www/people/sites/all/modules/feed_field/feed_field.module on line 207.
warning: pg_query(): Query failed: ERROR: currval of sequence "itservices_feed_field_settings_id_seq" is not yet defined in this session in /var/www/people/includes/database.pgsql.inc on line 139.
user warning: query: SELECT CURRVAL('itservices_feed_field_settings_id_seq') in /var/www/people/includes/database.pgsql.inc on line 232.
warning: pg_query(): Query failed: ERROR: currval of sequence "itservices_feed_field_settings_id_seq" is not yet defined in this session in /var/www/people/includes/database.pgsql.inc on line 139.
user warning: query: SELECT CURRVAL('itservices_feed_field_settings_id_seq') in /var/www/people/includes/database.pgsql.inc on line 232.
The insert syntax is not correct SQL (according to postgres, it may be ok in mysql).
Correcting the syntax and manually filling the {feed_field_settings} table doesn't help, it still wants to do an insert instead of an update on each view.
Comments
#1
Making these changes at line 133:
//db_query("INSERT INTO {feed_field_settings} SET url='%s', nid=%d, delta=%d",
db_query("INSERT INTO {feed_field_settings} (url,nid,delta) VALUES ('%s', %d, %d);",
and at 207(208 after the other change):
//db_query("INSERT INTO {feed_field_settings} SET url='%s', nid=%d, modified='%s', delta=%d", $item['feed_field_url'], $nid, $settings['modified'], $item['#delta']);
db_query("INSERT INTO {feed_field_settings} (url,nid,modified,delta) VALUES ('%s', %d, '%s', %d)", $item['feed_field_url'], $nid, $settings['modified'], $item['#delta']);
Seems to have cleared out the big problem.
However, at the first node-save of a node with a new feed field, I got a sql error about a not null constraint on the modified field.
This went away on subsequent viewing/edits. Probably the modified field needs to be added to the initial feed addition in line 133.