This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I'm receiving the following error on LightSpeed 3.0: "ERROR: 42P01: missing FROM-clause entry for table \"xxx\"" The generated Query is (SQL): SELECTg1.nameFROM(SELECT"yyy"."name"FROM"xxx"."xxx" "xxx"INNER JOIN"xxx"."yyy"ON"xxx"."yyy_id" = "yyy"."yyy_id"WHERENOT (EXISTS (SELECT"yyy".*FROM"xxx"."yyy"WHERE"yyy"."yyy_id" = "xxx"."yyy_id" AND"yyy"."name" IS NULL))GROUP BY"yyy"."name")"g1"INNER JOIN"xxx"."yyy"ON"xxx"."yyy_id" = "yyy"."yyy_id"ORDER BYg1.name |
|
|
Is it possible for you to post the (suitably sanitised) code of the original query? Just makes it easier for us to repro than reconstructing the query from the debug view. Thanks! |
|
|
Also could you check if there is any mismatch in the casing between the table names being specified in the query and how they are represented in the database? (I am presuming that they would be defined correctly in the Table attributes in the Model definition).
Jeremy |
|
|
Hi guys, the table names are encoded just fine. Unfortunately it won't be too easy to share this project with you guys. I'll contact you directly via e-mail to perhaps make this happen.
|
|
|
Don't worry about the repro then -- I've reconstructed the query from the debug trace and reproduced the error here, so we can now get an investigation and fix under way. |
|
|
We've committed a fix for this based on your sanitised repro, and it's available in the current nightly build. Let us know if the error still occurs in your real scenario. |
|