Avatar Problem

[Freddie Bingham]

Running this query should resolve the problem:

ALTER TABLE customavatar CHANGE filedata filedata MEDIUMBLOB NOT NULL

If not, please submit the support ticket.

[iardon]

Tried that but got this error.

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'entermyw_vb.customavatar' doesn't exist

Also, will this apply to the custom profile pics? Not sure if I have a problem with them being the file system but was just curios.

[Steve Machol]

If you are using a table prefix, add that prefix in front of 'customavatar'.

[iardon]

Does the custom avatar table also hold the profile pics?

[Steve Machol]

No, that would be the customprofilepic table.

[iardon]

That seemed to solve the problem... thanks Freddie. I probably won't understand your explanation but I'll ask anyhow... what does this (the query) change that makes it work now?

Running this query should resolve the problem:

ALTER TABLE customavatar CHANGE filedata filedata MEDIUMBLOB NOT NULL

If not, please submit the support ticket.

[Acido]

Running this query should resolve the problem:

ALTER TABLE customavatar CHANGE filedata filedata MEDIUMBLOB NOT NULL

If not, please submit the support ticket.

Worked for me. Thanx !

[martync]

Did not work for me, is there another fix?

Martyn

[Freddie Bingham]

Then you must have an unrelated problem. This issue was also resolved with v3.5.2 without a need to run the query.