[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [Bug #1103] SQL Error when updating a link
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [Bug #1103] SQL Error when updating a link |
Date: |
Fri, 30 Aug 2002 07:16:11 -0400 |
=================== 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