bugphpGroupWare - Bugs: bug #21660, Missing "comma" in query


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

bug #21660: Missing "comma" in query

Submitter:  Sigurd Nes <sigurdne>
Submitted:  Wed 28 Nov 2007 12:11:33 PM UTC
Category:  None Item Group:  SVN trunk (dev code)
Severity:  3 - Normal Priority:  5 - Normal
Status:  None Privacy:  Public
Assigned to:  maat Open/Closed:  Open
Component Version:  SVN Operating System:  None
Reproducibility:  None Planned Release:  None
Fixed Release: 

Wed 13 Aug 2008 04:10:03 PM UTC, comment #4: 

It would be:

$sql="SELECT ged_history.*, ged_elements.name, ged_elements.reference, ged_elements.description as descriptione, ";
$sql.="ged_versions.major, ged_versions.minor, ged_versions.description as descriptionv ";



Sigurd Nes <sigurdne>
Group Member
Wed 13 Aug 2008 12:53:39 PM UTC, comment #3: 

what would be the correct pgsql way for this ?

Pascal Vilarem <maat>
Group Member
Wed 13 Aug 2008 12:49:46 PM UTC, comment #2: 

Ah that explains it.
I'm afraid that won't work on postgresql - one has to spell it out.



Sigurd Nes <sigurdne>
Group Member
Wed 13 Aug 2008 09:31:44 AM UTC, comment #1: 

ged_versions.status finalstatus means "as finalstatus" : comma is not missing here.

What database are you using please ?

Pascal Vilarem <maat>
Group Member
Wed 28 Nov 2007 12:11:33 PM UTC, original submission:  

Tiny error:

[file] => /path/to/phpgroupware/ged/inc/class.ged_dm.inc.php
[line] => 2824

ERROR:  syntax error at or near "finalstatus"
LINE 1: SELECT ged_history.*, ged_versions.status finalstatus, ged_v...



Sigurd Nes <sigurdne>
Group Member


(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


Carbon-Copy List
  • -email is unavailable- added by maat (Posted a comment)
  • -email is unavailable- added by sigurdne (Submitted the item)

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.


    No changes have been made to this item

    Back to the top

    Powered by Savane 3.13-4b48.
    Corresponding source code