Title: WPDataAccess stopped working
Last modified: October 10, 2021

---

# WPDataAccess stopped working

 *  [rebarsan](https://wordpress.org/support/users/rebarsan/)
 * (@rebarsan)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/wpdataaccess-stopped-working/)
 * Error Message: ERROR: Column tot_events not found ERROR: Column rank_by_miles
   not found
 * I have blue exclamation point in the Data Publisher with notice to affect that“
   Schema, table or Column Name validation not possible . .”
    The connection is 
   to a non-wordpress database we maintain on the server.
 * Note that all tables stopped working suddenly. All have been working well up 
   to this point.
 * Thanks,
    Rick
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwpdataaccess-stopped-working%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/wpdataaccess-stopped-working/#post-14956190)
 * Hi Rick,
 * It looks like your database connection no longer works.
 * If this is a remote database you can check your connection on the settings page:
   –
   Go to Settings > WP Data Access – Tab: Plugin – Section: Remote database connections–
   Click edit icon – Click button Test
 * If the connection cannot be established, check the firewall, database, username,
   password, privileges, and so on. Was there anything changed?
 * Does this help?
    Peter
 *  Thread Starter [rebarsan](https://wordpress.org/support/users/rebarsan/)
 * (@rebarsan)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/wpdataaccess-stopped-working/#post-14986191)
 * Data Base Connection works well.
    The problem seems to be running a function 
   in a VIEW that is then displayed by your plugin. Other VIEW’s work well. I have
   a function named “anon” (which takes 2 parameters) and when I have a VIEW with
   this:
 * [SELECT…
    `members`.`last_name` AS `last_name`, …]
 * your plugin works, but when I use the function as in:
 * [SELECT… `anon`(`members`.`anonymous`,`members`.`last_name`) AS `last_name`,
   …]
 * the plugin does not work. The VIEW itself works well.
    Have you tried a query
   containing a function? If it doesn’t work, do you have a suggested “work around”?
   Many thanks, Rick
 *  Thread Starter [rebarsan](https://wordpress.org/support/users/rebarsan/)
 * (@rebarsan)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/wpdataaccess-stopped-working/#post-14986208)
 * I should add that the plugin seems to work on my development server, but not 
   on my host, InMotion.
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/wpdataaccess-stopped-working/#post-14987756)
 * Hi Rick,
 * Can you check if the function you are calling in the view is created on your 
   host? If you are ISP hosted, you may not be allowed to use functions. Can you
   please check?
 * Thanks,
    Peter

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

The topic ‘WPDataAccess stopped working’ 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/)

 * 4 replies
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [4 years, 6 months ago](https://wordpress.org/support/topic/wpdataaccess-stopped-working/#post-14987756)
 * Status: not resolved