bugphpGroupWare - Bugs: bug #3374, Bad SQL and poor relation in...


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

bug #3374: Bad SQL and poor relation in /registration/inc/class.soreg.inc.php

Submitted by:  Kai Hofmann <powerstat>
Submitted on:  Tue Apr 29 09:06:03 2003  
Item Group: SVN trunk (dev code)Category: registration
Severity: 3 - NormalPriority: 3 - Low
Status: NonePrivacy: Public
Assigned to: Joseph Engo <jengo>Open/Closed: Open
Component Version: NoneOperating System: None
Reproducibility: Every TimePlanned Release:
Fixed Release: 

Wed Apr 21 08:10:46 2004, comment #2:

jengo's app. registration was not included in 16 afaik.

Dave Hall <skwashd>
Project Administrator
Wed Apr 21 07:42:29 2004, comment #1:

is this still valid?
Kai, did you provide a patch?

Dr. Christian Böttger <cboettger>
Tue Apr 29 09:06:03 2003, original submission:

The SQL statement I found here is wrong - because in SQL


is not what you want - correct it must be:

phpgw_addressbook.lid like '%$account_lid%'

last but not least referencing two tables in this way is absolutly evil! primary and foreign keys should always
be of the same type without a pattern matching!

$GLOBALS['phpgw']->db->query("select * from phpgw_accounts, phpgw_addressbook where account_lid='$account_lid' and phpgw_addressbook.lid='$account_lid'",__LINE__,__FILE__);

Kai Hofmann <powerstat>


No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


CC list is empty


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 Jul 15 23:00:00 2004skwashdPlanned ReleaseNone=>
Wed Apr 21 08:10:46 2004skwashdPriority5 - Normal=>3 - Low
  Assigned toskwashd=>jengo
Wed Apr 21 07:42:29 2004cboettgerAssigned toNone=>skwashd
Tue Apr 29 22:46:03 2003skwashdReproducibilityNone=>(Error - Not Found)
  SummaryBad SQL and relation usage=>

Back to the top

Powered by Savane 3.1-cleanup1