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