Imp : Issue in submitting assigments , 500 server error

Tagged: 500 server error, assignments

This topic has 1 reply, 2 voices, and was last updated 8 years, 2 months ago by Anshuman Sahu.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts
October 16, 2016 at 5:04 pm #74792

amitgoel1287
Spectator

Following are the steps to reproduce the issue. I have created assignments with text area option. I have comments enabled . I have activity also enabled in buddy press. Now, When I submit answer to the assignment in the given text area and click Answer Assignment button. I get 500 Server error. Then I press the back button of the browser but the assignment is submitted. Also, If I update the answer and submit again, the same problem (500 server error) happens but the updated answer is also submitted. On pressing back button on the browser to go back to assignment, I see the first answer still showing in the answer text area. I have following SQL error log if it helps you in debugging .. 2016/10/16 10:42:03 [error] 1051#1051: *78535 FastCGI sent in stderr: "PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS activity
WHERE activity.component = 'course'

' at line 1 for query

SELECT date_recorded FROM AS activity

WHERE activity.component = 'course'

AND activity.type = 'assignment_submitted'

AND user_id = 37

AND ( item_id = 4482 OR secondary_item_id = 4482 )

ORDER BY date_recorded DESC

LIMIT 0,1
 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), bp_template_redirect, do_action('bp_template_redirect'), bp_screens, do_action('bp_screens'), bp_course_my_results, bp_core_load_template, load_template, require_once('/themes/wplms/members/single/home.php'), locate_template, load_templa" while reading upstream, client: 49.207.4.243, server: careerplot.com, request: "GET /members/aabcc/course/course-results/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/php-fpm-wordpress.sock:", host: "careerplot.com", referrer: "https://careerplot.com/members/aabcc/course/course-stats/" Please advise me a fix ASAP.

October 17, 2016 at 11:47 am #74923

Anshuman Sahu
Keymaster

I just checked the assigment submissions and assignment results also and found them to be working just fine . Please make sure that your wplms theme and all its plugins are updated to latest version .Clear cache and re-save permalinks after update . If already updated and still facing the issue then please share your site url and admin credentials to check the issue at your end .
Author

Posts

Viewing 2 posts - 1 through 2 (of 2 total)

The topic ‘Imp : Issue in submitting assigments , 500 server error’ is closed to new replies.