search

learningequality / ka-lite

KA Lite: lightweight web server for serving core Khan Academy content (videos and exercises) without needing internet connectivity
https://learningequality.org/ka-lite/
Other
458 stars 305 forks source link

Video topic tree not loading in Spanish #4926

Closed radinamatic closed 8 years ago

radinamatic commented 8 years ago

Summary

I'm not sure if this is related to what @aronasorman is fixing in #4914, so I'm filing separately.

No errors appear in the console while the tree loads, just as the download actually starts. At the end of each failed video download appears the same [INFO] [2016-02-27 01:19:13,941] kalite: Error en la descarga de xEDnwEOOf7Y: no such column: t1.sort_order; pasando al siguiente video. in the log, and TypeError: node is null in the console.

Funny thing is videos are downloaded and present in the content folder, but the tree does not seem to register them, not even after the Scan the content folder for videos.

Branch or installer method

latest 0.16

Traceback or relevant snippet from server.log

[INFO] [2016-02-27 01:18:18,372] django.request: HTTP Request /update/videos/ - Response: 200
[27/Feb/2016 01:18:18] "GET /update/videos/?lang=es-ES HTTP/1.1" 200 4527
[INFO] [2016-02-27 01:18:20,111] django.request: HTTP Request /_generated/dynamic.css - Response: 200
[27/Feb/2016 01:18:20] "GET /_generated/dynamic.css HTTP/1.1" 200 63
[INFO] [2016-02-27 01:18:20,131] django.request: HTTP Request /_generated/dynamic.js - Response: 200
[27/Feb/2016 01:18:20] "GET /_generated/dynamic.js HTTP/1.1" 200 302
[INFO] [2016-02-27 01:18:20,149] django.request: HTTP Request /content/locale/js/i18n/es-ES.js - Response: 200
[INFO] [2016-02-27 01:18:20,160] django.request: HTTP Request /jsreverse/ - Response: 200
[27/Feb/2016 01:18:20] "GET /jsreverse/ HTTP/1.1" 200 3992
[27/Feb/2016 01:18:20] "GET /content/locale/js/i18n/es-ES.js HTTP/1.1" 200 36082
[INFO] [2016-02-27 01:18:20,950] django.request: HTTP Request /securesync/api/user/status/ - Response: 200
[27/Feb/2016 01:18:20] "GET /securesync/api/user/status/?_=1456532300487 HTTP/1.1" 200 298
[WARNING] [2016-02-27 01:18:20,984] django.request: Not Found: /node_modules/jquery.fancytree/dist/skin-lion/loading.gif
[INFO] [2016-02-27 01:18:21,268] django.request: HTTP Request /node_modules/jquery.fancytree/dist/skin-lion/loading.gif - Response: 404
[27/Feb/2016 01:18:21] "GET /node_modules/jquery.fancytree/dist/skin-lion/loading.gif HTTP/1.1" 404 2449
[INFO] [2016-02-27 01:18:22,490] django.request: HTTP Request /api/videos/topic_tree - Response: 200
[27/Feb/2016 01:18:22] "GET /api/videos/topic_tree?parent=root&_=1456532300490 HTTP/1.1" 200 630
[INFO] [2016-02-27 01:18:22,903] django.request: HTTP Request /securesync/api/info - Response: 200
[27/Feb/2016 01:18:22] "GET /securesync/api/info?fields=online&_=1456532300491 HTTP/1.1" 200 54
[27/Feb/2016 01:18:22] "GET /api/updates/progress?process_name=videodownload&_=1456532300492 HTTP/1.1" 200 2
[27/Feb/2016 01:18:27] "GET /api/updates/progress?process_name=videodownload&start_time=2016-02-27T00:18:22.000Z&_=1456532300493 HTTP/1.1" 200 2
[27/Feb/2016 01:18:33] "GET /api/updates/progress?process_name=videodownload&start_time=2016-02-27T00:18:22.000Z&_=1456532300494 HTTP/1.1" 200 2
[27/Feb/2016 01:18:37] "GET /api/updates/progress?process_name=videodownload&start_time=2016-02-27T00:18:22.000Z&_=1456532300495 HTTP/1.1" 200 2
[INFO] [2016-02-27 01:18:42,151] django.request: HTTP Request /api/videos/topic_tree - Response: 200
[27/Feb/2016 01:18:42] "GET /api/videos/topic_tree?parent=math&_=1456532300496 HTTP/1.1" 200 5051
[27/Feb/2016 01:18:42] "GET /api/updates/progress?process_name=videodownload&start_time=2016-02-27T00:18:22.000Z&_=1456532300497 HTTP/1.1" 200 2
[27/Feb/2016 01:18:48] "GET /api/updates/progress?process_name=videodownload&start_time=2016-02-27T00:18:22.000Z&_=1456532300498 HTTP/1.1" 200 2
[INFO] [2016-02-27 01:18:49,262] django.request: HTTP Request /api/videos/topic_tree - Response: 200
[27/Feb/2016 01:18:49] "GET /api/videos/topic_tree?parent=pre-algebra&_=1456532300499 HTTP/1.1" 200 747
[INFO] [2016-02-27 01:18:51,069] django.request: HTTP Request /api/videos/topic_tree - Response: 200
[27/Feb/2016 01:18:51] "GET /api/videos/topic_tree?parent=negatives-absolute-value-pre-alg&_=1456532300500 HTTP/1.1" 200 410
[INFO] [2016-02-27 01:18:52,675] django.request: HTTP Request /api/videos/topic_tree - Response: 200
[27/Feb/2016 01:18:52] "GET /api/videos/topic_tree?parent=abs-value-pre-alg&_=1456532300501 HTTP/1.1" 200 716
[27/Feb/2016 01:18:52] "GET /api/updates/progress?process_name=videodownload&start_time=2016-02-27T00:18:22.000Z&_=1456532300502 HTTP/1.1" 200 2
[INFO] [2016-02-27 01:18:56,594] django.request: HTTP Request /api/videos/topic_tree - Response: 200
[27/Feb/2016 01:18:56] "GET /api/videos/topic_tree?parent=decimals-pre-alg&_=1456532300503 HTTP/1.1" 200 628
[27/Feb/2016 01:18:57] "GET /api/updates/progress?process_name=videodownload&start_time=2016-02-27T00:18:22.000Z&_=1456532300504 HTTP/1.1" 200 2
[INFO] [2016-02-27 01:19:01,861] django.request: HTTP Request /api/videos/start - Response: 200
[27/Feb/2016 01:19:01] "POST /api/videos/start?lang=es-ES HTTP/1.1" 200 68
[27/Feb/2016 01:19:02] "GET /api/updates/progress?process_name=videodownload&_=1456532300505 HTTP/1.1" 200 2
[27/Feb/2016 01:19:04] "GET /api/updates/progress?process_name=videodownload&start_time=2016-02-27T00:19:02.000Z&_=1456532300506 HTTP/1.1" 200 2
[27/Feb/2016 01:19:06] "GET /api/updates/progress?process_name=videodownload&start_time=2016-02-27T00:19:02.000Z&_=1456532300507 HTTP/1.1" 200 2
[27/Feb/2016 01:19:08] "GET /api/updates/progress?process_name=videodownload&start_time=2016-02-27T00:19:02.000Z&_=1456532300508 HTTP/1.1" 200 145
[27/Feb/2016 01:19:08] "GET /api/updates/progress?process_id=26&_=1456532300509 HTTP/1.1" 200 145
[INFO] [2016-02-27 01:19:09,263] kalite: Descargando 'Adding, subtracting fractions, decimals, percentages'
[27/Feb/2016 01:19:10] "GET /api/updates/progress?process_id=26&_=1456532300510 HTTP/1.1" 200 206
[27/Feb/2016 01:19:12] "GET /api/updates/progress?process_id=26&_=1456532300511 HTTP/1.1" 200 201
[ERROR] [2016-02-27 01:19:13,941] kalite: No content database file found
[INFO] [2016-02-27 01:19:13,941] kalite: Error en la descarga de xEDnwEOOf7Y: no such column: t1.sort_order; pasando al siguiente video.

