Forum OpenACS Development: Re: Schedule proc
What happens when you run the proc in the developer shell?
Are you using a xql file? You seem to have a different query appearing in the error than the one you give in the proc definition:
select recent_ratings_id from recent_ratings
select * from recent_ratings
(As a matter of style, I prefer not to use "select *" in queries, but instead to always name the columns I want. You might get a few surprises with "select *")