bugphpGroupWare - Bugs: bug #22733, Creating admin/demo accounts in...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #22733: Creating admin/demo accounts in setup fails with postgres 8.3

Submitted by:  Olivier Berger <olberger>
Submitted on:  Wed 26 Mar 2008 11:52:00 AM UTC  
 
Item Group: 0.9.16.012Category: API - phpGroupware API
Severity: 3 - NormalPriority: 7 - High
Status: FixedPrivacy: Public
Assigned to: Dave Hall <skwashd>Open/Closed: Closed
Component Version: DEBOperating System: GNU/Linux - Debian
Reproducibility: Every TimePlanned Release: 0.9.16.011+
Fixed Release: 0.9.16-svn

(Jump to the original submission Jump to the original submission)

Thu 27 Mar 2008 10:17:34 AM UTC, comment #6:

grrr I forgot you have to mark a ticket as closed when you mark it as fixed

Dave Hall <skwashd>
Project AdministratorIn charge of this item.
Thu 27 Mar 2008 10:16:20 AM UTC, comment #5:

This was applied in r18511 - thanks for the patch

I only did a quick visual review but it looked good to me. We don't officially suppport pg8.3 in 0.9.16, but we can offer best effort with it.

Dave Hall <skwashd>
Project AdministratorIn charge of this item.
Wed 26 Mar 2008 02:57:08 PM UTC, comment #4:

FYI, the proposed fix does not seem to hurt over mysql 5 either.

Olivier Berger <olberger>
Wed 26 Mar 2008 01:58:44 PM UTC, comment #3:

Caeies, you guessed right ;)

But it may be also in testing too (future stable)... Dunno, had never tested over postgresql.

Lookin forward to hearing from you (either for 0.9.18 or 0.9.16.012+)

Best regards,

Olivier Berger <olberger>
Wed 26 Mar 2008 01:53:09 PM UTC, comment #2:

Hi Olivier,

Thanks for the report.

I guess that pgsql 8.3 is in unstable :(. Applying the patch will be hard for us, since we are moving on the .18. Anyway, we will discuss this with skwashd and see what we can do (and test for it is the more hard parts of the job).

Regards,

Caeies

PS: the file is phpgwapi/inc/class.config.inc.php

Caeies <Caeies>
Project Administrator
Wed 26 Mar 2008 11:54:43 AM UTC, comment #1:

The attached patch seems to fix it for potsgresql

(file #15338)

Olivier Berger <olberger>
Wed 26 Mar 2008 11:52:00 AM UTC, original submission:

Forward of http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=472679 :
----------------------------
Trying to create an admin account and the 3 demo accounts with postgres 8.3, I get this error :

http://localhost/phpgroupware/setup/setup_demo.php

Database error: Invalid SQL: DELETE FROM phpgw_app_sessions WHERE sessionid = '0' AND loginid = 0 AND app = 'phpgwapi' AND location = 'config'
PostgreSQL Error: 1 (ERREUR: l'opérateur n'existe pas : character varying = integer LINE 1: ...gw_app_sessions WHERE sessionid = '0' AND loginid = 0 AND ap... ^ HINT: Aucun opérateur ne correspond au nom donné et aux types d'arguments. Vous devez ajouter des conversions explicites de type.)

File: /usr/share/phpgroupware/phpgwapi/inc/class.config.inc.php
Line: 68

Session halted.

Dunno if this is linked to this very version of postgresql or what.

Olivier Berger <olberger>

 

Attached Files
file #15338:  472679.patch added by olberger (412B - text/x-diff)

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -unavailable- added by skwashd (Posted a comment)
  • -unavailable- added by Caeies (Posted a comment)
  • -unavailable- added by olberger (Submitted the item)
  •  

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 6 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Thu 27 Mar 2008 10:17:34 AM UTCskwashdOpen/ClosedOpen=>Closed
    Thu 27 Mar 2008 10:16:20 AM UTCskwashdStatusNone=>Fixed
      Planned ReleaseNone=>0.9.16.011+
      Fixed Release=>0.9.16-svn
    Wed 26 Mar 2008 01:53:09 PM UTCCaeiesAssigned toNone=>skwashd
    Wed 26 Mar 2008 11:54:43 AM UTColbergerAttached File-=>Added 472679.patch, #15338

    Back to the top


    Powered by Savane 3.1-cleanup1