Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: vsebir on July 04, 2009, 02:05:17 PM

Title: upload avatar error
Post by: vsebir on July 04, 2009, 02:05:17 PM
hy. i have a small problem with my smf forum. in the profile page i ca not upload avatars.
Title: Re: upload avatar error
Post by: Arantor on July 04, 2009, 02:52:06 PM
What happens? Do you get an error or something?
Title: Re: upload avatar error
Post by: vsebir on July 05, 2009, 04:12:17 AM
Its not showing any errors, its not uploading the file. The athachments in topics works.
Title: Re: upload avatar error
Post by: Norv on July 05, 2009, 05:04:13 AM
Can you please check the forum error log also, if you didn't already?
Admin > forum error log.

Is uploading avatars enabled from admin control panel,  avatars settings?
Title: Re: upload avatar error
Post by: vsebir on July 05, 2009, 07:15:23 AM
     Apply Filter: Only show the errors of this type  Type of error: Critical
Apply Filter: Only show the error messages of this URL http://vs-r.com/forum/index.php?action=profile;area=forumprofile;save
Apply Filter: Only show the errors with the same message
The database value you're trying to insert does not exist: file_hash
Function: profileSaveAvatarData
Apply Filter: Only show the errors from this file
File: /home/vsrcom/public_html/forum/Sources/Profile-Modify.php
Line: 2589

this is the error. if it helps i can give you the error log file
Title: Re: upload avatar error
Post by: Arantor on July 05, 2009, 07:51:11 AM
Grab the 2.0RC1-1 update file, extract updateDatabase.php out of it, upload that to the same place as Settings.php, then browse to it - e.g. if your forum is in mysite.com/forum, browse to mysite.com/forum/updateDatabase.php.

The problem is that it is missing the column that should have been applied in the 2.0RC1-1 update.
Title: Re: upload avatar error
Post by: vsebir on July 05, 2009, 01:03:26 PM
I dont find updateDatabase.php . i foun this files
upgrade_1-0.sql
upgrade_1-1.sql
upgrade_2-0_mysql.sql
upgrade_2-0_postgresql.sql
upgrade_2-0_sqlite.sql





Title: Re: upload avatar error
Post by: Arantor on July 05, 2009, 01:32:45 PM
There are more files in there than that in the 1.1.9/2.0 patch. Which file did you download exactly?
Title: Re: upload avatar error
Post by: Norv on July 05, 2009, 11:00:28 PM
Strange, I cannot find the file updateDatabase.php in either smf_2-0-rc1-1_update.zip or smf_2-0-rc1-1_upgrade.zip (both downloaded a few weeks ago), I would have expected it to be there though.
I wonder if all packages really contain it, and I am not seeing it given the early coffee.

Please, use the attached file.
Title: Re: upload avatar error
Post by: vsebir on July 06, 2009, 09:33:40 AM
Yesterday i have downloaded the both smf  2.0 RC1-1 upgrade archives, and i didn't find the update.database file
Title: Re: upload avatar error
Post by: vsebir on July 06, 2009, 09:54:13 AM
 :D now its working, but it shows avatars oversized, very  very big, from where i can change that?
Title: Re: upload avatar error
Post by: Norv on July 06, 2009, 11:10:08 AM
Check out the options at Admin > Forum > Attachments and avatars > Avatar settings
Title: Re: upload avatar error
Post by: vsebir on July 06, 2009, 11:22:13 AM
I have changed the width and the height to 72 but no result
Title: Re: upload avatar error
Post by: Norv on July 06, 2009, 11:46:29 AM
Please take a look at all options there, and eventually make a screenshot with them, for us to see, in case it still doesn't work.
For example, Uploadable avatars > "Resize oversized large avatars" is checked?
Title: Re: upload avatar error
Post by: vsebir on July 06, 2009, 01:55:03 PM
It helps if i make an new update just to repair errors
Title: Re: upload avatar error
Post by: Norv on July 06, 2009, 02:37:17 PM
It might help.
If you don't have mods, you could take the large upgrade package and upload the files on your server, overwriting your files. There's no need to run the upgrade script, I think.

On another note, do you still have errors in the error log when you try to upload the avatar, and if so, what error(s)?
Title: Re: upload avatar error
Post by: vsebir on July 06, 2009, 03:38:17 PM
it helps if i give you my forum error log file?
Title: Re: upload avatar error
Post by: Norv on July 06, 2009, 03:52:43 PM
Please post it, yes.
Title: Re: upload avatar error
Post by: vsebir on July 06, 2009, 04:08:49 PM
you gone see many errors generated because i work to modify the wireless template
Title: Re: upload avatar error
Post by: Norv on July 06, 2009, 04:26:39 PM
Nothing in the log. :(
But is the full log? It ends on July 4th, so it seems that the error you posted yesterday does not exist in this file, are you sure there aren't a few more days with errors?
Title: Re: upload avatar error
Post by: vsebir on July 06, 2009, 05:05:53 PM
i upgraded the forum and now avatars work


Title: Re: upload avatar error
Post by: Norv on July 06, 2009, 05:43:38 PM
Good to hear!
I'll be marking this as solved on the basis of the last comment, please though feel free to reopen it if the problem re-occurs.
Title: Re: upload avatar error
Post by: vsebir on July 07, 2009, 01:19:59 AM
Thank you for help
Title: Re: upload avatar error
Post by: MarChelo on July 07, 2009, 06:34:19 AM
I have the same problem.

My log:

http://www.xxxxx.net/index.php?action=profile;area=forumprofile;save

The database value you're trying to insert does not exist: file_hash
Function: profileSaveAvatarData
Apply Filter: Only show the errors from this file
File: /home/xxxxx/www/Sources/Profile-Modify.php
Line: 2617

Ive uploaded the updateDatabase.php and run it, but nothing.
Title: Re: upload avatar error
Post by: Norv on July 07, 2009, 07:13:59 AM
Please consider opening another topic because as this is marked as solved, it is unlikely it will be read by the support team, thus reducing your chances to get appropriate help.
And if you do, please tell what version of SMF you are using, and how you got to it (upgrade from a previous one, or fresh install).