Opencaching.de

Opencaching International => HOWTO questions => Thema gestartet von: DudleyGrunt am 09. Februar 2012, 04:36:04

Titel: Getting OKAPI Method Error Messages - How to Respond
Beitrag von: DudleyGrunt am 09. Februar 2012, 04:36:04
We've been getting OKAPI error e-mails, such as the following.  Any suggestions on how to respond?

Zitat
-----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

Titel: Re: Getting OKAPI Method Error Messages - How to Respond
Beitrag von: wrygiel am 08. April 2012, 14:07:45
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?