Title: BUG – Create View
Last modified: March 6, 2020

---

# BUG – Create View

 *  Resolved [gypsybytes](https://wordpress.org/support/users/gypsy-bytes/)
 * (@gypsy-bytes)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/bug-create-view/)
 * Hi Peter,
 * Me again 🙂
 * I can’t seem to create views via the WPDA back end. I am trying to do it by importing
   a SQL script. I have imported the script on both the Data Explorer and the Data
   Designer screens. In both cases, no errors are reported and WPDA informs me that
   the import completed successfully. (By the way, you may want to fix the spelling
   in your message: it’s “successfully” and not “succesfully”)
 * It’s not a case of not displaying the view and it’s not because I have not given
   access in the settings. It does not create the view at all. It does not exist
   if I check via phpMyAdmin.
 * I am, of course, able to run the scripts in PHPMyAdmin to create the views and
   that is what I am doing, but the whole point of WPDA is that I shouldn’t have
   to use phpMyAdmin, right?
 * Some more info:
 * My SQL script that I’ve written starts like this:
 * CREATE VIEW tcsa_v_schedule AS etc. etc.
 * When I create the view in phpMyAdmin and then export the SQL from WPDA>>Data 
   Explorer>>Manage>>SQL it starts like this:
 * CREATE ALGORITHM=UNDEFINED DEFINER=`_EU_dc4e44893c912b9d`@`%` SQL SECURITY DEFINER
   VIEW `tcsa_v_schedule` AS etc. etc.
 * You can see all those extra parameters?!? between the words CREATE and VIEW. 
   Not sure what they mean, anyway, I have tried to use my own script and the script
   generated by WPDA with all the quotes inserted. Neither of them create the view.
   My database permissions allow the creating of views. And once the view is created,
   I can DROP it via WPDA.
 * Again, not a critical problem for me, but it may be something to consider working
   on for a future release.
 * Kind regards
    Melody

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

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/bug-create-view/#post-12516641)
 * Hi Melody,
 * To run scripts from the Data Explorer, you need to end every SQL statement with
   semi-colon followed by a new line. If the plugin doesn’t find this “SQL statement
   end”, your SQL will not be processed correctly. Can you confirm that your create
   view statement end with semi-colon and a new line?
 * Best regards,
    Peter
 *  Thread Starter [gypsybytes](https://wordpress.org/support/users/gypsy-bytes/)
 * (@gypsy-bytes)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/bug-create-view/#post-12517010)
 * Ahhhh! I had the semi-colon, but did not realise I needed a new line after ..
   it works now.
 * Thanks for the quick response.

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

The topic ‘BUG – Create View’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [gypsybytes](https://wordpress.org/support/users/gypsy-bytes/)
 * Last activity: [6 years, 2 months ago](https://wordpress.org/support/topic/bug-create-view/#post-12517010)
 * Status: resolved