Forum OpenACS Q&A: load-data-model error

Posted by Terry G. Lorber 2nd on 06/01/00 01:55 AM

I've got one error in my datamodel.txt file:


psql:education.sql:1594: ERROR: parser: parse error at or near "eval"

Also, in starting the acceptance test...I don't have a


user_tables

table.

Thanks.

2: Response to load-data-model error (response to 1)

Posted by Don Baccus on 06/01/00 09:05 PM

1. I've just updated my copy of education, and got no errors. I've not upgraded my copy of PostgreSQL in a few weeks, can someone else out there with the release version of PG 7.0 verify whether or not this is really a bug?

2. user_tables is referenced in the schema_browser, which hasn't been ported over. I assume that's an Oracle table used to store information about user tables. We do want to port this module over...

Have you run into another reference to this table?

3: Response to load-data-model error (response to 1)

Posted by Roberto Mello on 06/01/00 09:15 PM

I loaded OpenACS fresh from start a couple days ago and it worked fine. I just grepped the output from load-data-model and there are no errors. How old is your release ? Check for differences with the CVS version of education.sql

OpenACS finals is due next week, so you can either fetch the CVS tree or wait till next week.

4: Response to load-data-model error (response to 1)

Posted by Luke Mitchell on 06/16/00 06:59 AM

I got exactly the same error as Terry.
Using Redhat 6.2, AOLserver 3 final, PG 7.0.2, openacs 3.2.2b3 and the latest (downloaded today) pg driver.

Before this I had problems loading the datamodel because the language setting in "postgres.sql" was a lower case 'c', while PG or the driver (not sure which) was expecting 'C'. This is just FYI

Also nuke user failed with "Database operation "dml" failed"

Cheers

5: Response to load-data-model error (response to 1)

Posted by Roberto Mello on 06/16/00 07:20 AM

Check your load-data-model.sql and make sure you are loading postgres.sql. nMake sure your postgres.sql has the libraries pointing to their right location on your HD.

I've loaded fresh OpenACS installs many times sine June 1 and had no problems with the education module.

On the nuke problem, tell your AOLserver (on your DB pools) "ns_param logsqlerrors on", restart it, try to nuke again and post the SQL error here so we can have a better clue. AFAIK it's working but we may have missed something.

OpenACS final is coming... somethings delayed us, but final release should come next week.

6: Response to load-data-model error (response to 1)

Posted by Marshall Trammell,III on 06/17/00 03:05 AM


eval problem in my datamodel.txt too

there is an sql statement where a table is aliased as eval
is that ok

also for me: [ad_parameter GroupsDirectory ug] returns nothing
my user group types table has all virtual_directories allowed as false.

Error:/tcl/user_group_defs.tcl:function ug_serve_group_pages:first
   element in url list is not [ad_parameter GroupsDirectory ug]

   
so when I try to log in at say http://mydomain.com i get a crash


see my "fails to register" post for more errors on startup
anybody have an idea?

7: Response to load-data-model error (response to 1)

Posted by Roberto Mello on 06/17/00 03:13 AM

It seems like it's a beta 3 error or something. I am not getting it because I am loading the latest-and-greatest OpenACS from the CVS.

You can fetch the latest OpenACS from the Sourceforge CVS server with:

cvs -d:pserver:anonymous@cvs.acs-pg.sourceforge.net:/cvsroot/acs-pg login

(Assuming you have CVS installed on your machine). You may need to do a "export CVS_RSH=ssh"

8: Response to load-data-model error (response to 1)

Posted by Luke Mitchell on 06/21/00 03:19 AM

I finally got around to downloading openacs from the cvs.
Which seems to have fixed the errors I was having before (loading datamodel and nuke user).

Thanks

Luke Mitchell

9: Response to load-data-model error (response to 1)

Posted by Terry G. Lorber 2nd on 06/21/00 09:55 PM

Same error occurs. I downloaded another psg driver and acs directory from this site.

I also tried the CVS from sourceforge...maybe I need to read the manpages on that one. I didn't have the postgres.sql file.