Error: Multiple statements are not allowed.

  • Resolved chelminski

    (@chelminski)


    2 months ago

    Hey ?? ,

    I’m trying to create logs using Automator. I’m attempting to execute a query, but I keep seeing the error “Multiple statements are not allowed.” How should I write the query to make everything work?

    INSERT INTO asto_user_event_log (user_id, event_type, event_opis, widok)
    VALUES (1481, 'logged_in', '[IP: 128.0.0.1; Permissions+Directory: Helper, Administration]', '0');

    Sorry for the issue, but I don’t understand. I thought the above statement was a single SQL query/task.

    Greetings,
    chelminski

Viewing 1 replies (of 1 total)
  • Saurabh

    (@saurabhshukla)

    Hi @chelminski,

    Since this is a question about a Pro action, I recommend reaching out here https://automatorplugin.com/automator-support/ or through your membership dashboard.

    The multiple query error comes from a sanitization function that considers ; as the query delimiter within the text. This is getting triggered by the semi-colon after the IP address.

    The quickest fix would be to either replace it with another punctuation, separator. However, if it is necessary to use it, kindly reach out to the Premium support channel so that we may help with this, asap.

    Best

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.