MEDIUMBLOB entry not updating...

[woolyg]

Hi all,

I've set up a table with column 'image1' (MEDIUMBLOB). I use PHPMyAdmin to manually enter the data onto the table.

 

I enter a 16KB image in the field 'image1' - which goes in fine, PHPMyAdmin displays this info:

fenway: image removed, requries password!

 

Then I go back in, and remove the image reference, which displays this info:

fenway: image removed, requries password!

 

Now, when I try to insert another image, or re-insert the same image, the process fails, and does not insert the image. I need to be able to update this image field manually upon request, but once I've removed the image, it doesn't allow me to update that field.

 

Anyone seen this before? Can you shed light on it? Any & all help much appreciated.

 

Woolyg.

[woolyg]

Server version: 4.1.22-standard-log.

phpMyAdmin - 2.10.0.2

MySQL client version: 4.1.21

 

- Woolyg

[fenway]

Please provide more query info.

[woolyg]

There is no SQL query here. I am manually updating the table, and browsing for the image to be entered as binary into the table.

 

When I wish to remove the image, I edit the table entry, and select no image, and click go - this removes the entry for the image.

 

Then, when I wish to update the table again with another image, I edit the table entry, and browse for an image, and click go. This SHOULD update the table with an image entry, but it does not- it simply returns the full table data, as if I entered the query

 

SELECT *
FROM table

[fenway]

There is no SQL query here. I am manually updating the table, and browsing for the image to be entered as binary into the table.

 

When I wish to remove the image, I edit the table entry, and select no image, and click go - this removes the entry for the image.

 

Then, when I wish to update the table again with another image, I edit the table entry, and browse for an image, and click go. This SHOULD update the table with an image entry, but it does not- it simply returns the full table data, as if I entered the query

 

SELECT *
FROM table

 

I have no idea what you're describing, sorry.

[woolyg]

Let me rephrase with a question -

 

When I want to remove a Medium Blob from a table, what should I do?

 

(Rephrasing with this will hopefully make it more clear)

Cheers for the help,

Woolyg

[fenway]

Set it to NULL or blank.

[woolyg]

...which makes the entry a [bLOB - NULL] one.

 

Now, when I try to insert an image into its place, or re-import the same image, the table won't accept the image. Bah!

 

 

 

For any entries in the table that say [bLOB - 0B], it is possible to insert images. But upon removing these images, the table disallows any further update in this regard.

 

 

Any ideas?

Cheers,

WoolyG

 

 

[fenway]

What error message is produced from the insert statement/