[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [bug #20952] MySQL Error When Viewing User Profil
From: |
D.C. Parris |
Subject: |
[Phpgroupware-tracker] [bug #20952] MySQL Error When Viewing User Profile in HR |
Date: |
Sat, 01 Sep 2007 16:32:19 +0000 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.4) Gecko/20070508 Iceweasel/2.0.0.4 (Debian-2.0.0.4-0etch1) |
URL:
<http://savannah.gnu.org/bugs/?20952>
Summary: MySQL Error When Viewing User Profile in HR
Project: phpGroupWare
Submitted by: dcparris
Submitted on: Saturday 09/01/2007 at 12:32
Item Group: 0.9.16.011
Category: hr
Severity: 3 - Normal
Priority: 5 - Normal
Status: None
Privacy: Public
Assigned to: None
Open/Closed: Open
Discussion Lock: Any
Component Version: TGZ
Operating System: GNU/Linux - Debian
Reproducibility: Every Time
Planned Release: None
Fixed Release:
_______________________________________________________
Details:
I am using phpgw 0.9.16.012 on a shared hosting account. The OS is Debian
GNU/Linux. The provider upgraded MySQL from 4.1.x to 5.x (not sure which
minor version) not long before I installed phpgw. I am using PHP 4.1.
I accessed the HR module, selected a user, and then attempted to view that
user's profile . Here is the MySQL error I got as a result:
Database error: Invalid SQL: SELECT contact_addr.contact_id AS
addr_contact_id, contact_addr.contact_addr_id AS key_addr_id,
contact_addr.addr_type_id AS addr_type, contact_addr.add1 AS addr_add1,
contact_addr.add2 AS addr_add2, contact_addr.city AS addr_city,
contact_addr.state AS addr_state, contact_addr.postal_code AS
addr_postal_code, contact_addr.country AS addr_country, contact_addr.preferred
AS addr_preferred, contact_addr_type.description AS addr_description FROM
phpgw_contact_addr AS contact_addr LEFT JOIN phpgw_contact_addr_type AS
contact_addr_type ON contact_addr_type.addr_type_id =
contact_addr.addr_type_id WHERE (( (contact_addr.preferred = 'Y' OR
contact_addr.preferred IS NULL) AND (contact_addr.contact_id = )))
MySQL Error: 1064 (You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use near
')))' at line 1)
File: /[myhomedirpath]/htdocs/phpgwapi/inc/class.contacts_sql.inc.php
Line: 1334
Session halted.
_______________________________________________________
Reply to this item at:
<http://savannah.gnu.org/bugs/?20952>
_______________________________________________
Message sent via/by Savannah
http://savannah.gnu.org/
- [Phpgroupware-tracker] [bug #20952] MySQL Error When Viewing User Profile in HR,
D.C. Parris <=