[FX.php List] What is your approach to queries that receives an error?

[Gjermund Gusland Thorsen]

Personally I log them in a separate table.

$q = new FX( $serverIP, $webCompanionPort, $dataSourceType );
$q->SetDBData( 'www', 'phpFailedFXQuery' );
$q->SetDBPassword( $webPW, $webUN );
$q->AddDBParam( 'queryExecuted', $r['URL'] );
$q->AddDBParam( 'errorCode', $r['errorCode'] );
$q->AddDBParam( 'post', var_export( $_POST, true ) );
$q->AddDBParam( 'get', var_export( $_GET, true ) );
$q->AddDBParam( 'server', var_export( $_SERVER, true ) );
$q->AddDBParam( 'cookie', var_export( $_COOKIE, true ) );
$q->AddDBParam( 'session', var_export( $_SESSION, true ) );
$r = $q->FMNew();

And I have built a script to regenerate queryExecuted as a form for
admin to rebuild the query, this is especially usefull for claims and
orders.

ggt667