CodingForums.com - View Single Post - Can't write new data after adding new column in table

Jian0203 · 01-04-2013, 12:02 PM

Below is my original table in database which save customer login information.

Code:

CREATE TABLE IF NOT EXISTS `customerdetail` (
  `customer_id` varchar(20) NOT NULL,
  `customer_pass1` varchar(20) NOT NULL,
  `customer_pass2` varchar(20) NOT NULL,
  `customer_pass3` varchar(20) NOT NULL,
  `customer_pass4` varchar(20) NOT NULL,
  `customer_pass5` varchar(20) NOT NULL,
  `customer_email` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Before the new column that allow users to upload their display image is added, my system works fine with the existing table.

PS: I use 5 password fields due to requirement.

After i add in the line below the add the new column ( display picture function ) :

Code:

ALTER TABLE customerdetail ADD customer_display blob NOT NULL;

Then my system can't write any data into the table anymore even i upload an "empty" picture.

Can anyone please verify for me what i did wrongly ?

Thank you so much for helping. I appreciate a lot.

01-04-2013, 12:02 PM	PM User \| #1
Jian0203 New Coder Join Date: Mar 2012 Posts: 47 Thanks: 2 Thanked 0 Times in 0 Posts	Can't write new data after adding new column in table Below is my original table in database which save customer login information. Code: CREATE TABLE IF NOT EXISTS `customerdetail` ( `customer_id` varchar(20) NOT NULL, `customer_pass1` varchar(20) NOT NULL, `customer_pass2` varchar(20) NOT NULL, `customer_pass3` varchar(20) NOT NULL, `customer_pass4` varchar(20) NOT NULL, `customer_pass5` varchar(20) NOT NULL, `customer_email` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Before the new column that allow users to upload their display image is added, my system works fine with the existing table. PS: I use 5 password fields due to requirement. After i add in the line below the add the new column ( display picture function ) : Code: ALTER TABLE customerdetail ADD customer_display blob NOT NULL; Then my system can't write any data into the table anymore even i upload an "empty" picture. Can anyone please verify for me what i did wrongly ? Thank you so much for helping. I appreciate a lot.