Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › Odd search result
- This topic has 5 replies, 2 voices, and was last updated 5 months, 3 weeks ago by
toddkarr_OkUr.
-
AuthorPosts
-
December 7, 2025 at 11:12 pm #56454
toddkarr_OkUr
ParticipantHi, Ernest
Wow, my search is working beautifully. The memory limit is at 512mb and working faster.
However, I noticed that one entry showed up without its ID tag and missing its “dust jacket” field entry. Dust jacket shows up fine in other results, and it’s in the original spreadsheet.
Any thoughts?
I reset your username to ajaxsearchpro and password to searchtheindex
Thank you.
December 8, 2025 at 8:20 am #56458toddkarr_OkUr
ParticipantUPDATE
The problem seems to be that I have some duplicate entries, but not on my spreadsheet/CSV.
Yesterday, while initially importing, I stopped an initial index table generation when I realized that I had not added the ID number that gives them a unique identity.
I stopped the index, and then deleted all the Books posts from my site.
I then corrected the spreadsheet/CSV and imported it again, then generated a new index table.
Somehow, the old entries remained and now they show up in the results.
I will start over later and delete all the Books posts and import them again. then delete the current Index Table and generate a new one. Hopefully that will solve the problem.
See attached.
December 8, 2025 at 8:28 am #56460toddkarr_OkUr
ParticipantUPDATE
OK, I know what happened. The hidden rows in my spreadsheet are showing up. I need to delete them before importing it. That should eliminate the ghost entries.
December 8, 2025 at 8:39 am #56461toddkarr_OkUr
ParticipantFIXED: I saved a lot of time and did a search on my posts for the empty parentheses in the title – “()” – because of the missing identifier, then deleted all those posts. Whew. I had forgotten this quirk about OSX Numbers.
December 8, 2025 at 2:35 pm #56468Ernest Marcinko
KeymasterAll right, thank you for updating me. I have very little experience with importing CSV files, so I’m learning with you.
December 8, 2025 at 2:37 pm #56469toddkarr_OkUr
ParticipantMy pleasure. I shouldn’t even have hidden rows. I was keeping them saved in case I needed to access the information, but I’ll be deleting them permanently so I don’t run into this problem or have an extra step to deal with!
-
AuthorPosts
- You must be logged in to reply to this topic.