Pls Help - Customer field can not be added.

[michaeldeng]

Appreciate your help on this.
OS: GNU/Linux CentOS 5.2, PHP: 5.2.9, Database: Mysql 5.1.32, HTTPD 2.11. SugarCRM: 5.2.0c.
We added these modules: ZukerReports CE 1.11, Teams 0.98.12338. Connector for Google Calendar 1.0.7.
This issue only happened in Accounts module - when we tried to add a new customer field, the button add filed does not work. When you tried to change existing fields - no matter customer fields or original field, it does not work - the button or the link does not work, system just show error in the buttom.
but it does work on other modules such as contacts, call. etc.

I checked the error message:
invalid flag after regular expression
http://aws1.verican.us/sugarcrm/incl...-all.js?c=1%22
Line 10
[Break on this error] <b>Warning</b>: ksort() expects paramet...efield.php</b> on line <b>215</b><br />\n

André thought it's a php error fetched by ajax based javascript.
Have a look at the error_log of apache and check if there is any error related to this line at the tail of this file.

But I checked Error_log, there is no warning or error message.

André or any other experts can help?

if you need any other information, Pls let me know.

here is the thread I post before: http://www.sugarcrm.com/forums/showthread.php?t=48356

Thanks

Michael Deng

[andopes]

Hi Michael

Install and enable Firebug.
Make sure you enable Network monitoring.
Go to Studio and try to add another custom field.
You will see the error message, then open firebug and go to network tab.
Let us know the full error message.

Cheers

[michaeldeng]

André:

Thanks for your help.

Pls check all the information:

Thanks
Michael

Here is the header information:
Date

Mon, 08 Jun 2009 05:26:18 GMT

Server

Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8b PHP/5.2.9

X-Powered-By

PHP/5.2.9

Expires

Thu, 19 Nov 1981 08:52:00 GMT

Cache-Control

no-store, no-cache, must-revalidate, post-check=0, pre-check=0

Pragma

no-cache

Set-Cookie

ck_login_id_20=1; expires=Sun, 06-Sep-2009 05:26:19 GMT
ck_login_theme_20=Sugar; expires=Sun, 06-Sep-2009 05:26:19 GMT
ck_login_language_20=en_us; expires=Sun, 06-Sep-2009 05:26:19 GMT

Keep-Alive

timeout=5, max=100

Connection

Keep-Alive

Transfer-Encoding

chunked

Content-Type

text/html; charset=UTF-8

请求头信息
Host

aws1.verican.us

User-Agent

