Mysql question

[eismann]

Hello Users!

Problem is that in the database Table "smf_members" the filename is not set in "Avatar".
In the "smf_attachments" its in its table.

I tried

Code Select Expand

insert into `smf_members` set `avatar` = select `filename` from `smf_attachments` where ( "smf_attachments.ID_MEMBER" = "smf_members.ID_MEMBER" )

But i get an error from mysql...

Can someone help me..?

Greetings - Eismann

[Arantor]

The filename will only be set in the members table on certain occasions and will only be in the attachments table under other occasions.

It would be useful to know 1) what the error you're actually getting from SMF is and 2) what you're actually trying to do that involves bypassing the complexities of the avatar system.