bugphpGroupWare - Bugs: bug #1103, SQL Error when updating a link

 
 

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

bug #1103: SQL Error when updating a link

Submitted by:  Invalid User ID <Invalid User ID>
Submitted on:  Fri 30 Aug 2002 10:13:31 AM UTC  
 
Item Group: 0.9.14 releaseCategory: bookmarks
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: Mark A Peters <skeeter>Open/Closed: Closed
Component Version: NoneOperating System: None
Reproducibility: NonePlanned Release: None
Fixed Release: 

Mon 02 Sep 2002 12:37:07 AM UTC, comment #2:

Patch #497 applied to correct this problem.

Thanks,
Mark A Peters (Skeeter)

Mark A Peters <skeeter>
Project AdministratorIn charge of this item.
Fri 30 Aug 2002 11:16:09 AM UTC, comment #1:

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

Anonymous

 

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

 

 

Follow 4 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Mon 02 Sep 2002 12:37:07 AM UTCskeeterStatusNone=>(Error - Not Found)
  Assigned toNone=>NA
  Open/ClosedOpen=>(Error - Not Found)
  Closed on-=>-

Back to the top


Powered by Savane 3.1-cleanup1