• Resolved j2fb

    (@j2fb)


    I’m getting the error below in PHP logs since the latest update, any suggestions? Thanks!

    WordPress database error Unknown column ‘total_downloads’ in ‘order clause’ for query
    SELECT wp_posts.ID
    FROM wp_posts LEFT JOIN wp_dlm_downloads ON (wp_posts.ID = wp_dlm_downloads.download_id) LEFT JOIN
    ( SELECT wp_postmeta.meta_value, wp_postmeta.post_id FROM wp_postmeta WHERE
    wp_postmeta.meta_key = ‘_download_count’ GROUP BY wp_postmeta.post_id ) as meta_downloads ON ( meta_downloads.post_id = wp_posts.ID )
    WHERE 1=1 AND ((wp_posts.post_type = ‘dlm_download’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘xlwctydisabled’ OR wp_posts.post_status = ‘wcst_triggerdisabled’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’
    OR wp_posts.post_status = ‘private’)))
    GROUP BY wp_posts.ID
    ORDER BY total_downloads DESC
    LIMIT 0, 10
    made by wp_dashboard, do_meta_boxes, DLM_Admin_Dashboard->popular_downloads, DLM_WordPress_Download_Repository->retrieve, WP_Query->query, WP_Query->get_posts

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Razvan Aldea

    (@raldea89)

    Hello @j2fb ,

    Could you please let me know from what version did you update? We did not made any modifications to database queries in the last update.

    Warmly,
    Razvan

    Thread Starter j2fb

    (@j2fb)

    Hi, it seems I skipped at least one update, I must have been using 4.8.8

    I am also seeing this error on two separate sites.

    I found these two entries in Simple History for one of the sites:

    9/9/23 Updated plugin “Download Monitor” to 4.8.10 from 4.8.9
    3/9/23 Updated plugin “Download Monitor” to 4.8.9 from 4.8.6

    Does that mean skipping 4.8.7 or 4.8.8 broke something? How can I fix it?

    Plugin Support Teo Alex

    (@altesin)

    Hello @j2fb and @mpclark ,

    Can you please give us more details about your website ?
    1. What server are you using?
    2. What is your PHP version?
    3. What database and witch version of database are you using?

    To find these informations you can go in your WordPress dashboard -> Tools -> Site Health -> Info

    Hi! Details of an example site are as follows:

    Server architecture: Linux 6.0.2-x86_64-linode157 x86_64
    Web server: Apache/2.4.57 (Debian)
    PHP version: 7.4.33 (Supports 64bit values)

    Extension: mysqli
    Server version: 10.4.20-MariaDB-1:10.4.20+maria~buster-log
    Client version: mysqlnd 7.4.33

    Happy to provide further info etc by email.

    Plugin Support Teo Alex

    (@altesin)

    We could not reproduce the issue in the cases you mentioned.

    Please install Health Check & Troubleshooting and only activate Download Monitor while troubleshooting and check if the error persists.

    Marking this support thread as resolved due to inactivity. If you have any other questions or need further help please open a new thread.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘WordPress database error Unknown column ‘total_downloads’ in ‘order clause’’ is closed to new replies.