[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Random search results
Quoting Jon (prtyof5@attglobal.net):
>
>
> Steve wrote:
>
> > I am just setting up a store for the first time. I have my files in and
> > the pages look OK so far. The problem is when I do a SEARCH sometimes
> > all the results don't come back. For example if I SEARCH on Booklets I
> > get all 72. If I SEARCH on Books I only get 7 out of the 13. If I
> > SEARCH on a keyword, I don't get all the titles containing it. I
> > couldn't find one item no matter what I put in the SEARCH. It said NOT
> > FOUND When I added the item in as a new item, then the SEARCH found it
> > but still didn't find the old listing which I hadn't deleted from the
> > table. The two table entries looked the same (except for the SKU which
> > I changed so I could see which was found).
>
> I had the exact same thing happen to me. It was very odd.
> By any chance did you add the products via the database
> directly ? I have MySQL and used MySQLTool to edit the
> area, category, product, and options tables. For those products
> that I added via MySQLTool I wasn't able to search them.
> If I add items via the IC Admin UI then no problem.
> Unfortunately I can't explain why this is happening.
>
You are using a text search and the database has not been exported
to its text file. Export it and it should be fine....
--
Mike Heins
Perusion -- Expert Interchange Consulting http://www.perusion.com/
phone +1.513.523.7621 <mike@perusion.com>
I don't want to get to the end of my life and find I have just
lived the length of it. I want to have lived the width of it as
well. -- Diane Ackerman