eduTrac SIS Support Center
  • Support
    • Forums
    • Issues
  • Services
    • Support
    • Enterprise
  • News
  • Resources
  • Subscription

Community Forums

Home/Forums/Product Support/Localhost Installs/Student Roster 404 Error

Student Roster 404 Error

SROS
  • 4 years, 8 months ago Marc Tanis
    Member
    • Topics: 1
    • Replies: 5
    • Total Posts: 6

    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

    4 years, 9 months ago Joshua Parker
    Keymaster
    • Topics: 4
    • Replies: 638
    • Total Posts: 642

    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 | tinyCampaign

    You need to login in order to like this post: click here

    4 years, 9 months ago Marc Tanis
    Member
    • Topics: 1
    • Replies: 5
    • Total Posts: 6
    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

    4 years, 9 months ago Joshua Parker
    Keymaster
    • Topics: 4
    • Replies: 638
    • Total Posts: 642

    Are you using Safari by chance? What happens when you use a different browser?

    Joshua Parker
    Twitter | Facebook | DigitalOcean | tinyCampaign

    You need to login in order to like this post: click here

    4 years, 9 months ago Marc Tanis
    Member
    • Topics: 1
    • Replies: 5
    • Total Posts: 6

    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

    4 years, 9 months ago Joshua Parker
    Keymaster
    • Topics: 4
    • Replies: 638
    • Total Posts: 642

    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 | tinyCampaign

    You need to login in order to like this post: click here

    4 years, 9 months ago Marc Tanis
    Member
    • Topics: 1
    • Replies: 5
    • Total Posts: 6

    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

    4 years, 9 months ago Joshua Parker
    Keymaster
    • Topics: 4
    • Replies: 638
    • Total Posts: 642

    What is in the error logs (/app/tmp/logs/*.txt)?

    Joshua Parker
    Twitter | Facebook | DigitalOcean | tinyCampaign

    You need to login in order to like this post: click here

    4 years, 9 months ago Marc Tanis
    Member
    • Topics: 1
    • Replies: 5
    • Total Posts: 6

    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

    4 years, 9 months ago Joshua Parker
    Keymaster
    • Topics: 4
    • Replies: 638
    • Total Posts: 642

    Are there students in the course section you are trying to print out a roster for?

    Joshua Parker
    Twitter | Facebook | DigitalOcean | tinyCampaign

    You need to login in order to like this post: click here

    4 years, 9 months ago Marc Tanis
    Member
    • Topics: 1
    • Replies: 5
    • Total Posts: 6

    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

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

You must be logged in to reply to this topic.

The Educator

Subscribe to The Educator to receive weekly updates and educational resources.

Search Forums

Support Forum Topics

  • List of All Screens by  A. David Rivera
    1 year, 6 months ago
  • Warning after first intallation by  Cits Ser
    1 year, 8 months ago
  • Blank screen after install by  Adebobola Adesuyan
    1 year, 8 months ago
  • etSIS Analytics by  David Casas
    1 year, 11 months ago
  • etSIS Analytics by  David Casas
    1 year, 11 months ago

Topic Tags

6.3.0-RC3 6.3.0-RC4 6.3.4 acceptance letter batchregistration Canvas Contributing Cron custom_fields error FERPA Forms get_option graduation Importer LMS manual user account moduleversion NAE offline Search filter in RGN SQL SROS SSO Student application Student Program stuLoad cannot be null Transfer

Support Topics Stats

  • Resolved so far 66.67%
  • 2 Not resolved
  • 4 Resolved
  • 0 Working on it

Follow eduTrac On Facebook

About eduTrac SIS

eduTrac SIS is a free and open source student information system for higher education. We believe that it is the best free system out there for higher education and specialized schools.

Lastest Updates

  • eduTrac SIS 6.3.4 Maintenance Release
  • eduTrac SIS 6.3.1 Maintenance Release

Follow eduTrac SIS