Unable to remove item with multiple table structure.

OSF

Hello,

Please see the screenshot for my database table structure. I use different tables, and all work fine (add, edit).
But "remove" item not work ? Any idea, why ? Missing the METADATA TableName for Row_ID ?

rf1234

It should work. Just deleted a row from one of my data tables:

The only difference I can see is that your row is basically empty and the fields that are not empty are "->set( false )". Not sure whether that makes a difference. It probably shouldn't.

Have you checked the console for errors?

OSF

Hi,

Thanks for answere. Yes, i know. Your example works. You are in the same sql Database ? But i use two databases (GMM and METADATA) i have three levels, you only two. I thinks thats the problem…

rf1234

@allan
could this be a bug in Editor?

OSF

Think so @allan do you have a idea ?

allan

It's certainly possible! Can you show me the JSON reply from the server please from when you make the delete action run? I see the data being sent there, but it would be useful to see the response, particularly since you have the debug option enabled.

Allan

OSF

Hi @allen,

yes, give me few minutes... But i remember me 99,9% the debug result array was empty.

allan

If so, that would suggest that there is an error in this function somewhere. I'd probably need to ask you to add a little debug into it if that's okay?

Allan

OSF

@allen, you are saving my day....

It looks like I am using an older editor version.
I seem to remember that something else stopped working after updating to the new editor version.

With your sent function everything works as it should.

I will update to the new editor version this week, and report back to you why my project stopped working after that.

Thank you both for your support!

allan

Hi,

Thanks for the update. Yes, if you run into any issues with the update, just shout.

Allan

OSF

Hi @allen,

i have updated to new editor version, and follow exist code no longer work:

...
    ->where( function ( $q ) use ($SelectedDvrZeroPoint) {
        $q->where( 'CLIPPINGS.UTC_Start', "'$SelectedDvrZeroPoint'", '>', false );
        $q->and_where( 'CLIPPINGS.UTC_End', 'NOW()', '<', false );
    } )
    ->process( $_POST )
    ->json();

Error:

{"fieldErrors":[],"error":"An SQL error occurred: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '02:11:34' AND  `CLIPPINGS`.`UTC_End` < NOW()' at line 1","data":[],"ipOpts":[],"cancelled":[]}

$SelectedDvrZeroPoint are "2022-12-23 02:11:34", not '02:11:34'

This is the Debug

...  AND  `CLIPPINGS`.`UTC_Start` > `2022-12-23` 02:11:34 AND  `CLIPPINGS`.`UTC_End` < NOW()  ...

OSF

Edit:

    ->where( function ( $q ) use ($SelectedDvrZeroPoint) {
        print_r( $SelectedDvrZeroPoint );
        $q->bind(':zeropoint', $SelectedDvrZeroPoint);                
        $q->where( 'CLIPPINGS.UTC_Start', ':zeropoint', '>', false );
        $q->and_where( 'CLIPPINGS.UTC_End', 'NOW()', '<', false );
    } )

Shows me:

2022-12-23 02:31:44
{"fieldErrors":[],"error":"An SQL error occurred: SQLSTATE[42S22]: Column not found: 1054 Unknown column ''2022-12-23 02:31:44'' in 'where clause'","data"