MSM and duplication issue…. |
|||
|---|---|---|---|
| Date: | 05/21/2008 | Severity: | Minor |
| Status: | Resolved | Reporter: | Robin Sowell |
| Version: | EE 1.6.3 | Assigned To: | Not Assigned |
| Keywords: | MySQL Errors | ||
Details
re: http://expressionengine.com/forums/viewthread/79550/P18/#402223
Long thread- boils down to- if you already have custom cat fields created and you duplicate a weblog when creating an MSM site- the exp_category_fields table gets the new rows added ok- but the exp_category_field_data table doesn’t get the new fields to match them added. So- when you go to edit categories on your new msm site, you get a mysql error:
Error Number: 1054
Description: Unknown column 'field_id_3' in 'field list'
Query: UPDATE `exp_category_field_data` SET `field_id_3` = '', `field_ft_3` = 'none' WHERE cat_id = '45'
Because- it’s missing those fields.