I looked through the forums and solved the search problem by editing the attributes that are configured to be used in listing and search. I also deleted a couple of attibutes like color etc.. that i will not be needing.
the search is working properly now. BUT… now..
in index management the product pricing index is showing constantly- processing- and it gives this error at the top.
-Some problem with reindexing process-
will this repairing the data base work for that as well? if so what table should i repair? something is wrong with the index.. and it started doing this after the deletion of attribultes and changing the attribute configuration to not show in the searches.
thanks for any help or suggestions-
Im past my due date of making this public.. everything is up and running as far as i can see in the front end.. but the back end is showing the product price indexing problem..