Have you told cake about your non-standard primary key? Add em like
this in your models.
class Booking extends AppModel {
var $name = 'Booking';
var $primaryKey = 'b_id';
... etc ...
}
Cheers,
Adam
On May 29, 3:51 pm, Sanfly <[EMAIL PROTECTED]> wrote:
> Hi
>
> Im trying to run two loops in one of my scripts to insert information
> into my database and running into the same problem for both of them.
> The info inserts into the database exactly as I would expect, but on
> my view it throws me the errors below, and I cant figure out why
> because I dont see why it should be trying to do that particular query
> - I havent asked it to (so far as I know, but I'm a noob and I still
> dont really get cake...)
>
> My databases are a carry on from a previous system and not exactly
> classically named: eg: my primary key for one is 'db_id' and the
> other is 'b_id' rather than them both just being 'id'.
>
> In this particular example i have three inserts/saves in my loop, and
> the error is only thrown for the first two 'bookings'. If I change my
> database naming, so 'b_id' is now just 'id', then I dont get any
> errors, but only the last (third) booking is inserted into the
> database.
>
> Does anyone know how to solve this problem? Or at the very least hide
> the errors in my view?
>
> Im hoping cake will make my life easier in the long run, but so far
> its taken me a week to do something that would have taken me less than
> a day in native PHP!!!
>
> The Errors eg:
>
> Query: SELECT COUNT(id) AS count FROM `bookings` WHERE `id` = 42
> Warning: SQL Error: 1054: Unknown column 'id' in 'field list' in G:
> \WAMP\www\UASC Sourceforge\trunk\cake\libs\model\datasources
> \dbo_source.php on line 440
>
> Query: SELECT COUNT(id) AS count FROM `bookings` WHERE `id` = 43
> Warning: SQL Error: 1054: Unknown column 'id' in 'field list' in G:
> \WAMP\www\UASC Sourceforge\trunk\cake\libs\model\datasources
> \dbo_source.php on line 440
>
> The foreach loop:
>
> foreach($this->data['Booking'] as $theBooking){
> $theBooking['b_created_at'] = date("Y-m-d H:i:s");
> $theBooking['b_booking_group_id'] = $booking_group_id;
> $this->Booking->save($theBooking);
>
> }
>
> $this->data['Booking'] is an array that comes from my form on the
> previous page, eg:
>
> <input type="hidden" name="data[Booking][1][b_name]" value="<? echo
> $members['Member']['first_name'] . " " . $members['Member']
> ['last_name']; ?>" />
> <input type="hidden"
> name="data[Booking][1][b_contact_phone]"
> value="<? echo $members['Member']['phone']; ?>" />
> <input type="hidden"
> name="data[Booking][1][b_member_no]"
> value="<? echo $members['Member']['id']; ?>" />
> <input type="hidden"
> name="data[Booking][1][b_member_group]"
> value="<? echo $members['Member']['member_group_id']; ?>" />
> <input type="hidden"
> name="data[Booking][1][b_is_contact_person]"
> value="1" />
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
