field builder error when adding new item

I'm about at my wits end. I just downloaded dolphin and installed it lastnight.

I want to change some fields on my site as my site is very content specific.

I was able to add one field fine and dandy

But when I try to add any other fields it tells me "Unable to add New_Item. Check if New_Item is already added"

I named the field that I did add, so it's no longer named New_Item I have checked every field and every form and no other New_Items exsist.

I have ensured that I have updated to the current dolphin and installed all the patches. Please help before I go insane. Thank you.

Hi Xeno,

Not too hard to fix - see this thread: http://www.expertzzz.com/forumz/?action=goto&cat_id=1#action=goto&topic_id=15444

Rob

Yay. thank you for making my first experience with the boonex community a positive one :)

That worked great ^_^b

kudos rob. good looking out for somebody on here

later,

DosDawg

Maybe you were a little quick on the "Kudos" DosDawg, because now I am getting the same error again, and my magic trick no longer seems to work.

When I get the error "can't insert NEW_ITEM" on profile fields builder, I usually go to the "profiles" table in phpmyadmin, and delete "NEW_ITEM" from the field list there.  This time, however, I couldn't find it in the profiles table so I checked table "profile fields " table and found and deleted it there.  When I go back to fields builder though, I get the exact same "can't insert NEW_ITEM" message, and then when I look back in phpmyadmin the "NEW_ITEM" field I had just deleted is back.  So I'm stuck- I can't add a new item in my field builder.

Anyone have any thoughts on what I should do to make this work.  I need to get at least the registration system on Dolphin working soon.

Rob

Anyone?  Now I am at wits end and can no longer add a new field to my join form.  As described above, this time "NEW_ITEM" appears in profile fields table (not profile table) but when I delete it, it just goes back and the process repeats itself.  I'm stuck.

Rob

I would take it out of the inc/db_cache/profilefields.inc cache too ...

Only way I can recreate it is to actually have a new item in one area and try to put it on another.

Please check all areas.

If its out of the DB & PF.inc it CANT show!!!! period.

you know what i had that error the other day when i was doing injections into the dbase. i dropped that and reset the two rows,and all was okie dokie. do you have a remote mysql administrator app? i posted earlier with the link to it. excellent tool.

later,
DosDawg

rob,

i will take a look at your dbase if you want me to, i am sure that is where the glitch is at. holla at me and let me know what you wanna do/

later,
DosDawg

While adding a new item click on it to edit the settings and chagne all the names like system name to other name. Then drag the new one. This will solve your problem.

Regards,

Praveen.

http://www.dolphinpros.com

Praveenkv,

It is not possible to click on NEW_ITEM when it is in the inactive area.  The cursor is four directional arrows, and you can't click on it until it is in the active area, but by that time I get the "NEW_ITEM already exists" error message.  DosDawg generously helped me for more than two hours yesterday and we tried just about everything.  We restored my database to a prior version, cleared that cache file, replaced the fields.php file, and repeatedly deleted NEW_ITEM when it showed up in the profile fields table or the profile table - and nothing seemed to work.

I have been working since last year on Dolphin and still have never even had a working registration form - much less a successful implementation.  Even with backups I somehow manage to make reverse progress, and somehow always reach the point where someone says "you're screwed- you have to start all over again with a new install and lose all your data" - which I have done about four times now.    I am extremely frustrated with this - does anyone have any ideas on how to handle this latest snafu?

Thank you

Rob

Regarding what was done with caltrades site. and this is not to say that i know everything to do, but was just wanting to help and see if i could make something work.

I initially logged into admin, and tried to push a new item up to a new block. immediately it is reported that you are cannot  do this, as New_Item already exists. well there is not one visible, so if it exists, there is a glitch somewhere. I opened phpmyadmin, and searched for New_Item, there were reports of 4 in the localization keys, and one in the profile fields. I dropped all of these instances which you would think would drop them from the site. i then took the /inc/db_cache and dropped it completely. set an empty file back to the server. Went back to admin, tried once more to push the New_Item up to the block, and again it was reported that the New_Item already exists. well i am certain that the dbase was clean, and there was no instance of New_Item anywhere on the dbase, or in the db_cache. So what happens here is that as you push the item up to the block, its appearing as if it wants to write twice. The new item will go up to the block, and you can start to modify it, but when you hit save, it does not maintain the parameters you have assigned to it.

I suggested reloading the fields.php file. essentially this didnt offer any help at all. Mrpowless, do you know of a way to do an injection on the profile fields, like we do for creating a new page? that would be my only other option on here, as clearly the new item is not working at all. something has caused this functionality to corrupt itself is my opinion.

