Error on Hook , how to detect it ?

[altomarketing]

Im developing some hooks to run as DailyCronJob, but it does not work. Is there any way to detect why it is not working ?

 

sql query works fine in phpmyadmin.

 

code is:

 

<?php
function domainpending_sendclientmail() 
 {
 # Template file name
 $emailtpl = "EM - Dominio pendiente";
 # API Command
 $command = 'SendEmail';
 # Admin Username or ID
 $adminuser = "myadminuserhere";
 #todos pending.
 $d = mysql_query('Select * FROM tbldomains WHERE status="Pending" and registrationdate <= ( CURRENT_DATE( ) -5 )');
 #make array
 while ($result = mysql_fetch_assoc($d)) 
	 {
	 $domain = $result['domain'];
	 $values = array('messagename' => $emailtpl, 'id' => $domain);
	 $apiresults = localAPI($command,$values,$adminuser); 
	 }
}

add_hook('DailyCronJob', 5, 'domainpending_sendclientmail');

[jljubich]

Have you lastly upgraded to 5.2.5?. We have upgraded to 5.2.5 last saturday and are experiencing serious troubles regarding dailyCronJob, including duplicated billing.

[altomarketing]

No upgrade.., im using 5.1

[altomarketing]

... wait... i fixed..

 

i changed $domain = $result['domain']; for $domain = $result['id'];

 

because in array 'id' is the 'domainid' , required to send emails, right