• 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 to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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

    (@rebarsan)

    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

    (@rebarsan)

    I should add that the plugin seems to work on my development server, but not on my host, InMotion.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    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.