mrp, i know you said you were not able to get this to replicate itself, but it is on his server, just acting crazy as all get out. i tried from every angle that i could think of, and had no success. when i did try to do the injection and wrote all the fields from the dbase, it was there on the join form, but, after filling out the form, and submitting there is a dbase query error in red, as if you had edited one of the existing items, and it wasnt able to write to the dbase.

well that is about all i can think of, if somebody needs screen shots, to troubleshoot this, i can get with caltrade and see if we cant go through the motions again, and do screen captures for every step.

later,

DosDawg

I was not asking you to edit the system name in the inactive area. Edit it in the active area. Check all the fields in the active area. There will be one with system name NEW_ITEM.

Regards,

Praveen

praveenky,

as stated in the posts above, the string NEW_ITEM is not present in the dbase, nor present on any of the items that have been loaded up. thank you for your suggestion, and hopefully we can find a solution to this anomoly.

later,

DosDawg

Thanks everybody - DosDawg especially.  I sent an email to Boonex technical support - and asked them to send me a solution or post it here.

Rob

If you have troubles like

'"Unable to add New_Item. Check if New_Item is already added"'

I recommend you check database (ProfileFields + Profiles tables (in case of fields of profiles)  or  PageCompose table (case of pages) ) and move to end of this tables and delete this New_Item element

But strange and interesting .. how you make this bug-like elements? :)

usually if work carefully - all Ok

after deleting such New element just reload page and try to work again

Andrey,

As we have tried to communicate, we have ALREADY deleted NEW_ITEM from the profile fields table and the profile table many times.  Again, it keeps coming back whenever I drag and drop it to the active item area when it give the error message and won't stick.

As for these bugs happening with Dolphin because I am "not being careful" could you be more specific.  I think I am being very careful - essentially treating Dolphin with kid gloves.  I got your private message and I know that you are not Boonex technical support.  I dropped a note to you and Praveenkv because I thought you might know- but we have already tried what you both suggested as documented above.  I also wrote support@boonex.com and am hopeful that they will know what is going on.

Rob

I've had this problem too.  But rather than delete NEW_ITEM in the db, I renamed it, and it worked.

Damn, didn't work.  Same thing, "unable to insert NEW_ITEM.."  (I also made sure I changed the ID field, which was set at "0")

You got me all excited, Moonchild, but I didn't think it would be that easy.  I'm hopeful some smart person or someone at Boonex will get sick of seeing this thread and will help me fix it.

Your solution might work for someone else - thanks for posting it.

Rob

Okay. In the Fields Builder under the Join Form Page. I grab a new_item block and try to place it in the active section. It drops down and won't stick (like Caltrade says). So I grab it again and try placing it above an established block and it sticks. I am able to open it and set it. Am I missing something in your error Caltrade (D6.1.2).?

I try to read carefully but some of these post get over redundant and recreating the problem isn't so easy. But Kudos to Dosdawg for droppin 2 hours on the issue. Was it free.? :) JstPlyn

Let me know if you can get the new-item block to stick in the active window above an established block. Then what happens or does this not work.? Thanks

Ghost, I have noticed on occasion that I couldn't get an item to stick if I put it at the very top, but in this case it won't stick no matter what I do.    Once again, when I drag NEW_ITEM anywhere in the active area, it will stick for maybe on second, then I get a message "sorry, couldn't insert new item.  Please check to see if NEW_ITEM already exists".

No answer from the letter I wrote to Boonex technical support on this- I think I will send it again.

Rob

If the last NEW_ITEM you created didn't get named, it could be hanging you up.  In the Active Items area, check the items you created to see if they are all named.  Also check for blanks in newly-created rows in the LocalizationStrings table.

Moonchild - thank you for responding - I am EXTREMELY frustrated as I have been working on this for more than an month and no longer even have a working registration system for my portal.    Both my letters to Boonex technical support have gone unanswered.

I have checked every item in field builder as you recommended, and can find no instances of NEW_ITEM.  I didn't find any blank entries in in the LocalizationStrings table but did find a few duplicates which I deleted.  As already discussed, I delete any new instances of NEW_ITEM whenever it appears in the profiles table or the profile fields table.  As Mrpowless advised, I also empty the inc/db_cache/profilefields.inc cache before I try to add a new item, but that doesn't work either.

I have managed to get some new fields in the join form by renaming NEW_ITEM in the profile fields table which is some progress.   Unfortunately, I can't change any of the parameters of this field in field builder- including the caption.  So for example, the field "full name" (which I have been trying to add for more than a month now) has a caption of "_FieldCaption_NEW_ITEM_Join".

