new_Item error on field builder 2017

is there a real solution of this error, i'm stuck since 8 days now, i can't continue on my project because of that, i follow and read all topics about it, doesn't help me.

 

1-https://www.boonex.com/forums/topic/NEWBLOCK-NEW-ITEM-database-error.htm

2-https://www.boonex.com/forums/topic/Unable-to-create-new-Item-in-Fields-builder.htm

3-https://www.boonex.com/forums/topic/Error-Sorry-couldn-t-insert-new-item.htm

4-https://www.boonex.com/forums/topic/Please-check-if-NEW-ITEM-already-exists-.htm

5-https://www.boonex.com/forums/topic/NEW-ITEM-issue.htm

6-https://www.boonex.com/forums/topic/Editing-New-Item-in-Fields-builder.htm

7-https://www.boonex.com/forums/topic/I-can-not-create-a-new-item-.htm

 

Is there a super man here can help me ??

why there is no action from Boonex to resolve this issue??

 

 

it was happened to me on 2013 and i cant fix it and there was no help at all, so i was stop using Boonex, and new after the "huuuuuuuuuge update" its same issue, nothing more ,, nothing less!!!!

...
Quote · 1 Dec 2016

i can fix it if you like let me know in a PM... 

https://dolphin-techs.com - Skype: Dolphin Techs
Quote · 1 Dec 2016

anyone please!! i'm really stuck here, :@

...
Quote · 1 Dec 2016

please explain what exactly your issue is. if trying to add a new block and it says block already exists - try a different name, or try refreshing the page and then looking for existing block. One other thing - you can not pull multiple New Blocks up into your menus you have to pull one up and name it before you can pull up another. Also clear caches.

caredesign.net
Quote · 2 Dec 2016

The problem is when you have to many profile fields set to varchar 255.  I changed a handful of fields to varchar 32 in the database and its working again. (sex, city, country, zip, income, weight, firstname, lastname, fullname...) 

The problem is that it sets them by defualt to varchar 255 when you drag up a new item..... This should be changed.

if( !db_res( "ALTER TABLE `Profiles` ADD `NEW_ITEM` varchar(255) NOT NULL default ''", 0 ) ) {

https://dolphin-techs.com - Skype: Dolphin Techs
Quote · 4 Dec 2016

 

The problem is when you have to many profile fields set to varchar 255.  I changed a handful of fields to varchar 32 in the database and its working again. (sex, city, country, zip, income, weight, firstname, lastname, fullname...) 

The problem is that it sets them by defualt to varchar 255 when you drag up a new item..... This should be changed.

if( !db_res( "ALTER TABLE `Profiles` ADD `NEW_ITEM` varchar(255) NOT NULL default ''", 0 ) ) {

The problem is that most users are not IT people, not database people.  Boonex did 255 because of course they had no idea what item would be added and they wanted to avoid issues.  Perhaps include a number of characters question for users; "How many characters needed for this field" or something along those lines.

Geeks, making the world a better place
Quote · 4 Dec 2016
 
 
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.