Database Query Error

Database error in xxxxx xxxx
Query:
SELECT COUNT(*) FROM `Profiles` WHERE `Email` = 'xxxx@xxxxxxx.com'

Mysql error:
Unknown column 'Email' in 'where clause'

Found error in file /home/frienden/public_html/inc/classes/BxDolProfileFields.php
at line 330. Called db_value function
with erroneous argument #0

I cleared the cache to see if that would work. Nothing.

I am using 6.1.4 I have 2 websites. 1 works great, this one I have this problem.

I have added a couple more fields for people to participate in including first and last name and phone number.

On my other the first and last name didn't seem to mess anything up.

So I am guessing that it is a problem with Email... but not sure exactly what.

Any suggestions or info would be great. I have always been good about searching the forum and haven't asked a question yet because I have always found the answer.

Thanks in advance.

PS xxxx are added to cover up the name and email address.

Quote · 25 Aug 2008

is the field email active?

profiles table in the DB does not have file email, put it there in admin/builder/fields builder

on tabs join edit

I have video tutorials to help you mrpowless.com
Quote · 25 Aug 2008

is the field email active?

profiles table in the DB does not have file email, put it there in admin/builder/fields builder

on tabs join edit

It is active. That is why it states the email address that you enter  (WHERE `Email` = 'xxxx@xxxxxxx.com')

The only place that the "Email" field is not "active", is under the "view profile" for MEMBERS and GUESTS.

On the JOIN page, it is in "General Info" 4 blocks down.

Is that what Mrpowless was asking?

Any other suggestions or clarifications?

Quote · 25 Aug 2008

Anyone? Please....

Quote · 25 Aug 2008
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.