Closed (fixed)
Project:
Integrated Metatags
Version:
6.x-1.0-beta7
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
17 Jan 2010 at 22:03 UTC
Updated:
3 Feb 2010 at 09:00 UTC
Hi, I just installed the module, am using POSTGRES and I have been trying to figure out why the meta tags just dont show up in the sourcecode.
I am getting two errors in the logs (admin/reports/dblog):
1.
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: column "int_meta_fields.type" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ... WHERE (type = 'tutorial' OR type = '') ORDER BY type ASC, ... ^ in /path/to/drupal/includes/database.pgsql.inc on line 139.
2.
query: SELECT COUNT(*) FROM int_meta_fields WHERE (type = 'tutorial' OR type = '') ORDER BY type ASC, field ASC, name ASC in /path/to/drupal/sites/site/modules/int_meta/int_meta.module on line 342.
I have to note that when i go to /admin/content/int_meta I don't see any dymanic entries that i have made (so I cannot delete any, neither confirm that any exists), but when i query the database manually i get:
select * from int_meta_fields;
field | type | name | combine | status
-------------+----------+-------------+---------+--------
node.teaser | | description | 0 | 1
term.*.name | | keywords | 1 | 1
node.teaser | tutorial | description | 0 | 1
term.*.name | tutorial | keywords | 1 | 1
(4 rows)
Any ideas? Thanks.
Comments
Comment #1
fractile81 commentedI believe I have this fixed in the latest DEV build for 6.x. Would you mind trying it to see if it fixes your problem?
Comment #2
vevhlos commentedYes it is fixed. Thanks a lot!