Project

General

Profile

Bug #4477

SQL error when creating a new course

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

Status:
Bug resolved
Priority:
Normal
Category:
-
Target version:
Start date:
14/03/2012
Due date:
% Done:

100%

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

Description

Hi,
I've installed a new Chamilo1.9
If a create a new course and change admin parameters to Test server
I've got a SQL error

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 'AND
ctt.c_id = AND
tet.las' at line 1
QUERY :
SELECT tet.*, tet.lastedit_date last_date, tet.tool tool, tet.ref ref, tet.lastedit_type type, tet.to_group_id group_id, ctt.image image, ctt.link link FROM `chamiloOrig`.`c_item_property` tet, `chamiloOrig`.`c_tool` ctt WHERE tet.c_id = AND
ctt.c_id = AND
tet.lastedit_date > '2012-03-14 09:59:57' AND ctt.name = tet.tool AND ctt.visibility = '1' AND tet.lastedit_user_id != 1 AND tet.id_session = '0' ORDER BY tet.lastedit_date
FILE :
/home/chamilo/www/chamilo.googlecode.orig/main/inc/lib/display.lib.php
LINE :
1080
CLASS :
Display
METHOD :
show_notification

regards,

Associated revisions

Revision 3789e8d3 (diff)
Added by Hubert Borderiou over 7 years ago

Replace show_notification($course) with show_notification($course_info) - ref #4477

Revision 536d319e (diff)
Added by Julio Montoya over 7 years ago

One more fix due a SQL error see #4477

History

#1

Updated by Hubert Borderiou over 7 years ago

  • Status changed from New to Needs more info
  • % Done changed from 0 to 90

Replace in main/inc/lib/course.lib.php
Replace show_notification($course) with show_notification($course_info)

#2

Updated by Yannick Warnier over 7 years ago

  • Status changed from Needs more info to Bug resolved
  • Assignee set to Hubert Borderiou
  • Target version set to 1.9 Beta
  • % Done changed from 90 to 100

I consider the issue closed... (since then we've had other versions without problems in courses creation, so I guess it's fixed).

Also available in: Atom PDF