ERROR: Wrong arguments [no data found]

  • Resolved kzirk2020

    (@kzirk2020)


    6 years ago

    Data is being entered properly. I hate to bother you again, but I have two questions. One is that the data entry form at the bottom of the page is showing the column names instead of the column labels I defined. I’m not sure where the style sheet is for that either. I’ve been digging around.

    The second issue is the topic title. After I submit a record, it is written to the database but then it displays the message “ERROR: Wrong arguments [no data found]” which I assume is supposed to show the data just entered but is not.

    The page I need help with: [log in to see the link]

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

    (@peterschulznl)

    6 years ago

    Hi Karin,

    There are two ways to define column labels:
    (1) From the Data Explorer > Manage > Settings > Column Settings
    See instructions here: https://wpdataaccess.com/docs/documentation/data-explorer/table-settings/
    (2) From Data Projects > Manage Table Options
    This one is more complex but allows more possibilities as well. See video instructions here: https://wpdataaccess.com/docs/documentation/data-projects/manage-table-options/

    I checked your page and added a few rows to test. Hope you don’t mind. The arguments do not seem to produce this error. Does your table have a primary key? This is not needed for an insert, but when the plugin tries to read to data back it needs a primary key. Can you please add a primary key and check again?

    Don’t worry about bothering me! This is what I love to do… 🙂

    Best regards,
    Peter

    Thread Starter kzirk2020

    (@kzirk2020)

    6 years ago

    Hi @peterschulznl As you can see this is a super simple table. I can’t have a primary key on name because there are many people with the same name. I added a third column to server as the primary key on the MySQL table. It’s INT, AUTO_INCREMENT but this is breaking the inserts. I’m a bit befuddled. Sorry I’m a back end DBA and don’t do a lot of front end stuff. I just volunteered to do this for some friends. Does the PK need to be on a column that people are entering?

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    6 years ago

    Hi Karin,

    If you add an auto increment column the user wont need to enter a value. It just needs to be visible. Maybe you can add a hint to your column label to let people know it is auto generated.

    Best regards,
    Peter

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

The topic ‘ERROR: Wrong arguments [no data found]’ is closed to new replies.