Visit BoonEx Page at Facebook

Facebook

Join BoonEx group at LinkedIn

LinkedIn

Follow BoonEx on Twitter

Twitter

Subscribe to BoonEx Blog RSS feed

RSS
boonex

Error adding a new field

When I try to add any fields in the Fields Builder it tells me "Unable to add New_Item. Check if New_Item is already added".

bad
1
good
 
 

Answers

boonex
boonex 444 days agocomment permalink
 
Enter phpMyAdmin (or a different database manager), open the structure of the table '''Profiles''' and remove the column '''NEW_ITEM''' (it is usually the last column in this table).

Try to create a new field again.
 
bad
0
good
 
View 1 replies to this comment
 
Borsho
Borsho 439 days agocomment permalink
 
I am trying to use Dolphin 6.1.4. I have the can't add "new_item" problem.
And there is no "new_item" field to delete in my database. I am using mysql. I've checked everywhere and cannot find a solution to this problem.
 
bad
0
good
 
 
jboyte
jboyte 428 days agocomment permalink
 
I have the same problem and need help also ... I think it has more to do with permissions to write to the database. But I really don't know.
 
bad
0
good
 
 
PurSid
PurSid 426 days agocomment permalink
 
Yep same here - 6.1.4 fresh install, I can not add a new item, it will not let me edit after I put it down, and then doesn't save it when I refresh the page. I can not seem to find an answer to this issue. No errors show and nothing in the db to reflect a stuck new_item.
 
bad
0
good
 
 
sunnyone341
sunnyone341 400 days agocomment permalink
 
I too am having the same problem. Can't add a new item. I am having the exact same problem as the poster above me.
 
bad
0
good
 
 
boonex
boonex 397 days agocomment permalink
 
Hello.
You should check the permissions of the files inside the "inc/db_cached" folder. They should have 666 permissions.

Best regards,
BoonEx Experts
BoonEx Ltd. - Community Software Experts
http://www.boonex.com
 
bad
0
good
 
View 2 replies to this comment
 
findmuslima
findmuslima 307 days agocomment permalink
 
to all of you out there... please read the second post b4 saying " I HAVE THE SAME PROBLEM "

The problem solved by deleting "NEW_ITEM" in '''Profiles''' table
10000%
in phpmyadmin click on the '''Profiles''' on the left you will see the contain on the right, the last raw is "NEW_ITEM"
 
bad
0
good
 
 
bobong
bobong 301 days agocomment permalink
 
how many fields can i add to the profile?
 
bad
0
good
 
 
baal
baal 255 days agocomment permalink
 
there is no "NEW_ITEM" in '''Profiles''' table. any other ideas?
 
bad
0
good
 
 
leila75
leila75 251 days agocomment permalink
 
Hi
I have tow servers one with unix and other with windows: On unix server, I can add new block and new item but not on windows server: It could be linked with ntfs permissions but I can't help it
 
bad
0
good
 
 
mdroca
mdroca 235 days agocomment permalink
 
I created a new Block and them few new Items inside that block for join page. All ok. New Item name is: "web" but when I see the new Items in the profile page I see: "_FieldCaption_web_View"

My page is in 2 languages: English and Spanish, How can I change _FieldCaption_web_View for Web.
Can you help me?? thank you!
 
bad
0
good
 
 
lirmont
lirmont 180 days agocomment permalink
 
I'm running Dolphin 6.1.4 on Windows/IIS.

I was able to resolve the problem by altering the structure of the "ProfileFields" table. The underlying error was that the initial INSERT query, which only included two fields (out of ~40-ish), was failing because some of the fields are set to NOT NULL and yet have no DEFAULT value set within the database. The solution to this is to set the fields that are NOT NULL and have no DEFAULT value to simply be allowed to be NULL.

If you'd like to do them one at a time, log into phpmyadmin as your control user. Select the "ProfileFields" table. Click "SQL". Copy the following line (this is the initial INSERT query for a new block, taken straight from the code):

INSERT INTO `ProfileFields` (`Name`, `Type` ) VALUES ('NEW BLOCK', 'block');

It will give you an error based on a field name. Remember what the field name is, then click "Structure". Select the pencil-looking icon to the right of the field name that caused the problem. Check the checkbox to the right of "NULL". Hit the "Go" button. Click the "SQL" tab. Re-run the query to see if it goes through. Repeat the above steps if it doesn't.

Otherwise, you can alter the following fields and then try running the query: "Extra", "Values", "Check", and "SearchParams".
 
bad
0
good
 
 
dectdan
dectdan 146 days agocomment permalink
 
I have the same issues there is no "NEW_ITEM" in '''Profiles''' table. anyone figure this?
 
bad
0
good
 
 


Post an Answer

Please login to post an answer.

This Question
 
 
boonex's questions
All Questions
Found a bug? Have a suggestion? We really value your feedback!
 
PET:0.478454113007