Plus I STILL can't add a new item.  I get the exact same "unable to add new item, please check to see if item already exists" error message.    If anyone has any other things to try please let me know- I have no idea what to do.  Also, if anyone has any contacts at BoonEx who might be willing to look at this, please let me know that as well.

Thank you

Rob

Still no answer from Boonex technical support- worked on it for about three hours today - EXTREMELY FRUSTRATED.

I've been able to get new items in by changing the name of the NEW_ITEM field bin phpmyadmin ut there is no way to change the caption in field builder- it just won't save.  Does anyone know how to do this in phpmyadmin?

I noticed that the profiles table doesn't have all the fields that the profile fields table does- could this just reflect the records that are actually in the database, or is it indicative of other problems?  In other words, if I manage to get a new record in there, will these fields then show up in the profile table?

I also noticed an anomaly - I found an empty file  inc/profilefield.inc  and deleted it  with no apparent affect.  It is not a part of either the 6.1.2 fresh install or the upgrade patch - does anyone know what it is for?   Should I put it back?

Finally, does anyone think it would help to replace the files that are used for profile builder?  - and could someone tell me what they are?  It seems like if something was corrupted there it wouldn't work at all but I really have nothing left to try.

Rob

I realize I am using this more like a blog than a forum, since people are probable sick of this thread- but if you are sick of it think of how I feel.  It would really help if Boonex would answer repeated support questions like this so if anyone has any suggestions on how to get their attention I would appreciate knowing how.

Now, back to the issue:  I think Moonchild might have been onto something with her suggestion that I look in the localization strings table.  As I said above, I found nothing unusual there, but when I looked at the localizationKeys table I found a number of unusual entries at the bottom:

I don't really understand the relationship between LocalizationStrings and LocalizationKeys.  Can I safely delete these entries?   Is this related to my other issues with Profile Fields Builder.

Rob

It wouldn't be "NEW_ITEM", it would be blank.

I didn't find any blank entries in in the LocalizationStrings table but did find a few duplicates which I deleted. 

They are only duplicates if they have duplicate ID numbers!  The IDs connect them to the LocalizationKeys.  So, for example, if you have a field "Real Name," and you add it to the Join, Edit and View pages, you would have the same string for three different keys; i.e. _FieldCaption_RealName_Join, _FieldCaption_RealName_Edit, _FieldCaption_RealName_View.  If it is coming up "_FieldCaption_NEW_ITEM_Join" rename it to "_FieldCaption_RealName_Join"  And don't forget to go under Advanced Settings > Language Settings and click "compile."  And count yourself blessed if you are only working in one language!

I noticed that the profiles table doesn't have all the fields that the profile fields table does- could this just reflect the records that are actually in the database, or is it indicative of other problems?  In other words, if I manage to get a new record in there, will these fields then show up in the profile table?

The profile table will only show the entry fields, not the blocks and system fields that are in the profile fields table.  Your real name field should show up in both. 

The last three LocalizationKeys shown in your table look odd to me, but I'm no expert.  I only know that I don't have them in my table, and that in the ProfileFields table, there is a "Country" row with a "#!Country" value which I believe is related to the PreValues table (i.e. predefined value lists in the admin settings).  Unless you are specifically trying to do something with countries, it's probably extraneous.

Now my disclaimer:  I am NOT an expert.  I don't have any php or sql training.  I just started with Dolphin, and am learning as I go.  I don't have answers, but I've at least looked at the db and can offer some suggestions.  And isn't that what forums are for?  If we put our heads together, we will find a way.

Best of luck to you, Caltrade! 

Moonchild - This is still not solved but you have been a great help- especially since Boonex won't answer my desperate support requests.

They are only duplicates if they have duplicate ID numbers!

I found one- I got all excited that it could be the issue, but deleting it and recompiling had no effect.   The NEW_ITEM field still won't add, and when I put a caption in any new field it just hangs, and doesn't add the caption.

The profile table will only show the entry fields, not the blocks and system fields that are in the profile fields table.  Your real name field should show up in both.

It doesn't - I've managed to get the"Full Name" field to show up in the field builder's table but it is not in the profile table.  I thought this might be because a record hadn't been added with that information yet, but you seem to be saying that is not the case.  Do you (or anyone) have a theory on why this would not get in that table?

The last three LocalizationKeys shown in your table look odd to me, but I'm no expert.

Those are for a special field I made (with the help of mrpowless and a few others) that allows multiple selection of countries from the country table.  It worked once and I don't think it is causing the problem.

I'll probably try still again to beg for help from Boonex, but if anyone has any other ideas I would like to hear them.

Rob

