Support » Plugin: Download Monitor » download_log : Unknown column ‘type’ in ‘where clause

  • Resolved patrice




    SELECT COUNT(ID) FROM {$wpdb->download_log} WHERE type = ‘download’ …

    But the type is not created by the installer :

    $dlm_tables = ”
    CREATE TABLE " . $wpdb->prefix . "download_log (
    ID bigint(20) NOT NULL auto_increment,
    user_id bigint(20) NOT NULL,
    user_ip varchar(200) NOT NULL,
    user_agent varchar(200) NOT NULL,
    download_id bigint(20) NOT NULL,
    version_id bigint(20) NOT NULL,
    version varchar(200) NOT NULL,
    download_date datetime DEFAULT NULL,
    download_status varchar(200) DEFAULT NULL,
    download_status_message varchar(200) DEFAULT NULL,
    meta_data longtext DEFAULT NULL,
    KEY attribute_name (download_id)
    ) $collate;
    dbDelta( $dlm_tables );

    No type column anywhere.

    So any logging request will return WordPress database error: [Unknown column ‘type’ in ‘where clause’]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Harish Chouhan


    Hey @eoni,

    Can you please let us know which version of our plugin you have installed and also where this error was recorded?

    Plugin Author Barry Kooij


    Also, do you have any Download Monitor extensions installed? If so, did you update these to version 4.0 as well?

    Plugin Author Barry Kooij


    This is a confirmed bug and will be fixed in 4.0.3

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘download_log : Unknown column ‘type’ in ‘where clause’ is closed to new replies.