Screenshots

topic_tree_es

node-null-actualizar_videos___ka_lite

radinamatic commented 8 years ago

Another piece of information: if the language by default is NOT English, topic tree on video download page is not loading at all, not even for videos in English.

0.16 .pkg installer (build 66) on OSX Yosemite, upgraded from 0.15.1. No errors in the console, server.log snippet below:

[INFO] [2016-02-28 10:31:36,131] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:31:36] "GET /static/js/distributed/bundles/bundle_base.js HTTP/1.1" 304 - "http://127.0.0.1:8008/update/videos/?lang=da" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:31:36,173] django.request: HTTP Request /_generated/dynamic.css - Response: 200
[INFO] [2016-02-28 10:31:36,869] django.request: HTTP Request /securesync/api/user/status/ - Response: 200
[WARNING] [2016-02-28 10:31:36,902] kalite: No content database file found
[INFO] [2016-02-28 10:31:36,903] django.request: HTTP Request /api/videos/topic_tree - Response: 200
[WARNING] [2016-02-28 10:31:36,910] django.request: Not Found: /node_modules/jquery.fancytree/dist/skin-lion/loading.gif
[INFO] [2016-02-28 10:31:36,928] django.request: HTTP Request /node_modules/jquery.fancytree/dist/skin-lion/loading.gif - Response: 404
[INFO] [2016-02-28 10:31:38,269] django.request: HTTP Request /securesync/api/info - Response: 200
[INFO] [2016-02-28 10:31:49,161] django.request: HTTP Request /api/cherrypy/getpid - Response: 200
[INFO] [2016-02-28 10:31:49,358] django.request: HTTP Request /api/videos/scan - Response: 200
[INFO] [2016-02-28 10:32:39,716] django.request: HTTP Request /api/cherrypy/getpid - Response: 200
[INFO] [2016-02-28 10:33:49,419] django.request: HTTP Request /api/cherrypy/getpid - Response: 200
[INFO] [2016-02-28 10:34:49,397] django.request: HTTP Request /api/cherrypy/getpid - Response: 200
[INFO] [2016-02-28 10:35:49,097] django.request: HTTP Request /api/cherrypy/getpid - Response: 200
[INFO] [2016-02-28 10:36:49,110] django.request: HTTP Request /api/cherrypy/getpid - Response: 200
[INFO] [2016-02-28 10:37:36,372] django.request: HTTP Request /update/videos/ - Response: 200
[INFO] [2016-02-28 10:37:36,579] django.request: HTTP Request /_generated/dynamic.js - Response: 200
[INFO] [2016-02-28 10:37:36,582] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:36] "GET /static/js/distributed/bundles/bundle_common.js HTTP/1.1" 304 - "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:36,584] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:36] "GET /static/js/i18n/en.js HTTP/1.1" 304 - "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:36,587] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:36] "GET /static/js/updates/bundles/bundle_update_videos.js HTTP/1.1" 304 - "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:36,589] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:36] "GET /static/django_js_reverse/js/reverse.js HTTP/1.1" 304 - "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:36,593] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:36] "GET /static/css/updates/base.css HTTP/1.1" 304 - "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:36,597] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:36] "GET /static/fonts/style.css HTTP/1.1" 304 - "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:36,599] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:36] "GET /static/js/distributed/bundles/bundle_base.js HTTP/1.1" 304 - "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:36,601] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:36] "GET /static/js/inline/bundles/bundle_inline_help.js HTTP/1.1" 304 - "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:36,684] django.request: HTTP Request /_generated/dynamic.css - Response: 200
[INFO] [2016-02-28 10:37:37,197] django.request: HTTP Request /securesync/api/user/status/ - Response: 200
[WARNING] [2016-02-28 10:37:37,237] kalite: No content database file found
[INFO] [2016-02-28 10:37:37,237] django.request: HTTP Request /api/videos/topic_tree - Response: 200
[WARNING] [2016-02-28 10:37:37,250] django.request: Not Found: /node_modules/jquery.fancytree/dist/skin-lion/loading.gif
[INFO] [2016-02-28 10:37:37,277] django.request: HTTP Request /node_modules/jquery.fancytree/dist/skin-lion/loading.gif - Response: 404
[INFO] [2016-02-28 10:37:37,314] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:37] "GET /static/images/distributed/CC-BY-NC-SA.png HTTP/1.1" 304 - "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:37,329] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:37] "GET /static/images/horizontal-logo-small.png HTTP/1.1" 304 - "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:37,342] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:37] "GET /static/images/distributed/FLE.png HTTP/1.1" 304 - "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:38,421] django.request: HTTP Request /securesync/api/info - Response: 200
[INFO] [2016-02-28 10:37:39,378] django.request: HTTP Request /api/cherrypy/getpid - Response: 200
[INFO] [2016-02-28 10:37:51,285] django.request: HTTP Request /update/videos/ - Response: 200
[INFO] [2016-02-28 10:37:51,395] django.request: HTTP Request /_generated/dynamic.css - Response: 200
[INFO] [2016-02-28 10:37:51,413] django.request: HTTP Request /_generated/dynamic.js - Response: 200
[INFO] [2016-02-28 10:37:51,418] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:51] "GET /static/django_js_reverse/js/reverse.js HTTP/1.1" 200 101784 "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:51,441] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:51] "GET /static/css/updates/base.css HTTP/1.1" 200 479 "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:51,444] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:51] "GET /static/js/updates/bundles/bundle_update_videos.js HTTP/1.1" 200 187345 "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:51,420] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:51] "GET /static/js/i18n/en.js HTTP/1.1" 200 5476 "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:51,425] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:51] "GET /static/js/distributed/bundles/bundle_common.js HTTP/1.1" 200 859031 "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:51,429] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:51] "GET /static/js/distributed/bundles/bundle_base.js HTTP/1.1" 200 875153 "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:51,419] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:51] "GET /static/fonts/style.css HTTP/1.1" 200 1502 "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:51,467] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:51] "GET /static/js/inline/bundles/bundle_inline_help.js HTTP/1.1" 200 41289 "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:52,262] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:52] "GET /static/images/horizontal-logo-small.png HTTP/1.1" 200 3961 "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:52,273] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:52] "GET /static/images/distributed/FLE.png HTTP/1.1" 200 2216 "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:52,280] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:52] "GET /static/images/distributed/CC-BY-NC-SA.png HTTP/1.1" 200 697 "http://127.0.0.1:8008/update/videos/?lang=en" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:52,537] django.request: HTTP Request /securesync/api/user/status/ - Response: 200
[WARNING] [2016-02-28 10:37:52,576] django.request: Not Found: /node_modules/jquery.fancytree/dist/skin-lion/loading.gif
[WARNING] [2016-02-28 10:37:52,597] kalite: No content database file found
[INFO] [2016-02-28 10:37:52,598] django.request: HTTP Request /api/videos/topic_tree - Response: 200
[INFO] [2016-02-28 10:37:52,626] django.request: HTTP Request /node_modules/jquery.fancytree/dist/skin-lion/loading.gif - Response: 404
[INFO] [2016-02-28 10:37:52,809] cherrypy.access.4348790032: 127.0.0.1 - - [28/Feb/2016:10:37:52] "GET /static/fonts/icomoon.woff?k0qp5y HTTP/1.1" 200 5076 "http://127.0.0.1:8008/static/fonts/style.css" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0"
[INFO] [2016-02-28 10:37:53,895] django.request: HTTP Request /securesync/api/info - Response: 200
[INFO] [2016-02-28 10:38:39,282] django.request: HTTP Request /api/cherrypy/getpid - Response: 200
aronasorman commented 8 years ago

Is this still the case @radinamatic? New content packs should solve this problem.

radinamatic commented 8 years ago

Yes, this is fixed! :+1: