Rating doesn’t work and an older problem

  • haween

    (@haween)


    1 day, 21 hours ago

    Hello,
    There are some issues with rating the photos in the contest.

    1. I can’t rate the photos; clicking on the number doesn’t trigger any response or update, which means the rating isn’t saved and the next photo isn’t displayed (as configured).
    2. As an admin, I don’t see any photos in the album overview that other users have uploaded via the front end.
    1. The following errors appear in the log file:

    Err: on:07/08/2026 22:42:11: HaWeeN (3764354): Update usedby failed. Old value = , new value = .6171. for id = 314
    Err: on:07/08/2026 22:41:59: HaWeeN (3749623): Update usedby failed. Old value = , new value = .6171. for id = 314
    Err: on: July 8, 2026 10:29:22 PM: HaWeeN (3749623): Update of usedby failed. Old value = , new value = .6171. for id = 314
    Err: on: July 8, 2026 10:27:23 PM: HaWeeN (3749623): Update of usedby failed. Old value = , new value = .6171. for id = 314
    Err: on:07/08/2026 22:27:22: HaWeeN (3713597): Update of usedby failed. Old value = , new value = .6171. for id = 314
    Err: on: July 8, 2026 10:14:27 PM: cron-job (3710586): Could not insert monatswettbewerb-volker into db table wppa_index

    2. Also in the query monitor, there is the error again, we have for a few weeks:

    SELECT *
    FROM wp_wppa_photos
    WHERE album = 315
    ORDER BY RAND(2811)
    LIMIT 0, 100

    Unknown column ‘RAND(2811)’ in ‘order clause’
    wppa_album_photos_bulk()
    wp-content/plugins/wp-photo-album-plus/wppa-photo-admin-autosave.php:3553
    _wppa_admin()
    wp-content/plugins/wp-photo-album-plus/wppa-album-admin-autosave.php:2188
    wppa_admin()
    wp-content/plugins/wp-photo-album-plus/wppa-admin.php:320
    do_action(‘toplevel_page_wppa_admin_menu’)
    wp-admin/admin.php:264
    Plugin: wp-photo-album-plus

Viewing 11 replies - 1 through 11 (of 11 total)
  • Thread Starter haween

    (@haween)

    1 day, 11 hours ago

    Update: The fact that I couldn’t see the photos in the albums as an admin only affected a new album. In existing albums, I could see some of the photos.

    Solution: I moved the album into a parent album. Now it works.

    The only problem left is the rating system that isn’t working….

    Here’s an update on that as well:

    When I change the rating and then refresh the page, the new value is applied. 


    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    1 day, 11 hours ago

    I just fixed the bulk edit issue, it is caused by the fact that random photo sequence caused the db error.

    If you install
    https://downloads.wordpress.org/plugin/wp-photo-album-plus.9.2.04.001.zip
    it will work again.

    Now i go investigate the rating issue and the usedby issue

    monatswettbewerb-volker is too long, max 20 chars

    Thread Starter haween

    (@haween)

    1 day, 10 hours ago

    OK, I installed the new version. Looks ok.

    I shortened the album title.

    I’m not entirely sure, but the problem shouldn’t be caused by the long album name, right?

    The error is still there.

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    1 day, 9 hours ago

    The db field for the search token (slug) is only 20 chars (slug varchar(20) NOT NULL)

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    1 day, 6 hours ago

    Here is a pre-release that faster updates ratings;
    https://downloads.wordpress.org/plugin/wp-photo-album-plus.9.2.04.002.zip

    Thread Starter haween

    (@haween)

    1 day, 5 hours ago

    Unfortunately, it didn’t work.

    I tested this again.

    When I rate a photo and then manually move on to the next one, rate it again, and so on, I don’t see any ratings or changes, even when I go back to the previous photos.

    However, after reloading the page, all the ratings are saved and correct.

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    1 day, 5 hours ago

    Yes, that is correct. The rating processing is done in the background; the slide display is not updated directly
    Maybe in a later versiuon, but for the time being you will have to live with it, srry.

    Thread Starter haween

    (@haween)

    1 day, 5 hours ago

    Oh, that’s too bad.

    I’m surprised, since it’s always worked so far, although I’m not exactly sure until when. The last contest was in March or April.

    I still have a few older versions saved—could I test the ones where I think it worked?

    Or could I run into problems with the database if I install older releases?

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    1 day, 4 hours ago

    could I test the ones where I think it worked

    Should not be a problem

    Thread Starter haween

    (@haween)

    1 day, 4 hours ago

    OK.

    I’ve now installed version 9.1.10.011.

    The rating feature works in this version.

    For now, I would switch to this version for the rating feature and otherwise continue using the current version.

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    8 hours, 29 minutes ago

    Sorry!

    You were completely right. It was a bug, and is fixed in the current stable release version
    https://downloads.wordpress.org/plugin/wp-photo-album-plus.9.2.04.003.zip

    I recommend you to install it because it alsofixes a few security issues

Viewing 11 replies - 1 through 11 (of 11 total)

You must be logged in to reply to this topic.