Customize ERROR msg

ERPNext
1

@Sangram hi can we convert error to a information

Like i want to convert below msg to message like Data Not saved Please contact administrator

image.png600×512 19.3 KB

2

@Parag_Kapoor,

Use the frappe.throw(“Data Not Saved”) method in try … expept block

3

@makarand_b

Can you explain me in details?

On which page, I have to code?

Thanks.

4

@progShubham,

can you share you code ?

5

Yes, you can but for that, you have to make changes in framework code.
Which is result into conflicts while taking updates.
Better way you can add your custom message as @makarand_b suggested for your functionality.

6

@makarand_b

Actually I have set limit to a mysql table (tabItem) for max 5 only. In case of 6th insert, it throws an mysql error OperationalError: (1048, “Column ‘id’ cannot be null”).

Now I just want to show my custom error for this above error.

Thanks

7

You can also set the field’s length property, it will limit the number of character in the field.

Screen Shot 2017-07-13 at 3.52.00 PM.png2120×368 13 KB

1 Like
8

@makarand_b

I don’t have to limit the max character. I just have to limit the number of rows can be stored in a mysql table and that limiting is already done.

Now I just have to show my custom message on popup.

Thanks

9

@progShubham,

try the below code

try:
	// Your code
except Exception as e:
	frappe.throw("Your Custom Error Message")
10

@makarand_b

Can you tell me, on which .py file , I have to implement this and what to write in try block for caching Mysql error?

Thanks

11

@progShubham

Check Exception handling in Python

Write your method accordingly, so it will catch your exception and Where you can throw a custom message.

12

@Sangram @makarand_b

I know Exception handling in Python, but I’m getting MySQL error on user registration. Getting MySQL error is not an issue as I have limited the max number of rows can be inserted on ‘tabUser’ MySQL table to 5 Only.

So it results, when ever 6th user is added, it throws an MySQL error “OperationalError: (1048, "Column 'id' cannot be null").”.

Now I just want to handle this exception but I don’t know the actual .py file where user registeration is processed and inserted in ‘tabUser’ MySQL table. So I want to know the .py file name from where I can implement my logic for this MySQL exception.

If anyone can provide me the .py file name from where I can handle this exception or any other way to show my custom message for this error, It would be really helpful for me.

Thanks.