Title: [Plugin: Testimonials Widget] Plugin not creating table. Using WP-DB-Abstraction to use SQL
Last modified: August 20, 2016

---

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

 *  Resolved [iamsmooney](https://wordpress.org/support/users/iamsmooney/)
 * (@iamsmooney)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/plugin-testimonials-widget-plugin-not-creating-table-using-wp-db-abstraction-to-use-sql/)
 * I am using [WP-DB-Abstraction](http://wordpress.org/extend/plugins/wordpress-database-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://wordpress.org/extend/plugins/testimonials-widget/](http://wordpress.org/extend/plugins/testimonials-widget/)

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

 *  Thread Starter [iamsmooney](https://wordpress.org/support/users/iamsmooney/)
 * (@iamsmooney)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/plugin-testimonials-widget-plugin-not-creating-table-using-wp-db-abstraction-to-use-sql/#post-2968452)
 * 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](https://wordpress.org/support/users/comprock/)
 * (@comprock)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/plugin-testimonials-widget-plugin-not-creating-table-using-wp-db-abstraction-to-use-sql/#post-2968461)
 * Great to hear about your self-fixing. Awesome work!
 *  Plugin Contributor [Michael Cannon](https://wordpress.org/support/users/comprock/)
 * (@comprock)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-testimonials-widget-plugin-not-creating-table-using-wp-db-abstraction-to-use-sql/#post-2968637)
 * 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](http://wordpress.org/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.

 * ![](https://s.w.org/plugins/geopattern-icon/testimonials-widget_c56561.svg)
 * [Testimonials Widget](https://wordpress.org/plugins/testimonials-widget/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/testimonials-widget/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/testimonials-widget/)
 * [Active Topics](https://wordpress.org/support/plugin/testimonials-widget/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/testimonials-widget/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/testimonials-widget/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Michael Cannon](https://wordpress.org/support/users/comprock/)
 * Last activity: [13 years, 9 months ago](https://wordpress.org/support/topic/plugin-testimonials-widget-plugin-not-creating-table-using-wp-db-abstraction-to-use-sql/#post-2968637)
 * Status: resolved