The database value you're trying to insert does not exist: file_hash

[ndefreitas]

Hi

I get this error when i try upload a avatar?

The database value you're trying to insert does not exist: file_hash

how can i fix that? please!!!!

Thanks

nelson

[karlbenson]

did you upgrade from 2.0 rc1 or did you install a new 2.0-rc1 installation.

The solution is to get a copy of UpdateDatabase.php from inside the patch package.
Upload it to where smf is (same folder as Settings.php)
then point to it in your browser

It will add the extra column needed

[ndefreitas]

i install a new 2.0-rc1 fresh.

I do the updateDatabase.php but the problem continue...

i check in the attachments table and i have the columns created.

the logs show me that:

http://www.site.com/forum/index.php?action=profile;area=forumprofile;save [nofollow]
The database value you're trying to insert does not exist: file_hash
Function: downloadAvatar
File: /home2/site/public_html/site/forum/Sources/Subs-Graphics.php
Line: 142

What is the possible problems?

Thanks..

Nelson

[ndefreitas]

ready, for some reason i have the database or some file corrupt, i do a new fresh installation and export the structure and data from the other database to the new database and every working fine now. by the moment.

Thanks.

[Aleksi "Lex" Kilpinen]

Glad to hear you were able to sort this out.

I'll just mark the topic solved now, but if you still need assistance related to this,
feel free to mark the topic not solved and post back.