Mozilla/5.0 (Windows; U; Windows NT 5.1; zh-CN; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10

Accept

text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

Accept-Language

zh-cn,zh;q=0.5

Accept-Encoding

gzip,deflate

Accept-Charset

gb2312,utf-8;q=0.7,*;q=0.7

Keep-Alive

300

Connection

keep-alive

X-Requested-With

XMLHttpRequest

Content-Type

application/x-www-form-urlencoded; charset=UTF-8

Referer

http://aws1.verican.us/sugarcrm/inde...ex&type=studio

Content-Length

106

Cookie

ck_login_id_20=1; ck_login_theme_20=Sugar; ck_login_language_20=en_us; __utma=50790062.1608860639849634800
.1233535525.1236214137.1240186751.3; __utmz=50790062.1233535525.1.1.utmcsr=(direct)|utm ccn=(direct)|utmcmd
=(none); showLeftCol=true; PHPSESSID=e5a69982a5d392aef990a975a757750a

here is the Post:
action

modulefield

field

module

ModuleBuilder

to_pdf

true

type

0

view_module

Accounts

view_package

studio

Here is the response:
<br />
<b>Warning</b>: ksort() expects parameter 1 to be array, null given in <b>/mnt/www/SugarCE-Full-5.2
.0c/modules/ModuleBuilder/views/view.modulefield.php</b> on line <b>215</b><br />
{"east":{"title":"Edit Field","crumb":"","content":"<div id=\"overDiv\" style=\"position:absolute; visibility
:hidden; z-index:1000\"><\/div>\n\n<script>\naddForm('popup_form');\n<\/script>\n\n\n<form name='popup_form'
id='popup_form_id' onsubmit='return false;'>\n<input type='hidden' name='module' value='ModuleBuilder'
>\n<input type='hidden' name='action' value='saveField'>\n<input type='hidden' name='new_dropdown' value
=''>\n<input type='hidden' name='to_pdf' value='true'>\n<input type='hidden' name='view_module' value
='Accounts'>\n<input type='hidden' name='is_update' value='true'>\n &nbsp
;<input type='button' class='button' name='fsavebtn' value='Save' onclick='if(validate_type_selection
() && check_form(\"popup_form\")){ ModuleBuilder.submitForm(\"popup_form\"); }'>\n \n
<hr>\n\n<table width=\"400px\" >\n<tr>\n <td class=\"mbLBL\" style=\"width:92px;\">Data
Type:<\/td>\n <td > <select name=\"type\" id=\"type\" onchange=\"ModuleBuilder.moduleLoadField
(&quot;&quot;, this.options[this.selectedIndex].value);\">\n<\/select>\n\n <img border
=\"0\" onmouseout=\"return nd();\

[michaeldeng]

more error message:

"\n onmouseover=\"return overlib('Select the appropriate data type
based on the type of data that will be entered into the field.', FGCLASS, 'olFgClass', CGCLASS, 'olCgClass'
, BGCLASS, 'olBgClass', TEXTFONTCLASS, 'olFontClass', CAPTIONFONTCLASS, 'olCapFontClass', CLOSEFONTCLASS
, 'olCloseFontClass', WIDTH, -1, NOFOLLOW, 'ol_nofollow',FIXX,250,FIXY,80 );\"\n src=\"themes\/default
\/images\/help.gif\"\/>\n (varchar) <input type='hidden' name='type'
value=varchar>\n <\/td>\n<\/tr>\n<\/table>\n\n\n\n<table width=\"100%\">\n<tr>\n\t<td class='mbLBL'
width='30%' >Field Name:<\/td>\n\t<td>\n\t\t\t<input id=\"field_name_id\" maxlength=30 type=\"text\"
name=\"name\" value=\"\" onchange=\"document.getElementById('label_key_id') .value = 'LBL_'+document
.getElementById('field_name_id').value.toUpperCase ();\n\t\tdocument.getElementById('label_value_id')
.value = document.getElementById('field_name_id').value.rep lace(\/_\/,' ');\n\t\tdocument.getElementById
('field_name_id').value = document.getElementById('field_name_id').value.toL owerCase();\" \/>\n\t\t\t
<script>\n\t\taddToValidate('popup_form', 'name', 'DBName', true,'Field Name [a-zA-Z_]' );\n\t\taddToValidateIsInArray
('popup_form', 'name', 'in_array', true,'Reserved Keyword', '[\"ADD\",\"EXCEPT\",\"PERCENT\",\"ALL\"
,\"EXEC\",\"PLAN\",\"ALTER\",\"EXECUTE\",\"PRECISI ON\",\"AND\",\"EXISTS\",\"PRIMARY\",\"ANY\",\"EXI T
\",\"PRINT\",\"AS\",\"FETCH\",\"PROC\",\"ASC\",\"F ILE\",\"PROCEDURE\",\"AUTHORIZATION\",\"FILLFACTOR
\",\"PUBLIC\",\"BACKUP\",\"FOR\",\"RAISERROR\",\"B EGIN\",\"FOREIGN\",\"READ\",\"BETWEEN\",\"FREETEXT
\",\"READTEXT\",\"BREAK\",\"FREETEXTTABLE\",\"RECO NFIGURE\",\"BROWSE\",\"FROM\",\"REFERENCES\",\"BUL K
\",\"FULL\",\"REPLICATION\",\"BY\",\"FUNCTION\",\" RESTORE\",\"CASCADE\",\"GOTO\",\"RESTRICT\",\"CASE
\",\"GRANT\",\"RETURN\",\"CHECK\",\"GROUP\",\"REVO KE\",\"CHECKPOINT\",\"HAVING\",\"RIGHT\",\"CLOSE\ "
,\"HOLDLOCK\",\"ROLLBACK\",\"CLUSTERED\",\"IDENTIT Y\",\"ROWCOUNT\",\"COALESCE\",\"IDENTITY_INSERT\ ",
\"ROWGUIDCOL\",\"COLLATE\",\"IDENTITYCOL\",\"RULE\ ",\"COLUMN\",\"IF\",\"SAVE\",\"COMMIT\",\"IN\",\"S CHEMA
\",\"COMPUTE\",\"INDEX\",\"SELECT\",\"CONSTRAINT\" ,\"INNER\",\"SESSION_USER\",\"CONTAINS\",\"INSERT\ "
,\"SET\",\"CONTAINSTABLE\",\"INTERSECT\",\"SETUSER \",\"CONTINUE\",\"INTO\",\"SHUTDOWN\",\"CONVERT \",
\"IS\",\"SOME\",\"CREATE\",\"JOIN\",\"STATISTICS\" ,\"CROSS\",\"KEY\",\"SYSTEM_USER\",\"CURRENT\",\"K ILL
\",\"TABLE\",\"CURRENT_DATE\",\"LEFT\",\"TEXTSIZE\ ",\"CURRENT_TIME\",\"LIKE\",\"THEN\",\"CURRENT_TIM ESTAMP
\",\"LINENO\",\"TO\",\"CURRENT_USER\",\"LOAD\",\"T OP\",\"CURSOR\",\"NATIONAL\",\"TRAN\",\"DATABASE\ "
,\"NOCHECK\",\"TRANSACTION\",\"DBCC\",\"NONCLUSTER ED\",\"TRIGGER\",\"DEALLOCATE\",\"NOT\",\"TRUNCAT E
\",\"DECLARE\",\"NULL\",\"TSEQUAL\",\"DEFAULT\",\" NULLIF\",\"UNION\",\"DELETE\",\"OF\",\"UNIQUE\",\" DENY
\",\"OFF\",\"UPDATE\",\"DESC\",\"OFFSETS\",\"UPDAT ETEXT\",\"DISK\",\"ON\",\"USE\",\"DISTINCT\",\"OPE N
\",\"USER\",\"DISTRIBUTED\",\"OPENCONNECTOR\",\"VA LUES\",\"DOUBLE\",\"OPENQUERY\",\"VARYING\",\"DROP
\",\"OPENROWSET\",\"VIEW\",\"DUMMY\",\"OPENXML\",\ "WAITFOR\",\"DUMP\",\"OPTION\",\"WHEN\",\"ELSE\",\ "OR
\",\"WHERE\",\"END\",\"ORDER\",\"WHILE\",\"ERRLVL\ ",\"OUTER\",\"WITH\",\"ESCAPE\",\"OVER\",\"WRITETE XT
\",\"ANALYZE\",\"ASENSITIVE\",\"BEFORE\",\"BIGINT\ ",\"BINARY\",\"BOTH\",\"CALL\",\"CHANGE\",\"CHARAC TER
\",\"CONDITION\",\"DATABASES\",\"DAY_HOUR\",\"DAY_ MICROSECOND\",\"DAY_MINUTE\",\"DAY_SECOND\",\"DEC\ "
,\"DECIMAL\",\"DELAYED\",\"DESCRIBE\",\"DETERMINIS TIC\",\"DISTINCTROW\",\"DIV\",\"DUAL\",\"EACH\",\" ELSEIF
\",\"ENCLOSED\",\"ESCAPED\",\"EXPLAIN\",\"FALSE\", \"FLOAT\",\"FLOAT4\",\"FLOAT8\",\"FORCE\",\"FULLTE XT
\",\"HIGH_PRIORITY\",\"HOUR_MICROSECOND\",\"HOUR_M INUTE\",\"HOUR_SECOND\",\"IGNORE\",\"INFILE\",\"IN OUT
\",\"INSENSITIVE\",\"INT\",\"INT1\",\"INT2\",\"INT 3\",\"INT4\",\"INT8\",\"INTEGER\",\"ITERATE\",\"KE YS
\",\"LEADING\",\"LEAVE\",\"LIMIT\",\"LINES\",\"LOC ALTIME\",\"LOCALTIMESTAMP\",\"LOCK\",\"LONGBLOB\",
\"LONGTEXT\",\"LOOP\",\"LOW_PRIORITY\",\"MATCH\",\ "MEDIUMBLOB\",\"MEDIUMINT\",\"MEDIUMTEXT\",\"MIDDL EINT
\",\"MINUTE_MICROSECOND\",\"MINUTE_SECOND\",\"MOD\ ",\"MODIFIES\",\"NATURAL\",\"NO_WRITE_TO_BINLO G\",
\"NUMERIC\",\"OPTIMIZE\",\"OPTIONALLY\",\"OUT\",\" OUTFILE\",\"PURGE\",\"READS\",\"REAL\",\"REGEXP\",
\"RELEASE\",\"RENAME\",\"REPEAT\",\"REPLACE\",\"RE QUIRE\",\"RLIKE\",\"SCHEMAS\",\"SECOND_MICROSECOND
\",\"SENSITIVE\",\"SEPARATOR\",\"SHOW\",\"SMALLINT \",\"SONAME\",\"SPATIAL\",\"SPECIFIC\",\"SQL\",\"S QLEXCEPTION
\",\"SQLSTATE\",\"SQLWARNING\",\"SQL_BIG_RESULT\", \"SQL_CALC_FOUND_ROWS\",\"SQL_SMALL_RESULT\",\" SSL
\",\"STARTING\",\"STRAIGHT_JOIN\",\"TERMINATED\",\ "TINYBLOB\",\"TINYINT\",\"TINYTEXT\",\"TRAILIN G\",
\"TRUE\",\"UNDO\",\"UNLOCK\",\"UNSIGNED\",\"USAGE\ ",\"USING\",\"UTC_DATE\",\"UTC_TIME\",\"UTC_TIMEST AMP
\",\"VARBINARY\",\"VARCHARACTER\",\"WRITE\",\"XOR\ ",\"YEAR_MONTH\",\"ZEROFILL\",\"CONNECTION\",\"LAB EL
\",\"UPGRADE\",\"DATE\",\"VARCHAR\",\"VARCHAR2\",\ "NVARCHAR2\",\"CHAR\",\"NCHAR\",\"NUMBER\",\"PLS_I NTEGER
\",\"BINARY_INTEGER\",\"LONG\",\"TIMESTAMP\",\"INT ERVAL\",\"RAW\",\"ROWID\",\"UROWID\",\"MLSLABEL\",
\"CLOB\",\"NCLOB\",\"BLOB\",\"BFILE\",\"XMLTYPE \"]', 'u==');\n\t\t<\/script>\n\t<\/td>\n<\/tr>\n<tr>
\n\t<td class='mbLBL'>Display Label:<\/td>\n\t<td>\n\t\t<input id=\"label_value_id\" type=\"text\" name
=\"label_value\" value=\"\">\n\t<\/td>\n<\/tr>\n<tr>\n\t<td class='mbLBL'>System Label:<\/td>\n\t<td
>\n\t\t\t<input id =\"label_key_id\" type=\"text\" name=\"label\" value=\"\">\n\t\t<\/td>\n<\/tr>\n<tr
>\n\t<td class='mbLBL'>Help Text:<\/td><td><input type=\"text\" name=\"help\" value=\"\">\t<\/td>\n<
\/tr>\n<tr>\n <td class='mbLBL'>Comment Text:<\/td><td><input type=\"text\" name=\"comments\" value
=\"\"> <\/td>\n<\/tr><tr>\n\t<td class='mbLBL'>Default Value:<\/td>\n\t<td>\n\t\t\t<input type='text'
name='default' id='default' value='' maxlength='50'>\n\t\t<\/td>\n<\/tr>\n<tr>\n\t<td class='mbLBL'
>Max Size:<\/td>\n\t<td>\n\t\t\t<input type='text' name='len' value='25' onchange=\"forceRange(this,1
,255);changeMaxLength(document.getElementById('def ault'),this.value);\">\n\t\t\n\t\t<script>\n\t\tfu nction
forceRange(field, min, max){\n\t\t\tfield.value = parseInt(field.value);\n\t\t\tif(field.value == 'NaN'
)field.value = max;\n\t\t\tif(field.value > max) field.value = max;\n\t\t\tif(field.value < min) field
.value = min;\n\t\t}\n\t\tfunction changeMaxLength(field, length){\n\t\t\tfield.maxLength = parseInt
(length);\n\t\t\tfield.value = field.value.substr(0, field.maxLength);\n\t\t}\n\t\t<\/script>\n\t\t\n
\t\t<\/td>\n<\/tr>\n<tr ><td class='mbLBL'>Required Field:<\/td><td><input type=\"checkbox\" name=\"required
\" value=\"1\" \/><\/td><\/tr>\n\n\n\n\n\n\n\n\n\n\n\n\n<tr><td class='mbLBL'>Audit:<\/td><td><input
type=\"checkbox\" name=\"audited\" value=\"1\" \/><\/td><\/tr>\n<tr><td class='mbLBL'>Importable:<
\/td><td>\n <select name=\"importable\" id=\"importable\">\n<option label=\"Yes\" value=\"true
\">Yes<\/option>\n<option label=\"No\" value=\"false\">No<\/option>\n<option label=\"Required\" value
=\"required\">Required<\/option>\n<\/select>\n\n <img border=\"0\" onmouseout=\"return nd();\"
\n onmouseover=\"return overlib('&lt;b&gt;Yes&lt;\/b&gt;: The field will be included in an import
operation.&lt;br&gt;&lt;b&gt;No&lt;\/b&gt;: The field will not be included in an import.&lt;br&gt;&lt
;b&gt;Required&lt;\/b&gt;: A value for the field must be provided in any import.', FGCLASS, 'olFgClass'
, CGCLASS, 'olCgClass', BGCLASS, 'olBgClass', TEXTFONTCLASS, 'olFontClass', CAPTIONFONTCLASS, 'olCapFontClass'
, CLOSEFONTCLASS, 'olCloseFontClass', WIDTH, -1, NOFOLLOW, 'ol_nofollow',FIXX,260,FIXY,300 );\"\n
src=\"themes\/default\/images\/help.gif\"\/>\n <\/td><\/tr>\n<tr><td class='mbLBL'>Duplicate Merge
:<\/td><td>\n\t \t<select name=\"duplicate_merge\" id=\"duplicate_merge\">\n<option label=\"Disabled
\" value=\"0\">Disabled<\/option>\n<option label=\"Enabled\" value=\"1\">Enabled<\/option>\n<\/select
>\n\n \t<img border=\"0\" onmouseout=\"return nd();\"\n onmouseover=\"return overlib('&lt;b&gt
;Enabled&lt;\/b&gt;: The field will appear in the Merge Duplicates feature, but will not be available
to use for the filter conditions in the Find Duplicates feature.&lt;br&gt;&lt;b&gt;Disabled&lt;\/b&gt
;: The field will not appear in the Merge Duplicates feature, and will not be available to use for the
filter conditions in the Find Duplicates feature.', FGCLASS, 'olFgClass', CGCLASS, 'olCgClass', BGCLASS
, 'olBgClass', TEXTFONTCLASS, 'olFontClass', CAPTIONFONTCLASS, 'olCapFontClass', CLOSEFONTCLASS, 'olCloseFontClass'
, WIDTH, -1, NOFOLLOW, 'ol_nofollow',FIXX,260,FIXY,0 );\"\n src=\"themes\/default\/images\/help.gif
\"\/>\n\t<\/td><\/tr>\n<\/table>\n\n<\/form>\n<script>\n\nfunction validate_type_selection(){\n var
typeSel = document.getElementById('type');\n if(typeSel && typeSel.options){\n if(typeSel
.options[typeSel.selectedIndex].value == ''){\n alert('Please Select a Field Type');\n
return false;\n }\n }\n return true;\n}\n\nModuleBuilder.helpSetup('fieldsEditor'
,'addField');\n<\/script>\n","action":"activate"}}

