No reviews imported

  • Resolved Gonab

    (@gonab)


    4 years, 10 months ago

    Hello,

    I’ve tried multiple times to import all my reviews in the Advanced Tab. When I press the Process Button, it shows Found 167 new reviews. When I press Import, I go back to the Advanced tab and I get the alert message : No reviews imported

    Any Ideas for me ?

Viewing 15 replies - 16 through 30 (of 50 total)
  • Plugin Author Design Extreme

    (@designextreme)

    @hacaro Ok, this sounds like the emoticons are not supported by WordPress’s core array to string functionality – this breaks when some database/table collations are used.

    Please read my first reply here for the solution.

    @designextreme it’s checked but not work.

    Plugin Author Design Extreme

    (@designextreme)

    @hacaro Ah, ok…

    In this case, I’ll need your Place ID and, if you know it, your database (or table) collation. It is shown in PHPMyAdmin.

    With the details, I’ll be able to replicate the issue here.

    Thanks,

    Noah

    @designextreme my collation is utf8mb4_unicode_520_ci

    my place id is ChIJLVOy14dsiEcRF03tqQrBRWE

    Thank You

    Plugin Author Design Extreme

    (@designextreme)

    @hacaro Thanks. The collation seems to be the default one that accepts emoticons, so maybe this is something new?

    Leave it with me and I’ll see what I can do.

    ok thank you very much for the support !

    Hi,

    I experienced the same issue. All reviews are shown on the import page, but I cannot import a single one (also none without any emoticons). Plugin-Version 3.3. Collation: utf8mb4_unicode_ci.

    A small proposal for a general improvement: It would be nice if you could append a link under the review list so that a user is able to see all reviews in a separate popup windows.

    Anyway, thank you very much for the plugin!

    Thanks for any help,
    Thorsten

    • This reply was modified 4 years, 10 months ago by thor_a.
    • This reply was modified 4 years, 10 months ago by thor_a.
    Plugin Author Design Extreme

    (@designextreme)

    @thor_a Thanks for the addition and the feature suggestion! ??

    Do you happen to have the following details: your Place ID and your database collation? If you don’t that’s also fine.

    I’ll be doing some testing for this issue later in the week.

    Ok, thanks! Just upgraded to WP 5.4.1, but the error still exists.

    PlaceID: ChIJxSU_Ak9QqEcRWpKChZJWs-g

    Collation: which table? There are some with a different one. Most use utf8mb4_unicode_ci.
    (see: https://i.imgur.com/x1kEcLz.png)

    Plugin Author Design Extreme

    (@designextreme)

    @thor_a Thanks for the Place ID, I’ll use this for testing as one or more of the characters may cause the storing of the data to fail – and this triggers a fail that means no change.

    For the collation, you’re right, it’s the standard WordPress selection. With my previous tests it has always succeeded so I am curious to find out what is happening now.

    Let me know if I can do anything else for testing purposes. Showing all reviews is very important to us, so if you have a workaround this would be great!

    Perhaps it has something to do with utf8 characters within the line beneath the name of a reviewer? E. g.: 

    Foo Bar

    ?·?1.278 Reviews?·?10.509 Photos
    The point separater and the space before and after are utf8 characters. Namely:
    thinspace: E2 80 89
    middledot: C2 B7

    Plugin Author Design Extreme

    (@designextreme)

    @thor_a @hacaro I have tested all the reviews for each place using utf8mb4_unicode_ci and utf8mb4_unicode_520_ci and it always imports correctly for me. I see the preview of the data as mentioned, but it then continues to store the data correctly on submission.

    Are you able to import a smaller number of reviews at one time – does it always fail?

    Plugin Author Design Extreme

    (@designextreme)

    @thor_a From experience, it has failed because the WordPress maybe_serialize() function fails to store the emoticon characters frequently present in the review text. In my testing, this only occurs when using a different non-utf8mb4_* collation.

    In the preview I can see all (34) other reviews. But even if I select only one preview it does not work. I even tried in a clean browser, but with the same result.
    Wordpress: 5.41

    See: https://i.imgur.com/ydPVWZN.png

    View post on imgur.com

    BTW To be sure that we use the same data for the import I uploaded the ‘lcorif’ code snippet here: https://www.sendspace.com/file/w1dd9t
    Could you please check that it’s identical to the code you tried to import?

    Is there any API check during the import? Because I think that for today my Google API access rights has been exhausted. Perhaps this could be the cause?

    BTW Is it possible for anybody to import reviews other than his own this way? I hope not. Otherwise one could easily cheat. I asked because you seemed to be able to test the import issue with my reviews.

Viewing 15 replies - 16 through 30 (of 50 total)
  • The topic ‘No reviews imported’ is closed to new replies.