We had some custom work done a while back. The first guy completely left us hanging. The second guy got it mostly working, but never really got it working 100%.
So, here is one of the problems...
When I run repair/rebuild. it generates this error.
/* Table : raz_payments */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - currency_id - ROW [name] => 'currency_id' [type] => 'char' [len] => '36' */
/* VARDEF - currency_id - ROW[required] => '' [name] => 'currency_id' [vname] => 'LBL_CURRENCY' [type] => 'char' [massupdate] => '0' [comments] => '' [help] => '' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '0' [reportable] => '0' [len] => '255' [studio] => 'visible' [function] => 'Array' [dbType] => 'id' */
/* INDEXES */
ALTER TABLE raz_payments modify column currency_id char(36) NUL
Can someone suggest the best way to fix this. Should I modify the table or per the error msg suggestion.
It won't do it on it's own.
running 5.1 on shared webhost.
Thanks,
Steve


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks