Have you tried deleting all the files in /tmp/cache/models/, I have
had similar problems and it ended up being these files. If you delete
all of them, cake will reproduce them the next time a page is loaded
with the current database schema. I now do this when ever I change
anything in the database.
On Oct 24, 2:53 am, Mona <[EMAIL PROTECTED]> wrote:
> Hi:
>
> I'm using version 1.1.19 and I keep getting a runtime error message
> about a non-existing field:
>
> Warning: pg_query() [function.pg-query]: Query failed: ERROR: column
> Organization.organization does not exist in /misc/www/projects/test/
> mona/cake/libs/model/dbo/dbo_postgres.php on line 123
>
> Query: SELECT "Organization"."id" AS "Organization__id",
> "Organization"."organization" AS "Organization__organization",
> "Organization"."organization_id" AS "Organization__organization_id",
> "Organization"."name" AS "Organization__name",
> "Organization"."org_type_id" AS "Organization__org_type_id",
> "Organization"."organization_abbrev" AS
> "Organization__organization_abbrev",
> "Organization"."organization_name" AS
> "Organization__organization_name", "Organization"."state" AS
> "Organization__state", "Organization"."country" AS
> "Organization__country", "Organization"."organization_url" AS
> "Organization__organization_url", "Organization"."city" AS
> "Organization__city", "Organization"."organization_phone" AS
> "Organization__organization_phone", "Organization"."nsf_org_code" AS
> "Organization__nsf_org_code", "Organization"."is_reconciled" AS
> "Organization__is_reconciled", "Organization"."amie_name" AS
> "Organization__amie_name", "Organization"."country_id" AS
> "Organization__country_id", "Organization"."state_id" AS
> "Organization__state_id" FROM "organizations" AS "Organization" WHERE
> 1 = 1
> Warning: SQL Error: ERROR: column Organization.organization does not
> exist in /misc/www/projects/test/mona/cake/libs/model/datasources/
> dbo_source.php on line 440
>
> The field "organization" has been removed from the table and all the
> MVC code, but I am still getting this error message and I don't know
> why. Is something cached somewhere? I've checked my code over and
> over and over again and I don't make any references to that field
> anywhere.
>
> I just don't know what the problem is. All help is appreciated!
>
> Here is my organization.php:
>
> <?php
>
> class Organization extends AppModel
> {
> var $name = 'Organization';
>
> var $useTable = "organizations";
>
> var $validate = array ( 'name' => VALID_NOT_EMPTY,
> 'state' => VALID_NOT_EMPTY,
> 'country' => VALID_NOT_EMPTY,
> 'city' => VALID_NOT_EMPTY );
>
> }
>
> ?>
>
> Here is my index.html:
>
> <?php $this->layout = 'list'; ?>
>
> <center>
> <h3>Organizations</h3>
> <table border="1" cellpadding="8">
> <tr>
> <th>IDx</th>
> <th>Name</th>
> <th>City</th>
> <th>State</th>
> <th>Country</th>
> </tr>
> <?php foreach ( $organizations as $organization ): ?>
> <tr>
> <td><?php echo $organization['Organization']['id']; ?></td>
>
> <td><?php echo $organization['Organization']['name']; ?></td>
>
> <td><?php echo $organization['Organization']
> ['state']; ?></td>
> <td><?php echo $organization['Organization']
> ['country']; ?></td>
> <td><?php echo $organization['Organization']['city']; ?></td>
>
> </tr>
> <?php endforeach; ?>
> </table>
> </center>
>
> Here is my organizations_controller.php:
>
> <?php
>
> class OrganizationsController extends AppController
> {
> var $name = 'Organizations';
>
> function index()
> {
> $this->set ( 'organizations', $this->Organization->findAll() );
>
> }
>
> }
>
> ?>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
