Menu
▾
▴
#2754 (ok 3.1) Can't edit row in VIEW
fixed
1
2013-06-11
2008-09-03
No
A simple VIEW that JOINs two tables can be viewed but not edited. An edit icon is present, but upon clicking edit, the error message is as follows:
Unknown column 'domain.id' in 'where clause'
Indeed, there is no such column "domain.id" in the VIEW, though this column is present in one of the underlying tables.
It appears PMA is referring to columns in the underlying tables instead of columns in the VIEW.
Discussion
SQL to re-create database with 3 tables
Fixed in subversion, thanks for reporting.