Jump to content

Rebuild entire index doesn't work


itzik glam
 Share

Recommended Posts

hey. i am working on website that sales files (download products) i added alot of products but Suddenly when i am adding product i get this message:

Array
(
   [0] => Column 'id_word' cannot be null
   [1] => Array
       (
           [0] => (211,(SELECT id_word FROM ps_search_word WHERE word = 'אבנרהמכ�' AND id_lang = 5 LIMIT 1),1)
       )

)


END



i tryed the "Rebuild entire index" and the "Add missing products to index" in the admin "search" Tag but i get this message again and the problem is still there

someone can help me please what is the problem?

thanx

Share this post


Link to post
Share on other sites

  • 3 months later...
  • 3 weeks later...
  • 1 month later...

probably out of my depth.. but i had errors with product import that resulted in the '?' symbol you have at the end of your string.. the symbol was caused because i wasnt importing in UTF-8 encoding. The feature in the prestashop import that says convert to UTF-8 convert doesnt work for me, I have to do it manually in php with utf8_encode(file.txt), or just save your file using a notepad program that can reencode the file.. after that it worked.

the symbol seems to appear when MYSQL encounters special characters that it cant deal with because of their encoding.

I've no idea whether this would resolve you problem with the search index, i've only seen it on products.

Share this post


Link to post
Share on other sites

to explain more fully, the error occurred in product description when i imported a csv. the product would import fine except that the description would be cut off where ever the encoding problem was encountered. I eventually noticed that if i manually copied the description into the 'add product' page in the back office it worked fine, but the import failed every time.

There was no documentation on this, i was just lucky i stumbled onto the problem.. before i figured it out the encoding was the last thing on my list to check since i assumed that the prestashop import tool was doing it correctly already.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More