phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

SQL Error : 1054 Unknown column


 
Search this topic... | Search General Support... | Search Box
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Author Message
stresseduser
Board Member



Joined: 26 Jul 2010

Posts: 1



PostPosted: Mon Jul 26, 2010 2:29 pm 
Post subject: SQL Error : 1054 Unknown column

Hi Everyone,

Currently, I'm using phpBB2Plus (I know, shoot me but it was the only way to add albums and blogs, etc). We've used this about 3 years. No, there is no support forum for it... hoping the good folks here will take pity on me. icon_smile.gif

A few days ago I added new profile fields. It added them ok. But now everytime I update a profile, I get this error. It seems to be a common php error but I can't find a solution anywhere. I have repaired all tables.

Error:

Could not update custom profile fields

DEBUG MODE

SQL Error : 1054 Unknown column 'pregnancyexposures' in 'field list'

UPDATE phpbb2plus_users SET casenumber = '', ******************************************
************************ (edited out for users privacy)

Line : 997
File : admin_users.php

Every time a new person signs up, the system crashes. I have to repair the database to get it back up. This forum is for parents of critically ill babies. So I REALLY need to fix this ASAP.

Any help deeply appreciated!
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 548
Location: North West UK


flag
PostPosted: Mon Jul 26, 2010 6:29 pm 
Post subject: Re: SQL Error : 1054 Unknown column

Looks as though you edited the files to add the fields but forgot to update the database to add them there.
There should be either a PHP file to run to add the fields to the database or within the install text there will be a section called "SQL" which you will need to copy and paste and then run in the database via phpmyadmin.

Jim
Back to top
Display posts from previous:   
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0249 seconds using 15 queries. (SQL 0.0023 Parse 0.0008 Other 0.0218)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo