ERROR: SQLSTATE[HY000]: General error: 1105 Syntax error in URL

  • Resolved istarion

    (@istarion)


    3 years, 6 months ago

    Host Siteground
    WordPress 6.1.1
    WP Data Access 5.2.9

    Using Premium Data Explorer, when attempting to create a Remote Data Connection, I am receiving the error:

    ERROR: SQLSTATE[HY000]: General error: 1105 Syntax error in URL

    I have added the IP of the Siteground WordPress site to the Remote Access List for the MySQL database in question, which is located on another Siteground site (not running WordPress).

    Using the same connection string parameters in MySQL Workbench, I am able to successfully connect to the remote database.

    Any ideas what could be causing this error?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    3 years, 6 months ago

    Hi @istarion,

    Are you connecting via PDS or directly from the Data Explorer?

    Thanks,
    Peter

    Thread Starter istarion

    (@istarion)

    3 years, 6 months ago

    Hi Peter. I started in PDS to activate the service and then went to Data Explorer.

    Thread Starter istarion

    (@istarion)

    3 years, 6 months ago

    I brought this issue up with Siteground’s hosting service technical support and there investigation into the problem showed no connection errors in the MySQL logs. They also tested the connection string parameters that I am using and were successfully able to connect both locally and from another remote host.

    Could the issue be with rdb:wpdafreeyouniquedata.com?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    3 years, 6 months ago

    “Using Premium Data Explorer,”

    You’re using a commercial/premium plugin, so please use their official support channel. We feel they are best equipped to support their products.

    https://wpdataaccess.com/

    Commercial products are not supported in these forums.

    Plugin Contributor Kim L

    (@kimmyx)

    3 years, 6 months ago

    Hi @istarion,

    As I mentioned in your other post:

    As this error seems to be related to Premium Data Services, kindly email us here with more details: https://wpdataaccess.com/contactform/

    Or by clicking on the Premium Support icon in the WP Data Access dashboard.

    We look forward to your email!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘ERROR: SQLSTATE[HY000]: General error: 1105 Syntax error in URL’ is closed to new replies.