Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Mar 2012
    Posts
    52
    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.

  • #2
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,959
    Thanks
    120
    Thanked 76 Times in 76 Posts
    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


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •