Problem with the script

[TheTerminator2]

Made a MYSQL database (not local) with two databases and run the script, but got the following error.

python updater.py --daily --intraday

/anaconda3/lib/python3.6/importlib/_bootstrap.py:219: RuntimeWarning: numpy.dtype size changed, may indicate binary incompatibility. Expected 96, got 88
return f(*args, **kwds)
/anaconda3/lib/python3.6/importlib/_bootstrap.py:219: RuntimeWarning: numpy.dtype size changed, may indicate binary incompatibility. Expected 96, got 88
return f(*args, **kwds)
2018-09-16 10:48:46,470 - INFO - USING DATABASE: PRICES_DAILY
Traceback (most recent call last):
File "updater.py", line 559, in
tickers=tickers)
File "updater.py", line 237, in database_update
data_source_id = fetchone(sql_cursor, query="SELECT GetDataSourceIDFromDataSourceName('{}')".format(data_source_name))
File "updater.py", line 48, in fetchone
sql_cursor.execute(query)
File "/anaconda3/lib/python3.6/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/anaconda3/lib/python3.6/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/anaconda3/lib/python3.6/site-packages/pymysql/connections.py", line 516, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/anaconda3/lib/python3.6/site-packages/pymysql/connections.py", line 727, in _read_query_result
result.read()
File "/anaconda3/lib/python3.6/site-packages/pymysql/connections.py", line 1066, in read
first_packet = self.connection._read_packet()
File "/anaconda3/lib/python3.6/site-packages/pymysql/connections.py", line 683, in _read_packet
packet.check_error()
File "/anaconda3/lib/python3.6/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/anaconda3/lib/python3.6/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1305, 'FUNCTION PRICES_DAILY.GetDataSourceIDFromDataSourceName does not exist')

[justinclarkhome]

Hi - Did you run the SQL create scripts first (rather than manually creating the databases)? They'll generate the databases and all the tables/functions/procedures required. Justin

…

On Sun, Sep 16, 2018, 04:55 TheTerminator2 ***@***.***> wrote: Made a MYSQL database (not local) with two databases and run the script, but got the following error. python updater.py --daily --intraday /anaconda3/lib/python3.6/importlib/_bootstrap.py:219: RuntimeWarning: numpy.dtype size changed, may indicate binary incompatibility. Expected 96, got 88 return f(*args, **kwds) /anaconda3/lib/python3.6/importlib/_bootstrap.py:219: RuntimeWarning: numpy.dtype size changed, may indicate binary incompatibility. Expected 96, got 88 return f(*args, **kwds) 2018-09-16 10:48:46,470 - INFO - USING DATABASE: PRICES_DAILY Traceback (most recent call last): File "updater.py", line 559, in tickers=tickers) File "updater.py", line 237, in database_update data_source_id = fetchone(sql_cursor, query="SELECT GetDataSourceIDFromDataSourceName('{}')".format(data_source_name)) File "updater.py", line 48, in fetchone sql_cursor.execute(query) File "/anaconda3/lib/python3.6/site-packages/pymysql/cursors.py", line 170, in execute result = self._query(query) File "/anaconda3/lib/python3.6/site-packages/pymysql/cursors.py", line 328, in _query conn.query(q) File "/anaconda3/lib/python3.6/site-packages/pymysql/connections.py", line 516, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/anaconda3/lib/python3.6/site-packages/pymysql/connections.py", line 727, in _read_query_result result.read() File "/anaconda3/lib/python3.6/site-packages/pymysql/connections.py", line 1066, in read first_packet = self.connection._read_packet() File "/anaconda3/lib/python3.6/site-packages/pymysql/connections.py", line 683, in _read_packet packet.check_error() File "/anaconda3/lib/python3.6/site-packages/pymysql/protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "/anaconda3/lib/python3.6/site-packages/pymysql/err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1305, 'FUNCTION PRICES_DAILY.GetDataSourceIDFromDataSourceName does not exist') — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ANsr28I-za7Lr07QQN4FVwH7flUpZPyvks5ubhIIgaJpZM4WqwIs> .

[TheTerminator2]

Hi

I found the error, I wasn't having SUPER privilege in AWS when making the MYSQL database. But when using the advice from this link ( soundcloud/lhm#76 ) and got the super privilege rights everythink works out fine. Thank you for the fast comment.

[justinclarkhome]

Nice - glad you got it sorted!

[justinclarkhome]

Glad you got that sorted! On Sep 16, 2018 15:07, "TheTerminator2" <[email protected]> wrote: Hi I found the error, I wasn't having SUPER privilege in AWS when making the MYSQL database. But when using the advice from this link ( soundcloud/lhm#76 <soundcloud/lhm#76> ) and got the super privilege rights everythink works out fine. Thank you for the fast comment. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#1 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ANsr2w9C5eNaKEAngtUl8WmMWQqx1Uzqks5ubqFVgaJpZM4WqwIs> .