Title: Table httpbl_log doesn't exist
Last modified: August 20, 2016

---

# Table httpbl_log doesn't exist

 *  [sandraqu](https://wordpress.org/support/users/sandraqu/)
 * (@sandraqu)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/table-httpbl_log-doesnt-exist-1/)
 * WordPress database error: [Table ‘myprefix.wp_httpbl_log’ doesn’t exist]
    SELECT
   blocked,count(*) FROM wp_httpbl_log GROUP BY blocked
 * Deactivating, un-installing and re-installing did not work as a solution for 
   me.
 * The table does not exist.
 * Can you provide me with the SQL code so that I can plug it in directly?
 * [http://wordpress.org/extend/plugins/httpbl/](http://wordpress.org/extend/plugins/httpbl/)

Viewing 1 replies (of 1 total)

 *  [Brendan](https://wordpress.org/support/users/br3nd4n/)
 * (@br3nd4n)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/table-httpbl_log-doesnt-exist-1/#post-2425535)
 * I know this is a bit late, but I saw your reply and thought I’d check out the
   code in case you or anyone else is interested.
 * The SQL is below:
 *     ```
       CREATE TABLE wp_httpbl_log
         (
            id              INT(6) NOT NULL auto_increment PRIMARY KEY,
            ip              VARCHAR(16) NOT NULL DEFAULT 'unknown',
            time            DATETIME NOT NULL,
            user_agent      VARCHAR(255) NOT NULL DEFAULT 'unknown',
            httpbl_response VARCHAR(16) NOT NULL,
            blocked         BOOL NOT NULL
         );
       ```
   
 * Note however you may need to check and change the table prefix from wp_ to your
   own prefix where required.
 * The plugin looks like it should create the table itself. If you get any error
   messages installing ensure you paste them in next time.

Viewing 1 replies (of 1 total)

The topic ‘Table httpbl_log doesn't exist’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/httpbl.svg)
 * [http:BL WordPress Plugin](https://wordpress.org/plugins/httpbl/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/httpbl/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/httpbl/)
 * [Active Topics](https://wordpress.org/support/plugin/httpbl/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/httpbl/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/httpbl/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Brendan](https://wordpress.org/support/users/br3nd4n/)
 * Last activity: [13 years, 10 months ago](https://wordpress.org/support/topic/table-httpbl_log-doesnt-exist-1/#post-2425535)
 * Status: not resolved