if you're using adodb for database connection, i have filed the error on trac https://trac.cakephp.org/ticket/4130 and the suggested fix.
On May 15, 3:21 am, TracyB <[EMAIL PROTECTED]> wrote: > I have a model using a table that's been around forever, so it's not a > CakePHP friendly name. My model is set up like so: > > class Quote extends AppModel > { > var $name = 'Quote'; > var $useTable = 'BillOfMaterial'; > var $primaryKey = 'BillID'; > var $useDbConfig = 'design'; > > When I do a $this->Quote->findAll() or $this->paginate('Quote'), this > is the query that gets generated: > > SELECT "Quote"."BillID" AS "Quote__BillID" AS "Quote"__"BillID" AS > "Quote__BillID" AS "Quote"__"BillID" AS "Quote__BillID" AS > "Quote"__"BillID" AS "Quote__BillID", "Quote"."JobNumber" AS > "Quote__JobNumber" AS "Quote"__"JobNumber" AS "Quote__JobNumber" AS > "Quote"__"JobNumber" AS "Quote__JobNumber" AS "Quote"__"JobNumber" AS > "Quote__JobNumber", "Quote"."Phase" AS "Quote__Phase" AS > "Quote"__"Phase" AS "Quote__Phase" AS "Quote"__"Phase" AS > "Quote__Phase" AS "Quote"__"Phase" AS "Quote__Phase", > "Quote"."QuoteNumber" AS "Quote__QuoteNumber" AS > "Quote"__"QuoteNumber" AS "Quote__QuoteNumber" AS > "Quote"__"QuoteNumber" AS "Quote__QuoteNumber" AS > "Quote"__"QuoteNumber" AS "Quote__QuoteNumber", "Quote"."Division" AS > "Quote__Division" AS "Quote"__"Division" AS "Quote__Division" AS > "Quote"__"Division" AS "Quote__Division" AS "Quote"__"Division" AS > "Quote__Division", "Quote"."Project" AS "Quote__Project" AS > "Quote"__"Project" AS "Quote__Project" AS "Quote"__"Project" AS > "Quote__Project" AS "Quote"__"Project" AS "Quote__Project", > "Quote"."CustID" AS "Quote__CustID" AS "Quote"__"CustID" AS > "Quote__CustID" AS "Quote"__"CustID" AS "Quote__CustID" AS > "Quote"__"CustID" AS "Quote__CustID", "Quote"."Purchaser" AS > "Quote__Purchaser" AS "Quote"__"Purchaser" AS "Quote__Purchaser" AS > "Quote"__"Purchaser" AS "Quote__Purchaser" AS "Quote"__"Purchaser" AS > "Quote__Purchaser", "Quote"."Attn" AS "Quote__Attn" AS "Quote"__"Attn" > AS "Quote__Attn" AS "Quote"__"Attn" AS "Quote__Attn" AS > "Quote"__"Attn" AS "Quote__Attn", "Quote"."Fax" AS "Quote__Fax" AS > "Quote"__"Fax" AS "Quote__Fax" AS "Quote"__"Fax" AS "Quote__Fax" AS > "Quote"__"Fax" AS "Quote__Fax", "Quote"."Phone" AS "Quote__Phone" AS > "Quote"__"Phone" AS "Quote__Phone" AS "Quote"__"Phone" AS > "Quote__Phone" AS "Quote"__"Phone" AS "Quote__Phone", "Quote"."Cell" > AS "Quote__Cell" AS "Quote"__"Cell" AS "Quote__Cell" AS > "Quote"__"Cell" AS "Quote__Cell" AS "Quote"__"Cell" AS "Quote__Cell", > "Quote"."CustPO" AS "Quote__CustPO" AS "Quote"__"CustPO" AS > "Quote__CustPO" AS "Quote"__"CustPO" AS "Quote__CustPO" AS > "Quote"__"CustPO" AS "Quote__CustPO", "Quote"."IsOrder" AS > "Quote__IsOrder" AS "Quote"__"IsOrder" AS "Quote__IsOrder" AS > "Quote"__"IsOrder" AS "Quote__IsOrder" AS "Quote"__"IsOrder" AS > "Quote__IsOrder", "Quote"."IncludeDelivery" AS > "Quote__IncludeDelivery" AS "Quote"__"IncludeDelivery" AS > "Quote__IncludeDelivery" AS "Quote"__"IncludeDelivery" AS > "Quote__IncludeDelivery" AS "Quote"__"IncludeDelivery" AS > "Quote__IncludeDelivery", "Quote"."IncludeGST" AS "Quote__IncludeGST" > AS "Quote"__"IncludeGST" AS "Quote__IncludeGST" AS > "Quote"__"IncludeGST" AS "Quote__IncludeGST" AS "Quote"__"IncludeGST" > AS "Quote__IncludeGST", "Quote"."IncludePST" AS "Quote__IncludePST" AS > "Quote"__"IncludePST" AS "Quote__IncludePST" AS "Quote"__"IncludePST" > AS "Quote__IncludePST" AS "Quote"__"IncludePST" AS > "Quote__IncludePST", "Quote"."IncludeHST" AS "Quote__IncludeHST" AS > "Quote"__"IncludeHST" AS "Quote__IncludeHST" AS "Quote"__"IncludeHST" > AS "Quote__IncludeHST" AS "Quote"__"IncludeHST" AS > "Quote__IncludeHST", "Quote"."Delivery" AS "Quote__Delivery" AS > "Quote"__"Delivery" AS "Quote__Delivery" AS "Quote"__"Delivery" AS > "Quote__Delivery" AS "Quote"__"Delivery" AS "Quote__Delivery", > "Quote"."GST" AS "Quote__GST" AS "Quote"__"GST" AS "Quote__GST" AS > "Quote"__"GST" AS "Quote__GST" AS "Quote"__"GST" AS "Quote__GST", > "Quote"."PST" AS "Quote__PST" AS "Quote"__"PST" AS "Quote__PST" AS > "Quote"__"PST" AS "Quote__PST" AS "Quote"__"PST" AS "Quote__PST", > "Quote"."HST" AS "Quote__HST" AS "Quote"__"HST" AS "Quote__HST" AS > "Quote"__"HST" AS "Quote__HST" AS "Quote"__"HST" AS "Quote__HST", > "Quote"."AppliedDiscount" AS "Quote__AppliedDiscount" AS > "Quote"__"AppliedDiscount" AS "Quote__AppliedDiscount" AS > "Quote"__"AppliedDiscount" AS "Quote__AppliedDiscount" AS > "Quote"__"AppliedDiscount" AS "Quote__AppliedDiscount", > "Quote"."LastModified" AS "Quote__LastModified" AS > "Quote"__"LastModified" AS "Quote__LastModified" AS > "Quote"__"LastModified" AS "Quote__LastModified" AS > "Quote"__"LastModified" AS "Quote__LastModified", > "Quote"."LastModifiedBy" AS "Quote__LastModifiedBy" AS > "Quote"__"LastModifiedBy" AS "Quote__LastModifiedBy" AS > "Quote"__"LastModifiedBy" AS "Quote__LastModifiedBy" AS > "Quote"__"LastModifiedBy" AS "Quote__LastModifiedBy", "Quote"."Notes" > AS "Quote__Notes" AS "Quote"__"Notes" AS "Quote__Notes" AS > "Quote"__"Notes" AS "Quote__Notes" AS "Quote"__"Notes" AS > "Quote__Notes", "Quote"."FreightOption" AS "Quote__FreightOption" AS > "Quote"__"FreightOption" AS "Quote__FreightOption" AS > "Quote"__"FreightOption" AS "Quote__FreightOption" AS > "Quote"__"FreightOption" AS "Quote__FreightOption", > "Quote"."ShipWithJob" AS "Quote__ShipWithJob" AS > "Quote"__"ShipWithJob" AS "Quote__ShipWithJob" AS > "Quote"__"ShipWithJob" AS "Quote__ShipWithJob" AS > "Quote"__"ShipWithJob" AS "Quote__ShipWithJob", "Quote"."WantDate" AS > "Quote__WantDate" AS "Quote"__"WantDate" AS "Quote__WantDate" AS > "Quote"__"WantDate" AS "Quote__WantDate" AS "Quote"__"WantDate" AS > "Quote__WantDate", "Quote"."USFunds" AS "Quote__USFunds" AS > "Quote"__"USFunds" AS "Quote__USFunds" AS "Quote"__"USFunds" AS > "Quote__USFunds" AS "Quote"__"USFunds" AS "Quote__USFunds", > "Quote"."Exchange" AS "Quote__Exchange" AS "Quote"__"Exchange" AS > "Quote__Exchange" AS "Quote"__"Exchange" AS "Quote__Exchange" AS > "Quote"__"Exchange" AS "Quote__Exchange", "Quote"."RepFee" AS > "Quote__RepFee" AS "Quote"__"RepFee" AS "Quote__RepFee" AS > "Quote"__"RepFee" AS "Quote__RepFee" AS "Quote"__"RepFee" AS > "Quote__RepFee", "Quote"."PaymentTerms" AS "Quote__PaymentTerms" AS > "Quote"__"PaymentTerms" AS "Quote__PaymentTerms" AS > "Quote"__"PaymentTerms" AS "Quote__PaymentTerms" AS > "Quote"__"PaymentTerms" AS "Quote__PaymentTerms", "Quote"."QSRRef" AS > "Quote__QSRRef" AS "Quote"__"QSRRef" AS "Quote__QSRRef" AS > "Quote"__"QSRRef" AS "Quote__QSRRef" AS "Quote"__"QSRRef" AS > "Quote__QSRRef", "Quote"."CreatedOn" AS "Quote__CreatedOn" AS > "Quote"__"CreatedOn" AS "Quote__CreatedOn" AS "Quote"__"CreatedOn" AS > "Quote__CreatedOn" AS "Quote"__"CreatedOn" AS "Quote__CreatedOn", > "Quote"."BookedOn" AS "Quote__BookedOn" AS "Quote"__"BookedOn" AS > "Quote__BookedOn" AS "Quote"__"BookedOn" AS "Quote__BookedOn" AS > "Quote"__"BookedOn" AS "Quote__BookedOn", "Quote"."CreatedBy" AS > "Quote__CreatedBy" AS "Quote"__"CreatedBy" AS "Quote__CreatedBy" AS > "Quote"__"CreatedBy" AS "Quote__CreatedBy" AS "Quote"__"CreatedBy" AS > "Quote__CreatedBy", "Quote"."BookedBy" AS "Quote__BookedBy" AS > "Quote"__"BookedBy" AS "Quote__BookedBy" AS "Quote"__"BookedBy" AS > "Quote__BookedBy" AS "Quote"__"BookedBy" AS "Quote__BookedBy", > "Quote"."AMID" AS "Quote__AMID" AS "Quote"__"AMID" AS "Quote__AMID" AS > "Quote"__"AMID" AS "Quote__AMID" AS "Quote"__"AMID" AS "Quote__AMID", > "Quote"."Site" AS "Quote__Site" AS "Quote"__"Site" AS "Quote__Site" AS > "Quote"__"Site" AS "Quote__Site" AS "Quote"__"Site" AS "Quote__Site", > "Quote"."UoM" AS "Quote__UoM" AS "Quote"__"UoM" AS "Quote__UoM" AS > "Quote"__"UoM" AS "Quote__UoM" AS "Quote"__"UoM" AS "Quote__UoM", > "Quote"."BillID" AS "Quote__BillID" AS "Quote"__"BillID" AS > "Quote__BillID", "Quote"."BillID" AS "Quote__BillID" FROM > "BillOfMaterial" AS "Quote" WHERE "IsOrder" = 0 ORDER BY > "Quote"."CreatedOn" desc LIMIT 25 > > Does anyone know what is causing it to try to ALIAS every single field > 6 times to the same name? It's causing my database to choke and I > don't get any results. > > Thanks in advance, > Tracy Barker --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---