SQL error in profile page

[ramesh]

Hello,

It seems there is a sql error in User control panel -> profile tab

Ramesh

[robert]

Hmm, doesn't happen for me. Maybe it was just been a glitch in the Matrix? Try again...

[ramesh]

Im getting this everytime. Here is what I see:

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.
Please notify the board administrator or webmaster: xxxxx_xxxxx@hotmail.com

[robert]

Okay, I'm looking into it, sorry about that!

[Guest]

Hi, i'm having the same problem on my forum. Can you help me how you solved this problem?

[HwRansom]

It's me again. I solved the problem.
It was due to an uncompleted database update, when upgrading from version 3.0.3 to 3.0.4 the database hasn't been updated successfully.

If anyone else is interested in the solution i put it here:
1. Change the database version (apparently) back to 3.0.3
Trick the phpBB board that it needs an upgrade. Edit the 'config' table in the mysql database. At 'version' put 3.0.3, or you can run the query:

Code: Select all

UPDATE [i]YOUR_TABLE_PREFIX[/i]_config SET config_value = '3.0.3' WHERE config_name ='version';

2.Upload files and upgrade database
Upload the upgrade installation files to the forum root folder and upgrade only the database by going to the address:
http://www.yourforum.com/install/database_update.php

Note: you can upgrade directly to the next version of phpbb, in my case to 3.0.5
Hope that i helped those who have the same problem.