The 2026 Drupal Business Survey is open. Your response will help shape the future of the Drupal business ecosystem.Get this error on all pages after ticking the module on.
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | aggregation_block-930800.patch | 6.11 KB | Ryan Palmer |
Comments
Comment #1
ClearXS commentedmissed some lines in copying..:
user warning: Table 'user'_'dbprefix'.node doesn't exist query: SELECT n.title, n.nid AS fid, ab.usefeed FROM node 'dbprefix'n LEFT JOIN 'dbprefix'aggregation_block ab ON ab.fid = n.nid WHERE n.type='aggregation_feed' AND ab.usefeed=1 ORDER BY n.title in aggregation_block/aggregation_block.module on line 62.
Has it to do with that I use a database table prefix and that this module doesn't work with that yet?
Comment #2
ClearXS commentedAddition (Oct 8th):
'user' is the account name at my webhost, like /home/userxyz/www/drupal/etc.
'dbprefix' is a table prefix I gave when Drupal install asked me if I wanted a prefix or not and that I selected because it gives more possibilities.
Addition: (Oct 12th) have removed the module now to keep my install without error messages again. However, this module will remain in my not activated list and is automatically checked for new future updates...
Comment #3
Ryan Palmer commentedThe queries were written improperly. Some table names were prefixed, some were not, and in this case the table name alias was enclosed in curly brackets and shouldn't have been.
Please apply the attached patch. I haven't tested it, but it should work.
Comment #4
pglatz commentedThanks for the patch, Ryan; I've applied to create new release 6.x-1.2 and a few minor cosmetic fixes. I've tested it with database prefixes, works fine now. I had thought coder might have detected the error I had before with the curly braces in the wrong place, but it didn't; a reminder to test with prefixes in the future.