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

* Your Email Address
* Spam protection	Enter the letters below: . . __ .___. __..__ \| \|/ ` _/ (__ [__) \|/\\|\__../__..__)\|
Comment	> 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
Attachment
Watch this ticket