2015-11-17 11:45:21
Errors occurred when moving Sent Message to inbox
Hi
I have 2.2 installed. When I went to sent message area and clicked on move to inbox button, errors occurred. The information is listed below
Please Help~ Thanks.
Action:
go "sent message" area and click "move to inbox" show error.
Error message 1: (language mode: english)
The following errors occurred:
ATutor was unable to access the database. If the problem persists, please report this to an Administrator with this date reference (11/17/2015 10:46:10 am)
Error message 2: (language mode: zh_tw)
[ AT_ERROR_DB_QUERY ]
Log:
[17-Nov-2015 10:15:24 Asia/Taipei] SELECT * FROM AT_config
[17-Nov-2015 10:15:24 Asia/Taipei] SELECT * FROM AT_languages ORDER BY native_name
[17-Nov-2015 10:15:24 Asia/Taipei] SELECT status FROM AT_themes WHERE dir_name='default'
[17-Nov-2015 10:15:24 Asia/Taipei] SELECT customized FROM AT_themes WHERE dir_name = 'default'
[17-Nov-2015 10:15:24 Asia/Taipei] SELECT customized FROM AT_themes WHERE dir_name = 'default'
[17-Nov-2015 10:15:24 Asia/Taipei] SELECT * FROM AT_courses ORDER BY title
[17-Nov-2015 10:15:24 Asia/Taipei] SELECT dir_name, privilege, admin_privilege, status, cron_interval, cron_last_run FROM AT_modules WHERE status=2
[17-Nov-2015 10:15:24 Asia/Taipei] SELECT L.* FROM AT_language_text L, AT_language_pages P WHERE L.language_code="en" AND L.term=P.term AND P.page="/inbox/sent_messages.php" ORDER BY L.variable ASC
[17-Nov-2015 10:15:25 Asia/Taipei] SELECT L.* FROM AT_language_text L WHERE L.language_code="en" AND L.term="test" ORDER BY variable ASC LIMIT 1
[17-Nov-2015 10:15:25 Asia/Taipei] INSERT IGNORE INTO AT_language_pages (`term`, `page`) VALUES ("test", "/inbox/sent_messages.php")
[17-Nov-2015 10:15:25 Asia/Taipei] SELECT status FROM AT_members WHERE member_id=51
[17-Nov-2015 10:15:25 Asia/Taipei] SELECT login, first_name, second_name, last_name FROM AT_members WHERE member_id='51'
[17-Nov-2015 10:15:25 Asia/Taipei] SELECT E.course_id FROM AT_course_enrollment E WHERE E.member_id=51 AND E.approved<>'n'
[17-Nov-2015 10:15:25 Asia/Taipei] SELECT COUNT(*) AS cnt FROM AT_messages WHERE to_member_id=51 AND new=1
[17-Nov-2015 10:15:25 Asia/Taipei] SELECT login, first_name, second_name, last_name FROM AT_members WHERE member_id='51'
[17-Nov-2015 10:15:25 Asia/Taipei] SELECT * FROM AT_messages_sent WHERE from_member_id=51 ORDER BY date_sent DESC
[17-Nov-2015 10:30:02 Asia/Taipei] 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 '51}, date_sent, 0, 0, subject, body FROM AT_messages_sent WHERE from_member_id=5' at line 1
SQL: INSERT INTO AT_messages SELECT 0, course_id, from_member_id, {51}, date_sent, 0, 0, subject, body FROM AT_messages_sent WHERE from_member_id=51 AND message_id IN (37,0)