Error about non-existing field!

[Mona]

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 cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---