So that last query you sent doesn’t return any records so I assume it must be a data entry issue. I’ll work on entering more data and see if that fixes the problem.
You need to login in order to like this post: click here
Hmm, below is the query for student roster. Run the following code through the SQL Interface and tell me if it returns a result. I am assuming the courseSecID is “1” based on your previous post:
SELECT a.stuID, a.courseSecCode, a.termCode, a.courseCredits, CASE a.status WHEN 'A' THEN 'Add' WHEN 'N' THEN 'New' ELSE 'Drop' end AS 'Status', b.acadProgCode, b.acadLevelCode, c.courseSection, c.facID, c.roomCode, c.secShortTitle, c.startDate, c.endDate, c.startTime, c.endTime, c.dotw, c.instructorMethod FROM stu_course_sec a LEFT JOIN stu_acad_level b ON a.stuID = b.stuID LEFT JOIN course_sec c ON a.courseSecID = c.courseSecID WHERE c.courseSecID = '1' AND c.termCode = a.termCode AND a.status IN( 'A', 'N', 'D' ) AND b.addDate = (SELECT Max(addDate) FROM stu_program WHERE stuID = a.stuID) GROUP BY a.stuID, a.courseSecCode, a.termCode
Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaignYou need to login in order to like this post: click here
I was using safari, but after using Chrome I received the same error. Is there anything in the code I could look at or start investigating to get more information on the issue?You need to login in order to like this post: click here
Are you using Safari by chance? What happens when you use a different browser?
Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaignYou need to login in order to like this post: click here
I ran those queries and there is a row with the student’s information in both tables.
You need to login in order to like this post: click here
If you go to SRPO screen (Screens > Person Management > Student > SPRO) and do a lookup for the student in question, is the record active or inactive? Using the SQL Interface (Screens > SQL > SQL Interface), run the following queries one at a time to make sure it returns data:
SELECT * FROM stu_course_sec; SELECT * FROM stu_acad_cred;
Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaignYou need to login in order to like this post: click here
That’s the weird thing. There are no logs for that error but there are for other errors. I tail the Log file when I try to generate the script and it doesn’t spit anything out, unlike other errors that I have found.
You need to login in order to like this post: click here
What is in the error logs (/app/tmp/logs/*.txt)?
Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaignYou need to login in order to like this post: click here
Yes. There’s only one class and I’ve added that student to the class.
You need to login in order to like this post: click here
Are there students in the course section you are trying to print out a roster for?
Joshua Parker
Twitter | Facebook | DigitalOcean | tinyCampaignYou need to login in order to like this post: click here
I was able to successfully register a student and was trying to then print off a roster for that class. However, I hit a snag as when I fill out the Fields for running the student roster report and click submit I get taken to a 404 page (/sect/sros/1/default/). Do you have any suggestions on things to try?
You need to login in order to like this post: click here
You must be logged in to reply to this topic.