2. PHPRunner General questions
  3. errant field during sync
This topic is locked

errant field during sync

 		3/31/2020 5:59:45 PM
PHPRunner General questions
K
 keithh0427 author

I have a table that, for some unknown reason, continues to insist that I have added a field to the table in the database. But I haven't.
If I sync the database, it tells me that I have added a field at the end of the table. When I check the SQL Query, it's not there. If I Reset Query, it's still not there. If I look on the Fields page, it is there. If I go to the Designer page, I can see it there to Add a field to any of the three options.
The funny thing is that the field does exist in the database, but not two of them in the table as PHPRunner suggests.
I'm lost.
N
 		Nir Frumer 3/31/2020

hi

you probably have to fix the sql script on the "query" (i.e 2nd tab, after Query designer)
hope it helps,

Nir.
K
 		keithh0427 author 3/31/2020



hi

you probably have to fix the sql script on the "query" (i.e 2nd tab, after Query designer)
hope it helps,

Nir.


When I look at the Query, it's correct. I've also clicked on the "Reset Query". Nothing changes. The query looks correct without the additional field.