View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||
---|---|---|---|---|---|---|---|---|---|
0000412 | v2.0 Release (Closed) | [All Projects] General | public | 2010-04-22 07:40 | 2010-06-21 21:17 | ||||
Reporter | pacho | ||||||||
Assigned To | caseydk | ||||||||
Priority | normal | Severity | block | Reproducibility | always | ||||
Status | closed | Resolution | fixed | ||||||
Product Version | |||||||||
Target Version | Fixed in Version | v2.0.0 | |||||||
Summary | 0000412: Creating dependant projects fails | ||||||||
Description | A user is trying to add an existing project as a subproject but could not find the according project. So the user tried to re-enter the subproject's data and an excepetion occurred (see additional info). it seems that the Shortdescription was too long??? Is this not checked??? I can live that an error occurs - even if a hint to the user regarding the field length would be better. I CANNOT LIVE WITH: That this is now the second error that occurred and the full DB access, including the admin password is displayed with the error! -> It should be avoided that within the error message a user name and especially the DB-admin password is displayed. | ||||||||
Additional Information | ERROR: C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\w2p\classes\query.class.php(1170) : query failed(INSERT INTO `projects`(`project_company`,`project_name`,`project_short_name`,`project_owner`,`project_start_date`,`project_end_date`,`project_status`,`project_color_identifier`,`project_description`,`project_creator`,`project_active`,`project_priority`,`project_type`,`project_parent`,`project_original_parent`,`project_updated`,`project_created`) VALUES ('1','ß-Test medico 18.00','ß-test med','6','2010-05-31 00:00:00','2010-07-01 23:59:59','2','FFFFFF','ß-Test Bettendispo und neues UI','6',1,'1','0','185','185',NOW(),NOW())) - error was: Data too long for column 'project_short_name' at row 1 Backtrace: 0 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\w2p\classes\query.class.php:1170 dprint('C:\\Program Files\\Apache Software Foundation\\Apache2.2\\htdocs\\w2p\\classes\\query.class.php',1170,0,'query failed(INSERT INTO `projects`(`project_company`,`project_name`,`project_short_name`,`project_owner`,`project_start_date`,`project_end_date`,`project_status`,`project_color_identifier`,`project_description`,`project_creator`,`project_active`,`project_priority`,`project_type`,`project_parent`,`project_original_parent`,`project_updated`,`project_created`) VALUES (\'1\',\'ß-Test medico 18.00\',\'ß-test med\',\'6\',\'2010-05-31 00:00:00\',\'2010-07-01 23:59:59\',\'2\',\'FFFFFF\',\'ß-Test Bettendispo und neues UI\',\'6\',1,\'1\',\'0\',\'185\',\'185\',NOW(),NOW())) - error was: Data too long for column \'project_short_name\' at row 1') 1 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\w2p\classes\query.class.php:1680 exec() 2 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\w2p\classes\w2p.class.php:223 insertObject('projects',CProject::__set_state(array( 'project_id' => 0, 'project_company' => '1', 'project_department' => NULL, 'project_name' => 'ß-Test medico 18.00', 'project_short_name' => 'ß-test med', 'project_owner' => '6', 'project_url' => '', 'project_demo_url' => '', 'project_start_date' => '2010-05-31 00:00:00', 'project_end_date' => '2010-07-01 23:59:59', 'project_actual_end_date' => NULL, 'project_status' => '2', 'project_percent_complete' => NULL, 'project_color_identifier' => 'FFFFFF', 'project_description' => 'ß-Test Bettendispo und neues UI', 'project_target_budget' => 0, 'project_actual_budget' => 0, 'project_scheduled_hours' => NULL, 'project_worked_hours' => NULL, 'project_task_count' => NULL, 'project_creator' => '6', 'project_active' => 1, 'project_private' => 0, 'project_departments' => '', 'project_contacts' => '', 'project_priority' => '1', 'project_type' => '0', 'project_parent' => '185', 'project_original_parent' => '185', 'project_location' => '', '_tbl_prefix' => '', '_tbl' => 'projects', '_tbl_key' => 'project_id', '_error' => '', '_query' => DBQuery::__set_state(array( 'query' => NULL, 'table_list' => NULL, 'where' => NULL, 'order_by' => NULL, 'group_by' => NULL, 'having' => NULL, 'limit' => NULL, 'offset' => -1, 'join' => NULL, 'type' => 'select', 'update_list' => NULL, 'value_list' => NULL, 'create_table' => NULL, 'create_definition' => NULL, 'include_count' => false, '_table_prefix' => '', '_query_id' => NULL, '_old_style' => NULL, '_db' => ADODB_mysql::__set_state(array( 'databaseType' => 'mysql', 'dataProvider' => 'mysql', 'hasInsertID' => true, 'hasAffectedRows' => true, 'metaTablesSQL' => 'SHOW TABLES', 'metaColumnsSQL' => 'SHOW COLUMNS FROM `%s`', 'fmtTimeStamp' => '\'Y-m-d H:i:s\'', 'hasLimit' => true, 'hasMoveFirst' => true, 'hasGenID' => true, 'isoDates' => true, 'sysDate' => 'CURDATE()', 'sysTimeStamp' => 'NOW()', 'hasTransactions' => false, 'forceNewConnect' => false, 'poorAffectedRows' => true, 'clientFlags' => 0, 'substr' => 'substring', 'nameQuote' => '`', 'compat323' => false, '_genIDSQL' => 'update %s set id=LAST_INSERT_ID(id+1);', '_genSeqSQL' => 'create table %s (id int not null)', '_genSeqCountSQL' => 'select count(*) from %s', '_genSeq2SQL' => 'insert into %s values (%s)', '_dropSeqSQL' => 'drop table %s', 'database' => 'dotproject', 'host' => 'localhost', 'user' => 'root', 'password' => 'xxxxxxxxx', 'debug' => false, 'maxblobsize' => 262144, 'concat_operator' => '+', 'length' => 'length', 'random' => 'rand()', 'upperCase' => 'upper', 'fmtDate' => '\'Y-m-d\'', 'true' => '1', 'false' => '0', 'replaceQuote' => '\\\'', 'charSet' => false, 'metaDatabasesSQL' => '', 'uniqueOrderBy' => false, 'emptyDate' => ' ', 'emptyTimeStamp' => ' ', 'lastInsID' => false, 'hasTop' => false, 'readOnly' => false, 'genID' => 0, 'raiseErrorFn' => false, 'cacheSecs' => 3600, 'memCache' => false, 'memCacheHost' => NULL, 'memCachePort' => 11211, 'memCacheCompress' => false, 'sysUTimeStamp' => false, 'arrayClass' => 'ADORecordSet_array', 'noNullStrings' => false, 'numCacheHits' => 0, 'numCacheMisses' => 0, 'pageExecuteCountRows' => true, 'uniqueSort' => false, 'leftOuter' => false, 'rightOuter' => false, 'ansiOuter' => false, 'autoRollback' => false, 'fnExecute' => false, 'fnCacheExecute' => false, 'blobEncodeType' => false, 'rsPrefix' => 'ADORecordSet_', 'autoCommit' => true, 'transOff' => 0, 'transCnt' => 0, 'fetchMode' => false, 'null2null' => 'null', '_oldRaiseFn' => false, '_transOK' => NULL, '_connectionID' => NULL, '_errorMsg' => 'Data too long for column \'project_short_name\' at row 1', '_errorCode' => false, '_queryID' => false, '_isPersistentConnection' => false, '_bindInputArray' => false, '_evalAll' => false, '_affected' => false, '_logsql' => false, '_transmode' => '', 'databaseName' => 'dotproject', )), '_db_funcs' => array ( 0 => 'NOW()', ), )), 'project_updated' => 'NOW()', 'project_created' => 'NOW()', )),'project_id') 3 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\w2p\modules\projects\projects.class.php:542 store() 4 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\w2p\modules\projects\do_project_aed.php:18 store(CAppUI::__set_state(array( 'state' => array ( 'SAVEDPLACE-1' => 'm=projects', 'SAVEDPLACE' => 'update_project_status=1&m=projects&project_status=0', 'ProjIdxTab' => 0, 'ProjIdxCompany' => '0', 'ProjIdxOrderDir' => 'desc', 'ProjIdxOrderBy' => 'task_log_problem', 'ProjVwTab' => 0, 'TaskListShowIncomplete' => 0, 'projsearchtext' => ' medico Release 18.00', 'ProjIdxowner' => 0, 'ProjIdxDepartment' => 'company_0', 'ProjectIdxFilter' => '-1', ), 'user_id' => '6', 'user_first_name' => 'Fr.', 'user_last_name' => 'Nolte', 'user_company' => '0', 'user_department' => '0', 'user_email' => 'med.uni-duesseldorf.de@med.uni-duesseldorf.de', 'user_type' => '0', 'user_prefs' => array ( 'LOCALE' => 'de_DE', 'TABVIEW' => '0', 'SHDATEFORMAT' => '%d.%m.%Y', 'TIMEFORMAT' => '%H:%M', 'UISTYLE' => 'web2project', 'TASKASSIGNMAX' => '100', 'USERFORMAT' => 'user', 'CURRENCYFORM' => 'de_DE', 'EVENTFILTER' => 'my', 'MAILALL' => '0', 'TASKLOGEMAIL' => '0', 'TASKLOGSUBJ' => '', 'TASKLOGNOTE' => '0', 'TASKSEXPANDED' => '1', 'LGDATEFORMAT' => '%B %d, %Y', 'TIMEZONE' => 'America/New_York', 'DAYLIGHTSAVINGS' => '1', ), 'day_selected' => NULL, 'user_locale' => 'de', 'user_lang' => array ( 0 => 'de_DE.utf-8', 1 => 'de', 2 => 'de_DE', 3 => 'de', ), 'base_locale' => 'en', 'msg' => '', 'msgNo' => 0, 'defaultRedirect' => '', 'cfg' => array ( 'locale_warn' => false, ), 'version_major' => 1, 'version_minor' => 3, 'version_patch' => 0, 'version_string' => '1.3.0-pre', 'last_insert_id' => '185', 'user_style' => NULL, 'user_is_admin' => 0, 'objStore' => NULL, 'project_id' => 0, 'boxTopRendered' => true, ))) 5 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\w2p\index.php:253 require('C:\\Program Files\\Apache Software Foundation\\Apache2.2\\htdocs\\w2p\\modules\\projects\\do_project_aed.php') | ||||||||
Tags | No tags attached. | ||||||||
Attached Files |
|
![]() |
|
caseydk (administrator) 2010-05-04 19:47 |
The string length validations are done using mb_string functions, please update and double check. Further, the error message is fixed in r1069 to not display db credentials. |
caseydk (administrator) 2010-05-23 20:14 |
Resolved. |
![]() |
|||
Date Modified | Username | Field | Change |
---|---|---|---|
2010-04-22 07:40 | pacho | New Issue | |
2010-04-29 19:25 | caseydk | Status | new => assigned |
2010-04-29 19:25 | caseydk | Assigned To | => caseydk |
2010-05-04 19:43 | caseydk | Project | v1.3 Release (Closed) => v2.0 Release (Closed) |
2010-05-04 19:48 | caseydk | Note Added: 0000856 | |
2010-05-04 19:48 | caseydk | Status | assigned => feedback |
2010-05-23 20:14 | caseydk | Note Added: 0000888 | |
2010-05-23 20:14 | caseydk | Status | feedback => resolved |
2010-05-23 20:14 | caseydk | Resolution | open => fixed |
2010-06-21 21:17 | caseydk | Status | resolved => closed |
2010-06-21 21:17 | caseydk | Fixed in Version | => v2.0 |