XiongShui's picture

Hi there:

since any weeks I find a daily log entry: "PDOException: SQLSTATE[42S02]: Base table or view not…" but I couldn't find out, what it means.

Can anyone give me an idea, what to do?

Thanks a lot

XiongShui ()

Most helpful answers

Hi @XiongShui,

The problem is that the httpbl module hasn't been properly ported to Backdrop. The blocked_ips table was removed from Backdrop CMS, so if the httpbl needs to store IP addresses it will need to implement hook_schema and define it's own database table to store them in.

This error in particular was triggered during a cron run, when the httpbl module was attempting to DELETE items from that table. If this module doesn't also store it's own data in that table, it may be safe to simply delete the cleanup routine from the module.

The error mentions the httpbl module. If you uninstall that module does it help?

Can you paste the text of the entire error here? It should give more specific text that can pinpoint the module (likely) that is causing the problem.

Comments

Can you paste the text of the entire error here? It should give more specific text that can pinpoint the module (likely) that is causing the problem.

XiongShui's picture

Hi Laryn,

excuse me, the information mail came today...

"PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DB33289.blocked_ips' doesn't exist: DELETE FROM {blocked_ips} WHERE (ip IN (SELECT hostname FROM {httpbl} WHERE status > 0 AND expire <= :time)) ; Array ( [:time] => 1534654365 ) in httpbl_cron() (line 393 of /var/www/5000124018/u9848/nachtschlaf.org/htdocs/modules/httpbl/httpbl.module)."

Any weeks ago I implemented a Honeypot (http://www.projecthoneypot.org/), so I think it could be a mistake I made by installing?

Friendly yours: XS ()

The error mentions the httpbl module. If you uninstall that module does it help?

XiongShui's picture

Hi laryn,

at first, I deleted this morning all "Quick Links" tomorrow I'll see, what is going on.

 

Update 22.08.: yes it was. Now, after deleting all Quicklinks, is there no fail warning more. This Quicklinks are to be redirect robots to an inexistent URL, this would, I think so, confusing, the cms- log- system.

Thanks, for help :)

XS ()

XiongShui's picture

hi herb,

it isn't a upgrading problem. It is only because the Honeypot installation.

Thanks, XS ()

jenlampton's picture

Hi @XiongShui,

The problem is that the httpbl module hasn't been properly ported to Backdrop. The blocked_ips table was removed from Backdrop CMS, so if the httpbl needs to store IP addresses it will need to implement hook_schema and define it's own database table to store them in.

This error in particular was triggered during a cron run, when the httpbl module was attempting to DELETE items from that table. If this module doesn't also store it's own data in that table, it may be safe to simply delete the cleanup routine from the module.