Slingshot! Issue with not being able to write to MySQL database

I am trying to set up Slingshot! to write my Grasshopper/Galapagos iterations to a MySQL database but am encountering an issue.

The error code I get is "System.NullReferenceException: Object reference not set to an instance of an object".

I was wondering if anyone has encountered this issue or has any idea what may be happening. I am able to see my MySQL databases and tables, but not able to write any data to them.

Attachments:

Capture1.JPG, 94 KB
Capture2.JPG, 100 KB

Replies to This Discussion

Permalink Reply by martyn hogg on January 20, 2016 at 4:36pm

I can only really guess at what might be going wrong from the info you have provided, but I think this sort of error happens when some data is passed to a component but something about the data confuses the component as it parses the data.

A common problem with SQL can be that certain characters within the SQL string can cause problems... like single and double quotes for example - if you built the SQL text by concatenating strings and one string contained and apostrophe, then this can create invalid SQL.

Maybe check any SQL by running it in the SQL database directly rather than trying to do it over the Slingshot connection?

RSS