[Phpgroupware-tracker] [Bug #1103] SQL Error when updating a link

[nobody]

=================== BUG #1103: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1103&group_id=509

Changes by: Anonymous user        Date: 2002-Aug-30 07:16

------------------ Additional Follow-up Comments ----------------------------
The problem is empty field.
'' is an empty string and not an integer.
you can't update an integer field with ''
there are 2 solution, removing empty field in SQL when update or replace '' 
with NULL for integer (int, bigint...)




=================== BUG #1103: FULL BUG SNAPSHOT ===================


Submitted by: lance                     Project: phpGroupWare                   
Submitted on: 2002-Aug-30 06:13
Category:  bookmarks                    Bug Group:  0.9.14 release              
Severity:  5 - Major                    Priority:  Normal                       
Resolution:  None                       Assigned to:  None                      
Status:  Open                           Platform Version:  None                 
Reproducibility:  None                  

Summary:  SQL Error when updating a link

Original Submission:  Database error: Invalid SQL: update phpgw_bookmarks set 
bm_url='http://www.netscape.fr/redir.pl?dest=tele', bm_name='Télévision', 
bm_desc='', bm_keywords='', bm_category='', bm_subcategory='', 
bm_rating='0',bm_info=',,1030702053', bm_access='public' where bm_id='12'
PostgreSQL Error: 1 (ERROR: Bad int8 external representation "" )

Follow-up Comments
*******************

-------------------------------------------------------
Date: 2002-Aug-30 07:16             By: None
The problem is empty field.
'' is an empty string and not an integer.
you can't update an integer field with ''
there are 2 solution, removing empty field in SQL when update or replace '' 
with NULL for integer (int, bigint...)





No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1103&group_id=509