[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: Mark A Peters <address@hidden>
Date: 2002-Sep-01 20:37 (EST5EDT)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Fixed
         Assigned to | None                      | skeeter
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
Patch #497 applied to correct this problem.

Thanks,
Mark A Peters (Skeeter)



=================== 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:  Fixed                      Assigned to:  skeeter                   
Status:  Closed                         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-Sep-01 20:37             By: skeeter
Patch #497 applied to correct this problem.

Thanks,
Mark A Peters (Skeeter)

-------------------------------------------------------
Date: 2002-Aug-30 08:28             By: lance
follow a patch which fixe the problem with postgres.
not tested with mysql but should work
I juste replace integer field that can be empty by NULL instead of ''

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



File Attachments
****************

-------------------------------------------------------
Date: 2002-Aug-30 08:28  Name: bookmark_update.diff  Size: 1KB   By: lance
patch working with postgresql
http://savannah.gnu.org/bugs/download.php?group_id=509&bug_id=1103&bug_file_id=78


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