Getting OKAPI Method Error Messages - How to Respond

All postings beginning with "How can i configure (or implement) ..."
Antworten
DudleyGrunt

We've been getting OKAPI error e-mails, such as the following.  Any suggestions on how to respond?
-----Original Message-----
From: OKAPI [mailto:noreply@opencaching.us]
Sent: Tuesday, February 07, 2012 10:44 PM
To: octeam@opencaching.us
Subject: OKAPI Method Error - http://www.opencaching.us/


OKAPI caught the following exception while executing API method request.
This is an error in OUR code and should be fixed. Please contact the
developer of the module that threw this error. Thanks!

*** SQL Error 1146: Table 'ocpl.okapi_stats_temp' doesn't exist

The query was:

insert into okapi_stats_temp (`datetime`, consumer_key, user_id, service_name, calltype, runtime)
values (
now(),
'FMAacZFCWZFdMCWWVLHv',
'-1',
'services/caches/search/nearest',
'internal',
'0.0011541843414307'
);

***

--- Stack trace ---
#0 /var/www/oc/okapi/core.php(283): okapi\Db::query('????insert into...')
#1 /var/www/oc/okapi/service_runner.php(150): okapi\Db::execute('????insert into...')
#2 /var/www/oc/okapi/service_runner.php(126): okapi\OkapiServiceRunner::save_stats('services/caches...', Object(okapi\OkapiInternalRequest), 0.0011541843414307)
#3 /var/www/oc/okapi/services/caches/shortcuts/search_and_retrieve.php(63): okapi\OkapiServiceRunner::call('services/caches...', Object(okapi\OkapiInternalRequest))
#4 [internal function]: okapi\services\caches\shortcuts\search_and_retrieve\WebService::call(Object(okapi\OkapiHttpRequest))
#5 /var/www/oc/okapi/service_runner.php(120): call_user_func(Array, Object(okapi\OkapiHttpRequest))
#6 /var/www/oc/okapi/views/method_call.php(27): okapi\OkapiServiceRunner::call('services/caches...', Object(okapi\OkapiHttpRequest))
#7 [internal function]: okapi\views\method_call\View::call('services/caches...')
#8 /var/www/oc/okapi/controller.php(58): call_user_func_array(Array, Array)
#9 /var/www/oc/okapi/controller.php(79): okapi\OkapiScriptEntryPointController::dispatch_request('/okapi/services...')
#10 {main}

--- OKAPI method called ---
/okapi/services/caches/shortcuts/search_and_retrieve
?format=json
&search_params=%7B%22status%22%3A+%22Available%22%2C+%22limit%22%3A+20%2C+%22radius%22%3A+500%2C+%22center%22%3A+%2245.51308%7C-122.64622%22%7D
&retr_method=services%2Fcaches%2Fgeocaches
&retr_params=%7B%22fields%22%3A+%22name%7Clocation%7Ctype%7Csize%7Cdifficulty%7Cterrain%7Crecommendations%22%7D
&wrap=true
&search_method=services%2Fcaches%2Fsearch%2Fnearest
&consumer_key=FMAacZFCWZFdMCWWVLHv

--- Request headers ---
User-Agent: AppEngine-Google; (+http://code.google.com/appengine; appid: geocachingbuddy)
Host: opencaching.us
Accept-Encoding: gzip
wrygiel

You have forgot to run http://yoursite/okapi/update after updating OKAPI code. It's better if you email me directly in case of errors, it's hard to notice such message in a forum.

Maybe you could add me to the list of admins which receive error messages from your server?
Antworten