No duplicate error message like that, how to change it ?

[samrainbow]

Hello,
I've just bought an AppGini license. It works fine, but i'm really getting annoyed by the SQL error returned in case of duplicate entry. It's an awful raw message such as this one " Duplicate entry 'http://youtube.com/watch=cUbD94eJdtM' for key 'Url_reference'Back."

As for the "You cannot leave this field empty" message (shown in a nice modal box), i'd really like (i really need) to setup such a message for the duplicate entry error. Can someone help me to quickly change that ? What code shall i change and in what file(s) ?
(My database will be used by professional users, and this sql error message doesn't really look professional when it suddenly appears).

Thanks in advance,

Sam Rainbow

[shasta59]

In my experience most error messages are aimed at the programmer to supply enough information for the programmer to determine the meaning. Error messages, in programming languages, are rarely aimed at the general public in terms of understanding.

In this case, as a guess, without seeing your code, tells me you have a duplicate entry (duh) and it has to do with a youtube reference. Without the actual code and the error trapping a development server does it is hard to tell exactly.

I always run my output on my development server first which gives me a ton of message and reports when an error happens so I can trace it quickly and fix it. This may be an idea in this case. Raise the error level reporting on your server. You can also change your php to give more error message by looking at this link:

http://php.net/manual/en/function.error-reporting.php

For mysql you could check out this link:

https://dev.mysql.com/doc/refman/5.5/en ... dling.html

While not a solution hopefully this points you in a direction to find a solution.

Alan