Hi, I tried customizing employee form by adding custom field. After adding field and clicking on Update, I don’t see status like Employee Updated. When I checked browser console, I see there is an interval server error and few connectivity timeouts. How can I fix this issue, so that I can add custom fields to Employee form? @bahaou@NCP
request.js:268
POST https://example.com/api/method/run_doc_method 500 (INTERNAL SERVER ERROR)
[NEW] Explain Console errors by using Copilot in Edge: click
to explain an error. Learn more
Don't show again
request.js:351 Unable to handle failed response
request.js:352
SyntaxError: Unexpected token '<', "<!doctype "... is not valid JSON
at JSON.parse (<anonymous>)
at frappe.request.report_error (request.js:512:18)
at 500 (request.js:214:20)
at Object.<anonymous> (request.js:345:6)
socketio_client.js:18
GET https://example.com:9000/socket.io/?EIO=4&transport=polling&t=PJl9WQP net::ERR_CONNECTION_TIMED_OUT
socketio_client.js:18
GET https://example.com:9000/socket.io/?EIO=4&transport=polling&t=PJl9bTz net::ERR_CONNECTION_TIMED_OUT
socketio_client.js:18
GET https://example.com:9000/socket.io/?EIO=4&transport=polling&t=PJl9c6n net::ERR_CONNECTION_TIMED_OUT
socketio_client.js:18
GET https://example.com:9000/socket.io/?EIO=4&transport=polling&t=PJl9hfg net::ERR_CONNECTION_TIMED_OUT
It gets saved, but it wont allow to update employee information. Also, employee list wont load. Again if you delete newly added field from form then I can update employee information. I tried different types of fields like data, select, check box etc. Same issue, cant update form and cant update employee information.
@anilpoda oh your list page is broken . that’s probably an error in your js file . did you edit the js file of employee ? override it or created a client script ?
As I said, when I delete custom field, list shows up without any issue and I can update employee information as well. The only issue is I am not able to customize form.
No, I dont have access to server files. How can I fix this?
Hi, I have asked Server admin to restart server and run bench start command. After that, when I tried adding custom field to Employee Form I got below error. How can I fix this?
pymysql.err.OperationalError: (1118, ‘Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs’)
Yeah, it looks like row size issue only. At the moment 197 fields are there including section/tab/column breaks. What is the difference between Data and Small Text field? There is an option called length, can I reduce the length which is by default 140? Is 65535 row size limit is for Employee table alone?
@anilpoda 65,535 bytes (64 KB) is the maximum size of a single row in a MySQL table ,not the entire database. the difference between data and small text is data is a varchar(140) (stored in the row and it’s faster to get the data) . small text is a TEXT field which is stored separately (does not count in the row limit). and yes , you can reduce the length if a data field.
So, for example email id field type is data. I have given 30 in length, does this mean 30 characters or 30 bytes? Is 30 fair length for email id with data field type? Mine is mariaDB @bahaou
