Project

General

Profile

Bug #7642

Work tool broken: impossible to edit

Added by Yannick Warnier over 4 years ago. Updated over 4 years ago.

Status:
Bug resolved
Priority:
High
Assignee:
Category:
Assignments / Work
Target version:
Start date:
19/04/2015
Due date:
% Done:

100%

Estimated time:
Complexity:
Normal
SCRUM pts - complexity:
?

Description

  • create a task
  • edit it
  • a dump appears (apparently an incomplete debug somehow)

This prevents edition. On line 111 of main/work/edit_work.php, there is a var_dump() and an exit

Once these are removed, the update queries fail anyway. Apparently, the "id" in c_student_publication_assignment is left to null (probably a consequence of adding the iid as unique key), which returns an error when trying to update (in work.lib.php).

I believe reviewing the full tool is necessary to avoid this issue.

Issue #7621 should be reviewed after this.

Associated revisions

Revision 9bf397d8 (diff)
Added by Julio Montoya over 4 years ago

Fix work edition see #7642

History

#1

Updated by Julio Montoya over 4 years ago

  • Status changed from Assigned to Needs more info
  • Assignee changed from Julio Montoya to Yannick Warnier

fixed

#2

Updated by Yannick Warnier over 4 years ago

  • Status changed from Needs more info to Assigned
  • Assignee changed from Yannick Warnier to Julio Montoya

After fresh install, I still get this when updating (adding a final deadline):

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 9' in /var/www/chamilo110x/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104 Stack trace: #0 /var/www/chamilo110x/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(104): PDO->query('UPDATE c_studen...') #1 /var/www/chamilo110x/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(833): Doctrine\DBAL\Driver\PDOConnection->query('UPDATE c_studen...') #2 /var/www/chamilo110x/main/inc/lib/database.lib.php(320): Doctrine\DBAL\Connection->executeQuery('UPDATE c_studen...') #3 /var/www/chamilo110x/main/work/work.lib.php(4267): Database::query('UPDATE c_studen...') #4 /var/www/chamilo110x/main/work/edit_work.php(113): updatePublicationAssignment('1', Array, Array, 0) #5 {main} Next exception 'Doctrine\DBAL\Driver\PDOException' with message in /var/www/chamilo110x/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 90

Also, the "non-final" deadline checkbox, when ticked, doesn't show the calendar selector.

#3

Updated by Julio Montoya over 4 years ago

  • Assignee changed from Julio Montoya to Yannick Warnier

I just fixed those.

#4

Updated by Yannick Warnier over 4 years ago

  • Status changed from Assigned to Bug resolved
  • Assignee changed from Yannick Warnier to Julio Montoya
  • % Done changed from 0 to 100

OK, now, indeed, it works. Thanks

Also available in: Atom PDF