Upon first activating the og_aggregator module, a SQL error is reported:

  • * 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 'DEFAULT CHARACTER SET utf8' at line 18 query: CREATE TABLE og_aggregator_feed ( fid int(10) NOT NULL auto_increment, title varchar(255) NOT NULL default '', url varchar(255) NOT NULL default '', refresh int(10) NOT NULL default '0', checked int(10) NOT NULL default '0', link varchar(255) NOT NULL default '', description longtext, image longtext, etag varchar(255) NOT NULL default '', modified int(10) NOT NULL default '0', block tinyint(2) NOT NULL default '0', nid int(10) unsigned NOT NULL default '0', keyword varchar(255) NOT NULL default '', antikeyword varchar(255) NOT NULL default '', PRIMARY KEY (fid), UNIQUE KEY duplicate (url,nid) ) DEFAULT CHARACTER SET utf8; in /homepages/19/d209187008/htdocs/intra_root/includes/database.mysql.inc on line 172.
  • 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 'DEFAULT CHARACTER SET utf8' at line 10 query: CREATE TABLE og_aggregator_item ( iid int(10) NOT NULL auto_increment, fid int(10) NOT NULL default '0', title varchar(255) NOT NULL default '', link varchar(255) NOT NULL default '', author varchar(255) NOT NULL default '', description longtext NOT NULL, timestamp int(11) default NULL, PRIMARY KEY (iid) ) DEFAULT CHARACTER SET utf8; in /homepages/19/d209187008/htdocs/intra_root/includes/database.mysql.inc on line 172.

Disabling and then re-enabling the module throws no error.. However, when trying to access admin/og_aggregator, the following error is thrown:

  • user warning: Table 'db209728775.og_aggregator_feed' doesn't exist query: SELECT f.*, COUNT(i.iid) AS items, n.title AS og_title FROM og_aggregator_feed f LEFT JOIN og_aggregator_item i ON f.fid = i.fid LEFT JOIN node n ON f.nid=n.nid GROUP BY f.fid, f.title, f.url, f.refresh, f.checked, f.link, f.description, f.etag, f.modified, f.image, f.block ORDER BY f.title in /homepages/19/d209187008/htdocs/intra_root/includes/database.mysql.inc on line 172.

Comments

zagorot’s picture

Your mysql version?

reubenavery’s picture

MySQL version 4.0.27

zagorot’s picture

I think you need recreate some tables which not existed in your database manually.

Taz’s picture

Status: Active » Closed (fixed)

Looks like the tables didn't create. Old version of MySQL was the case? I'm going to close this, re-open if it's still an issue and we can look at it freshly.