address@hidden: Re: [Phpgroupware-users] A couple of questions]

[Marco Gaiarin]

...i've not received ad answer to this message, so for now i've logged
another ``postgres upgrading from .15 to .16'' bug on savannah:

        https://savannah.gnu.org/bugs/index.php?func=detailitem&item_id=9143

please, please: say me something! I'm stuck with .14 on a site:

        http://www.ac.concordia-pordenone.it/

i cannot upgrade because the phpwebhosting/filemanager and sitemanager
bug, and this site grows, so my situation got every day worst!!!

----- Forwarded message from Marco Gaiarin <address@hidden> -----
From: Marco Gaiarin <address@hidden>
Date: Mon, 24 May 2004 14:36:08 +0200
To: address@hidden
Subject: Re: [Phpgroupware-users] A couple of questions
Organization: La Nostra Famiglia - Polo FVG

Mandi! Bart Bailey
  In chel di` si favelave...

> I know this may be a little late, but this past week I completed an upgrade
> from phpgroupware-0.9.14.006 to phpgroupware-0.9.16.001.  I had several failed
> attempts( Redhat 9 and Postgresql 7.3.4-3), however, after deleting all of the
> data from the phpgw_access_log (just because it took so long to process the
> table) and the phpgw_vfs tables, the upgrade went with out any further
> problems.

Ok, i was also stuck on phpgw_vfs error, i've tried and i confirm that
cleaning up phpgw_vfs tables suffices.

Please, the related bug:

        https://savannah.gnu.org/bugs/?func=detailitem&item_id=7743

after 2 month have not been touched, there's no assegnee at all...
Someone can explain this? Postgres is not the preferred database?
There's a preferred database? Someone hate Postgres?! ;-)


In any case i've tried to complete the switch.


I've maked a perl script (an hack, not a script ;) that eat up a .14
ldif file and return a .16 ldif file, if someone have to move from a
.14 to a .16 with account on ldap backend, this can help.
Attached.


I've found some more trouble: sitemanager stop working, if i try to add
some pages or contents, on any type, in anywhere (global or local) i
got:

  Database error: Invalid SQL: INSERT INTO phpgw_sitemgr_blocks 
(area,module_id,page_id,cat_id,sort_order,viewable) VALUES ('left',13,29,3,0,0)
  PostgreSQL Error: 1 (ERROR: Cannot insert a duplicate key into unique index 
phpgw_sitemgr_blocks_pkey )
  File: /usr/local/share/phpgroupware/sitemgr/inc/class.Content_SO.inc.php 
Line: 27
  Session halted.

my table are:

phpgroupwaresv=# select * from phpgw_sitemgr_blocks;
 block_id |  area  | cat_id | page_id | module_id | sort_order | viewable
----------+--------+--------+---------+-----------+------------+----------
        1 | CENTER |      3 |      29 |         3 |          0 | 0
        2 | CENTER |      4 |       2 |         3 |          0 | 0
        3 | CENTER |      5 |      16 |         3 |          0 | 0
        4 | CENTER |      3 |      12 |         3 |          0 | 0
        5 | CENTER |      3 |      14 |         3 |          0 | 0
        6 | CENTER |     15 |      28 |         3 |          0 | 0
        7 | CENTER |     14 |      19 |         3 |          0 | 0
        8 | CENTER |      6 |       4 |         3 |          0 | 0
        9 | CENTER |      6 |      17 |         3 |          0 | 0
       10 | CENTER |      6 |       5 |         3 |          0 | 0
       11 | CENTER |      4 |       3 |         3 |          0 | 0
       12 | CENTER |      7 |      21 |         3 |          0 | 0
       13 | CENTER |      5 |      13 |         3 |          0 | 0
       14 | CENTER |      5 |       6 |         3 |          0 | 0
       15 | CENTER |      3 |      24 |         3 |          0 | 0
       16 | CENTER |      7 |       9 |         3 |          0 | 0
       17 | CENTER |      7 |       8 |         3 |          0 | 0
       18 | CENTER |      7 |      10 |         3 |          0 | 0
       19 | CENTER |      5 |      15 |         3 |          0 | 0
       20 | CENTER |      7 |      11 |         3 |          0 | 0
       21 | CENTER |      3 |      20 |         3 |          0 | 0
       22 | CENTER |     15 |      25 |         3 |          0 | 0
       23 | CENTER |     15 |      22 |         3 |          0 | 0
       24 | CENTER |      5 |       7 |         3 |          0 | 0
       25 | CENTER |      3 |      26 |         3 |          0 | 0
       26 | CENTER |     15 |      27 |         3 |          0 | 0
(26 rows)

and seems that tables are ported correctly (table like
phpgw_sitemgr_content_lang are full with the content of the old -14
sitemanager pages) but the sitemanager site are empty, and the
sitemanager module report all the pages but no content.


Please, do something...

-- 
dott. Marco Gaiarin                                 GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  gaio(at)sv.lnf.it             tel +39-0434-842711    fax +39-0434-842797

 I brevetti software renderanno schiavo tutto il software, anche il software
  libero, ma le conseguenze potrebbero essere peggiori: tutta la società
           potrebbe ritrovarsi schiava del sistema brevettuale.

      http://www.fsfeurope.org/projects/swpat/letter-20040510.it.html


_______________________________________________
Phpgroupware-users mailing list
address@hidden
http://mail.gnu.org/mailman/listinfo/phpgroupware-users


----- End forwarded message -----

-- 
dott. Marco Gaiarin                                 GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  gaio(at)sv.lnf.it             tel +39-0434-842711    fax +39-0434-842797

    ... votantoniovotantoniovotantoniovotantoniovotantoniovotantonio ...
             resistenza arcobaleno contro la politica grigia

                    http://www.peacelink.it/votantonio