Welcome to all phpBB2 Refugees!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. |
|
Author |
Message |
stresseduser Board Member
Joined: 26 Jul 2010
Posts: 1
|
Posted: Mon Jul 26, 2010 10:29 am 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.
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: 656 Location: North West UK
|
Posted: Mon Jul 26, 2010 2: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 |
|
|
|
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0315 seconds using 16 queries. (SQL 0.0090 Parse 0.0005 Other 0.0220) |
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com
|
|