[Tickets #9029] Re: Vacation not updating postfixadmin tables correctly

bugs at horde.org bugs at horde.org
Tue May 18 07:11:02 UTC 2010


DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/9029
------------------------------------------------------------------------------
  Ticket             | 9029
  Updated By         | lorenzettoluca at provincia.treviso.it
  Summary            | Vacation not updating postfixadmin tables correctly
  Queue              | Vacation
  Version            | 3.2.1
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


lorenzettoluca at provincia.treviso.it (2010-05-18 03:11) wrote:

I created 2 stored procedures in mysql to be called by postfixadmin  
query_set and query_unset with

CALL BackVacation(\U)

and

CALL GoVacation(\U,\S,\M,\D)

------------------
CREATE DEFINER=`root`@`localhost` PROCEDURE `BackVacation`( IN vemail  
VARCHAR( 255 ) )
BEGIN
DELETE FROM vacation WHERE email = vemail;

UPDATE alias SET goto = vemail WHERE address = vemail;

END
--------------------
CREATE DEFINER=`root`@`localhost` PROCEDURE `GoVacation`( IN vemail  
VARCHAR( 255 ) , IN vsubject VARCHAR( 255 ) , IN vbody TEXT, IN  
vdomain VARCHAR( 255 ) )
BEGIN
REPLACE INTO vacation( email, subject, body, domain, created, active )  
VALUES (vemail, vsubject, vbody, vdomain, NOW() , 1);

UPDATE alias SET goto = CONCAT( goto, CONCAT( CONCAT( ", ", goto ) ,  
"@autoreply.provincia.treviso.it" ) ) WHERE address = vemail;

END
---------------


the only problem i have is in customsql.php lines 91 and 137 because  
call of a stored procedure does not return the affected rows






More information about the bugs mailing list