Go Back   CodingForums.com > :: Server side development > MySQL

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 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
Jian0203 is an unknown quantity at this point
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.
Jian0203 is offline   Reply With Quote
Old 01-04-2013, 01:57 PM   PM User | #2
BubikolRamios
Senior Coder

 
Join Date: Dec 2005
Location: Slovenia
Posts: 1,876
Thanks: 114
Thanked 76 Times in 76 Posts
BubikolRamios is on a distinguished road
You have to capture error message somewhere Higly rare situation would be : no error message.
__________________
Found a flower or bug and don't know what it is ?
agrozoo.net galery
if you don't spot search button at once, there is search form:
agrozoo.net galery search
BubikolRamios is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 06:39 AM.


Advertisement
Log in to turn off these ads.