MySQL Forums
Forum List  »  Newbie

Unknown column 'p.insurance_id' in 'on clause'
Posted by: Jonathan Blum
Date: January 06, 2006 11:55AM

Hi folks,

The other day we updated our live server with the latest stable release for fbsd, release 5.0.18, and we began to get 'unknown column in on clause' errors, error code #1054. At first I thought it was a problem with the installation, but I duplicated the exact errors on my personal windows xp pro pc by upgrading to release 5.0.18 from 5.0.11. On another query we get the following error: Line 258: Unknown column 'p.insurance_id' in 'on clause'. We tried creating a new field, called insurance_id_02, in the patient table and changing the code to look for that field instead of the p.insurance_id field in the on clauses, but mysql returned the same error. Any help would be greatly appreciated. I don't know if this is a bug in the new release or a strange quirk in our db.

Thank you,


Options: ReplyQuote

Written By
Unknown column 'p.insurance_id' in 'on clause'
January 06, 2006 11:55AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.