phpGroupWare - Bugs: bug #20952, MySQL Error When Viewing User...
You are not allowed to post comments on this tracker with your current authentication level.
bug #20952: MySQL Error When Viewing User Profile in HR
Submitter: | D.C. Parris <dcparris> | ||
Submitted: | Sat 01 Sep 2007 04:32:18 PM UTC | ||
Category: | hr | Item Group: | 0.9.16.012 |
Severity: | 3 - Normal | Priority: | 5 - Normal |
Status: | None | Privacy: | Public |
Assigned to: | None | Open/Closed: | Open |
Component Version: | TGZ | Operating System: | GNU/Linux - Debian |
Reproducibility: | Every Time | Planned Release: | None |
Fixed Release: |
Wed 05 Sep 2007 11:49:51 AM UTC, comment #1: |
Caeies <Caeies> |
Sat 01 Sep 2007 04:32:18 PM UTC, original submission:
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.
|
D.C. Parris <dcparris> |
No files currently attached
Depends on the following items: None found
Items that depend on this one: None found
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.
Follows 1 latest change.
Date | Changed by | Updated Field | Previous Value | => | Replaced by |
---|---|---|---|---|---|
2007-09-05 | Caeies | Item Group | 0.9.16.011 | 0.9.16.012 |
Powered by Savane 3.13-cf05.
Corresponding source code
Hi D.C.
It looks like this is not related to mysql upgrade (at least directly) since the sql you give us is wrong (missing the last argument, "(contact_addr.contact_id = )" ) ... So, can you check that the db is "ok" (using your last backup for example), then we can look at modification between 0.9.16.011 and 0.012 to see if we got a problem here ...
Regards,
Caeies