all () File "/usr/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3186, in all return list ( self ) File "/usr/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3342, in _iter_ return self. OperationalError: near "(": syntax error The above exception was the direct cause of the following exception:įile "", line 1, in File "/home/movieelo/cinelow/my_server/database/pers_movie_dbf.py", line 137, in get_top_movies_by_category movies = query. execute ( statement, parameters ) sqlite3. do_execute ( File "/usr/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 580, in do_execute cursor. Could it have anything to do with the fact that I was running Flask-SQLAlchemy?įile "/usr/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context self. ![]() I agree that it seems like SQLAlchemy is generating invalid SQL, but as mentioned before it was working perfectly when running on my own computer, so I am a little bit dumbfounded. ProgrammingError : 1064 ( 42000 ) : You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near '(PARTITION BY movie_category_scores.category_id ORDER BY movie_category_scores.s' at line 2 ** NO MATCH ** QUERY, query )) File "/usr/lib/python3.8/site-packages/mysql/connector/connection.py", line 478, in _handle_result raise errors. cmd_query ( stmt )) File "/usr/lib/python3.8/site-packages/mysql/connector/connection.py", line 590, in cmd_query result = self. execute ( statement, parameters ) File "/usr/lib/python3.8/site-packages/mysql/connector/cursor.py", line 569, in execute self. 2021 - 01 - 30 14 : 27 : 16, 434 : Exception on / m / 550 Traceback ( most recent call last ) : File "/usr/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context self. ObjectDeletedError : Instance '' has been deleted, or its row is otherwise not present. deferred_scalar_loader ( self, toload ) File "/usr/lib/python3.8/site-packages/sqlalchemy/orm/loading.py", line 985, in load_scalar_attributes raise orm_exc. _load_expired ( state, passive ) File "/usr/lib/python3.8/site-packages/sqlalchemy/orm/state.py", line 660, in _load_expired self. get ( state, dict_, passive = passive ) File "/usr/lib/python3.8/site-packages/sqlalchemy/orm/attributes.py", line 705, in get value = state. _get_state_attr_by_column ( File "/usr/lib/python3.8/site-packages/sqlalchemy/orm/mapper.py", line 2795, in _get_state_attr_by_column return state. _generate_lazy_clause ( state, passive ) File "/usr/lib/python3.8/site-packages/sqlalchemy/orm/strategies.py", line 650, in _generate_lazy_clause value = mapper. _emit_lazyload ( File "", line 1, in File "/usr/lib/python3.8/site-packages/sqlalchemy/orm/strategies.py", line 848, in _emit_lazyload lazy_clause, params = self. callable_ ( state, passive ) File "/usr/lib/python3.8/site-packages/sqlalchemy/orm/strategies.py", line 729, in _load_for_state return self. get ( instance_state ( instance ), dict_ ) File "/usr/lib/python3.8/site-packages/sqlalchemy/orm/attributes.py", line 710, in get value = self. append ( a ) File "/usr/lib/python3.8/site-packages/sqlalchemy/orm/attributes.py", line 282, in _get_ return self. add_movie ( movie_id ) File "/home/movieelo/cinelow/my_server/database/pers_movie_dbf.py", line 31, in add_movie cate. ![]() view_args ) File "/home/movieelo/cinelow/my_server/people_movies/routes.py", line 22, in moviePage pmf. dispatch_request () File "/usr/lib/python3.8/site-packages/flask/app.py", line 1935, in dispatch_request return self. ![]() handle_user_exception ( e ) File "/usr/lib/python3.8/site-packages/flask/app.py", line 1820, in handle_user_exception reraise ( exc_type, exc_value, tb ) File "/usr/lib/python3.8/site-packages/flask/_compat.py", line 39, in reraise raise value File "/usr/lib/python3.8/site-packages/flask/app.py", line 1949, in full_dispatch_request rv = self. full_dispatch_request () File "/usr/lib/python3.8/site-packages/flask/app.py", line 1951, in full_dispatch_request rv = self. 2021 - 01 - 30 14 : 22 : 31, 233 : Exception on / m / 550 Traceback ( most recent call last ) : File "/usr/lib/python3.8/site-packages/flask/app.py", line 2446, in wsgi_app response = self.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |