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

  • Resolved patrice

    (@eoni)



    Hi,

    DLM_Logging->has_ip_downloaded_version:

    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,
    PRIMARY KEY (ID),
    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

    (@hchouhan)

    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

    (@barrykooij)

    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

    (@barrykooij)

    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.