Welcome Guest, Not a member yet? Register   Sign In
Problem with Error Number: 1305
#1

[eluser]Unknown[/eluser]
Hi, i´m using this code

Code:
function inserta_medico($institucion){
   $this->load->helper('url');
  
   $nom = $this->input->post('nombre');
   $app = $this->input->post('apaterno');
   $apm = $this->input->post('amaterno');
   $city = $this->input->post('ciudad');
   //$inst = $this->input->post('institucion');
   $inst = $institucion;
   $ced = $this->input->post('cedula');
   $mail = $this->input->post('email');
   $tel = $this->input->post('tel');
  
   $cadena = "abcdefghijklmnopqrstuvwxyz123456789";
    $password = "";
  
    for($i=1;$i<=6;$i++)
   {
     $password .= substr($cadena,rand(1,35),1);
   }
   //---------------------------- Envia E-Mail de datos del médico ------------------------------------------
   $config['protocol'] = 'smtp';
   $config['smtp_host'] = '209.62.17.196';
   $config['wordwrap'] = TRUE;
   $config['newline'] = '\n';
   $config['mailtype'] = 'html';
   $config['smtp_user'] = '[email protected]';
   $config['smtp_pass'] = 'tamizalo';
  
   $this->load->library('email',$config);

   $this->email->from('[email protected]', 'Notificaciones automáticas SLEIMPN-PKU');
   $this->email->to($mail);
    
   $mensaje='Ha hecho una solicitud para entrar al sistema con Cédula:&lt;b&gt;&lt;u&gt;&lt;i&gt; '.$ced.'</i></u></b>, en breve recibirá información del registro.';
  
   $this->email->subject('Notificación SLEIMPN-PKU');
   $this->email->message($mensaje);
  
   $verify = $this->email->send();
  
   if(!$verify)
   {
    Header("Location: registro");
    echo $this->email->print_debugger();
   }else{
    $this->db->query("call sp_RegistroMedicos('".$ced."','".$password."','".$nom."','".$app."','".$apm."','".$city."','".$inst."','".$mail."','".$tel."');");
   }

but getting this SQL error:

Quote:Error Number: 1305

PROCEDURE seimytamiz.sp_RegistroMedicos does not exist

call sp_RegistroMedicos('medico','glmn84','reinaldo','castro','reyes','Aguascalientes','00000000001','[email protected]','5555555555');

Has anybody else experienced this or know of a solution?
#2

[eluser]vitoco[/eluser]
For what i understand, and read from the error, the stored procedure 'sp_RegistroMedicos' it's not created on the 'seimytamiz' database

Slds




Theme © iAndrew 2016 - Forum software by © MyBB