Forum OpenACS Q&A: Loading the data model incorrectly

I am having the exact same problem as Angel... do we need to re-populate the database model after correcting any problem we can find in the postgres.sql file? Which, BTW, I DID edit correctly... :)

I've got to do some digging now to find the source of this one.

Chari

Invalid return code from filter proc: Database opertaion "dml" failed (must be filter_ok, filter_return, or filter_break)

This was from the server.log file.

Chari

That fixed most of the problems... I had to recompile the postgres driver, and then reloaded the data model into the database. However, the index.tcl pages don't come up automatically when I go to the pageroot or the root of any directory. I've got .tcl, .html, .htm, and .shtml files listed as viable starting pages...

And, I couldn't login and create an account for myself still. I could, however, login as system and create myself as a user that way.

I'm at an Apache conference right now, so I don't have access to my intranet or the log files to tell you exactly what errors I'm getting.

Thanks,
Chari

I also have run into a few errors that seem like bugs.

Submitting user pic:  I choose the file but the submit fails.  The server.log says it is because of an ns_ora call.  DOH!

User login:  If I turn on the intranet module, then users can not login.  They get the password page, but it chokes on the pvt/home.tcl page.  With the intranet module off, it works fine.

Thanks Ben for ACS/pg. Thanks Roberto and Don for all above answers - I too now have ACS up and running locally. Painless, really.

If anyone's interested, here's the platform;

Thinkpad 760ED Pentium 133. Mandrake Linux 6.0 on a 1.4meg partition. Postgres 6.5.3 compiled from tarball (not RPM).

Haven't done much else other than a quick check of the modules.

I'll investigate these from the server logs, so this is not (yet) a bug report/ call for help. Some may be due not having any fully built-up users. Problems with ACS sourcing (ie error page delivered)
- bookmarks
- file storage
- intranet (as you already know)
- events
- stolen eqipment
- stolen equipment

I seem to be having a related problem.  Every time I start up the AOLserver, I see the following in the logs:

[17/Mar/2000:11:35:19][12535.1026][-sched-] Error: Ns_PgExec: result status: 7 message: ERROR:  ad_partner: Table does not exist.

[17/Mar/2000:11:35:19][12535.1026][-sched-] Error: nsd.tcl: Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
    while executing
"ns_db select $db "select distinct partner_cookie from ad_partner""
    invoked from within
"set sub_selection [ns_db select $db "select distinct partner_cookie from ad_partner"]..."
    invoked from within
"if { [catch {set db [ns_db gethandle subquery]} err_msg] } {
    ns_log Notice "ad-partner: Can't get db handle. Using list_of_cookies to register cookie ..."
    (procedure "ad_partner_initialize" line 7)
    invoked from within
"ad_partner_initialize"

which would seem to imply that the data model has been incorrectly loaded.  Note that I

1) have edited www/doc/sql/postgres.sql correctly for the rpm-based install of postgresql (v. 6.5.3) which I am using,

2) have downloaded and installed the latest driver from the ACS/PG site,

3) have destroyed the db and recreated it,

4) have redirected the stderr output of the load-data-model.sql load to a file to examine for errors and have found none,

5) have examined the file load-data-model.sql for the string "postgres65.sql" and have not found it, commented out or otherwise, although I did find the string "i postgres.sql" (which was uncommented), and

6) have made sure that I'm loading the data model as a postgresql superuser.

The system works to extent that I can add new users, become system and do certain administration functions, etc., but fails when (as a user) I try to access the Homepage Maintenance or Neighborhood functions, I end up with the message "Server Error :  The server encountered a configuration or operating system error while attempting to satisfy your request" and more server log entries about missing a missing users_homepages tables and failing operations due to queries not returning rows.  Again, since I can write certain information to the database (e.g., email addresses and names of users), I would guess that the data model is the problem, rather than the PostgreSQL itself.

Any suggestions?

Dan Katz

Loading the data model incompletely was the source of a number of those dml errors, I found. In most cases I just loaded the relevant *.sql files into Postgres and steamed ahead.
I loaded
- homepages.sql
- postgres-pgtcl.sql
- partner.sql
manually.

There may be more. At present, I am assuming its a local problem - slow machine/ loose nut on keyboard, but will find some time to look more closely at the load-data-models.sql.