bugphpGroupWare - Bugs: bug #7702, Postgres Error

 
 

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

bug #7702: Postgres Error

Submitter:  Troy <troyr>
Submitted:  Fri 13 Feb 2004 04:12:55 AM UTC
   
 
Category:  API - Admin Item Group:  0.9.16RC2
Severity:  3 - Normal Priority:  5 - Normal
Status:  None Privacy:  Public
Assigned to:  None Open/Closed:  Open
Component Version:  SVN Operating System:  GNU/Linux - Debian
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Fri 13 Feb 2004 04:12:55 AM UTC, original submission:  

I Get the following error msg when trying to access 'Sync Account Contact'

Im guessing the account_lastname field needs to be escaped?

Error
------------------

Database error: Invalid SQL: UPDATE phpgw_accounts SET account_firstname='Pat', account_lastname='O'Dwyer', account_status='A', account_expires=-1, account_lid='podwyer', person_id=175 WHERE account_id=62
PostgreSQL Error: 1 (ERROR: syntax error at or near "Dwyer" at character 72 )

File: /home/phpgwadmin/public_html/phpgroupware/phpgwapi/inc/class.accounts_sql.inc.php
Line: 102

Session halted.

Troy <troyr>

 

(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

 

CC list is empty

 

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.14-7003.
Corresponding source code