Hi Andre,

I have tested 4.0.0-rc11 and 3.21.1 both clean installations in Docker images using the following remote testing code and it worked fine for me:

<?php

include('JsonRPCClient.php');

$c = new org\jsonrpcphp\JsonRPCClient("http://localhost:8082/admin/remotecontrol");

$key = $c->get_session_key("admin","password");

$limeid = 584128;

//$r = $c->export_timeline($key,'335619','hour','2016-01-01','2018-01-01');

$dtoken = "QUEXSTESTTOKEN";
$np = $c->add_participants($key,$limeid,array(array('firstname'=>$dtoken,'lastname'=>$dtoken)));

var_dump($np);

if (isset($np[0]['tid'])) {
  $ret = array_keys($np[0]); //array of data
var_dump($ret);
 $r = $c->delete_participants($key,$limeid,array($np[0]['tid']));
}

var_dump($r);

$c->release_session_key($key);
?>

I also tested this same code on 3.15.1 (using: docker pull acspri/limesurvey:3.15.1 ) and it worked too.

Hi again Andre,

I ran into this problem again and was able to resolve it by changing the following code in helpers/remotecontrol/remotecontrol_handler.php:

replace (around line 1802):

            $aResult = array();
            foreach ($aTokenIDs as $iTokenID) {
                $iTokenID = (int) $iTokenID;
                $token = Token::model($iSurveyID)->findByPk($iTokenID);
                if (!isset($token)) {
                                        $aResult[$iTokenID] = 'Invalid token ID';
                } elseif ($token->delete()) {
                                        $aResult[$iTokenID] = 'Deleted';
                } else {
                                        $aResult[$iTokenID] = 'Deletion went wrong';
                }
            }
            return $aResult;

with:

            foreach ($aTokenIDs as $iTokenID) {
                $iTokenID = (int) $iTokenID;
                $token = Token::model($iSurveyID)->findByPk($iTokenID);
                if (!isset($token)) {
                                        $aResult[$iTokenID] = 'Invalid token ID';
                } else {
                                        $iDel = Token::model($iSurveyID)->deleteByPk($iTokenID);
                                        if ($iDel > 0) {
                                            $aResult[$iTokenID] = 'Deleted';
                                        } else {
                                            $aResult[$iTokenID] = 'Deletion went wrong';
                                        }
                }
            }
            return $aResult;

I couldn't work out the reason why, but somehow when getting the record $token, the record was visible and available, but then when calling $token->delete it caused an SQL error that looked like this:

PHP Fatal error: Uncaught Exception: Request error: CDbCommand failed to execute the SQL statement: 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 'LIMIT 1' at line 1. The SQL statement executed was: SELECT * FROM lsrx_tokens_737958 t WHERE tid= LIMIT 1

So it wasn't filling in the tid value...

I couldn't work out why this was happening sometimes but the code above seems to resolve it.

Adam

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=29309

Does this also fix https://bugs.limesurvey.org/view.php?id=14601?

It should - can you please confirm @ginosupport?

Fixed in Release 4.0.0+200116