Forum OpenACS Q&A: Re: ERROR: parser: parse error at or near "*"

Collapse
Posted by Jarkko Laine on
NM,

The error is due that your query doesn't return any rows (probably because the table is still empty) and the db_* proc you're using requires that at least one row is returned. It's a common error when you accidentally use db_1row instead of db_0or1row. Could you post the part of your code that bombs here?

Collapse
Posted by Robert Locke on
Actually, the error appears to be that the "samplenotes" table does not exist:

    ERROR:  Relation "samplenote" does not exist

I haven't seen the tutorial, but I imagine it should have been created either manually or when you installed the package.

Collapse
Posted by Robert Locke on
Ok, I looked at the documentation and at the very end of:

    https://openacs.org/doc/openacs-4-6-3/tutorial-database.html

You are told:

    "Once both scripts are working without errors, run the create script one last time and proceed."

Did you run the create script one last time?  Was there an error?  That should have created the "samplenote" table.

Good luck...

Oops, maybe I should start drinking coffee, too :) Or learn to read.