Access to database

  • Resolved mrblubber

    (@mrblubber)


    8 years ago

    Hello,

    we struggling with the Form Maker plugin currently.
    When using the field type Select and try with “From Database” fill our selection with values from our database, there doesn’t show any of the filtered values.
    So for example we try select a name from the “terms” table. In the Dropdown of the tables we select the “terms” table and get all the corresponding columns in the next dropdown.
    Choosing name and the filter where name = “Okay”. Sort asc from term_id.

    Now we try to use this form in a page but there doesn’t show the name or anything. Like the form doesn’t have access to the database.

    Has anyone a good idea how to solve that problem?

    Cheers
    Stefan

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Form Maker Support

    (@formmakersupport)

    8 years ago

    Hi Stefan,

    May I ask, are you connecting to a local or remote database?

    If remote, then please make sure that it is not private and the firewalls are not blocking.

    Thanks in advance, have a nice day!

    pwforaker

    (@pwforaker)

    8 years ago

    Choosing name and the filter where name = “Okay”. Sort asc from term_id.

    Just wondering… you have rows in the database where name = “Okay” ?

    Peter Rosendahl

    (@prmedia8903)

    8 years ago

    Hi @formmakersupport

    It seems that I have got the same issue as @mrblubber . When I try to add a form item such as “Multiple options” with options from my local database, I:
    1. choose Local connection,
    2. choose the preferred table (nothing seems to be wrong here),
    3. choose the desired column name in that table (nothing wrong here either),
    4. set the WHERE clause to be with the specific group ID that I know I have a series of data in,
    5. Set the sort order to descending,
    6. Press submit to submit the Multiple options field in the form.

    The result of the form is merely the alias/name of the field, and without any data to display.
    I have checked that the data is in the database table, and in other plugins (eg. a photo gallery) I can show the images (i.e. the desired data) without any issues.

    For the record: On a local WordPress site I have an older version of the plugin working just fine – so what I can momentarily conclude, is that the issue has come with the recent update of the plugin.

    I hope that you can find where the problem appears in the plugin code – and if you need more info to the matter, don’t hesitate to ask 🙂

    Thank you in advance for your support.

    Best regards
    Peter

    Plugin Contributor Form Maker Support

    (@formmakersupport)

    8 years ago

    Hi Peter,

    Please be informed that the issue that you are facing is the bug of the plugin.

    I contacted the development team and they told that are going to fix it in the upcoming update. Most probably the release will be during this week.

    Please, let us know whether after an update the issue will be solved.

    Thanks. Have a nice day.

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

The topic ‘Access to database’ is closed to new replies.