New column in existing table [SOLVED]

Archived from the Xataface Users forum.

cantlep — Wed Mar 17, 2010 7:44 am

Hiya all,

I’ve added a new column to an existing table and now, when I go to index.php?-table=tablename I get this error

Code: Select all

Error: Could not load current record: Unknown column tablename.columnname

Is it not possible to add new columns to existing tables once Xataface “knows” about it?

Cheers

Paul

---

shannah — Wed Mar 17, 2010 8:03 am

I have noticed this on some installs but don’t know why it is happening
the problem
is xataface uses views to cache custom queries and in some installs the views don’t auto update when the underlying tables are changed.

You can fix this by deleting al views named dataface__view_xxx

---

cantlep — Wed Mar 17, 2010 8:09 am

Hiya Steve,

Cheers for the uber quick reply. yeah, that sorted it. In case it helps, my entry for views in phpMyAdmin looked like this

Code: Select all

Table                                                                                       Action  Records 1  Type  Collation  Size  Overhead dataface__view_Customers_e513cea1f5bc17f6e064b39d30ea631b            ~02 View --- -  -

Although I notice it’s re-created it straight away with the same details so I guess that doesn’t help you figure out why it happens in the first place

Thanks for your help as always.

Cheers

Paul