Question
App Platform: API works perfect in prod but doesn't work
Hey all,
I’m writing an API and my API works completely on my machine, but then when I deploy it to DO’s App platform the auth and login functionality works but my schedulecontent/ resource breaks complaining:
phlik-it | 2020-10-15 20:00:12 10.244.0.43 - - [16/Oct/2020 01:00:12] "GET /schedulecontent HTTP/1.1" 308 -
phlik-it | 2020-10-15 20:00:12 [2020-10-16 01:00:12,517] ERROR in app: Exception on /schedulecontent/ [GET]
phlik-it | 2020-10-15 20:00:12 Traceback (most recent call last):
phlik-it | 2020-10-15 20:00:12 File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1950, in full_dispatch_request
phlik-it | 2020-10-15 20:00:12 rv = self.dispatch_request()
phlik-it | 2020-10-15 20:00:12 File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1936, in dispatch_request
phlik-it | 2020-10-15 20:00:12 return self.view_functions[rule.endpoint](**req.view_args)
phlik-it | 2020-10-15 20:00:12 File "/usr/local/lib/python3.7/site-packages/flask_restful/__init__.py", line 468, in wrapper
phlik-it | 2020-10-15 20:00:12 resp = resource(*args, **kwargs)
phlik-it | 2020-10-15 20:00:12 File "/usr/local/lib/python3.7/site-packages/flask/views.py", line 89, in view
phlik-it | 2020-10-15 20:00:12 return self.dispatch_request(*args, **kwargs)
phlik-it | 2020-10-15 20:00:12 File "/usr/local/lib/python3.7/site-packages/flask_restful/__init__.py", line 583, in dispatch_request
phlik-it | 2020-10-15 20:00:12 resp = meth(*args, **kwargs)
phlik-it | 2020-10-15 20:00:12 File "/usr/local/lib/python3.7/site-packages/flask_jwt/__init__.py", line 177, in decorator
phlik-it | 2020-10-15 20:00:12 return fn(*args, **kwargs)
phlik-it | 2020-10-15 20:00:12 File "/app/Resources/ScheduleContent.py", line 54, in get
phlik-it | 2020-10-15 20:00:12 cursor.execute(query)
phlik-it | 2020-10-15 20:00:12 sqlite3.OperationalError: no such column: None
and this makes no sense because everything is working just fine locally so there’s nothing for me to troubleshoot?
Any help or guidance on troubleshooting something like this would be MUCH appreciated.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×