2. PHPRunner General questions
  3. [SOLVED]  Unknown column 'nameofthefield' in 'field list'
This topic is locked
[SOLVED]

 Unknown column 'nameofthefield' in 'field list'

 		1/20/2010 2:30:29 AM
PHPRunner General questions
P
 plemax author

I am trying to build an interface for my DB, by using your demo software.

Very simple DB.
Tables:

Customer,

Address,

Donation,

Subscription.
I need to have Customer with rest of the tables joined. If I setup a Query, so fields from Address, Donation, Subscription shows up in the same web form with the Customer, I am getting an error Unknown column 'Address' in 'field list' if I am trying to save the data.

I do have primary and foreign keys in tables and query relations setup correctly with ID for every key. What do I do wrong and how to do this correctly? Thank you if you could explain to me this basics.
Sergey Kornilov admin 1/20/2010

You cannot edit fields from joined tables. To resolve this remove joined field from the Edit page ('Choose fields' screen in PHPRunner).
P
 		plemax author 1/20/2010



You cannot edit fields from joined tables. To resolve this remove joined field from the Edit page ('Choose fields' screen in PHPRunner).



I did and getting the same error.
J
 		Jane 1/21/2010

It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.