Database Error

  • Resolved Brad Brown

    (@bradbrownmagic)


    4 years, 2 months ago

    We’re seeing errors in our logs, apparently related to the download history. The history isn’t updating, but downloads seem to be working. (At least they work for me and I haven’t heard complaints from users.)

    This appears to have been going on since our upgrade to 3.1.12.

    Below are two example errors, with a few bits anonymized. How can we correct this issue?

    [27-Dec-2020 17:54:26 UTC] WordPress database error Unknown column 'filename' in 'field list' for query INSERT INTO 'wp_c2z54m2rcz_ahm_download_stats' ('pid', 'uid', 'oid', 'year', 'month', 'day', 'timestamp', 'ip', 'filename', 'agent', 'version') VALUES ('6121', '1911', '', '2020', '12', '27', '1609091666', 'XXX.XXX.XXX.XXX', 'https://XXXXX.com/file/book-downloads/The-Illustrated-Book-of-Magic-Tricks.pdf', 'Mozilla/5.0 (Linux; Android 8.0.0; SM-G930F) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.101 Mobile Safari/537.36', '') made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WPDM\libs\Apply->triggerDownload, include('/plugins/download-manager/wpdm-start-download.php'), WPDM\libs\DownloadStats->add
[27-Dec-2020 17:54:39 UTC] WordPress database error Unknown column 'filename' in 'field list' for query INSERT INTO 'wp_c2z54m2rcz_ahm_download_stats' ('pid', 'uid', 'oid', 'year', 'month', 'day', 'timestamp', 'ip', 'filename', 'agent', 'version') VALUES ('6034', '1911', '', '2020', '12', '27', '1609091679', 'XXX.XXX.XXX.XXX', 'https://XXXXX.com/file/book-downloads/Dai-Vernon-Mental-Card-Miracle.pdf', 'Mozilla/5.0 (Linux; Android 8.0.0; SM-G930F) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.101 Mobile Safari/537.36', '') made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WPDM\libs\Apply->triggerDownload, include('/plugins/download-manager/wpdm-start-download.php'), WPDM\libs\DownloadStats->add
    • This topic was modified 4 years, 2 months ago by Brad Brown. Reason: Improve error log formatting
    • This topic was modified 4 years, 2 months ago by Brad Brown. Reason: Improve error log formatting
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Shafaet Alam

    (@shafayat-alam)

    Please deactivate and reactivate the plugin, which should update the DB and resolve the issue.

    Thanks. I’m assuming a lot of users will find out about this problem after they see their history. Some general notice to all plugin users would help.

    Thread Starter Brad Brown

    (@bradbrownmagic)

    Deactivating/reactivating fixed it.

    Thanks!

    Hi Shafaet, I tried Deactivating/Reactivating the plugin but I can’t fix the issue. The database also can’t filter users, dates, etc. Can you help me please?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database Error’ is closed to new replies.