No reviews imported

@gonab Yes, I do have an idea and I’ve prepared functionality for this very scenario. It is very likely the database encoding doesn’t support WordPress’s array to string function.

There is a fall-back – in the main Setup tab, check the option: Clean Retrieved Data – Additional sanitization of retrieved data — emoticons are removed from text. This will strip out the characters that cause the data storage to fail and it should go through properly.

Please let me know how this goes?

Nope still the same error.
I tried to clear the cache. Same.

@gonab Firstly, try a smaller sample set at a time rather than the reviews at once.

To resolve this more permanently, please can you tell me the “Collation” used for your database (or the wp_options) table if that is different? It is listed in PHPMyAdmin under Operations. This is entirely optional – I can investigate this without this information but it will take a lot longer.

I tried with a smaller sample (26 reviews). Same result.

The collation of my database is utf8mb4_unicode_520_ci

If you’re interested in, I can give you an acces to the admin of my site too ? I just need a way to send you the informations.

@gonab The Collation is the recommended one for WordPress and I haven’t experienced any issues with emoticons and the storage function in this case before.

For the access, this is not permitted.

You’re welcome to get in touch directly using the support link to my website.

@gonab I have found the issue – it was a little more straight-forward than I had imagined! I’ll release a fix in the next version of the plugin. ??

thanks. Glad you found the solution.

@gonab If you want to perform the import now, you can reveal the missing table by editing the following file: ./admin/js/js.js on line: 970 …

Change this from:

jQuery('#import-button, #import-clear-button').show();

To:

jQuery('#reviews-import-table, #import-button, #import-clear-button').show();

Again, I’ll release an update shortly so you won’t have to wait long! ??

Works fine. Thanks again.

@gonab Please download version 3.2. The HTML Import display issue is now resolved.

@designextreme Unfortunately for me does not work ?? also with the new version.

Can you help me ?

Thanks in advance

• This reply was modified 4 years, 6 months ago by hacaro.

@hacaro After upgrading plugins generally, I find that old styles and scripts are still cached in the browser. Please perform a force reload of a page in the plugin’s settings and it it will ensure that the new styles and scripts are active.

@designextreme Unfortunately not work ?? i’ve checked the ./admin/js/js.js on line: 970 and it is ok. I’ve cleared the cache also from the plugin. I’ve reset all plugin data e restart, but nothing. I see all review when i past the div content but after import I receive the error. Can You help me please.

Thanks In advance and best Regards.

@hacaro This sounds like a separate issue. The one I resolved here was about a hidden table of the results, without an error appearing.

Something that will help me resolve this separate issue: what is the error message?

The error is No Reviews Imported

Here screenshot of what i do:

1 Copied html of div https://ibb.co/Cz3bbxP
2 see the review https://ibb.co/2K9k4F1
3 After Impor i receive this https://ibb.co/nPJLtF7

Thank You for the support !