SQL error in profile page

Post a reply

Smilies
:D :) ;) :( :o :shock: :? 8-) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :!: :?: :idea: :arrow: :| :mrgreen: :geek: :ugeek:
BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON
Topic review
   

Expand view Topic review: SQL error in profile page

Re: SQL error in profile page

Post by HwRansom » Wed Sep 16, 2009 6:16 pm

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.

Re: SQL error in profile page

Post by Guest » Wed Sep 16, 2009 3:51 pm

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

Re: SQL error in profile page

Post by robert » Tue Jun 30, 2009 12:05 pm

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

Re: SQL error in profile page

Post by ramesh » Tue Jun 30, 2009 4:07 am

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

Re: SQL error in profile page

Post by robert » Mon Jun 29, 2009 7:27 pm

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

SQL error in profile page

Post by ramesh » Mon Jun 29, 2009 1:51 pm

Hello,

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

Ramesh

Top