Is TablePress SQL Server Compatible?

  • Resolved cwalls

    (@cwalls)


    10 years, 11 months ago

    Does TablePress support SQL Server? We have it installed, but it appears to be using MySQL formatted SQL. We have the WordPress database abstraction plug-in installed and configured, but based on the SQL being logged, it appears the SQL issues by TablePress is somehow not going through this database abstraction layer. We know the WordPress and other plug-ins are using the abstraction layer due to the SQL logged by the sqlsvr component.

    https://www.ads-software.com/plugins/tablepress/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    TablePress does not use any direct SQL queries (the only place maybe is the WordPress search, where it modifies a query slightly).
    All data is retrieved/stored via existing WordPress APIs, to those should be mapped internally.
    Are you experiencing any problems with TablePress?

    Regards,
    Tobias

    Thread Starter cwalls

    (@cwalls)

    Knowing that TablePress is using the WordPress APIs was helpful. I went back into the SQL Server abstraction layer and determined that the function that strips off the single quotes from the column names was executing too early in the process. The code was refactored and the TablePress SQL was modified correctly.

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    very nice! ?? Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Is TablePress SQL Server Compatible?’ is closed to new replies.