[michaeldeng]

André :

Thanks for the instruction on error message.
I followed the error message and found this changes on /SugarCE-Full-5.2
.0c/modules/ModuleBuilder/views/view.modulefield.php line 215. Somebody commented the $field_types define:
/*
$field_types = array('varchar'=>'YourField', 'int'=>'Integer', 'float'=>'Decimal','bool'=>'Checkbox','enum'=>'Dro pDown',
'date'=>'Date', 'phone' => 'Phone', 'currency' => 'Currency', 'html' => 'HTML', 'radioenum' => 'Radio',
'relate' => 'Relate', 'address' => 'Address', 'text' => 'TextArea', 'url' => 'Link');
*/
$field_types = $GLOBALS['mod_strings']['fieldTypes'];

I am not sure if this is an update version issue or other issue. and I checked Contacts module and found the field type is null too when you clicked add field button.

what should I do - should I just remove the comment and comment this line - $field_types = $GLOBALS['mod_strings']['fieldTypes'];
Or are there any files missed? or data missed in the tables? and It's possible the global function $golobals with problems on others? are there any files/tables related to this function?

I am sorry to bother you on this. I do not know PHP. I am a business guy with few experience on database side.

Thanks

Michael

[michaeldeng]

here is the en_us.lang.php file. Pls check attached file.

