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

[Kilbride, James P.]

Paul,

I just took my guys code and played with this. I have two seperate
models, one pointing to one db, the other to a different one. One has a
table called asset, which it is fine with, and the code looks exactly
the same between the two tables except I change the table name from one
to the other. Don't even take the view into account and it seems to fail
only on the one they listed below. Looking at the error I'm wondering if
when we created the table in Mysql could we have created the database
with the 'wrong' type of mysql database so it's not recognizing it for
some reason? We're using InnoDB or not or something?

James Kilbride 

-----Original Message-----
From: solar-talk-bounces at lists.solarphp.com
[mailto:solar-talk-bounces at lists.solarphp.com] On Behalf Of Paul M Jones
Sent: Tuesday, November 13, 2007 1:31 PM
To: solar-talk at lists.solarphp.com
Subject: Re: [Solar-talk] Fatal error: Uncaught
exception'Solar_Controller_Page_Exception_DuringFetch' error

On Nov 13, 2007, at 12:17 PM, Walker, Jason T. wrote:
> When we try to load up the page we're gettin the following error 
> displayed in the browser:
> 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.'
...
> Is there a reason why Solar is trying to create a new table in our 
> database when the table already exists?

I'm sure there is, but not sure what it'd be.  Some things to try out:

1.  Try using a minimal script and instantiating the model in that,
instead of the full App system.  E.g., "test.php" with only a
Solar::start() and Solar::factory('MYSQLDB_Models_Asset') call.  That
will tell us if it's something about the model class, or if it's related
to the controller.

2. Is your controller descended from Solar_App, or directly from
Solar_Controller_Page?

3. I see you're using all caps for your table names; it might be related
to that somehow.  IIRC, you guys are going to move to Oracle after
setting up on MySQL, but even then the all-caps shouldn't matter at the
Solar level.  Try using lower-case for that stuff if you can.

That's just off-hand; happy to keep talking about it to nail down the
problem.



--

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>


_______________________________________________
Solar-talk mailing list
Solar-talk at lists.solarphp.com
http://mailman-mail3.webfaction.com/listinfo/solar-talk