When I try to create a new key using the services module I get the following error message:

    * user warning: Table 'drupal5.api_keys' doesn't exist query: SELECT * FROM api_keys WHERE kid = '7a486ffcc12d24c5b90440a37a04693b' in F:\Server\xampplite\htdocs\drupal5\includes\database.mysql.inc on line 167.
    * user warning: Table 'drupal5.api_keys' doesn't exist query: INSERT INTO api_keys (kid, title, domain) VALUES ('7a486ffcc12d24c5b90440a37a04693b', 'test', 'test.com') in F:\Server\xampplite\htdocs\drupal5\includes\database.mysql.inc on line 167.

Does anyone know how to fix this? I saw a similar error a few days ago, but I can no longer find it on the issue tracker. Thanks.

Comments

mikeypotter’s picture

mikeypotter commented

Do a search for api_keys and replace it with service_keys.

Mike

snelson’s picture

snelson commented

Thanks Mike.

This has been updated in HEAD. I was having some CVS trouble which has been fixed, but I haven't been able to get the 5.x dev release updated yet. Its still in the drupal.org site maintenance queue. Hopefully somebody can get it soon.

Scott

strayhand’s picture

strayhand commented

Ah... thanks. For anyone else following this. You need to do a search and replace for api_keys inside of the services_admin_keys.inc. Replace api_keys with "services_keys". It's plural. Looking at the install script you'll see that this is in fact the name of the db table. Thanks for your help guys.

snelson’s picture

snelson commented
Status: Active » Fixed

The CVS problems have been fixed and the 5.x release code should be current.

snelson’s picture

snelson commented
Status: Fixed » Postponed

The tarball has not yet been updated. Gonna check it on the next packaging script run.

snelson’s picture

snelson commented
Status: Postponed » Fixed

Tarball is updated.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)