Results 1 to 8 of 8
August 29th, 2005, 05:56 PM #1can 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
August 29th, 2005, 06:01 PM #2
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,
August 29th, 2005, 06:47 PM #3
for some reason I am still getting the error ????
August 29th, 2005, 07:05 PM #4
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.
August 29th, 2005, 07:42 PM #5
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,
August 29th, 2005, 08:03 PM #6
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.
August 29th, 2005, 08:07 PM #7
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.
August 29th, 2005, 08:17 PM #8