Sorry to keep bumping this, but since Boonex will not respond to support requests I don't know what else to do.  A few questions that may help me get to the bottom of this:

1.  Fields that are in the Profile Fields table but not in the Profile tables may provide a clue.  Can anyone think of why this might be?

2.  If I wanted to replace all the files that are used for the fields builder, what files should I replace?

Anything else anyone can think of that hasn't been tried yet?  I'm all out of ideas.

Rob

Hi Rob,

> 1.  Fields that are in the Profile Fields table but not in the Profile tables may provide a clue.  Can anyone think of why this might be?

Usually, common fields doubled in tables `Profiles` and `ProfileFields`, except several special (system) fields, like captcha, picture, dividers, such fields no need keep in Profiles table :)

>2.  If I wanted to replace all the files that are used for the fields builder, what files should I replace?

Anything else anyone can think of that hasn't been tried yet?  I'm all out of ideas.

Heh, Ok, fields are core of dolphin, and in place this hardcored (couples, several profile fields), so, if you totally change it, you should rewrite many functional,

this is files - all templates classes, BxDolClassifieds.php, BxDolPageView.php, BxDolPageViewAdmin.php, BxDolPFM.php, BxDolProfile.php, BxDolProfileFields.php, BxDolProfilesController.php, BxDolProfileView.php .. possible more

Would you give me access CalTrade so I can see for myself.? I have tried several times to reduplicate your error with no luck so I really am interested to work yourside, myself. Let me know. Shoot me an email :)

Sure Ghost - everyone else here has my passwords, you might as well also :-)

I have a question about AndreyP's post as I don't understand what he means when he says "so, if you totally change it, you should rewrite many functional".

Assuming I have made no mods to any of the files he mentioned, can I replace them without consequence?  In other words, do I have to go through that diff stuff, or can I just upload those files and see if it fixes anything?

Thanks

Rob

Ok, took three weeks and three requests, but I finally got an answer from Boonex technical support:

Hello Rob.  Navigate to your phpMyAdmin, open the table Profiles and delete the column NEW_ITEM
This should do the work.

Arrrrrgggggghhhhhhhhhh!!!

Fortunately people in this community have been willing to help.  I've been working with Ghost and he has determined that this is a corrupted install.  It probably happened when I accidently ran the install script twice.  I had my host do my first ever "restore" to correct this but apparently it did not restore the database properly.  Ghost is going to help me get back to a stable install hopefully without losing too much of my previous work.

I'd like to than everybody who jumped in on this to help- Dosdawg, Moonchild, AndreyP, Mrpowless, Praveenkv and Ghost.   Though Boonex technical support leaves quite a bit to be desired this emerging community will be invaluable when any of us get stuck, and to help us all build more powerful applications.

Thanks

Rob

So, did you ever resolve the NEW_ITEM issue?  If so, how?

Yes, but it was fixed by Boonex technical support (thanks again guys!) and they haven't told me how they did it or what was wrong yet.

Rob

Well, you'd think after all this discussion of the problem, whoever fixed it would post a solution on this forum. It appears to be a problem that more than a few are experiencing. Caltrade, if you ever find out what was wrong and how to fix it, please share it with the community. Meanwhile, I will have to put my site development plans on hold until I can get the software to work.

I will tell you as soon as I know- they haven't told me yet.

Rob

Hello.

Please refer to this post:

http://www.boonex.com/unity/answers/entry/Error_adding_a_new_field

--
Best regards,
BoonEx Experts
BoonEx Ltd. - Community Software Experts
http://www.boonex.com

Actually, that "answers" post just says to delete it from the profiles table - something we have already covered here.   Something I am doing in builders is causing the auto-increment to go away, and putting a default of 0 in the ID field.  I'm not doing anything directly in the database that would cause this, so I don't know what is going on. The same thing happened in my top menu as covered in another thread.  Here is the response (and SQL command) I got from Artur:

---

well - for some reason you have deleted auto increment in Top menu table - and in profiles table
This time problem was solved using this command in SQL

alter table `TopMenu` CHANGE `ID` `ID` int(8) unsigned NOT NULL auto_increment;

HI,

I read all posts and test all solutions but nothing work... i have already the same error.

If someone have a solution.

I use dolphin 6.1.4

Jackson

Hi,

I've just installed v.6.1.4. It's an almost fresh (one profile, one group) install and works fine, however I can't add new New Items under Pages Builder, keep receiving the same error as everybody else.

I got no New Items within the profiles and profilefields tables. The ID column in both tables is set to auto_increment and Allow Nulls = No.

Is there anything else you would like to know concerning my dolphin instance to track this one down?

Any help would be appreciated.

Thanks,

voytecku.