Forum OpenACS Q&A: problem/question about doc (HEAD) - Development Tutorial

Collapse
1: problem/question about doc (HEAD) - Development Tutorial
Posted by Yves Goldberg on 11/09/03 05:41 PM
I'm trying to learn about oacs and follow the  "Development Tutorial" at https://openacs.org/doc/openacs-HEAD/tutorial-database.html

I get the following error:
======================
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  Relation "samplenote" does not exist

SQL:
    select note_id,
          title,
          body
      from samplenote
[MORE]
=======================

Shouldn't myfirstpackage-create.sql create the table samplenote? If not; where (and when)is this table created?

thanks for any help.

Yves.

Collapse
2: Re: problem/question about doc (HEAD) - Development Tutorial (response to 1)
Posted by Joel Aufrecht on 11/09/03 07:41 PM
This tutorial is being reworked to use the content repository, which surprisingly turned out to have a really good database API, such that the tutorial database create and drop scripts went from hundreds of lines to under ten each.  On the flip side, the cr API (and the bcms API that will get merged in Real Soon Now) doesn't seem to be very complete on the tcl side.  So that part of the tutorial isn't updated yet, and as a result the tutorial doesn't make much sense.  Sorry for leaving it that way - I should have put in a note while I left it broken for a day that's turned into about two weeks and counting until I can corner Lars and pick his brain.  Meanwhile, consider everything after the database part to be an exercise for the reader :)
Collapse
4: Re: problem/question about doc (HEAD) - Development Tutorial (response to 2)
Posted by Carl Robert Blesius on 11/09/03 08:33 PM
Thank you Joel.
Collapse
3: Re: problem/question about doc (HEAD) - Development Tutorial (response to 1)
Posted by Yves Goldberg on 11/09/03 08:36 PM
IC. I thought I was missing something here.

It is MI-3 to learn oacs :)

thanks joel.

Yves.