MySQL Database

Topics: 1. General, 5. Support
Aug 29, 2016 at 1:13 PM
Hi,
I have successfully logged in my SQL database on a different Server.
Unfortunately I receive continuesly the follwing error response when running './SBFspot -v -finq - nocsv_:

'Error: [spot_data]exec_query() returned: Table 'SBFspot.SpotData' doesn't exist ...'

Does have anyone an idea what I have done wrong?

Thanks.

PS: I double checked: permission in mysql are set to "full".
Coordinator
Aug 31, 2016 at 6:43 AM
Sure the table is still there?
select table_name from information_schema.tables;
Aug 31, 2016 at 6:40 PM
I did not know the table needed to be created.
After reading yesterday evening this thread here "https://sbfspot.codeplex.com/discussions/641234" I created all tables and now it works splendingly.
Thank you very much.

PS: I thought, that similar to e.g. openhab the tables would be created automatically.
Coordinator
Sep 1, 2016 at 9:36 AM
SBFspotUser doesn't necessarily has the rights to create the tables, that's why.
I did my best to put this in the documentation too ;-)