sandbox.amadeus.com uses Honeypot during the user registration flow (and it works very well :) )

We are working to enable federation registration / login through Github, so we have enabled the Github Connect module v7.x-1.1

However, with the Github Connect module enabled, when an unregistered user clicks on the Create Account button (causing a post to /user/register), Honeypot throws the following critical error in all cases:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hostname' in 'where clause': SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {honeypot_user} hs WHERE (uid = :db_condition_placeholder_0) AND (timestamp > :db_condition_placeholder_1) AND (hostname = :db_condition_placeholder_2) ) subquery; Array ( [:db_condition_placeholder_0] => 0 [:db_condition_placeholder_1] => 1472751226 [:db_condition_placeholder_2] => 204.2.207.11 ) in honeypot_get_time_limit() (line 336 of /srv/bindings/99898c3e24ec41ab9451062e75a8d554/code/sites/all/modules/contrib/honeypot/honeypot.module)

It's possible to work around this issue by disabling the minimum time limit to complete the registration form

Drupal version is 7.50, running on Pantheon.io
Other registration time modules that are running include reCAPTCHA (7.x-2.2), LoginToboggan (7.x-1.5), BOTCHA (7.x-3.3)

Comments

tadhgpearson created an issue. See original summary.

geerlingguy’s picture

Category: Bug report » Support request

Can you go to your status report page and make sure there are no database updates that remain to be run? There was a schema change for the Honeypot module recently, and you'd need to either visit /update.php or run drush updb to make sure Honeypot is at the right database schema version.

geerlingguy’s picture

Closing this for now; please let me know if this is still an issue.

geerlingguy’s picture

Status: Active » Closed (cannot reproduce)