New column in existing table [SOLVED]

[cantlep]

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]

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]

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