Database Error - How to fix?

SO I wanted to add a little bit more info to people's profiles, something like an 'about me' with marital status, kids, education, etc.. (all optional)

and I created a new item called 'status' for the marital status thingy..

thats when my probs began, when I realised that there were 2 'status' items, (with a database error), I just deleted the one I created..

and now I get the error

unknown column 'Status' in 'where clause'

found error in file **/public_html/inc/match.inc.php at line 58.
Called db_res function with erroneous argument #0

(if anybody can tell me how to stop cron daemon mailing me every couple of minutes would be good too, I know what and why, just not the how.. it doesn't need to keep telling me..)

Help!!!

somehow I have an active field in the profiles database called NEW_ITEM that doesn't actually show up on the builder.. :s

clever me renamed it to NEW through phpmyadmin so I could recreate the 'status' item which has stopped the error messages being sent every minute..

I still have the problem of how to change the DB so that I don't have 2 instances of status ("Status" = system & "status" = custom field) as that causes current memberships to be inactive and a DB error when a new member tries to register.

(DB error = Mysql error: Column 'status' specified twice)

A bit more detailed info:

In the language keys I've now got:

• _Status (string = Status, category = misc)
• _FieldCaption_Status_Edit (string = Status, category = Profile Fields)
• _FieldCaption_Status_View (string = Status, category = Profile Fields)
• _FieldCaption_maritalstatus_Join (string = test, category = Profile Fields) (I assume this is from me trying to rename the custom field)
• _FieldCaption_status_Join (string = test, category = Profile Fields) (I think this is my custom field)
• _FieldDesc_Status_Edit (string = System User Status)
  
• _FieldDesc_status_Join (string = [blank], category = Profile Fields)
  

I didn't actually use the 'status' field that I created as I then came across the 'NEW_ITEM' error.

So, I'd also like to know how I can remove that active 'NEW_ITEM' (now NEW) without causing more errors. Like I said, it doesn't show up in the builder at all.. :/

problem solved..

had to edit both the profile fields and profiles tables in the database and /inc/db_cached/ProfileFields.inc to remove the second reference to status.

now all appears well again, accounts are active, new members can register, so.. I think it's fixed

I did the same thing now I have the same error

can you please give me instruction an how to fix the error

thank you.

Cron jobs are important , however if you want to totally stop mails to you I think just deleting the cron settings in your cpanel will do the trick, iand if you want your cron to function at a more spaced out time, try udjusting the "times to perform" in your cron job  0 0 * * * and the */10 * * * *, havnt done this but I think it will do.

You created a field the same as a system field?

What I did was a dump of the affected table to my hard drive, then edited it in notepad to:

1. remove the offending field and
2. re-insert the correct field

Can I give instructions as to how? well not really as I was working blind... (mainly guesswork rather than knowledge). Basically, the 'status' field I created replaced the system 'Status' field in the profiles table and as the system field refers to membership levels it killed the accounts/registration etc. It needed changing back, i.e. Status = 'Active', I also had a little help from someone on IRC that has mysql knowledge who told me what the problem was and what not to do when editing the table.

If you want to copy the table into a post here I'll try and point out what needs changing, if I can.

From the sound of all this couldn't you just simply delete the 'created' (new) status field from the table in phpMyAdmin  .....  ?

Why doesn't Boonex make it impossible to delete a system field name, or to give an name to a new field that is the same as a system field name.  This has caused problems for a bunch of us here.

I tried that RumpyBumpy, it caused all sorts of fun... mails every minute telling me that there were DB errors.

That was because I deleted the 'status' field and hadn't re-added the original system 'Status' field. It's critical to the operation of Dolphin as it defines account status (e.g. Active, Inactive, Suspended, etc..)

Oh, and it took me 24 hours to figure out what the issue was... not good at all and one I definitely learned from!

thanks you guys for trying to help me out.

I try to fix it and now I have that same error and so much more, i'll just pay the guy to re-install the whole thing again, I think that would be a good ida, I aint got much to lose .

What do you thing Do you thing  if I get it re-install all the problem will be solv?

thanks again for your reply.

I suppose that depends on how much you have modified the original installation..

I'd spent a lot of time on mine and made a lot of changes.. I was loathe to try reinstalling as I'd have been back at square one.

can you post the error mail here so we can advise you better as to how to fix instead?

hi i am new to here.

i have met same  problem, i add some new fields at register form. my english version register form work good after add new fields. but my chinese version work no good. i got those lines:

_FieldCaption_MaritalStatus_Join:

_FieldCaption_Have_children_Join:

_FieldCaption_Length_Join: *

etc,

how i can fix it at my chinese versioin dolphin?

who can give me some idea?

thank you so much.

Because you have not completed the process.  You applied the fields to your join page, but you never went and fully edited and filled in all sections on the profile view/account and so on pages. 

Go into Admin => Builders => Field Builders =>Profile and click on  the items that are showing incorrectly such as MaritalStatus_Join and so on and fill in the blank box for "Caption"  Save and your problem will be solved.

Hi mydatery:

thank you reply.

but can you open my site:

http://www.universelove.com/join.php?lang=sc

then you will see chinese register form, error fields.

i did login admin, but i find english fields is correct.

where i can fix error chinese fields? i did not find where i can fix it

Hi mydatery:

i go to database table:  LocalizationStrings

insert some records like this: (2969, 2, '头发颜色''),
(2967, 2, '眼睛颜色');
then i try refresh site, but chinese form fields still like this:

_FieldCaption_Eye_colour_Join:

_FieldCaption_Hair_colour_Join:

do you have any idea about this?

Don't go to the DB tables unless you know exactly which tables to change.  Do as I say, not as you think you should do. 

1.  Go to Admin

2.  Builders

3.  Field Builders

4.  Profile

5.  Open the tag for the item that is erring out

6.  Note the caption is blank, fill in that caption.

Now, I don't read chinese so I can't translate whatever you typed above this, but if your not going to listen then I can't help you.  If your still getting the _FieldCaption_Hair_colour_Join: on your profile view pages or any other page, then you may need to do it this way:

1.  Admin

2.  Settings

3.  Language Settings

4.  Do a search for _FieldCaption_Hair_colour_Join:

5.  Locate and edit it so that it says Hair colour

Now, a curious question I have for you:  When online dating first came about it was necessary to note hair color and such on the forms, but with these sites that are so heavy into video/photo technology now, why are you loading your DB with such basic physical information? 

Also, after editing the DB did you recompile the language?

hi i did try go to Language Settings--> search _FieldCaption_Hair_colour_Join: then  Add a new language key Hair color-->chinese String, not sure what reason, site page still display error code:_FieldCaption_Hair_colour_Join:,donot display i add chinese. i will try tomorrow again.

about your curious question : i think those forms important for some people. and not everyone like upload their video.

i deleted new records(i added) from DB, i think you are right,i donot exactly how to compiler DB.

Follow the first set of instructions in the above that tells you to go to Builders, your captions are blank and need to be filled in.  You did it on the Join Form, but you need to do it on the Profile & Search forms now.  Geesh, the Language Settings were the 2nd step you were supposed to do. 

You know they say sex promotes brain cell growth in the male.  I'm thinking someone needs to go get a lot of prostitutes before he continues building his site.