MySQL sync: no matches for field item_id

Follow

Thomas Hysselinckx

• February 05, 2021 10:30
• Edited

Hi there!

I'm trying to sync Podio to MySQL via Podio Workflow Automation. The connection to my database works fine. I can connect the Hash Checksum to the column I created (hash - varchar(32).

However, it does not find a match for the item_id column. Here's my create table code:

CREATE TABLE `sprints` (
  `ID` int AUTO_INCREMENT PRIMARY KEY,
  `item_id` int unsigned,
  `test_column` int(11),
  `hash` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
) ENGINE=InnoDB

I tried multiple setups, and this code creates three INT columns. I would expect ID as well as item_id would work, but this is the result:

As you see, the hash match works fine:

Any ideas on what I'm doing wrong here?

Thanks in advance!

-Thomas

1

• 

  Charlotte Bürki

  • June 18, 2021 10:25

  Hi,

  I have exactly the same problem. Did you find any solution?

  Charlotte

   

   

  1

  Comment actions Permalink

Please sign in to leave a comment.