Re: Table Rename Join Error
I finally figured it out. I changed the table name
(scheduler_customers_sheduler_services) but I didn't change the column
names to scheduler_customer_id and scheduler_service_id. Once I did
that it started working again. Thanks again for your help.
On Oct 17, 10:00 am, MDB <[EMAIL PROTECTED]> wrote:
> Okay, here is what I have now and I am no longer getting any error but
> the services for the cusomer are no longer showing.
>
> table customers is now scheduler_customers
> table services is now scheduler_customers
> table customers_services is now scheduler_customers_sheduler_services.
>
> My customer model now looks something like this:
>
> class Customer extends AppModel
> {
> var $name = 'Customer';
> var $useTable = 'scheduler_customers';
>
> var $hasAndBelongsToMany = array(
> 'Service' => array(
> 'className' => 'Service',
> /*
> 'joinTable' => 'customers_services',
> 'foreignKey' => 'customer_id',
> 'associatedForeignKey' => 'service_id',
> */
> 'joinTable' => null,
> 'foreignKey' => null,
> 'associatedForeignKey' => null,
> 'conditions' => null,
> 'fields' => null,
> 'order' => null,
> 'limit' => null,
> 'uniq' => true,
> 'offset' => null,
> 'fnderQuery' => null,
> 'deleteQuery' => null,
> 'insertQuery' => null
> )
> );
>
> }
>
> and my service model looks like this:
>
> class Service extends AppModel
> {
> var $name = 'Service';
> var $useTable = 'scheduler_services';
>
> var $hasAndBelongsToMany = array(
> 'Customer' => array(
> 'className' => 'Customer',
> 'joinTable' =>
> 'scheduler_customers_scheduler_services',
> 'foreignKey' => 'service_id',
> 'associatedForeignKey' => 'customer_id'
> )
> );
>
> }
>
> Once again, in short, I changed the table names and set the useTable
> and now the services no longer show. Not real sure what else I should
> look for?
>
> On Oct 17, 9:28 am, MDB <[EMAIL PROTECTED]> wrote:
>
>
>
> > Thank you, that fixed the error however now the services are not
> > showing for the customer. Is there something else that I am missing?
>
> > On Oct 17, 9:14 am, scs <[EMAIL PROTECTED]> wrote:
>
> > > Cake handles the join table naming convention based off the tables
> > > used, rename your join table to customers_scheduler_services
>
> > > On Oct 17, 8:22 am, MDB <[EMAIL PROTECTED]> wrote:
>
> > > > Being new to cake (became the owner of 2 cakephp applications), I dont
> > > > think I am getting something simple. First, I have three tables,
> > > > customers (PK ID int), services (PK ID int) and then
> > > > customers_services (customer_id int, service_id int). I then have the
> > > > 2 models below. I am in the process of moving this application over
> > > > to another DB and I have to change the tables names so, I first
> > > > changed the services table to scheduler_services and then in the
> > > > service model I changed it to use the correct table name (var
> > > > $useTable = 'scheduler_services'). Once I did this, I am now getting
> > > > this error:
>
> > > > Missing Database Table
> > > > Error: Database table customers_scheduler_services for model
> > > > CustomersSchedulerService was not found.
>
> > > > I am guessing it has something to do with the table join however can
> > > > not figure it out. I changed other table names without a problem
> > > > however this is the only one that has a join to it.
>
> > > > Service Model
>
> > > > class Service extends AppModel
> > > > {
> > > > var $name = 'Service';
> > > > var $useTable = 'scheduler_services';
>
> > > > var $hasAndBelongsToMany = array(
> > > > 'Customer' => array(
> > > > 'className' => 'Customer',
> > > > 'joinTable' => 'customers_services',
> > > > 'foreignKey' => 'service_id',
> > > > 'associatedForeignKey' => 'customer_id'
> > > > )
> > > > );
>
> > > > }
>
> > > > Customer Model
>
> > > > class Customer extends AppModel
> > > > {
> > > > var $name = 'Customer';
> > > > var $actsAs = array('SoftDeletable');
>
> > > > var $hasAndBelongsToMany = array(
> > > > 'Service' => array(
> > > > 'className' => 'Service',
> > > > /*
> > > > 'joinTable' => 'customers_services',
Re: Table Rename Join Error
Okay, here is what I have now and I am no longer getting any error but
the services for the cusomer are no longer showing.
table customers is now scheduler_customers
table services is now scheduler_customers
table customers_services is now scheduler_customers_sheduler_services.
My customer model now looks something like this:
class Customer extends AppModel
{
var $name = 'Customer';
var $useTable = 'scheduler_customers';
var $hasAndBelongsToMany = array(
'Service' => array(
'className' => 'Service',
/*
'joinTable' => 'customers_services',
'foreignKey' => 'customer_id',
'associatedForeignKey' => 'service_id',
*/
'joinTable' => null,
'foreignKey' => null,
'associatedForeignKey' => null,
'conditions' => null,
'fields' => null,
'order' => null,
'limit' => null,
'uniq' => true,
'offset' => null,
'fnderQuery' => null,
'deleteQuery' => null,
'insertQuery' => null
)
);
}
and my service model looks like this:
class Service extends AppModel
{
var $name = 'Service';
var $useTable = 'scheduler_services';
var $hasAndBelongsToMany = array(
'Customer' => array(
'className' => 'Customer',
'joinTable' => 'scheduler_customers_scheduler_services',
'foreignKey' => 'service_id',
'associatedForeignKey' => 'customer_id'
)
);
}
Once again, in short, I changed the table names and set the useTable
and now the services no longer show. Not real sure what else I should
look for?
On Oct 17, 9:28 am, MDB <[EMAIL PROTECTED]> wrote:
> Thank you, that fixed the error however now the services are not
> showing for the customer. Is there something else that I am missing?
>
> On Oct 17, 9:14 am, scs <[EMAIL PROTECTED]> wrote:
>
>
>
> > Cake handles the join table naming convention based off the tables
> > used, rename your join table to customers_scheduler_services
>
> > On Oct 17, 8:22 am, MDB <[EMAIL PROTECTED]> wrote:
>
> > > Being new to cake (became the owner of 2 cakephp applications), I dont
> > > think I am getting something simple. First, I have three tables,
> > > customers (PK ID int), services (PK ID int) and then
> > > customers_services (customer_id int, service_id int). I then have the
> > > 2 models below. I am in the process of moving this application over
> > > to another DB and I have to change the tables names so, I first
> > > changed the services table to scheduler_services and then in the
> > > service model I changed it to use the correct table name (var
> > > $useTable = 'scheduler_services'). Once I did this, I am now getting
> > > this error:
>
> > > Missing Database Table
> > > Error: Database table customers_scheduler_services for model
> > > CustomersSchedulerService was not found.
>
> > > I am guessing it has something to do with the table join however can
> > > not figure it out. I changed other table names without a problem
> > > however this is the only one that has a join to it.
>
> > > Service Model
>
> > > class Service extends AppModel
> > > {
> > > var $name = 'Service';
> > > var $useTable = 'scheduler_services';
>
> > > var $hasAndBelongsToMany = array(
> > > 'Customer' => array(
> > > 'className' => 'Customer',
> > > 'joinTable' => 'customers_services',
> > > 'foreignKey' => 'service_id',
> > > 'associatedForeignKey' => 'customer_id'
> > > )
> > > );
>
> > > }
>
> > > Customer Model
>
> > > class Customer extends AppModel
> > > {
> > > var $name = 'Customer';
> > > var $actsAs = array('SoftDeletable');
>
> > > var $hasAndBelongsToMany = array(
> > > 'Service' => array(
> > > 'className' => 'Service',
> > > /*
> > > 'joinTable' => 'customers_services',
> > > 'foreignKey' => 'customer_id',
> > > 'associatedForeignKey' => 'service_id',
> > > */
> > > 'joinTable' => null,
> > > 'foreignKey' => null,
> > > 'associatedForeignKey' => null,
> > > 'conditions' => null,
> > > 'fields' => null,
> > > 'order' => null,
> > > 'limit'
Re: Table Rename Join Error
Thank you, that fixed the error however now the services are not
showing for the customer. Is there something else that I am missing?
On Oct 17, 9:14 am, scs <[EMAIL PROTECTED]> wrote:
> Cake handles the join table naming convention based off the tables
> used, rename your join table to customers_scheduler_services
>
> On Oct 17, 8:22 am, MDB <[EMAIL PROTECTED]> wrote:
>
>
>
> > Being new to cake (became the owner of 2 cakephp applications), I dont
> > think I am getting something simple. First, I have three tables,
> > customers (PK ID int), services (PK ID int) and then
> > customers_services (customer_id int, service_id int). I then have the
> > 2 models below. I am in the process of moving this application over
> > to another DB and I have to change the tables names so, I first
> > changed the services table to scheduler_services and then in the
> > service model I changed it to use the correct table name (var
> > $useTable = 'scheduler_services'). Once I did this, I am now getting
> > this error:
>
> > Missing Database Table
> > Error: Database table customers_scheduler_services for model
> > CustomersSchedulerService was not found.
>
> > I am guessing it has something to do with the table join however can
> > not figure it out. I changed other table names without a problem
> > however this is the only one that has a join to it.
>
> > Service Model
>
> > class Service extends AppModel
> > {
> > var $name = 'Service';
> > var $useTable = 'scheduler_services';
>
> > var $hasAndBelongsToMany = array(
> > 'Customer' => array(
> > 'className' => 'Customer',
> > 'joinTable' => 'customers_services',
> > 'foreignKey' => 'service_id',
> > 'associatedForeignKey' => 'customer_id'
> > )
> > );
>
> > }
>
> > Customer Model
>
> > class Customer extends AppModel
> > {
> > var $name = 'Customer';
> > var $actsAs = array('SoftDeletable');
>
> > var $hasAndBelongsToMany = array(
> > 'Service' => array(
> > 'className' => 'Service',
> > /*
> > 'joinTable' => 'customers_services',
> > 'foreignKey' => 'customer_id',
> > 'associatedForeignKey' => 'service_id',
> > */
> > 'joinTable' => null,
> > 'foreignKey' => null,
> > 'associatedForeignKey' => null,
> > 'conditions' => null,
> > 'fields' => null,
> > 'order' => null,
> > 'limit' => null,
> > 'uniq' => true,
> > 'offset' => null,
> > 'fnderQuery' => null,
> > 'deleteQuery' => null,
> > 'insertQuery' => null
> > )
> > );
>
> > }
>
> > If anyone can help I would greatly appreciate it.- Hide quoted text -
>
> - Show quoted text -
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---
Re: Table Rename Join Error
Cake handles the join table naming convention based off the tables
used, rename your join table to customers_scheduler_services
On Oct 17, 8:22 am, MDB <[EMAIL PROTECTED]> wrote:
> Being new to cake (became the owner of 2 cakephp applications), I dont
> think I am getting something simple. First, I have three tables,
> customers (PK ID int), services (PK ID int) and then
> customers_services (customer_id int, service_id int). I then have the
> 2 models below. I am in the process of moving this application over
> to another DB and I have to change the tables names so, I first
> changed the services table to scheduler_services and then in the
> service model I changed it to use the correct table name (var
> $useTable = 'scheduler_services'). Once I did this, I am now getting
> this error:
>
> Missing Database Table
> Error: Database table customers_scheduler_services for model
> CustomersSchedulerService was not found.
>
> I am guessing it has something to do with the table join however can
> not figure it out. I changed other table names without a problem
> however this is the only one that has a join to it.
>
> Service Model
>
> class Service extends AppModel
> {
> var $name = 'Service';
> var $useTable = 'scheduler_services';
>
> var $hasAndBelongsToMany = array(
> 'Customer' => array(
> 'className' => 'Customer',
> 'joinTable' => 'customers_services',
> 'foreignKey' => 'service_id',
> 'associatedForeignKey' => 'customer_id'
> )
> );
>
> }
>
> Customer Model
>
> class Customer extends AppModel
> {
> var $name = 'Customer';
> var $actsAs = array('SoftDeletable');
>
> var $hasAndBelongsToMany = array(
> 'Service' => array(
> 'className' => 'Service',
> /*
> 'joinTable' => 'customers_services',
> 'foreignKey' => 'customer_id',
> 'associatedForeignKey' => 'service_id',
> */
> 'joinTable' => null,
> 'foreignKey' => null,
> 'associatedForeignKey' => null,
> 'conditions' => null,
> 'fields' => null,
> 'order' => null,
> 'limit' => null,
> 'uniq' => true,
> 'offset' => null,
> 'fnderQuery' => null,
> 'deleteQuery' => null,
> 'insertQuery' => null
> )
> );
>
> }
>
> If anyone can help I would greatly appreciate it.
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---
