Please keep this thread in english so that Wojciech understands the discussion.
Poniżej wiadomość od: Wojciech Rygielski (2013-12-16 15:00:05)
===8<===
I wonder how it's possible that this problem occurs only in your
installation. AFAIR, last time we talked about it, you said this way
caused by some server issues. Is it still true? Can I somehow help
with fixing it?
> 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!
> ===== ERROR MESSAGE =====
> SQL Error 1100: Table 'okapi_cache' was not locked with LOCK TABLES
> The query was:
> replace into okapi_cache (`key`, value, expires)
> values (
> 'cron_schedule',
> '???n?0?w?
> h?k?+C????Xv??Nlg?????}E4?ʲ?????
> Y&?.a?daNЪCiM?i?????N?\Z????|3?b????B?gY\n??yFb!?h`,`??}X??΄1?a???4??CA???\0}|??{??#??q?6????53#??u?
> ?D??\r5????lSժ??aS?????!v????\0?U\0???U_????g??y?G.W\Zs???V?Q??¨??2Cׅ?????@?((4?[?ju??\'ȋG_?',
> date_add(now(), interval '2592000' second)
> );
> =========================
> --- Stack trace ---
> #0 /var/www/www.opencaching.de/code/htdocs/okapi/core.php(436):
> okapi\Db::query('????replace int...')
> #1 /var/www/www.opencaching.de/code/htdocs/okapi/core.php(1659):
> okapi\Db::execute('????replace int...')
> #2 /var/www/www.opencaching.de/code/htdocs/okapi/cronjobs.php(101):
> okapi\Cache::set('cron_schedule', Array, 2592000)
> #3 /var/www/www.opencaching.de/code/htdocs/okapi/core.php(993):
> okapi\cronjobs\CronJobController::run_jobs('pre-request')
> #4 /var/www/www.opencaching.de/code/htdocs/okapi/core.php(1106):
> okapi\Okapi::execute_prerequest_cronjobs()
> #5
> /var/www/www.opencaching.de/code/htdocs/okapi/controller.php(61): okapi\Okapi::init_internals(true)
> #6
> /var/www/www.opencaching.de/code/htdocs/okapi/controller.php(98):
> okapi\OkapiScriptEntryPointController::dispatch_request('/okapi/services...')
> #7 {main}
> --- OKAPI method called ---
> /okapi/services/caches/shortcuts/search_and_retrieve
> ?search_method=services%2Fcaches%2Fsearch%2Fbbox
> &search_params=%7B%22status%22%3A%22Available%7CTemporarily+unavailable%22%2C%22bbox%22%3A%2234.388426%7C132.479998%7C34.389434%7C132.480770%22%7D
> &retr_method=services%2Fcaches%2Fgeocaches
> &retr_params=%7B%22fields%22%3A+%22code%7Cname%7Clocation%7Ctype%7Cstatus%7Cdifficulty%7Cterrain%7Csize%22%7D
> &wrap=true
> &langpref=jp%7Cen
> &consumer_key=J6M7x5rNz9YFJX38fE9n
> --- OKAPI revision ---
> 893
> --- Request headers ---
> Accept: application/json, text/javascript, */*; q=0.01
> Accept-Charset: utf-8,iso-8859-1;q=0.8,utf-16;q=0.8,*;q=0.7
> Accept-Language: en-US,*;q=0.9
> X-Requested-With: XMLHttpRequest
> Host:www.opencaching.de
> Connection: Keep-Alive
> User-Agent: Mozilla/5.0 (Linux; U; Android 2.2; en-us; Nexus One
> Build/FRF91) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1
> Accept-Encoding: gzip
--
Nic na świecie nie jest tak sprawiedliwie rozdzielone jak rozum:
nikt nie uważa, że ma go za mało.
===8<===
--
Consciousness: that annoying time between naps.
lots of them until the database tables are repaired after a server crash...
