Error adding a new field

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.

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.

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.

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.

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.

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

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"

how many fields can i add to the profile?

there is no "NEW_ITEM" in '''Profiles''' table. any other ideas?

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

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!

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".

I have the same issues there is no "NEW_ITEM" in '''Profiles''' table. anyone figure this?