Results 1 to 8 of 8
  1. #1
    pph Expert! Gordon's Avatar
    Join Date
    January 18th, 2005
    Location
    Edmonton Canada
    Posts
    5,781
    can anyone help me with this please?
    In my import.php file I am trying to replace this line :-
    description text NOT NULL, with
    description blob NOT NULL,
    and I keep getting this error below, does anybody know what I am doing wrong please? When I use the description text NOT NULL, everything loads as it should.


    I cannot create the xxxx_temp tables: Can't create table './xxxx_xxx/xxxx_temp.frm' (errno: 140)

    Thanks in advance
    One day parasites and their ilk will be made illegal, I bet a few Lawyers will be pissed off when the day comes.
    Mr. Spitzer is fetching it nearer

    YouTrek

  2. #2
    ABW Ambassador Greg Rice's Avatar
    Join Date
    January 18th, 2005
    Location
    Ohio
    Posts
    4,889
    So it works with description text NOT NULL but won't with description blob NOT NULL? Here's two different lines, cut and pasted here from my actual import script, and they work ok. I'm using PHP/mySQL

    ShortDesc blob NOT NULL,
    LongDesc longblob NOT NULL,
    Greg Rice Affiliate Program Management
    www.gocmc.com info(AT)gocmc.com | 330-259-1223

    Join us! - MiNeeds.com | DiscountCandleShop/CheeseSupply | Feng Shui Plaza

  3. #3
    pph Expert! Gordon's Avatar
    Join Date
    January 18th, 2005
    Location
    Edmonton Canada
    Posts
    5,781
    for some reason I am still getting the error ????
    One day parasites and their ilk will be made illegal, I bet a few Lawyers will be pissed off when the day comes.
    Mr. Spitzer is fetching it nearer

    YouTrek

  4. #4
    ABW Ambassador Greg Rice's Avatar
    Join Date
    January 18th, 2005
    Location
    Ohio
    Posts
    4,889
    Weird, mine works with blob and with text and I'm running mySQL 4.0.22. So text is working ok and blob is not? What field is set to Primary Key? If you want I can PM you with my import code if that would help.
    Greg Rice Affiliate Program Management
    www.gocmc.com info(AT)gocmc.com | 330-259-1223

    Join us! - MiNeeds.com | DiscountCandleShop/CheeseSupply | Feng Shui Plaza

  5. #5
    pph Expert! Gordon's Avatar
    Join Date
    January 18th, 2005
    Location
    Edmonton Canada
    Posts
    5,781
    I have a field called "ID" set to increment

    I have no idea why it will work with text NOT NULL, yet will not work with blob NOT NULL,
    One day parasites and their ilk will be made illegal, I bet a few Lawyers will be pissed off when the day comes.
    Mr. Spitzer is fetching it nearer

    YouTrek

  6. #6
    ABW Ambassador Greg Rice's Avatar
    Join Date
    January 18th, 2005
    Location
    Ohio
    Posts
    4,889
    Do you have the text column set to index by chance? You can index text but shouldn't be able to index blob. Sorry, I'm not an expert with this but only learn "what I need to know" when I want to do something.
    Greg Rice Affiliate Program Management
    www.gocmc.com info(AT)gocmc.com | 330-259-1223

    Join us! - MiNeeds.com | DiscountCandleShop/CheeseSupply | Feng Shui Plaza

  7. #7
    pph Expert! Gordon's Avatar
    Join Date
    January 18th, 2005
    Location
    Edmonton Canada
    Posts
    5,781
    I figured it Greg

    I had this line in my script
    FULLTEXT fulltxtsearch(productname, longdescription)
    I removed the longdescription bit and it worked. I don't know why but I'm happy it works LOL

    Thanks very much for your help.
    One day parasites and their ilk will be made illegal, I bet a few Lawyers will be pissed off when the day comes.
    Mr. Spitzer is fetching it nearer

    YouTrek

  8. #8
    ABW Ambassador Greg Rice's Avatar
    Join Date
    January 18th, 2005
    Location
    Ohio
    Posts
    4,889
    Ahh, ok, so it was trying to index blob, which it won't do, so it errored out. Glad you got it working.
    Greg Rice Affiliate Program Management
    www.gocmc.com info(AT)gocmc.com | 330-259-1223

    Join us! - MiNeeds.com | DiscountCandleShop/CheeseSupply | Feng Shui Plaza

  9. Newsletter Signup

+ Reply to Thread

Posting Permissions

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