Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Bug Reports » Problem in Delete Operation (SQL Errors during Delete in Sample System Classroom)
Problem in Delete Operation [message #1285] Wed, 12 March 2008 22:41 Go to next message
melvinsdb is currently offline  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

===========================================================
Re: Problem in Delete Operation [message #1288 is a reply to message #1285] Thu, 13 March 2008 07:29 Go to previous message
AJM is currently offline  AJM
Messages: 2347
Registered: April 2006
Location: Surrey, UK
Senior Member
Problem found and fixed. You can download the patch from http://www.radicore.org/forum/index.php?t=msg&goto=1287

Previous Topic: Problem with utf-8/Serbian(Latin)
Next Topic: v1.34 issue with audit_logging and getFieldspec_original
Goto Forum:
  


Current Time: Thu Mar 28 09:56:31 EDT 2024

Total time taken to generate the page: 0.00932 seconds