> What happens when you run the query manually? > > SELECT > amavis_rules.ID, amavis_rules.Name, > amavis_rules.Disabled, > policies.Name AS PolicyName > > FROM > amavis_rules, policies > > WHERE > policies.ID = amavis_rules.PolicyID > > ORDER BY > policies.Name
mysql> SELECT amavis_rules.ID, amavis_rules.Name, amavis_rules.Disabled, policies.Name AS PolicyName FROM amavis_rules, policies WHERE policies.ID = amavis_rules.PolicyID ORDER BY policies.Name; +----+------------------------------+----------+------------+ | ID | Name | Disabled | PolicyName | +----+------------------------------+----------+------------+ | 1 | Default system amavis policy | 0 | Default | +----+------------------------------+----------+------------+ 1 row in set (0.01 sec) I'm still getting the errors: [Sun Feb 14 03:35:36 2010] [error] [client x.x.x.x] PHP Fatal error: Call to a member function fetchObject() on a non-object in /usr/local/src/cluebringer-2.0.10/webui/policy-main.php on line 86, referer: http://72.51.44.162/policyd/policy-main.php Please suggest a fix. Help appreciated. _______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users
