When I click 'sources' from the navigation menu on a recently created drupal 4.7 site, I am seeing the following message:

* warning: Missing argument 1 for og_aggregator_page_sources() in /var/www/modules/og_aggregator/og_aggregator.module on line 727.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT COUNT(*) FROM og_aggregator_item WHERE fid = in /var/www/drupal-4.7.5/includes/database.mysql.inc on line 121.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY timestamp DESC, iid DESC LIMIT 0, 20' at line 1 query: SELECT * FROM og_aggregator_item WHERE fid = ORDER BY timestamp DESC, iid DESC LIMIT 0, 20 in /var/www/drupal-4.7.5/includes/database.mysql.inc on line 121.

The non-og news aggregator works fine. I have added a feed, which is updated fine.

When I click 'aggregator' from a group page, it says 'nothing', without options for adding the feed.

Also when I click admin -> og aggregator, there is also no way to add a feed.

In user access, I do not see a specific set of permissions for og_aggregator.

So how do I add feeds specific to groups, and how will I get rid of the error message?

Any suggestions welcome.

Comments

gerbrand’s picture

gerbrand commented

UPDATE:

I can submit og sources. it was a theme issue.

although the db table was missing the 'antikeyword' field, which i added by hand. now it works.

however, i am still getting the

" * warning: Missing argument 1 for og_aggregator_page_sources() in /var/www/modules/og_aggregator/og_aggregator.module on line 727.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT COUNT(*) FROM og_aggregator_item WHERE fid = in /var/www/drupal-4.7.5/includes/database.mysql.inc on line 121.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY timestamp DESC, iid DESC LIMIT 0, 20' at line 1 query: SELECT * FROM og_aggregator_item WHERE fid = ORDER BY timestamp DESC, iid DESC LIMIT 0, 20 in /var/www/drupal-4.7.5/includes/database.mysql.inc on line 121."

error message on http://.../og_aggregator/sources

zagorot’s picture

zagorot commented

thanks for your report.
I will rewrite some functions of this module soon.

zagorot’s picture

zagorot commented
Assigned: Unassigned » zagorot

thanks for your report.
I will rewrite some functions of this module soon.

skassam’s picture

skassam commented

What table did you add the field 'antikeyword' and what data type should it be?

zagorot’s picture

zagorot commented

please use 4.7.x-1.0, this is latest and stable release, fixed "Incomplete og_aggregator_feed table creation script".

the missing field 'antikeyword' should be varchar(255) NOT NULL default ''

see og_aggregator.install of this package, you can get all db structure here, and then find out antikeyword varchar(255) NOT NULL default '', at line 28, that's the missed field.

Again, there are two releases here, note that 4.7.x-1.0 is the latest and stable release. 4.7.x-0.1.x-dev is a broken release with a bug above.

thanks.

zagorot’s picture

zagorot commented
Status: Active » Closed (fixed)