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

Collapse
4: Re: ERROR: parser: parse error at or near "*" (response to 1)
Posted by Jarkko Laine on 07/22/03 08:17 AM
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
6: Re: ERROR: parser: parse error at or near "*" (response to 4)
Posted by Robert Locke on 07/22/03 08:49 AM
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
7: Re: ERROR: parser: parse error at or near "*" (response to 4)
Posted by Robert Locke on 07/22/03 08:57 AM
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...

Collapse
8: Re: ERROR: parser: parse error at or near "*" (response to 6)
Posted by Jarkko Laine on 07/22/03 09:12 AM
Oops, maybe I should start drinking coffee, too :) Or learn to read.