| Problem in Delete Operation [message #1285] |
Wed, 12 March 2008 22:41  |
|
|
Sir Tony,
We encountered errors in Deleting Teachers, Students, Subjects, Lessons,... even if they are newly added, then deleted right after.
The error message is posted below.
Any suggestions on fixing this?
Thanks
Melvin
============================================================ =
The following has been reported to the administrator:
2008-03-13 02:36:36
Fatal Error: MySQL error: 1052 - Column 'last_name' in field list is ambiguous (# 1052).
SQL query: SELECT SQL_CALC_FOUND_ROWS crs_conflict.*, crs_class.class_name, crs_lesson1.lesson_name AS lesson_name1, crs_lesson2.lesson_name AS lesson_name2, CONCAT(last_name, ', ', first_name) AS student_name, CONCAT(title, ' ', first_name, ' ', last_name) AS teacher_name FROM crs_conflict LEFT JOIN crs_class ON (crs_class.class_id=crs_conflict.class_id) LEFT JOIN crs_lesson AS crs_lesson1 ON (crs_lesson1.lesson_id=crs_conflict.lesson_id1) LEFT JOIN crs_lesson AS crs_lesson2 ON (crs_lesson2.lesson_id=crs_conflict.lesson_id2) LEFT JOIN crs_student ON (crs_student.student_id=crs_conflict.student_id) LEFT JOIN crs_teacher ON (crs_teacher.teacher_id=crs_conflict.teacher_id) WHERE crs_conflict.teacher_id='2'
Error in line 420 of file 'E:\xampp\htdocs\starsii\includes\dml.mysqli.class.inc'.
Host Info: localhost via TCP/IP
Server Version: 5.0.51
Client Info: 5.0.51, Client Encoding: latin1
Script: /radicore/classroom/teacher_del.php
User Id: MANAGER
Remote Address: 127.0.0.1
Request URI: /radicore/classroom/teacher_del.php?session_name=menu2
===========================================================
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
