email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Post here if you experience problems or get unexpected errors.
Hi

I am having a problem with the email parser while inserting a record:

SQL Query:
Code: Select allConnecting to MySQL server 5.77.33.38 Connected Running the SQL statement: INSERT INTO `purchases` (`PurchaseID`, `ClientName`, `ClientEmail`, `ClientTelephone`, `Product`, `ShowDateTime`, `Channel`, `OrderNumber`, `QuantityPurchased`, `BookingTime`, `BookingAmount`, `BookingRef`, `TimeStamp`)VALUES ("","test", "test", "123451", "Test", STR_TO_DATE("26/01/2018 08:00:00","%d/%m/%Y %H:%i:%s"), "test", "KGH-GH", 2, STR_TO_DATE("26/01/2018 08:00:00","%d/%m/%Y %H:%i:%s"), 14.52, "HYD", TIMESTAMP('')) Error. Incorrect parameter count in the call to native function 'STR_TO_DATE'.
If however I take the above query and paste it into PHPmyAdmin it works perfectly fine.

Can you help please?

Thanks

Gavin
Hello Gavin,
Error. Incorrect parameter count in the call to native function 'STR_TO_DATE'.
This error message comes from MySQL itself, not Email Parser.

I would try running this on a tool like HeidiSQL (like phpmyAdmin but in an app) and see if the result is the same.