[andopes]

Hi Michael

It seems the language file for ModuleBuilder module is incomplete.
If you are using some language pack other than en_us, make sure it contains the language files for ModuleBuilder, specially check if contains all entries refereed on this file: modules/ModuleBuilder/views/view.modulefield.php
Make sure the Sugar folder is writeable by the user under which apache is running, check the httpd.conf and look for user and group parameters then run this command as root:

chown -R <the_user>.<the_group> /path/to/sugar

Cheers

[michaeldeng]

André,

Thanks for your help on this.

I did not find the latest language file so I tried to change the file: modules/ModuleBuilder/views/view.modulefield.php.
change from :
/*
$field_types = array('varchar'=>'YourField', 'int'=>'Integer', 'float'=>'Decimal','bool'=>'Checkbox','enum'=>'Dro pDown',
'date'=>'Date', 'phone' => 'Phone', 'currency' => 'Currency', 'html' => 'HTML', 'radioenum' => 'Radio',
'relate' => 'Relate', 'address' => 'Address', 'text' => 'TextArea', 'url' => 'Link');
*/
$field_types = $GLOBALS['mod_strings']['fieldTypes'];

to:
$field_types = array('varchar'=>'YourField', 'int'=>'Integer', 'float'=>'Decimal','bool'=>'Checkbox','enum'=>'Dro pDown',
'date'=>'Date', 'phone' => 'Phone', 'currency' => 'Currency', 'html' => 'HTML', 'radioenum' => 'Radio',
'relate' => 'Relate', 'address' => 'Address', 'text' => 'TextArea', 'url' => 'Link');
/* $field_types = $GLOBALS['mod_strings']['fieldTypes']; */

