SQL error in profile page

Yes, we know Fifesoft.com is ugly. It's homegrown! Feedback is welcome here.

Moderator: robert

SQL error in profile page

Postby ramesh » Mon Jun 29, 2009 1:51 pm

Hello,

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

Ramesh
ramesh
 
Posts: 7
Joined: Wed Jun 24, 2009 9:53 am

Re: SQL error in profile page

Postby 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...
User avatar
robert
 
Posts: 794
Joined: Sat May 10, 2008 5:16 pm

Re: SQL error in profile page

Postby 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
ramesh
 
Posts: 7
Joined: Wed Jun 24, 2009 9:53 am

Re: SQL error in profile page

Postby robert » Tue Jun 30, 2009 12:05 pm

Okay, I'm looking into it, sorry about that!
User avatar
robert
 
Posts: 794
Joined: Sat May 10, 2008 5:16 pm

Re: SQL error in profile page

Postby 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?
Guest
 

Re: SQL error in profile page

Postby 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.
User avatar
HwRansom
 
Posts: 1
Joined: Wed Sep 16, 2009 3:49 pm


Return to Web Site Feedback

Who is online

Users browsing this forum: No registered users and 0 guests

cron