search

openwebwork / webwork2

Course management front end for WeBWorK
http://webwork.maa.org/wiki/Main_Page
Other
141 stars 164 forks source link

Please help debug Assignment Type = Test error #2341

Closed hartww closed 5 months ago

hartww commented 5 months ago

Please see attached for error that occurs in my Spring 2024 course even though in my Fall 2023 course the same practice test works great. I imported it from Fall 2023 into my Spring 2024 course, and get this error in Spring 2024. proctoredexamerror.pdf

Our WeBWorK administrator tried this Test in other Fall 2023 courses and Spring 2024 courses, and the Test works in Fall 2023 courses but not Spring 2024 courses. Our tech support updated our system to the latest/current version 2.18 in summer 2023 and says no changes have been made to the server at all since last year's upgrade

Alex-Jordan commented 5 months ago

The error message indicates that someone should go into the admin course for your server, and use the "Upgrade Courses" tool applied to this course.

hartww commented 5 months ago

Thanks for your quick reply, but our course administrator checked the upgrade tool, and shared the attached image, which seems to say that our Spring 2024 courses do not need upgrading. What more should our admin check? Joan

From: Alex Jordan @.***> Sent: Monday, February 26, 2024 5:08 PM To: openwebwork/webwork2 Cc: Joan Hart; Author Subject: Re: [openwebwork/webwork2] Please help debug Assignment Type = Test error (Issue #2341)

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

The error message indicates that someone should go into the admin course for your server, and use the "Upgrade Courses" tool applied to this course.

— Reply to this email directly, view it on GitHubhttps://github.com/openwebwork/webwork2/issues/2341#issuecomment-1965491754, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BGPJZUNQCJFKM4ZEJLKENQLYVUIX7AVCNFSM6AAAAABD3B3VKGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRVGQ4TCNZVGQ. You are receiving this because you authored the thread.Message ID: @.***>

Alex-Jordan commented 5 months ago

I think the attached image did not make it to your post. Can you try posting it directly on the GitHub thread?

hartww commented 5 months ago
courseslist

The above is the missing attachment.

Alex-Jordan commented 5 months ago

OK, looking more closely at the first screenshot, it's like there is some database query that joined some tables and need to fully qualify the set_id field as to which table it came from. Or something like that. We will look into it.

hartww commented 5 months ago

Thanks for looking into it, Joan

From: Alex Jordan @.***> Sent: Monday, February 26, 2024 5:25 PM To: openwebwork/webwork2 Cc: Joan Hart; Author Subject: Re: [openwebwork/webwork2] Please help debug Assignment Type = Test error (Issue #2341)

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

OK, looking more closely at the first screenshot, it's like there is some database query that joined some tables and need to fully qualify the set_id field as to which table it came from. Or something like that. We will look into it.

— Reply to this email directly, view it on GitHubhttps://github.com/openwebwork/webwork2/issues/2341#issuecomment-1965509478, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BGPJZUPKBRYT7EYE5E75NZ3YVUKXDAVCNFSM6AAAAABD3B3VKGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRVGUYDSNBXHA. You are receiving this because you authored the thread.Message ID: @.***>

Alex-Jordan commented 5 months ago

Pinging other developers: I'm not sure I can understand this with only the screenshots. Going down the call stack from the first image, the first time set_id is used is at line 198 of ProblemSet.pm. The error message says that 'set_id' is ambiguous in some order clause. I think that comes from the third argument of sub get_records_where in DB/Schema/NewSQL/Std.pm but that's as far as I can probe this for now.

drgrice1 commented 5 months ago

@hartww: Which database and perl database driver are you using? Are you using mysql or mariadb for the database? Are you using DBD::mysql or DBD::MariaDB for the perl database driver? (Note that DBD::mysql can be used with the mariadb database, and DBD::MariaDB can be used with mysql, so I need to ask both.)

drgrice1 commented 5 months ago

@hartww: I created a pull request that might fix this issue. If you could get the administrator of your webwork instance to test it and see if it fixes the issue, we would appreciate it. The pull request is #2344.

drgrice1 commented 5 months ago

If you could find out from your system administrator the answer to my question about which database setup the system has, that would also be useful.

hartww commented 5 months ago

Our tech support for our server said that based on your discussion he changed it from usingdbd:mysql to dbd:mariadb in the site.conf file. Both drivers were installed but the default configuration was mysql My practice exam still gave me an error, so he installed the patch and now my practice exam with Assignment Type = "Proctored Test" works. Thank you!