download_log : Unknown column ‘type’ in ‘where clause
-
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’]
- The topic ‘download_log : Unknown column ‘type’ in ‘where clause’ is closed to new replies.