[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Solved! Re: [ic] I busted flex_select, help!
Barry Treahy, Jr. wrote:
> Barry Treahy, Jr. wrote:
>
>> mike@perusion.com wrote:
>>
>>> Quoting Barry Treahy, Jr. (Treahy@MMaz.com):
>>>
>>>> Sometime between 11:30 last night and moments ago, I have managed
>>>> to change something that has busted flex_select. Now, anytime a
>>>> flex_select link is clicked, the resulting error is:
>>>>
>>>> w2k.mmaz.com VfUKrI2k:192.168.10.10 - [31/August/2002:12:55:29
>>>> -0400] mmb2c /cgi-bin/mmb2c/admin/flex_select search error: Limit
>>>> subroutine creation: bad limit creation code in coordinated search,
>>>> probably search group without search specification. at
>>>> /ibin/interchange/lib/Vend/Search.pm line 768.
>>>>
>>>>
>>>
>>> Probably a bad mv_metadata entry for the table. Just remove the key
>>> that matches the table name.
>>>
>>> That is why we don't put that table in SQL, it is nice to just edit
>>> the file and correct the problem.
>>>
>> Ok, I'll start scanning the tables that I've modified since late last
>> night, but in the UI at the moment, I cannot get any of the tables to
>> edit; all are returning the same flex_select search error. Last
>> night, the last major set of changes were the addition of locales,
>> which I believe I had already grumbled about and setting up gpg.
>> When my first order test blew with transaction errors, I figured it
>> was time to stop and now returning this morning, well...
>>
>> I'll start looking... Thanks...
>
> I just compared my mv_metadata.asc file from yesterday morning to now,
> and the only change I have recorded when I diff the files is related
> to the available mailing lists... No new meta keys or elements...
Found it. I restarted the server first thing today and I had noticed an
oddly named table until moments ago, but it was a mutilated spelling of
inventory. I had added another index in the products table early
Friday, but hadn't actually did a restart of the server and it seems
that if you have an index for a table that doesn't exist, flex_select
breaks....
Barry
--
Barry Treahy, Jr * Midwest Microwave * Vice President & CIO
E-mail: Treahy@mmaz.com * Phone: 480/314-1320 * FAX: 480/661-7028