Topic Options
#54094 - 10/15/16 10:42 AM W3613 : Error converting database: Multiple-step
Alikeware Offline
OL Newbie

Registered: 02/14/08
Posts: 26
Loc: USA, Maryland
Need help please!

I have a DB plugin that is retrieving data from a MySQL DB. I have a specific set of records that won't execute. It gives the "W3001 : Error while executing plugin: W3613 : Error converting database: Multiple-step operation generated errors. Check each status value".

Any ideas? It works for everything but this specific product that I am searching for. I ran the SQL query using MySQL Bench and it returns all 28 records just fine.

Thanks...

Top
#54095 - 10/16/16 10:43 AM Re: W3613 : Error converting database: Multiple-step [Re: Alikeware]
Philippe F. Offline
OL Expert

Registered: 09/06/00
Posts: 1931
Loc: Objectif Lune, Montreal, Qc
Looks like there's an invalid value in one of the fields returned by your Query. Google MySQL Multiple-step operation generated errors and you'll see it's a fairly common error with MySQL.

From what I can gather, you should try and reduce your query to identify which field value causes an issue. So for instance, instead of issuing a query like:

Quote:
SELECT * FROM MyTable where Category='CAT'


you could start by querying only a few fields and see how that turns out, e.g.

Quote:
SELECT ID, Name, Description FROM MyTable where Category='CAT'
_________________________
Technical Product Manager
I don't want to achieve immortality through my work; I want to achieve immortality through not dying - Woody Allen

Top