Re: [project-open-development] Why Project is not created

[Malte S. <mal...@co...>]

You need to manually configure postgres as ]project-open[ and OpenACS did not yet change old coding habits. This will happen with OpenACS 5.7 and ]project-open[ 4.x, I presume.

# Also edit the configuration to allow add_missing_from, default_with_oids and set the regex_flavor to extended

sudo emacs /etc/postgresql/8.4/main/postgresql.conf
sudo /etc/init.d/postgresql-8.4 reload

Best wishes
  Malte


Am 28.06.2011 um 12:36 schrieb Adarsh Sharma:

> Dear all,
> 
> I am sorry if i forgot to follow any guidelines to post in this mailing 
> list.
> 
> I configure Project Open in my CentOS  ( Linux ws-test 2.6.18-164.el5 #1 
> SMP Thu Sep 3 03:28:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux ) system. 
> Postgres Version is 8.4.2
> I installed the following rpm packages :
> 
> aolserver-4.5.0-1.po.rhel5.i386
> aolserver-tcl-8.4.14-1.po.rhel5.i386
> nscache-1.5-1.po.rhel5.i386
> nspostgres-4.0-2.po.rhel5.i386
> tDOM-0.8.1cvs-3.po.rhel5.i386
> nssha1-0.1-1.po.rhel5.i386
> 
> My Project Open is installed properly after following the below link :
> http://www.project-open.org/documentation/install_redhat
> 
> But don't know why when I create a new project or any user following 
> error occurs :
> 
> Database operation "0or1row" failed (exception ERROR, "ERROR:  missing FROM-clause entry for table "acs_object_id_seq" at character 8
> QUERY:  select acs_object_id_seq.nextval
>                    from dual
> CONTEXT:  PL/pgSQL function "acs_object__new" line 12 at SQL statement
> PL/pgSQL function "im_project__new" line 19 at assignment
> ")
> 
> ERROR:  missing FROM-clause entry for table "acs_object_id_seq" at character 8
> QUERY:  select acs_object_id_seq.nextval
>                    from dual
> CONTEXT:  PL/pgSQL function "acs_object__new" line 12 at SQL statement
> PL/pgSQL function "im_project__new" line 19 at assignment
> 
> SQL: 
> 
> select im_project__new (
>        NULL,         
>        'im_project',
>        '2011-06-28 11:46:56.729132+05',
>        '624',
>        '127.0.0.1',
>        NULL,
>        'Orkash Globe',
>        '2011_0001',
>        '2011_0001',
>        NULL,
>        '16622',
>        '99',
>        '76'
> );
> 
> 
> 
>    while executing
> "ns_pg_bind 0or1row nsdb0 {
> 
> select im_project__new (
>        NULL,         
>        'im_project',
>        :creation_date,
>        :creation_user,
>    ..."
>    ("uplevel" body line 1)
>    invoked from within
> "uplevel $ulevel [list ns_pg_bind $type $db $sql]"
>    ("postgresql" arm line 2)
>    invoked from within
> "switch $driverkey {
>                oracle {
>                    return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
>                }
>       ..."
>    invoked from within
> "db_exec 0or1row $db $full_statement_name $sql"
>    invoked from within
> "if {[regexp -nocase -- {^\s*select} $test_sql match]} {
>                ns_log Debug "PLPGSQL: bypassed anon function"
>                set selection [..."
>    ("uplevel" body line 6)
>    invoked from within
> "uplevel 1 $code_block "
>    invoked from within
> "db_with_handle -dbn $dbn db {
>            # plsql calls that are simple selects bypass the plpgsql 
>            # mechanism for creating anonymous fun..."
>    (procedure "db_exec_plsql" line 57)
>    invoked from within
> "db_exec_plsql create_new_project $sql"
>    (procedure "project::new" line 57)
>    invoked from within
> "project::new  -project_name	$project_name  -project_nr		$project_nr  -project_path	$project_path  -company_id		$company_id  -parent_id		$parent_id  -p..."
>    invoked from within
> "if {[form is_valid $form_id]} {
> 
>    set project_path $project_nr
> 
>    # -----------------------------------------------------------------
>    # Creat..."
>    ("uplevel" body line 532)
>    invoked from within
> "uplevel {
>    	  # /packages/intranet-core/projects/new.tcl
> #
> # Copyright (C) 1998-2004 various parties
> # The software is based on ArsDigita ACS 3.4
> #..."
>    (procedure "code::tcl::/web/projop/packages/intranet-core/www/projects/n..." 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..."
> 
> 
> 
> Please guide me how to solve the issue as I struggle to find the root 
> cause of it.
> 
> 
> Thanks
> 
> ------------------------------------------------------------------------------
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security 
> threats, fraudulent activity, and more. Splunk takes this data and makes 
> sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-d2d-c2
> _______________________________________________
> project-open-development mailing list
> pro...@li...
> https://lists.sourceforge.net/lists/listinfo/project-open-development

--

Malte Sussdorff
                                                      
cognovís GmbH
Schrödersweg 27
D-22453 Hamburg
Mobil:   +49 (0)151 / 230 33 826
Fon:      +49 (0)40 / 386 60 521
Fax:      +49 (0)40 / 386 60 523
www.cognovis.de 
                                                      
HRB Hamburg 28909
Geschäftsführer: Malte Sussdorff
 
Diese Nachricht ist streng vertraulich und enthält rechtlich geschützte Informationen. Sie ist nur für die Adressaten bestimmt. Falls Sie diese Mail fälschlicherweise erhalten haben, bitten wir Sie freundlicherweise uns umgehend telefonisch oder per E-Mail zu informieren und den Inhalt dieser Nachricht in Ihrem System zu löschen. Diese Nachricht ist anfällig für Datenkorruption, Abfangen von Daten, nicht autorisierte Änderungen, Verfälschung und Viren. Wir senden und empfangen E-Mails nur auf der Grundlage, dass wir nicht für solche Datenkorruption, Abfangen von Daten, nicht autorisierte Änderungen, Verfälschung und Viren und deren Konsequenzen haften.
 
This e-mail is confidential and may contain legally privileged information. It is intended only for the addressees. If you have received this e-mail in error, kindly notify us immediately by telephone or e-mail and delete the message from your system. E-Mail is susceptible to data corruption, interception, unauthorised amendment, tampering and viruses, and we only send and receive e-mails on the basis that we are not liable for any such corruption, interception, unauthorised amendment, tampering and viruses or any consequences thereof.