MySQL Error on "Go"

Discuss DataPipe. Get help with installation and running it, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators

rsanders
Posts: 2
Joined: Tue Feb 12, 2013 8:03 am

MySQL Error on "Go"

Postby rsanders » Tue Feb 12, 2013 8:12 am

I'm trying to support a user of your tool. She hadn't used it in a while, but was asked to make some changes to a DB driven web site and decided to re-install DataPipe (after upgrading to the latest version). Our Windows Admin installed the MySQL ODBC driver (unicode) on her computer and gave her access to setup a System DSN. She and I walked through your instructions on setting up a System DNS and it was showing a valid connection. Note that this connection is tunneled over SSH (using Putty). She is able to connect to the database, and DataPipe is connecting. She is able to setup a TextPipe transform and the "Preview" is working. However when she click "Go" she just gets Error updating row 1, [MySQL][ODBC 5.2(w) Driver][mysqld-5.5.30]Build WHERE -> insert_fields() failed This is against a MySQL 5.5 Server, the database and text fields are set to UTF-8 encoding.

Anyone have any ideas?

I'm remote from her location, so I have not been able to get a hands on with her setup. If I don't hear something back, then tomorrow I'm going to setup the trial on my computer and see if I run into the same problem or not.

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: MySQL Error on "Go"

Postby DataMystic Support » Tue Feb 12, 2013 8:17 am

It sounds like the connection is read-only, please check if the MySQL username has insert/update permission, and also check if the ODBC connection is set to read/write - there is usually a read-only option set on this.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

rsanders
Posts: 2
Joined: Tue Feb 12, 2013 8:03 am

Re: MySQL Error on "Go"

Postby rsanders » Wed Feb 13, 2013 12:04 am

Thanks for the info. In this case I was pretty sure the connection was not read only since I helped set it up. I actually found the answer and forgot to post it yesterday, so I'm doing so now. I continued googling the error message she was getting, and also she sent me the SQL SELECT . It turns out the the SELECT did not include the table's primary key, so the ODBC apis could not update the rows. Adding the primary key to the SELECT resolved the issue. Its just too bad that the MySQL driver (or ODCB) doesn't return a clearer error in this case.

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: MySQL Error on "Go"

Postby DataMystic Support » Wed Feb 13, 2013 12:58 pm

Agreed - most error messages are awful. I believe the help file mentions that you need to select the primary key, I will check this now and add it if not.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “DataPipe Support”

Who is online

Users browsing this forum: No registered users and 3 guests