[Solar-talk] PHP Fatal error: Uncaught exception 'Solar_Controller_Page_Exception_DuringFetch'

[Walker, Jason T.]

I managed to use the solar models to connect to the database and pull
down some data again some of the tables in my MYSQL database.  But now
i'm running into the error below as i'm creating more models for the
other tables in the DB.  I have two tables called "event" and
"eventType".  I created the model for "event" first and it work fine.
But when i try to implement the model for "eventType" i'm getting the
error below.  I'm not sure why or where it's getting that "CREATE TABLE
event_type " stmt since my model and database table is called eventType.
Any ideas?

Thanks



127.0.0.1 - - [13/Nov/2007:15:50:01 -0500] "GET
/SolarApps/PatrolAvailability HTTP/1.1" 200 1156
PHP Fatal error:  Uncaught exception
'Solar_Controller_Page_Exception_DuringFetch'
class::code 'MYSQLDB_App_PatrolAvailability::ERR_DURING_FETCH' 
with message 'Exception encountered in the fetch() method.' 
information array (
  'exception' => 
  Solar_Sql_Adapter_Exception_QueryFailed::__set_state(array(
     '_info' => 
    array (
      'pdo_code' => '42000',
      'pdo_text' => '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 \') TYPE=InnoDB\' at line 3',
      'host' => '192.48.143.51',
      'port' => 3306,
      'user' => 'user',
      'name' => 'mysqldb',
      'stmt' => 'CREATE TABLE event_type (
	
) TYPE=InnoDB',
      'pdo_trace' => '#0
C:\\Solar\\Solar-0.28.0\\Solar\\Sql\\Adapter.php(541):
PDOStatement->execute()
#1 C:\\Solar\\Solar-0.28.0\\Solar\\Sql\\Adapter.php(1466):
Solar_Sql_Adapter->query(\'CREATE TABLE ev...\')
#2 C:\\Solar\\Solar-0.28.0\\Solar\\Sql\\Model.php(2283): in
C:\Solar\Solar-0.28.0\Solar.php on line 573
127.0.0.1 - - [13/Nov/2007:15:52:08 -0500] "GET
/SolarApps/PatrolAvailability HTTP/1.1" 200 1156
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman-mail3.webfaction.com/pipermail/solar-talk/attachments/20071113/5dda4ac0/attachment.html