comp426-2022-spring / comp426-2022-spring/a05
accesslog db no column referrer?
- Dominant language
- HTML
- Stars
- 0
- Forks
- 3
- PR merge metrics
- No merged PRs in 30d
Description
SqliteError: table accesslog has no column named referrer
at Database.prepare (/home/wenboliu/comp426/a05-wenbo68/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21)
at /home/wenboliu/comp426/a05-wenbo68/index.js:76:24
at Layer.handle [as handle_request] (/home/wenboliu/comp426/a05-wenbo68/node_modules/express/lib/router/layer.js:95:5)
at trim_prefix (/home/wenboliu/comp426/a05-wenbo68/node_modules/express/lib/router/index.js:328:13)
at /home/wenboliu/comp426/a05-wenbo68/node_modules/express/lib/router/index.js:286:9
at Function.process_params (/home/wenboliu/comp426/a05-wenbo68/node_modules/express/lib/router/index.js:346:12)
at next (/home/wenboliu/comp426/a05-wenbo68/node_modules/express/lib/router/index.js:280:10)
at logger (/home/wenboliu/comp426/a05-wenbo68/node_modules/morgan/index.js:144:5)
at Layer.handle [as handle_request] (/home/wenboliu/comp426/a05-wenbo68/node_modules/express/lib/router/layer.js:95:5)
at trim_prefix (/home/wenboliu/comp426/a05-wenbo68/node_modules/express/lib/router/index.js:328:13)
Contributor guide
No contributing guide indexed for this repository
Research direction
Start at index.js line 76 and reproduce the request that triggers the better-sqlite3 error. Inspect how the accesslog table is created and how referrer is inserted, then verify that the schema and insert agree and the request completes without the missing-column error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- express, javascript, node.js, sqlite
- Domain
- backend, database
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100