bugphpGroupWare - Bugs: bug #20952, MySQL Error When Viewing User...

 
 

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

bug #20952: MySQL Error When Viewing User Profile in HR

Submitted by:  D.C. Parris <dcparris>
Submitted on:  Sat 01 Sep 2007 04:32:18 PM UTC  
 
Item Group: 0.9.16.012Category: hr
Severity: 3 - NormalPriority: 5 - Normal
Status: NonePrivacy: Public
Assigned to: NoneOpen/Closed: Open
Component Version: TGZOperating System: GNU/Linux - Debian
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Wed 05 Sep 2007 11:49:51 AM UTC, comment #1:

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

Caeies <Caeies>
Project Administrator
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.

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.

D.C. Parris <dcparris>

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -unavailable- added by Caeies (Posted a comment)
  • -unavailable- added by dcparris (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):

     

     

    Follows 1 latest change.

    Date Changed By Updated Field Previous Value => Replaced By
    Wed 05 Sep 2007 11:49:51 AM UTCCaeiesItem Group0.9.16.011=>0.9.16.012

    Back to the top


    Powered by Savane 3.1-cleanup