Help! Users cannot edit their profile!!! Help please

[macgos]

Support Request Template
What version of phpBB are you using? phpBB 3.0.3
What is your board's URL? http://forum.rcsoaring.co.nz/phpbb/
How did you install your board? Using a Tool
Is your board a fresh install or a conversion? a simple upgrade from 3.0.2
Do you have any MODs installed? No
Please describe your problem. When a user is trying to access their profile, they are getting this message:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'f.field_show_profile' in 'where clause' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Also, when I try to create a new profile field in the ACP for my registration page, I get this error:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'field_show_profile' in 'field list' [1054]

SQL

UPDATE phpbb_profile_fields SET field_length = '9', field_minlen = '9', field_maxlen = '9', field_novalue = '0', field_default_value = '2', field_validation = '', field_required = 1, field_show_on_reg = 0, field_hide = 0, field_show_profile = 0, field_no_view = 0 WHERE field_id = 2

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/acp/acp_profile.php
LINE: 1064
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_profile.php
LINE: 693
CALL: acp_profile->save_profile_field()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_profile->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

Why is this. I have recently upgraded from 3.0.2 to 3.0.3. Never had either of these errors before....please help. Thanks
What styles do you currently have installed? prosilver
What language(s) is your board currently using? british english
Which database type/version are you using? MySQL 4
Generated by SRT Generator ($Rev: 2817 $)

[ric323]

How exactly did you do the upgrade?
One step has been skipped, updating the daabase schema.
upload the install foldr again, and browse to your_board_address/install/database_update.php
then delete the install folder again.

[macgos]

I upgraded thru Godaddy - basically I clicked a button and they upgraded it from their hosting site for me. When I did 3.02 to 3.03 like this - it was fine.

I'm not sure how to do what you suggested. I have the option of 'rolling' back to the previous version thru Godaddy. Will this fix this problem? If not, how would I manually upload the file you suggested?

Thanks for your time on this.

[ric323]

Step 1. Stop using any tools supplied by your web host, they nearly always skip steps.

We can't support boards which are not installed using files downloaded from here. They make changes to the files which we know nothing about.
That is why rule4a says we don't support downloads from elsewhere.

Start reading from docs/INSTALL.html#update_full for how to do a real update.

[macgos]

How do I run install/database_update.php - where do I find this?

[Kevin Clark]

Upload the install folder from 3.0.3 (the download page has a link on the right to previous versions)
Go to
http://forum.rcsoaring.co.nz/phpbb/inst ... update.php
Let it run
Delete the install folder.

Then update to 3.0.4