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

[Kilbride, James P.]

Paul,
 
I think part of our problem(for example database name being in all caps
was causing some of the original errors) is that we have to connect to
existing tables at times that solar wouldn't be creating and which we
will not have control over the naming structure. Does solar always
lowercase table names when looking for them(so if they are in the
database in all caps it's going to fail?) or does it preserve the
capitalization of the names when we put them into the fields? I seem to
get the impression that it is not preserving capitalization quite right.

James Kilbride

________________________________

From: solar-talk-bounces at lists.solarphp.com
[mailto:solar-talk-bounces at lists.solarphp.com] On Behalf Of Walker,
Jason T.
Sent: Tuesday, November 13, 2007 4:08 PM
To: solar-talk at lists.solarphp.com
Subject: [Solar-talk] PHP Fatal error: Uncaught
exception'Solar_Controller_Page_Exception_DuringFetch'



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/b23abb2e/attachment-0001.html