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

[Paul M Jones]

On Nov 13, 2007, at 3:07 PM, Walker, Jason T. wrote:

> 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.
Good news!


> 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?

Solar does attempt to maintain some level of portability so it can  
work with any of the supported databases.  Not all DBs honor case in  
identifier names (iirc MySQL is the only one doing that), so using  
"eventType" is not going to work here.  Try using "eventtype" or  
"event_type".

Well, let me backtrack a bit: are these existing tables that are  
already used in other projects, or ones that you're creating anew?



--

Paul M. Jones  <http://paul-m-jones.com>

Solar: Simple Object Library and Application Repository
for PHP5.  <http://solarphp.com>

Join the Solar community wiki!  <http://solarphp.org>

Savant: The simple, elegant, and powerful solution for
templates in PHP.  <http://phpsavant.com>