2. PHPRunner General questions
  3. SQL Editor keeps loosing table references.
This topic is locked

SQL Editor keeps loosing table references.

 		3/9/2016 9:49:05 AM
PHPRunner General questions
K
 kamil6x author

I use joins in manual sql queries; save the project and build and everything is fine.

Then I exit phprunner and restart it, open the project and try to edit the manual SQL query and get the error

"Column 'YYYY' in field list is ambiguous".
Basically PHPRunner removes all the table prefixes from the manually entered SQL and I have to add back all the prefixes.
This happens after every restart of PHPRunner.
PHPRunner 8.0 (Build 22849 x86)
P.S. when checking the PHPRunner xml project file there are major changes in many places; even if I only change 1 sql query.
Sergey Kornilov admin 3/9/2016

Try the latest build of PHPRunner. If this issue is still happening contact support directly sending your database structure and SQL Query in question so we can suggest a workaround.