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

Posted by Randy O'Meara on

You haven't provided quite enough information to say for certain what the problem is. However, this sounds very much like you're executing a DB query, the Query Dispatcher is not able to locate your named query, and your program is failing when the "{*SQL*}" dummy argument is parsed. You'll see the same dummy argument appearing throughout the toolkit just for this purpose. It's supposed to flag an error very close to the missing query to get your dubugging started in the right general area.

Anyhow, assuming that this is the cause of your error, analysis of your server error file will show that the qd could not find the named query. Why? Probably due to a mistyped query name, misplaced or mis-named query file, or syntax.

The query ("notes_query" from chapter 8) lives in index.xql while your code lives in index.tcl and your display template resides in index.adp. All of these files must reside in the same directory, namely the "www" directory. Check all of these carefully to be certain that a typo hasn't "crept" in.