add CommonTable->optimize() method and call it during refresh

1 files changed, 5 insertions, 1 deletions

diff --git a/class/TableIterator.php b/class/TableIterator.php
index dfae859..6e44c18 100644
--- a/class/TableIterator.php
+++ b/class/TableIterator.php
@@ -230,7 +230,11 @@ class TableIterator  implements Iterator
         if ($this->_res && $this->_pos<0) {
             if (!$this->_res->execute()) {
                 $err = $this->_res->errorInfo();
-                throw new Exception($err[2]);
+                throw new Exception(
+                    "\nSQL: " . $this->_sql .
+                    "\nERROR: " . $err[2] .
+                    "\nCODE:" . $err[0]
+                );
             }
         }
         return $this->next();