Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Multiple-table update/delete commands are not supported

Discussion in 'Database Discussion' started by RustyB, May 9, 2019.

  1. RustyB

    RustyB Registered

    Joined:
    May 9, 2019
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    After upgrading from MariaDB 10.1 to 10.3, I began receiving the following error when running an update statement. "Multiple-table UPDATE/DELETE commands are not supported". This update always ran fine before. I searched for this error online and could not find one instance of it. It is also important to note that I only get this error if running an update on a Maria table in which the source is a CONNECT table (in my case SQL Server). My OS is Debian 8, and I've installed unixODBC and FreeTDS. I can select from the CONNECT table fine. But when I use it in an update, I get the above error. Note again, I am not trying to Update the SQL Server CONNECT table. I just use is as a source in my UPDATE query. What would have changed from MariaDB 10.1 to 10.3 that would cause this to stop working all of a sudden?
     
  2. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,254
    Likes Received:
    479
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Can you please open a ticket using the link in my signature? Once open please reply with the Ticket ID here so that we can update this thread with the resolution once the ticket is resolved.


    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice