|
|
Sponsored Content
The Lounge
What is on Your Mind?
Debugging Our Computer Science Trivia Feature
Post 303040591 by Neo on Friday 1st of November 2019 09:21:04 AM
11-01-2019
Administrator
Debugging Our Computer Science Trivia Feature
Only a few days after I coded this new feature from scratch, we are seeing over 3000 entries in the database from members (mostly guests) playing CS trivia.
I have spend a lot of time coding this (from scratch) and testing the API. From the logs, it seems to have an API bug which appears about 5 times or less per thousand impressions, but I am not sure.
The bug seems to happen when there is some issue where the answer to a question in the Javascript is blank (on rare occasion) or there is a problem with the AJAX XHR request based on a network issue.
I have written a lot of "error trapping" code today to try to see exactly what causes this small bug.
If anyone sees any CS trivia statement and their T/F answer seems wrong, the issue is more-than-likely related to this rare bug, but then again, it could be a typo in the DB (or some strange HTML entity which was not encoded and decoded properly). So, if you do see anything which seems ODD, please take a screenshot of your screen and post it back here.
If you are a savvy at web dev, you can help out by opening your web dev console and inspecting the Javascript console and the Network XHR request and responses (and take a screen shot of any console errors and the XHR request / response).
Either way, if anyone want to help debug the API during the testing phase, the best way to debug is to answer a lot of questions, push NEXT and answer more. I have done this for the past two days for countless hours and I think I have trapped most network and AJAX issues, but I am sure there are more bugs, as there are always bugs in new code, without exception.
Please note that today one user from the Philippines answered over 100 questions. A lot of people worldwide are finding good value with this new feature so you can help me and help others by helping debug, so I can make sure all errors are trapped.
Thanks for help debugging.
Cheers!
Note: Code and other special chars must be encoded before they are submitted to the DB (for DB integrity) and I have written some special code to decode the HTML entities (in JS) but there are some occasional HTML entities (encodings) which are not decoded properly. If you see any of the HTML entities still encoded, please take a screen shot and post back so I can trap those and decode them as well. If you do not know what an HTML entity is, I have screen shots I can share
I have spend a lot of time coding this (from scratch) and testing the API. From the logs, it seems to have an API bug which appears about 5 times or less per thousand impressions, but I am not sure.
The bug seems to happen when there is some issue where the answer to a question in the Javascript is blank (on rare occasion) or there is a problem with the AJAX XHR request based on a network issue.
I have written a lot of "error trapping" code today to try to see exactly what causes this small bug.
If anyone sees any CS trivia statement and their T/F answer seems wrong, the issue is more-than-likely related to this rare bug, but then again, it could be a typo in the DB (or some strange HTML entity which was not encoded and decoded properly). So, if you do see anything which seems ODD, please take a screenshot of your screen and post it back here.
If you are a savvy at web dev, you can help out by opening your web dev console and inspecting the Javascript console and the Network XHR request and responses (and take a screen shot of any console errors and the XHR request / response).
Either way, if anyone want to help debug the API during the testing phase, the best way to debug is to answer a lot of questions, push NEXT and answer more. I have done this for the past two days for countless hours and I think I have trapped most network and AJAX issues, but I am sure there are more bugs, as there are always bugs in new code, without exception.
Please note that today one user from the Philippines answered over 100 questions. A lot of people worldwide are finding good value with this new feature so you can help me and help others by helping debug, so I can make sure all errors are trapped.
Thanks for help debugging.
Cheers!
Note: Code and other special chars must be encoded before they are submitted to the DB (for DB integrity) and I have written some special code to decode the HTML entities (in JS) but there are some occasional HTML entities (encodings) which are not decoded properly. If you see any of the HTML entities still encoded, please take a screen shot and post back so I can trap those and decode them as well. If you do not know what an HTML entity is, I have screen shots I can share
|
|
7 More Discussions You Might Find Interesting
1. What is on Your Mind?
Hi,
I haven't posted on the forums for a while now, I tried to find the most appropriate section for this post, but if this is in the wrong section please forgive me.
First, let me say I'm a sophomore in HS. I know that job wise I definitely want to do something in computers. A while ago I was... (5 Replies)
Discussion started by: hpicracing
5 Replies
2. Programming
I am now a student in university in 2nd year. I am studying computer science. But I am not sure what type of jobs computer science provide. I know some of them are software programming or network management. Recently, I hear some about Web Development. I wonder if it is a part of computer science.... (1 Reply)
Discussion started by: Anna Hussie
1 Replies
3. Web Development
I am now a student in university in 2nd year. I am studying computer science. But I am not sure what type of jobs computer science provide. I know some of them are software programming or network management. Recently, I hear some about Web Development. I wonder if it is a part of computer... (3 Replies)
Discussion started by: Anna Hussie
3 Replies
4. What is on Your Mind?
I have added a new experimental "Computer Science and Mathematics Trivia - True or False" section in the discussions, currently under the tags box.
In the future, I plan to
Expand this feature to add more trivia categories from math, science and technology.
Keep track of correct and... (20 Replies)
Discussion started by: Neo
20 Replies
5. What is on Your Mind?
The UNIX and Linux Forums now has over 1000 TRUE / FALSE computer science and computer related trivia question in our database. These questions are of relatively high quality (compared to similar sites on the web) and are fun (according to feedback by users). In the first week during the... (1 Reply)
Discussion started by: Neo
1 Replies
6. What is on Your Mind?
Thanks to Akshay, who helped me write the core MySQL queries, we now have two new draft leaderboards, by (1) member and by (2) country:
https://www.unix.com/trivia_stats.php
Currently milhan leads the members with a high score of 90%:
... (3 Replies)
Discussion started by: Neo
3 Replies
7. What is on Your Mind?
Just noticed that our successful computer trivia feature (stats here) has surpassed over 50,000 questions answered by users:
https://www.unix.com/trivia_stats.php
This was a coding effort worth while and I'm pleased to see so many people enjoying it in such a short time since it was released... (3 Replies)
Discussion started by: Neo
3 Replies
LEARN ABOUT OPENSOLARIS
mysqlshow
mysqlshow(1) MySQL database mysqlshow(1) NAME
mysqlshow - Shows the structure of a mysql database (databases,tables and columns) USAGE
shell> mysqlshow [OPTIONS] [database [table [column]]] SYNOPSIS
mysqlshow [-#|--debug=...] [-?|--help] [-c|--character-sets-dir=...] [-C|--compress] [-h|--host=...] [-i|--status] [-k|--keys] [-p|--password[=...]] [-P|--port=...] [-S|--socket=...] [-u|--user=#] [-V|--version] DESCRIPTION
-#|--debug=... output debug log. Often this is 'd:t:o,filename` -?|--help display help and exit -c|--character-sets-dir=... Directory where character sets are -C|--compress Use compression in server/client protocol -h|--host=... connect to host -i|--status Shows a lot of extra information about each table -k|--keys show keys for table -p|--password[=...] password to use when connecting to server If password is not given it's asked from the tty. -P|--port=... Port number to use for connection -S|--socket=... Socket file to use for connection -u|--user=# user for login if not current user -V|--version output version information and exit NOTE
If last argument contains a shell or SQL wildcard (*,?,% or _) then only what's matched by the wildcard is shown. If no database is given then all matching databases are shown. If no table is given then all matching tables in database are shown If no column is given then all matching columns and columntypes in table are shown SEE ALSO
isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi- lege_tables(1), mysql_zap(1), perror(1), replace(1) For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online at http://www.mysql.com/doc/en/ BUGS
Please refer to http://bugs.mysql.com/ to report bugs. AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur- media.com) ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +--------------------+------------------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +--------------------+------------------------------------+ |Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt | +--------------------+------------------------------------+ |Interface Stability | External | +--------------------+------------------------------------+ NOTES
Source for mysql is available on http://opensolaris.org. MySQL 4.0 19 December 2000 mysqlshow(1)