Error

warnings.warn("urllib3 ({}) or chardet ({})/charset_normalizer ({}) doesn't match a supported " Traceback (most recent call last): File "C:\Python3\lib\site-packages\sqlalchemy\engine\base.py", line 1705, in _execute_context self.dialect.do_execute( File "C:\Python3\lib\site-packages\sqlalchemy\engine\default.py", line 691, in do_execute cursor.execute(statement, parameters) File "C:\Python3\lib\site-packages\pymysql\cursors.py", line 148, in execute result = self._query(query) File "C:\Python3\lib\site-packages\pymysql\cursors.py", line 310, in _query conn.query(q) File "C:\Python3\lib\site-packages\pymysql\connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "C:\Python3\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result result.read() File "C:\Python3\lib\site-packages\pymysql\connections.py", line 1156, in read first_packet = self.connection._read_packet() File "C:\Python3\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "C:\Python3\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "C:\Python3\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1054, "Unknown column 'ticker' in 'field list'")

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "D:\PROJECTS\xxxxxxxxxx\component\vendor\vsd\security*detail.py", line 354, in res = MAIN_DATABASE_SESSION.execute( File "C:\Python3\lib\site-packages\sqlalchemy\orm\session.py", line 1662, in execute result = conn._execute_20(statement, params or {}, execution_options) File "C:\Python3\lib\site-packages\sqlalchemy\engine\base.py", line 1520, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "C:\Python3\lib\site-packages\sqlalchemy\sql\elements.py", line 313, in _execute_on_connection return connection._execute_clauseelement( File "C:\Python3\lib\site-packages\sqlalchemy\engine\base.py", line 1389, in _execute_clauseelement ret = self._execute_context( File "C:\Python3\lib\site-packages\sqlalchemy\engine\base.py", line 1748, in _execute_context self._handle_dbapi_exception( File "C:\Python3\lib\site-packages\sqlalchemy\engine\base.py", line 1929, in _handle_dbapi_exception util.raise*( File "C:\Python3\lib\site-packages\sqlalchemy\util\compat.py", line 211, in raise_ raise exception File "C:\Python3\lib\site-packages\sqlalchemy\engine\base.py", line 1705, in _execute_context self.dialect.do_execute( File "C:\Python3\lib\site-packages\sqlalchemy\engine\default.py", line 691, in do_execute cursor.execute(statement, parameters) File "C:\Python3\lib\site-packages\pymysql\cursors.py", line 148, in execute result = self._query(query) File "C:\Python3\lib\site-packages\pymysql\cursors.py", line 310, in _query conn.query(q) File "C:\Python3\lib\site-packages\pymysql\connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "C:\Python3\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result result.read() File "C:\Python3\lib\site-packages\pymysql\connections.py", line 1156, in read first_packet = self.connection._read_packet() File "C:\Python3\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "C:\Python3\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "C:\Python3\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, "Unknown column 'ticker' in 'field list'") [SQL: SELECT DISTINCT ticker, CAST(REGEXP_SUBSTR(reference_link, '[0-9]+$') AS UNSIGNED) AS vsd_number FROM aa.aa WHERE status = 'A' ] (Background on this error at: http://sqlalche.me/e/14/e3q8)