Hi
I am having a problem with the email parser while inserting a record:
SQL Query:
Can you help please?
Thanks
Gavin
I am having a problem with the email parser while inserting a record:
SQL Query:
Code: Select all
If however I take the above query and paste it into PHPmyAdmin it works perfectly fine.Connecting 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'.
Can you help please?
Thanks
Gavin
Hello Gavin,
I would try running this on a tool like HeidiSQL (like phpmyAdmin but in an app) and see if the result is the same.
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.