The dbutil backup function is not working as what i expected

This is my code:

PHP Code:

$prefs = array(
            'tables'        => array(),  
            'ignore'        => array(),         
            'format'        => 'zip',              // gzip, zip, txt
            'filename'      => $filename.'.sql',       
            'add_drop'      => TRUE,      
            'add_insert'    => TRUE,     
            'newline'       => "\n"       
        );

        $backup = $this->dbutil->backup($prefs);        
        $backup_path = 'backups/db/';        
        $backup_file = FCPATH. $backup_path . $filename. "." . $prefs["format"]; 
        $backup_created = write_file( $backup_file, $backup); 


I am writing a backup data to a file , the string are not getting what i expected ;


Example output:

PHP Code:

INSERT INTO `104_activity_history` (`id`, `user_id`, `ip`, `done_by`, `date`, `activity`, `notification_status`, `data`) VALUES 
(9, 16, 127.0.0.1, 16, 2018-07-22 15:21:22, login, 0, ); 


This is what i am expecting:

INSERT INTO `104_activity_history` (`id`, `user_id`, `ip`, `done_by`, `date`, `activity`, `notification_status`, `data`) VALUES (9, 16, '127.0.0.1', 16, '2018-07-22 15:21:22', 'login', 0, '');

Look the value, The invertercomma is missing the output.

 

@niyasali64,

Have you tried running your expected query in MySQL workbench to make sure it works properly? Also, are you sure that your input values are formatted correctly?

Why would you have a comma for the last one when you have no value after it?

the comma is an sql delimiter.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

This is my code:

PHP Code:

$prefs = array(
            'tables'        => array(),  
            'ignore'        => array(),         
            'format'        => 'zip',              // gzip, zip, txt
            'filename'      => $filename.'.sql',       
            'add_drop'      => TRUE,      
            'add_insert'    => TRUE,     
            'newline'       => "\n"       
        );

        $backup = $this->dbutil->backup($prefs);        
        $backup_path = 'backups/db/';        
        $backup_file = FCPATH. $backup_path . $filename. "." . $prefs["format"]; 
        $backup_created = write_file( $backup_file, $backup); 


I am writing a backup data to a file , the string are not getting what i expected ;


Example output:

PHP Code:

INSERT INTO `104_activity_history` (`id`, `user_id`, `ip`, `done_by`, `date`, `activity`, `notification_status`, `data`) VALUES 
(9, 16, 127.0.0.1, 16, 2018-07-22 15:21:22, login, 0, ); 


This is what i am expecting:

INSERT INTO `104_activity_history` (`id`, `user_id`, `ip`, `done_by`, `date`, `activity`, `notification_status`, `data`) VALUES (9, 16, '127.0.0.1', 16, '2018-07-22 15:21:22', 'login', 0, '');

Look the value, The invertercomma is missing the output.

 

It is a bug. Pls update the codeigniter version to the latest. After the update create a new backup and test it.

See: https://github.com/bcit-ci/CodeIgniter/issues/5276