WordPress.org

Forums

[Plugin: Pods 2.0] Installation on MSSQL broken (5 posts)

  1. inter5
    Member
    Posted 2 years ago #

    I’m attempting to install Pods 2.0.4.1 on Windows Server and using a MSSQL database and while trying to activate the plugin, I’m greeted with the error “Cannot setup SQL tables; SQL: DROP TABLE IF EXISTS wp_STSCpodsrel; Response: Array.” After adding drop permissions for my WordPress user and trying to activate the plugin again, I was taken to the initial WordPress installation page. Being unable to access any pages but the WordPress installation page, I manually disabled Pods in the WordPress database and then tried activating again. Unfortunately, this now seems to cause issues where this error message is the only thing that shows on the entire site until I manually enter the database and remove Pods from the active plugins list again.

    I’ve had no issues with Pods in the past, but this is my first time installing it on MSSQL so I’m assuming this is what’s causing the problem. Does anyone have any suggestions as to how I might be able to get this working?

  2. Scott Kingsley Clark
    Member
    Posted 2 years ago #

    We haven't tested extensively on other databases yet, we're working on a new database layer in Pods 2.x that will make it possible to run Pods on just about any of the major DB engines out there. Right now, I think WordPress itself only runs on MySQL and MS SQL.

    I'll get with a host and see if we can set up some test environments to get these resolved.

  3. Scott Kingsley Clark
    Member
    Posted 2 years ago #

    I've posted a bug in our tracker about it, you can follow progress here:

    https://github.com/pods-framework/pods/issues/771

  4. inter5
    Member
    Posted 2 years ago #

    Thanks for the reply, Scott.

    If it's helpful, I'm using the WP Database Abstraction plugin (http://wordpress.org/extend/plugins/wordpress-database-abstraction/) to handle my database connection.

  5. Scott Kingsley Clark
    Member
    Posted 2 years ago #

    I hadn't seen that plugin before, I'll have to dig in and see why it's not automatically translating everything.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.