[ic] "Cannot merge metadata -- column(s) 'extended, default' is missing in table mv_metadata"

[Paul Jordan]

Mike Heins [mike at perusion.com] wrote:
> Quoting Art (art at alpentech.net):
>> Upgraded from 4.8.7 to 4.9.8 during a major server move.
>> Everything _seems_ to be working now, except it doesn't seem to be
>> using bulk pricing even though it's all filled in as before, all
>> data seems imported without too much trouble, but the main menu upon
>> login shows:
>> UI update appears to have been done and metadata has not been
>>     updated for this catalog... Merge Metadata
>>
>> So, performing the Merge Metadata causes the following error message:
>> Merge run, UI version 4.9.8, metadata version 4.8.7
>>         Cannot merge metadata -- column(s) 'extended,default' is
>> missing in table mv_metadata. Items to merge
>>
>
> Fire up your text editor, edit CATDIR/products/mv_metadata.asc, and
> add those two fields (extended and default) to the first line. That
> is all.

Yes, sorry, I should have mentioned more. DON'T edit this on windows and ftp it
back up. Use vi or some such. 99% this file will have newlines and/or carriage
returns, html, javascript, etc. Also, check the columns first... I had the same
error, but 'default' was already in there. (it may have just been my particular
store at the time) but I just put extended in and it went away. Also... add
those two fields at the end (right) of the column listing and separate them
with tabs.

hth
Paul