why datatable editor giving SQLSTATE[42000] error?

patelleena57

Hi

I am trying datatable editor. But it gives me <b>Fatal error</b>: Uncaught Error: Call to undefined method PDO::transaction() in Editor.php:547 error

I cant figure out the problem

Would appreciate any help

And the code is

       <?php
        // DataTables PHP library
       include( "Editor/php/DataTables.php" );

        $database = 'metro_rail';
           $user = 'root';
           $password = '';
   $host = gethostbyname('localhost');
       $db = new PDO("mysql:host=$host;dbname=" . $database . ';charset=utf8', $user, 
        $password,
        array(PDO::ATTR_EMULATE_PREPARES => false,
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));

       // Alias Editor classes so they are easy to use
       use
           DataTables\Editor,
           DataTables\Editor\Field,
           DataTables\Editor\Format,
           DataTables\Editor\Mjoin,
           DataTables\Editor\Upload,
           DataTables\Editor\Validate;

       // Build our Editor instance and process the data coming from _POST
       Editor::inst( $db, 'bim_with_vault_final_master_data' , 'id')
           ->fields(
               Field::inst( 'bim_with_vault_final_master_data.Document_Number' ),
               Field::inst( 'bim_with_vault_final_master_data.Revision' ),
               Field::inst( 'bim_with_vault_final_master_data.Title' ),
               Field::inst( 'bim_with_vault_final_master_data.Revision_Date' ),
               Field::inst( 'bim_with_vault_final_master_data.Design_Stage' ),
               Field::inst( 'bim_with_vault_final_master_data.Status' ),
               Field::inst( 'bim_with_vault_final_master_data.File_Type' ),
               Field::inst( 'bim_with_vault_final_master_data.Upload_Date' ),
       Field::inst( 'bim_with_vault_final_master_data.Source' ),
       Field::inst( 'bim_with_vault_final_master_data.REV_CHK' ),
       Field::inst( 'bim_with_vault_final_master_data.DESIGN_STAGE_CHANGED' ),
       Field::inst( 'bim_with_vault_final_master_data.STATUS_CHANGED' ),
       Field::inst( 'bim_with_vault_final_master_data.Model_Status' ),
       Field::inst( 'bim_with_vault_final_master_data.Model_Captured_Status' ),
       Field::inst( 'bim_with_vault_final_master_data.PROJECT_DES' ),
       Field::inst( 'bim_with_vault_final_master_data.ORG_DES' ),
       Field::inst( 'bim_with_vault_final_master_data.DIS_DES' ),
       Field::inst( 'bim_with_vault_final_master_data.TECH_DIS_DES' ),
       Field::inst( 'bim_with_vault_final_master_data.SUB_SYS_DES' ),
       Field::inst( 'bim_with_vault_final_master_data.DOC_TYPE_DES' ),
               Field::inst( 'bim_with_vault_final_master_data.WBS_DES' )
           )
           ->process( $_POST )
           ->json();


        ?>