Error Renaming Fields

PtrNrs

Member
In order to conform to my field naming convention, when creating tables in Fabrik, I rename . . .

  • field "id" to pfxID";
  • field "date_time" to "pfxEntered"
. . . where pfx is the chosen prefix for the table.

On adding data to the list, I get this error . . .
Store row failed:
Unknown column 'recEntered' in 'field list' SQL=INSERT INTO `jos_ssc_record` ( `recEntered`,`recTitle` ) VALUES ( '2011-03-07 00:00:00','Masterpieces' )
The cause is that, on renaming the field, the field name is updated in jos_fabrik_elements but not in the custom table (in this case jos_ssc_record).
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top