Uncaught Unknown file table name: files

Maikel

i have a custom button

{
extend: "selectedSingle",
text: "Start/Stop",
action: function ( e, dt, node, config ) {
var d = table.row( { selected: true } ).data();
console.log(d);
console.log(table);
console.log(editor);
editor.edit( table.row( { selected: true } ).index(), false )
.set( "mailing.status", ( editor.get("mailing.status") === "delayed" ? "started" : "delayed" ) )
.submit();
}
},

when this button is pressed i get the following error:
Uncaught Unknown file table name: files

debug from the datatables debugger
https://debug.datatables.net/odoqaf

any help would be apriciated, all other stuff in the table works perfectly, this used to work also

Maikel

this is a debug with an upgraded version:
https://debug.datatables.net/osasok

Maikel

i traced it to the editor.file part

, {
- label: "Atachment:",
- name: "mailing.attachment",
- type: "upload",
- display: function ( file_id ) {
- return editor.file( 'files', file_id ).web_path;
- }

allan

Hi Maikel,

Thanks for the debug trace. It shows "files": [], in the loaded data, so there would indeed be an error given.

How are you populating the files information at the server-side?

Allan

Maikel

this is the serverside code

        DataTables\Editor::inst( $db, 'mailing' )
            ->fields(
                    DataTables\Editor\Field::inst( 'mailing.subject' )->validator( 'Validate::notEmpty' ),
                    DataTables\Editor\Field::inst( 'mailing.to' )->validator( 'Validate::notEmpty' ),
                    DataTables\Editor\Field::inst( 'mailing.creator' )->validator( 'Validate::notEmpty' ),
                    DataTables\Editor\Field::inst( 'mailing.status' )->validator( 'Validate::notEmpty' ),
                    DataTables\Editor\Field::inst( 'mailing.added' ),
                    DataTables\Editor\Field::inst( 'mailing.started' ),
                    DataTables\Editor\Field::inst( 'mailing.stopped' ),
                    DataTables\Editor\Field::inst( 'mailing.txt' ),
                    DataTables\Editor\Field::inst( 'mailing.id' ),
                    DataTables\Editor\Field::inst( 'mailing.addAccreditatie' ),
                    DataTables\Editor\Field::inst( 'mailing.addExcel' ),
                    DataTables\Editor\Field::inst( 'mailing.addContract' ),
                    DataTables\Editor\Field::inst( 'mailing.toType' ),
                    DataTables\Editor\Field::inst( 'mailing.toID' ),
                    DataTables\Editor\Field::inst( 'mailing.toStatus' ),
                    DataTables\Editor\Field::inst( 'files.filename' ),
                    DataTables\Editor\Field::inst( 'files.filesize' ),
                    DataTables\Editor\Field::inst( 'mailing.attachment' )
                        ->upload( DataTables\Editor\Upload::inst( $cfg->get('uploadDir').'/downloads/__ID__.__EXTN__' )
                            ->db( 'files', 'id', array(
                                'filename'    => DataTables\Editor\Upload::DB_FILE_NAME,
                                'filesize'    => DataTables\Editor\Upload::DB_FILE_SIZE,
                                'web_path'    => DataTables\Editor\Upload::DB_WEB_PATH,
                                'system_path' => DataTables\Editor\Upload::DB_SYSTEM_PATH
                            ) )
                          )
            )
            ->join(
                    DataTables\Editor\Mjoin::inst('mailing_que')
                            ->set(false)
                            ->link( 'mailing_que.mailing_id', 'mailing.id')
                            ->fields(
                                    DataTables\Editor\Field::inst( 'id' ),
                                    DataTables\Editor\Field::inst( 'status' )
                            )
            )
            ->leftJoin( 'files', 'mailing.attachment', '=', 'files.id' )
            ->debug( true )
            ->process( $p )
            ->json();

Maikel

any idea whats going on here?
we still see this problem.
note that not all rows in the mailing table will have a file attached

allan

Hi Maikel,

Could you upload a new debug trace for me please? Old ones get deleted automatically.

Thanks,
Allan