Subject: Crash report from Locus - help desk
From: Locus <support.locus@asamm.com>
Date: 20. 3. 2014 6:50
To: jiri.mlavec@asamm.com

EXCEPTION: SQLSTATE[HY093]: Invalid parameter number: no parameters were boundException on line 20775 in file /hosting/www/locusmap.eu/help/library/hotFiles.php, PHP 5.3.28 (Linux)
Error has occured!
Error description:

EXCEPTION: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound

Exception on line 20775 in file /hosting/www/locusmap.eu/help/library/hotFiles.php, PHP 5.3.28 (Linux)

Corrupted query:
SELECT `ur_knowledge_base_categories`.* FROM `ur_knowledge_base_categories` WHERE (id = ?) LIMIT 1

Requested page:
http://help.locusmap.eu/response/hold_center_method/edit

Module name:system
Controller name:response
Action name:edit
Parameters:slug = (string) hold_center_method
type = (string) idea
title = (string) Hold center method improvements
content = (string) From the manual: "Hold center method – after 5 seconds of inactivity the map returns to your actual GPS position on the center of the screen". But not necessary. When for example I shift the map and turn on geocache dialog and I leave it after longest time the map is centered on gps position again. In my opinion it should not because there wasn`t a 5 sec inactivity - I do something on the screen all the time. Suggestion: when some dialogs are open on the screen, map inactivity timer should be paused until dialog is closed.
MAX_FILE_SIZE = (string) 31457280
categoryIds = (array) 1
knowledgeBaseEnable = (string) 0is_private = (string) 0
Stack trace:
In file On line Called class Called function With arguments
hotFiles.php20153Zend_Db_Statement_Pdo_executearray
hotFiles.php1273Zend_Db_Statementexecutearray
hotFiles.php2312Zend_Db_Adapter_Abstractqueryobject, array
hotFiles.php8314Zend_Db_Adapter_Pdo_Abstractqueryobject
hotFiles.php8176Zend_Db_Table_Abstract_fetchobject
Events.php312Zend_Db_Table_AbstractfetchRowobject
Event.php63KnowledgeBase_Handler_EventsonAfterSaveobject
Useresponse.php(1) : eval()'d code(9) : eval()'d code994Singular_Eventdispatchstring, object
Response.php1049System_Model_Rowsavearray
ResponseController.php286System_Model_Responsesavearray
hotFiles.php44847ResponseControllereditAction
hotFiles.php27607Zend_Controller_Actiondispatchstring
hotFiles.php6380Zend_Controller_Dispatcher_Standarddispatchobject, object
Bootstrap.php244Zend_Controller_Frontdispatch
index.php90Singular_Bootstraprun
System information:
PHP version:
5.3.28 on Linux runned as cgi-fcgi

Loaded extensions:
Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dba, dom, hash, fileinfo, filter, ftp, gd, gettext, gmp, SPL, iconv, session, json, mbstring, mcrypt, standard, mysqlnd, mysqli, odbc, mysql, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, pspell, Reflection, imap, shmop, SimpleXML, snmp, soap, sockets, SQLite, exif, sysvsem, sysvshm, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, cgi-fcgi, imagick, mhash

MySQL server:
MySQL 5.5.21 via PDO_MYSQL 1.0.2
UseResponse:
Product version:
2.3.10 released on March 12, 2013 12:00:00 AM GMT by USWebStyle, Inc

Installed modules:
Systemv. 2.3.10 on March 12, 2013 12:00:00 AM GMT by USWebStyle, Inc
Resourcesv. 2.2 on August 5, 2013 12:00:00 AM GMT by USWebStyle, Inc
Ideasv. 2.1 on August 5, 2013 12:00:00 AM GMT by USWebStyle, Inc
Problemsv. 2.1 on March 15, 2013 12:00:00 AM GMT by USWebStyle, Inc
Questionsv. 2.1 on March 15, 2013 12:00:00 AM GMT by USWebStyle, Inc
Thanksv. 2.1 on March 15, 2013 12:00:00 AM GMT by USWebStyle, Inc
Filesv. 2.0 on June 7, 2012 12:00:00 AM GMT by USWebStyle, Inc
Categoriesv. 2.2 on August 5, 2013 12:00:00 AM GMT by USWebStyle, Inc
Moderationv. 2.0 on June 7, 2012 12:00:00 AM GMT by USWebStyle, Inc
Updatesv. 2.1 on March 15, 2013 12:00:00 AM GMT by USWebStyle, Inc
Login Plusv. 2.1 on August 5, 2013 12:00:00 AM GMT by USWebStyle, Inc
Mergerv. 2.0 on June 7, 2012 12:00:00 AM GMT by USWebStyle, Inc
Pollsv. 2.0 on June 7, 2012 12:00:00 AM GMT by USWebStyle, Inc
Backupv. 2.0 on June 7, 2012 12:00:00 AM GMT by USWebStyle, Inc
Private Objectsv. 2.1 on March 15, 2013 12:00:00 AM GMT by USWebStyle, Inc
Knowledge Basev. 2.1 on March 15, 2013 12:00:00 AM GMT by USWebStyle, Inc
Chatv. 2.3 on March 15, 2013 12:00:00 AM GMT by USWebStyle, Inc
Autoglobal variables:

GET

Array ( )

POST

Array ( [type] => idea [title] => Hold center method improvements [content] => From the manual: "Hold center method – after 5 seconds of inactivity the map returns to your actual GPS position on the center of the screen". But not necessary. When for example I shift the map and turn on geocache dialog and I leave it after longest time the map is centered on gps position again. In my opinion it should not because there wasn`t a 5 sec inactivity - I do something on the screen all the time. Suggestion: when some dialogs are open on the screen, map inactivity timer should be paused until dialog is closed. [MAX_FILE_SIZE] => 31457280 [categoryIds] => Array ( [0] => 1 ) [knowledgeBaseEnable] => 0 [is_private] => 0 )

