1081 Update – Server Edition email problem after updating

In update 1081 we made some performance tweaks to the Email Manager using the “LEFT(…)” function available in PostgreSQL. Since rolling out the update however, we’ve discovered that older installations of PGSQL (specifically 8.x and earlier) don’t support the LEFT function.

You will know if you are affected by this issue if you get the following error message when trying to access your emails :-
function left(text, integer) does not exist

RESOLUTION

You could update the PostgreSQL installation on your server computer. However we only recommend this if you’re 100% sure that you know what you’re doing… and PLEASE backup first if you do decide to do this.

The recommended and much easier fix is to follow these instructions :-

[1] Log on to ClinicOffice as an ADMINISTRATOR and then click TOOLS | ADVANCED DB OPERATION
[2] Make sure “Can Adjust SQL” is NOT ticked, and “As Administrator” IS ticked
[3] Copy and paste the following code into the box :-

CREATE OR REPLACE FUNCTION left(IN text, IN int)
RETURNS text as
$BODY$
BEGIN
RETURN substr($1, 1, $2);
END;
$BODY$
LANGUAGE PLpgSQL;

[4] Click the EXECUTE button
[5] Close down ClinicOffice, then launch it again, log on and try it out

You only need to follow the above instructions ONCE on one of your computers. This will create the LEFT function on your database server which will resolve the issue.

Please feel free to post below if you need any further assistance with the above instructions.