[Plugin: Testimonials Widget] Plugin not creating table. Using WP-DB-Abstraction to use SQL

  • Resolved iamsmooney

    (@iamsmooney)


    13 years, 10 months ago

    I am using WP-DB-Abstraction to use SQL in my wordpress website. I can activate the plugin and the fields_map changes to include all of the fields in the database, but the table is not created. Instead when saving a testimonial I get this error:
    “Database table not found”

    I’ve confirmed that the table is not in the database and that the db user has the proper permissions (db_owner). But even going in and manually creating the table did not work. I still get the same error message when trying to add testimonials.

    Any ideas if this can work with SQL or is there mysql specific languange that cannot be used?

    Thanks so much for your help.

    http://ww.wp.xz.cn/extend/plugins/testimonials-widget/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter iamsmooney

    (@iamsmooney)

    13 years, 10 months ago

    Ok I hacked through this but it turns out that the DB Abstraction plugin was not correctly replacing the column name PUBLIC with [PUBLIC] in the queries. The problem is in MSSQL ‘public’ is a reserved word and should be enclosed in brackets to mean a name.

    So I changed all queries containing PUBLIC with [PUBLIC] in the testimonials-widget-admin.php and testimonials-widget.php files and it fixed my problem.

    I’ll mark this resolved since it fixed my issue, though moving forward I’ll have to re-write this if I update the plugin.

    Plugin Contributor Michael Cannon

    (@comprock)

    13 years, 10 months ago

    Great to hear about your self-fixing. Awesome work!

    Plugin Contributor Michael Cannon

    (@comprock)

    13 years, 9 months ago

    With the 2.0 rewrite, the public issue will go away.

    Also, I’m doing a 2.0 rewrite of Testimonials Widget, could you please read and suggest features or changes at http://ww.wp.xz.cn/support/topic/plugin-testimonials-widget-version-20-rewrite-suggestions-request?replies=1?

    Thank you,

    MIchael

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

The topic ‘[Plugin: Testimonials Widget] Plugin not creating table. Using WP-DB-Abstraction to use SQL’ is closed to new replies.