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