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

Submitted by:  Troy <troyr>
Submitted on:  Fri 13 Feb 2004 04:12:55 AM UTC  
 
Item Group: 0.9.16RC2Category: API - Admin
Severity: 3 - NormalPriority: 5 - Normal
Status: NonePrivacy: Public
Assigned to: NoneOpen/Closed: Open
Component Version: SVNOperating System: GNU/Linux - Debian
Reproducibility: Every TimePlanned 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>

 

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):

 

 

No Changes Have Been Made to This Item

Back to the top


Powered by Savane 3.1-cleanup1