Radicore Forum: Bug Reports » Problem in Delete Operation

Home » RADICORE development » Bug Reports » Problem in Delete Operation (SQL Errors during Delete in Sample System Classroom)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem in Delete Operation [message #1285]

Wed, 12 March 2008 22:41

melvinsdb
Messages: 16
Registered: November 2006
Location: Philippines

Junior Member

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

===========================================================

Report message to a moderator