View Issue Detail

ID	Project	Category	Submitted / Last Updated
00801	UserSpice	Misc Code	2020-01-29 18:48:52 / 2021-11-20 10:32:47
Reported	John Williams	Assigned To	Unassigned
Priority	low	Reported	5.0.08
Status	acknowledged	Resolution Version and Commit
Summary	Feature: DB - Error Logging to database.
Description	<p>Version: 5.0.9 (Need to update the Version on submit.)</p> <p> </p> <p>Would be nice to have a error reporting for SQL.</p> <p>This is something to put into users\classes\db.php</p> <p> </p> <p>Need to create a $log_error in the US Settings, that we can toggle on or off.</p> <p> </p> <p>This first If statement, it goes inside query, insert, update...</p> <p>if($db->error() && $log_error == 1){            </p> <p>            this->log_error($table, $fields=[], $id=NULL)</p> <p>        }</p> <p>        </p> <p>Need to update the command to show current page.</p> <p>        public function log_error($table, $fields=[], $id=NULL){</p> <p>            $sql_errors = array(</p> <p>                'sql_user' => $user->data()->id,</p> <p>                'sql_currentpage' => "",</p> <p>                'sql_table' => $table,</p> <p>                'sql_id' => $id,</p> <p>                'sql_fields' => $fields,</p> <p>                'sql_errorinfo' => $db->errorInfo(),</p> <p>                'sql_errorstring' => $db->errorString(),</p> <p>            );</p> <p>            $db->insert("sql_errors",$sql_errors); </p> <p>        }</p>

November 2021

Also need to create table: sql_errors With following Fields: 'sql_user' => $user->data()->id,                 'sql_currentpage'                 'sql_table'                 'sql_id'                 'sql_fields',                 'sql_errorinfo'                 'sql_errorstring'
November 2021

This is a great idea, thank you.