2. PHPRunner General questions
  3. Error in Lookup menu
This topic is locked

Error in Lookup menu

 		4/30/2011 12:42:13 PM
PHPRunner General questions
P
 PhprFan author

Hello.

I added a lookup menu in add form to get another table field value trhu id, but when saving record error appears "Unknown column 'tablex.fieldx' in 'field list'. Previewing in Lookup works and all relations are set up... what can it be ?!
Sergey Kornilov admin 4/30/2011

If you join several tables in SQL query make sure fields from joined tables don't appear on Add/Edit pages.
If this doesn't help post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
P
 		PhprFan author 4/30/2011



If you join several tables in SQL query make sure fields from joined tables don't appear on Add/Edit pages.
If this doesn't help post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.


There are only two joined tables and i only have one of the tables fields for Add/Edit. Error persists.

I proceeded as you instructed and alredy sent a ticket, regards.