Axios在資料存在時回傳500錯誤狀態碼

Question

我正在使用Laravel 8，VueJS 和Axios 來開發我的應用程式，但每次都嘗試從資料庫>Axios 來開發我的應用程式，但每次嘗試從資料庫中取得所有記錄時，它都會傳回一個狀態碼為500的錯誤。即使使用 Postman/Insomnia 取得資料時沒有錯誤。

我嘗試清空獲取資料的表，錯誤消失了，並傳回狀態碼為200的空資料。

Store 模組：

import axios from 'axios'

export default {
    namespaced: true,
    state: {
        courses: [],
        teacher: '',
    },
    getters: {
        allCourses(state) {
            return state.courses
    },
},
actions: {
    async fetchAllCourses({ commit }) {
        const response = await axios.get('teacher/course-management/list')
        console.log(response.data.data)
        commit('SET_COURSES', response.data.data)
    }
},
mutations: {
    SET_COURSES(state, courses) {
        state.courses = courses
    }
}

控制器：

public function fetchAllCourses() {
    try {
        $courses = Course::all()->sortBy('id');

        $data = $courses->transform(function ($course) {
            // ! 取得教師ID
            $teacherId = $this->user->teacher->id;
            // ! 根據ID取得教師姓名
            $teacherName = $this->getTeacherName($teacherId);

            return [
                'id' => $course->id,
                'teacher_id' => $course->teacher_id,
                'teacher' => $teacherName,
                'section' => $course->section,
                'code' => $course->code,
                'status' => $course->status,
                'image' => $course->image,
            ];
        });

        return $this->success('請求成功', $data);
    } catch (\Exception $e) {
        return $this->error($e->getMessage(), $e->getCode());
    }
}

Answer 1

問題已解決。

public function fetchAllCourses() {
        try {
            $courses = Course::all()->sortBy('id');
    
            $data = $courses->transform(function ($course) {
                return [
                    'id' => $course->id,
                    'teacher_id' => $course->teacher_id,
                    'teacher' => $this->getTeacherName($course->teacher_id),
                    'section' => $course->section,
                    'code' => $course->code,
                    'status' => $course->status,
                    'image' => $course->image,
                ];
            });
    
            return $this->success('请求成功', $data);
        } catch (\Exception $e) {
            return $this->error($e->getMessage(), $e->getCode());
        }   
    }