now at least the add field and edit field work now.
I am not sure if there're other impacts.

was this caused by version upgrade?

Thanks Again.

Michael

[Hardwares]

I really enjoyed your thoughts and would love to know more about your ideas in next.

[andopes]

André,

Thanks for your help on this.

I did not find the latest language file so I tried to change the file: modules/ModuleBuilder/views/view.modulefield.php.
change from :
/*
$field_types = array('varchar'=>'YourField', 'int'=>'Integer', 'float'=>'Decimal','bool'=>'Checkbox','enum'=>'Dro pDown',
'date'=>'Date', 'phone' => 'Phone', 'currency' => 'Currency', 'html' => 'HTML', 'radioenum' => 'Radio',
'relate' => 'Relate', 'address' => 'Address', 'text' => 'TextArea', 'url' => 'Link');
*/
$field_types = $GLOBALS['mod_strings']['fieldTypes'];

to:
$field_types = array('varchar'=>'YourField', 'int'=>'Integer', 'float'=>'Decimal','bool'=>'Checkbox','enum'=>'Dro pDown',
'date'=>'Date', 'phone' => 'Phone', 'currency' => 'Currency', 'html' => 'HTML', 'radioenum' => 'Radio',
'relate' => 'Relate', 'address' => 'Address', 'text' => 'TextArea', 'url' => 'Link');
/* $field_types = $GLOBALS['mod_strings']['fieldTypes']; */

now at least the add field and edit field work now.
I am not sure if there're other impacts.

was this caused by version upgrade?

Thanks Again.

Michael

Honestly I don't know?
Have you upgraded your system from a previous version?

Cheers