• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
database Truncate error

#1
[eluser]reghan[/eluser]
Hello I am having issues with my database/codeigniter program


there error I am getting is:

Error Number: 1265

Data truncated for column 'Day2_LostRevenue' at row 1

its when I try and submit a blank into the database.

its set up as follows:

type: float(9,2)
null: yes
default: null

is this happening because its trying to insert null into a column thats a float?

I am just not sure what to do. I would like to be able to insert nothing an have it blank if that makes sense.

Thanks in advance


Messages In This Thread
database Truncate error - by El Forum - 07-06-2012, 11:17 AM
database Truncate error - by El Forum - 07-06-2012, 11:43 AM
database Truncate error - by El Forum - 07-06-2012, 11:59 AM
database Truncate error - by El Forum - 07-06-2012, 12:02 PM
database Truncate error - by El Forum - 07-06-2012, 12:08 PM
database Truncate error - by El Forum - 07-06-2012, 12:10 PM
database Truncate error - by El Forum - 07-06-2012, 03:47 PM
database Truncate error - by El Forum - 07-06-2012, 05:24 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.