Testimonials Widget
[resolved] Plugin not creating table. Using WP-DB-Abstraction to use SQL (4 posts)

  1. iamsmooney
    Posted 3 years 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.


  2. iamsmooney
    Posted 3 years 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.

  3. Michael Cannon
    Plugin Author

    Posted 3 years ago #

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

  4. Michael Cannon
    Plugin Author

    Posted 3 years 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://wordpress.org/support/topic/plugin-testimonials-widget-version-20-rewrite-suggestions-request?replies=1?

    Thank you,


Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Testimonials Widget
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic


No tags yet.