It appears that no table was created for goaway in the db on install and so many error messages are being thrown. Here is the message:

Table 'kathyan_newdrupal.goaway' doesn't exist query: select count(gid) AS count from goaway where ip = '67.230.48.209' in /hsphere/local/home/kathyann/caribexams.org/sites/all/modules/goaway/goaway.module on line 9.

I think the table is the problem but I am not sure.

Comments

As If’s picture

Hi Kristaal. Is there anything unusual about your database? This worked normally in testing. Meanwhile, if you have direct access to the db (or if you use PHPMyAdmin) you can create the required table with the following SQL statement:

CREATE TABLE goaway (
  gid int(10) unsigned NOT NULL auto_increment,
  ip varchar(15) NOT NULL default '',
  PRIMARY KEY  (gid),
  KEY ip (ip)
);
kristaal’s picture

Hi, no nothing unusual about the db. I was thinking about creating the table, then I also noticed that there was a conflict with the "comment page" module that I have loaded. It seemed to cause that module to disappear from my admin> settings page. When I uninstalled goaway, everything went back to normal.

As If’s picture

I just tested this module with Comment Page running on the same site, and both modules are working normally. I'm guessing there's something unusual about your site, perhaps some custom code? Feel free to reopen this issue or start another if you find something significant.

As If’s picture

Status: Active » Closed (fixed)
modctek’s picture

I hit this same bug on two separate sites. I suspect there may be a conflict with some other module, but I've got too many installed to be able to narrow it down without extensive testing. Creating the table after the fact makes it all better. :)

helloadorable’s picture

I also ran into this same bug on a new site I'm setting up right now with very few other modules installed so I don't think it's a conflict with another module.

Could it be this function in goaway.install which has it's only line of code commented out?

function goaway_install() {
  // drupal_install_schema('goaway');
}

If not that, then it maybe this function in goaway.install does something that not all version of mySQL can handle? I'm using mysql 5.0.92 personally.

function goaway_schema() {
  $schema['goaway'] = array(
    'fields' => array(
      'gid' => array('type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE, 'description' => 'Identifier for a ban'),
      'ip' => array('type' => 'varchar', 'length' => '15', 'not null' => TRUE, 'default' => '', 'description' => 'An IP address'),
    ),
    'primary key' => array('gid'),
    'indexes' => array('ip' => array('ip')),
  );
  return $schema;
}
As If’s picture

Version: 6.x-1.5 » 6.x-1.0
Assigned: As If » Unassigned

I'm pretty sure you're right on the first one. That line should NOT be commented out. (Checking older version...) It wasn't commented out in version 1.4. Probably a brainfart from the D7 upgrade procedure. Try uncommenting it and run the update again.

EDIT: Uninstall version 6.x-1.5. Use 6.x-1.6 instead.

As If’s picture

Version: 6.x-1.0 » 6.x-1.5
Assigned: Unassigned » As If
Status: Closed (fixed) » Active
As If’s picture

Status: Active » Closed (fixed)

Fixed in version 6.x-1.6.