View Issue Detail

ID	Project	Category	Submitted / Last Updated
01109	UserSpice	Misc	2021-01-20 23:01:14 / 2021-03-01 02:31:45
Reported	Banging Heads	Assigned To	Unassigned
Priority	none	Reported	5.2.2
Status	closed fixed	Resolution Version and Commit	5.2.5
Summary	Catch PDOExceptions in DB Class
Description	<p>Altering tables to add rows that already exist etc causes PDOExceptions.</p> <p>These exceptions should be caught as errors like the others.</p> <p>This would cause the code to look something like this:</p> <p> </p> <div style="color: #d4d4d4; background-color: #1e1e1e; font-family: Consolas, 'Courier New', monospace; font-weight: normal; font-size: 14px; line-height: 19px; white-space: pre; --darkreader-inline-color: #cdc8c2; --darkreader-inline-bgcolor: #171819;" data-darkreader-inline-color="" data-darkreader-inline-bgcolor=""> <div><span style="color: #c586c0; --darkreader-inline-color: #c688c1;" data-darkreader-inline-color="">try</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> {</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">    </span><span style="color: #c586c0; --darkreader-inline-color: #c688c1;" data-darkreader-inline-color="">if</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> (</span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_query</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #dcdcaa; --darkreader-inline-color: #d8d89f;" data-darkreader-inline-color="">execute</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">()) {</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">        </span><span style="color: #c586c0; --darkreader-inline-color: #c688c1;" data-darkreader-inline-color="">if</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> (</span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_query</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #dcdcaa; --darkreader-inline-color: #d8d89f;" data-darkreader-inline-color="">columnCount</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">() > </span><span style="color: #b5cea8; --darkreader-inline-color: #afcaa1;" data-darkreader-inline-color="">0</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">) {</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">            </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_results</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> = </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_query</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #dcdcaa; --darkreader-inline-color: #d8d89f;" data-darkreader-inline-color="">fetchALL</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">(</span><span style="color: #4ec9b0; --darkreader-inline-color: #5ccdb6;" data-darkreader-inline-color="">PDO</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">::FETCH_OBJ);</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">            </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_resultsArray</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> = </span><span style="color: #dcdcaa; --darkreader-inline-color: #d8d89f;" data-darkreader-inline-color="">json_decode</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">(</span><span style="color: #dcdcaa; --darkreader-inline-color: #d8d89f;" data-darkreader-inline-color="">json_encode</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">(</span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_results</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">),</span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">true</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">);</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">        }</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">        </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_count</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> = </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_query</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #dcdcaa; --darkreader-inline-color: #d8d89f;" data-darkreader-inline-color="">rowCount</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">();</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">        </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_lastId</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> = </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_pdo</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #dcdcaa; --darkreader-inline-color: #d8d89f;" data-darkreader-inline-color="">lastInsertId</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">();</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">    } </span><span style="color: #c586c0; --darkreader-inline-color: #c688c1;" data-darkreader-inline-color="">else</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">{</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">        </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_error</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> = </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">true</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">;</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">        </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_results</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> = [];</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">        </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_errorInfo</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> = </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_query</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #dcdcaa; --darkreader-inline-color: #d8d89f;" data-darkreader-inline-color="">errorInfo</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">();</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">    }</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">} </span><span style="color: #c586c0; --darkreader-inline-color: #c688c1;" data-darkreader-inline-color="">catch</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> (</span><span style="color: #4ec9b0; --darkreader-inline-color: #5ccdb6;" data-darkreader-inline-color="">PDOException</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> </span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">$e</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">) {</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">    </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_error</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> = </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">true</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">;</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">    </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_results</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> = [];</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">    </span><span style="color: #569cd6; --darkreader-inline-color: #60a4d8;" data-darkreader-inline-color="">$this</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">_errorInfo</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color=""> = </span><span style="color: #9cdcfe; --darkreader-inline-color: #87d5fe;" data-darkreader-inline-color="">$e</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">-></span><span style="color: #dcdcaa; --darkreader-inline-color: #d8d89f;" data-darkreader-inline-color="">getMessage</span><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">();</span></div> <div><span style="color: #d4d4d4; --darkreader-inline-color: #cdc8c2;" data-darkreader-inline-color="">}</span></div> </div>

November 2021

<p>Thanks BH!</p>