cake_1.2.x.x_6590
postrges 8.3 LOCAL
postgres 8.1.4 REMOTE
I've just noticed that a query is failing when i move an app from my
desktop box to the remote server. It appears that Cake is losing the
result of a previous SELECT. At least, i'm assuming that Cake is
getting a proper result. The query runs just fine on the remote DB.
Everything has been rsynced to the server. I'm confident there are no
diffs anywhere.
This is the query that grabs the foreign keys:
SELECT "GalleryItem"."id" AS "GalleryItem__id",
"GalleryItem"."artist_id" AS "GalleryItem__artist_id" FROM
"gallery_items" AS "GalleryItem" WHERE "GalleryItem"."artist_id" IN
('8');
As i said, this returns a proper result set when run directly. The
GRANTs are all fine. I don't think the problem lies with Postgres.
This is the query Cake is trying to later pass to the DB:
SELECT "GalleryItem"."id" AS "GalleryItem__id",
"GalleryItem"."artist_id" AS "GalleryItem__artist_id",
"GalleryItem"."discipline_id" AS "GalleryItem__discipline_id",
"GalleryItem"."media_type_id" AS "GalleryItem__media_type_id",
"GalleryItem"."created" AS "GalleryItem__created",
"GalleryItem"."modified" AS "GalleryItem__modified",
"GalleryItem"."enabled" AS "GalleryItem__enabled",
"GalleryItem"."date_work_created" AS "GalleryItem__date_work_created",
"GalleryItem"."lang" AS "GalleryItem__lang", "GalleryItem"."title" AS
"GalleryItem__title", "GalleryItem"."slug" AS "GalleryItem__slug",
"GalleryItem"."subject" AS "GalleryItem__subject",
"GalleryItem"."summary" AS "GalleryItem__summary",
"GalleryItem"."description" AS "GalleryItem__description",
"GalleryItem"."publisher" AS "GalleryItem__publisher",
"GalleryItem"."contributor" AS "GalleryItem__contributor",
"GalleryItem"."copyright" AS "GalleryItem__copyright" FROM
"gallery_items" AS "GalleryItem" WHERE "GalleryItem"."id" IN ()
As you can see, the list of IDs has been truncated.
I'm poking around in dbo files to see if i can get Cake to log the
results temporarily so that i can be sure that the initial query is
really returning something. The thing is, I would assume (yeah, I know
...) that Cake wouldn't bother with the later query if the first one
came back empty.
If anyone has any insight into how to go about solving this mystery
I'd really appreciate it.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
