Project

General

Profile

Bug #4054

Assignement submition causes SQL error on c_id

Added by Hubert Borderiou almost 8 years ago. Updated over 7 years ago.

Status:
Feature implemented
Priority:
Normal
Assignee:
-
Category:
-
Target version:
Start date:
18/11/2011
Due date:
% Done:

50%

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

Description

When I want to submit a paper.

----------------------------------------------------------------
DATABASE ERROR #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 'WHERE c_id = 1' at line 1
QUERY :
SHOW FIELDS FROM `chamilo19`.`c_student_publication` LIKE 'sent_date' WHERE c_id = 1
FILE :
/home/chamilo/www/chamilo.classic/main/work/work.php
LINE :
799
----------------------------------------------------------------
DATABASE ERROR #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 'WHERE c_id = 1' at line 1
QUERY :
ALTER TABLE `chamilo19`.`c_student_publication` ADD sent_date DATETIME NOT NULL WHERE c_id = 1
FILE :
/home/chamilo/www/chamilo.classic/main/work/work.php
LINE :
802
----------------------------------------------------------------

Associated revisions

Revision 405c0ff2 (diff)
Added by Julio Montoya almost 8 years ago

Removing very weird "alter table add column sent_date" in the work tool see #4054 thanks hborderiou for reporting it

History

#1

Updated by Julio Montoya almost 8 years ago

  • Status changed from New to Assigned
  • Assignee set to Julio Montoya
#2

Updated by Julio Montoya almost 8 years ago

  • Status changed from Assigned to Needs more info
  • Assignee deleted (Julio Montoya)
  • % Done changed from 0 to 50
#3

Updated by Julio Montoya over 7 years ago

  • Status changed from Needs more info to Feature implemented
  • Target version set to 1.9 Stable

Also available in: Atom PDF