Error on executing sql query create user

[Sergio A.]

Hi.

I have followed all the installation instructions without errors until the "tinytm-create-user.sql" step. I tried to execute the query from PgAdminIII but it returned this:

    ERROR: relation "tinytm_groups" does not exist
    SQL state: 42P01

Then if I click on the new TinyTM tab which appears on the home page, it gives a Server error:

Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:

    can't read "project_status_id": no such variable
        while executing
    "template::element::set_value $form_id project_status_id $project_status_id"
        invoked from within
    "if {[im_permission $current_user_id "view_projects_all"]} { 
        ad_form -extend -name $form_id -form {
        {project_status_id:text(im_category_tree),op..."
        ("uplevel" body line 59)
        invoked from within
    "uplevel {
              # /packages/intranet-invoices/www/index.tcl
    #
    # Copyright (C) 2008 ]project-open[
    #
    # This program is free software. You can redistri..."
        (procedure "code::tcl::/web/projop/packages/intranet-tinytm/www/index" line 2)
        invoked from within
    "code::tcl::$__adp_stub"
        invoked from within
    "if { [file exists $__adp_stub.tcl] } {

          # ensure that data source preparation procedure exists and is up-to-date
          adp_init tcl $__adp_stub
    ..."
        ("uplevel" body line 3)
        invoked from within
    "uplevel {

        if { [file exists $__adp_stub.tcl] } {

          # ensure that data source preparation procedure exists and is up-to-date
          adp_init t..."
        (procedure "adp_prepare" line 2)
        invoked from within
    "adp_prepare "
        (procedure "template::adp_parse" line 30)
        invoked from within
    "template::adp_parse [file root [ad_conn file]] {}"
        (procedure "adp_parse_ad_conn_file" line 5)
        invoked from within
    "$handler"
        ("uplevel" body line 2)
        invoked from within
    "uplevel $code"
        invoked from within
    "ad_try {
                    $handler
                } ad_script_abort val {
                    # do nothing
                }"
        invoked from within
    "rp_serve_concrete_file [ad_conn file]"
        (procedure "rp_serve_abstract_file" line 60)
        invoked from within
    "rp_serve_abstract_file "$root/$path""
        ("uplevel" body line 2)
        invoked from within
    "uplevel $code"
        invoked from within
    "ad_try {
                rp_serve_abstract_file "$root/$path"
                set tcl_url2file([ad_conn url]) [ad_conn file]
                set tcl_url2path_info..."

---END---

By the way, the online demo server (www.tinytm.org/intranet-tinytm/) returns a Server error too...

Cheers
Sergio A.

[Frank Bergmann]

Hi Sergio,

You are trying to install TinyTM on top of ]project-open[, is that right?

In this case it's the easiest to use the ]project-open[ package manager at http://<your_server>/acs-admin/apm/ to install the "intranet-tinytm" module. Maybe this is missing in the installer, because it assumes a "standalone" installation. However, now you may have to revert to a backup or manually drop the "standalone" tables, because the ]project-open[ version defines these tables as "views" to the ]po[ structures.

In general, there are three files to install TinyTM in a PosgreSQL DB:

- tinytm-create-standalone.sql
  As the filename says: "standalone". Use this one if no ]po[ is available.
  This file defines for example "tinytm_users" as a table.

Or:

- tinytm-create-projectopen.sql
  This contains for example "tinytm_users" as a SQL "view" to the ]po[ users table.

Then you have to run the next script to create the main part of TinyTM which is identical between the two versions:

- tinytm-create-procedures.sql

Finally, there are some demodata from the EURAMIS TM, just for testing out stuff. Executing this script via "psql -f tinytm-create-demodata.sql" will produce some error messages, which you can ignore.

Cheers!
Frank