COOKIE

Array ( [_ga] => GA1.2.744253119.1385979105 [__utma] => 160818720.744253119.1385979105.1394960015.1395066645.80 [__utmz] => 160818720.1394646792.74.12.utmcsr=facebook.com|utmccn=(referral)|utmcmd=referral|utmcct=/l.php [views] => {"1529":1,"1556":1,"1558":1,"1588":1,"1590":1,"226":1,"209":1,"18":1,"1591":1,"1599":1,"1623":1,"1631":1,"1643":1,"1684":1,"1250":1,"1973":1,"1958":1,"1207":1,"1715":1,"1738":1,"783":1,"1751":1,"1782":1,"1796":1,"1799":1,"1820":1,"1864":1,"1826":1,"1875":1,"1902":1,"1909":1,"1913":1,"1942":1,"1943":1,"217":1,"239":1,"349":1,"356":1,"255":1,"430":1,"1960":1,"1974":1,"1470":1,"279":1,"292":1,"342":1,"358":1,"359":1,"408":1,"412":1,"361":1,"1937":1,"1976":1,"1975":1,"1348":1,"1245":1,"1557":1,"1952":1,"1979":1,"1959":1,"1347":1,"1982":1,"4":1,"28":1,"31":1,"75":1,"121":1,"124":1,"211":1,"54":1,"109":1,"162":1,"318":1,"470":1,"503":1,"613":1,"833":1,"904":1,"1019":1,"1068":1,"1188":1,"1431":1,"1533":1,"1584":1,"1665":1,"1710":1,"1726":1,"1962":1,"258":1,"496":1,"900":1,"1013":1,"1061":1,"1906":1,"1361":1,"364":1,"363":1,"390":1,"422":1,"433":1,"455":1,"30":1,"411":1,"464":1,"476":1,"493":1,"502":1,"469":1,"489":1,"619":1,"261":1,"23":1,"511":1,"517":1,"524":1,"551":1,"561":1,"598":1,"604":1,"620":1,"627":1,"553":1,"1365":1,"1467":1,"1056":1,"624":1,"666":1,"761":1,"775":1,"746":1,"762":1,"462":1,"8":1,"348":1,"90":1,"386":1,"369":1,"1983":1,"1984":1,"1372":1,"1367":1,"1985":1,"1587":1,"1914":1,"765":1,"1020":1,"1488":1,"478":1,"1651":1,"1003":1,"1158":1,"912":1,"1500":1,"1451":1,"1251":1,"1112":1,"1853":1,"1771":1,"1254":1,"1364":1,"1871":1,"1761":1,"1823":1,"1818":1,"1686":1,"723":1,"1714":1,"1692":1,"1691":1,"492":1,"160":1,"1988":1,"1877":1,"1987":1,"142":1,"1986":1,"1935":1,"1044":1,"32":1,"207":1,"536":1,"6":1,"180":1,"922":1,"956":1,"1026":1,"1164":1,"1278":1,"1526":1,"1661":1,"1732":1,"1208":1,"960":1,"688":1,"1648":1,"1312":1,"1395":1,"1005":1,"257":1,"105":1,"1081":1,"1554":1,"1921":1,"1350":1,"1951":1,"589":1,"1989":1,"1972":1,"1990":1,"1968":1,"1971":1,"283":1,"1991":1,"1828":1,"1858":1,"1842":1,"1829":1,"1857":1,"1525":1,"1517":1,"1420":1,"1031":1,"995":1,"885":1} [PHPSESSID] => qsft9jsm0snfvumj8kksetq411 [PHPSESID] => 4158cfe31bf66b39a6b5adb707dc66aa )

SESSION

Array ( [R0LE] => Array ( [assigned] => UseResponse ) [Notifications] => Array ( [messages] => Array ( [error] => Array ( ) [success] => Array ( ) [info] => Array ( ) ) ) [Zend_Auth] => Array ( [storage] => stdClass Object ( [id] => 124 [ldap_id] => 0 [google_id] => 0 [twitter_id] => 0 [facebook_id] => 0 [full_name] => Menion [password] => c5ae757ebc318203619d746f6c177b10 [email] => jiri.mlavec@asamm.com [gravatar_email] => jiri.mlavec@asamm.com [photo] => migrated_avatar_3777500.jpg [role] => administrator [is_active] => 1 [created_at] => 2012-01-14 00:00:00 [updated_at] => 2014-03-07 07:56:58 [logged_at] => [is_trusted] => 0 [hidden] => 0 [api_key] => ) ) [Redirect] => Array ( [url] => ) )