View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||
---|---|---|---|---|---|---|---|---|---|
0000366 | v1.3 Release (Closed) | [All Projects] General | public | 2010-02-02 05:30 | 2010-03-31 22:41 | ||||
Reporter | clement | ||||||||
Assigned To | caseydk | ||||||||
Priority | normal | Severity | minor | Reproducibility | sometimes | ||||
Status | closed | Resolution | fixed | ||||||
Product Version | |||||||||
Target Version | Fixed in Version | 1.3 | |||||||
Summary | 0000366: Duplicate entry in task_departments on new task submission | ||||||||
Description | ERROR: /home/www/dmd.vhosts/w2p/web2project/classes/query.class.php(1169) : query failed(INSERT INTO `task_departments`(`task_id`,`department_id`) VALUES ('15','1')) - error was: Duplicate entry '15-1' for key 1 Backtrace: 0 /home/www/dmd.vhosts/w2p/web2project/classes/query.class.php:1169 dprint('/home/www/dmd.vhosts/w2p/web2project/classes/query.class.php',1169,0,'query failed(INSERT INTO `task_departments`(`task_id`,`department_id`) VALUES (\'15\',\'1\')) - error was: Duplicate entry \'15-1\' for key 1') 1 /home/www/dmd.vhosts/w2p/web2project/modules/tasks/tasks.class.php:612 exec() 2 /home/www/dmd.vhosts/w2p/web2project/modules/tasks/do_task_aed.php:156 store(CAppUI::__set_state(array( 'state' => array ( 'SAVEDPLACE-1' => 'm=tasks&a=view&task_id=14', 'SAVEDPLACE' => 'm=projects&a=view&project_id=2', 'ProjIdxTab' => 1, 'ProjIdxCompany' => '1', 'ProjIdxOrderDir' => 'asc', 'ProjVwTab' => 0, 'TaskListShowIncomplete' => 0, 'TaskLogVwTab' => 0, 'TaskAeTabIdx' => 0, ), 'user_id' => '4', 'user_first_name' => 'User', 'user_last_name' => 'NAME', 'user_company' => '1', 'user_department' => '1', 'user_email' => 'some_user@example.com', 'user_type' => '6', 'user_prefs' => array ( 'CURRENCYFORM' => 'en', 'EVENTFILTER' => 'all', 'LOCALE' => 'fr_FR', 'MAILALL' => '0', 'SHDATEFORMAT' => '%d/%m/%Y', 'TABVIEW' => '0', 'TASKASSIGNMAX' => '100', 'TASKLOGEMAIL' => '0', 'TASKLOGNOTE' => '0', 'TASKLOGSUBJ' => '', 'TIMEFORMAT' => '%H:%M', 'UISTYLE' => 'wps-redmond', 'USERFORMAT' => 'user', 'TASKSEXPANDED' => '0', ), 'day_selected' => NULL, 'user_locale' => 'fr', 'user_lang' => array ( 0 => 'fr_FR.utf-8', 1 => 'fra', 2 => 'fr_FR', 3 => 'fr', ), 'base_locale' => 'en', 'msg' => '', 'msgNo' => 0, 'defaultRedirect' => '', 'cfg' => array ( 'locale_warn' => false, ), 'version_major' => 1, 'version_minor' => 2, 'version_patch' => 2, 'version_string' => '1.2.2', 'last_insert_id' => '78', 'user_style' => NULL, 'user_is_admin' => 0, 'objStore' => NULL, 'project_id' => 0, 'boxTopRendered' => false, ))) 3 /home/www/dmd.vhosts/w2p/web2project/index.php:253 require('/home/www/dmd.vhosts/w2p/web2project/modules/tasks/do_task_aed.php') | ||||||||
Additional Information | Looks like issue 0000327, but with version 1.2.2 Issue occured two times today, and i've not managed to reproduce it yet. | ||||||||
Tags | No tags attached. | ||||||||
Attached Files |
|
![]() |
|
caseydk (administrator) 2010-02-02 22:40 |
I moved this to v1.3 as this is the next release (0000013:0000035 days). |
caseydk (administrator) 2010-03-27 22:05 |
Please go to the w2pversion table in your database and see what the maximum value of the db_version field is. This problem was resolved in database update 12 which was in the v1.1 release. |
caseydk (administrator) 2010-03-31 20:29 |
Marking this one as resolved since no one has been able to reproduce it since database update 12 in v1.1 |
caseydk (administrator) 2010-03-31 22:41 |
Closed in v1.3 release. |
![]() |
|||
Date Modified | Username | Field | Change |
---|---|---|---|
2010-02-02 05:30 | clement | New Issue | |
2010-02-02 22:39 | caseydk | Status | new => assigned |
2010-02-02 22:39 | caseydk | Assigned To | => caseydk |
2010-02-02 22:40 | caseydk | Project | v1.2 Release (Closed) => v1.3 Release (Closed) |
2010-02-02 22:40 | caseydk | Note Added: 0000744 | |
2010-03-27 22:05 | caseydk | Note Added: 0000778 | |
2010-03-31 20:29 | caseydk | Note Added: 0000794 | |
2010-03-31 20:29 | caseydk | Status | assigned => resolved |
2010-03-31 20:29 | caseydk | Resolution | open => fixed |
2010-03-31 22:41 | caseydk | Note Added: 0000800 | |
2010-03-31 22:41 | caseydk | Status | resolved => closed |
2010-03-31 22:41 | caseydk | Fixed in Version | => 1.3 |