New Row button doesn’t work

Hi @cdrockey,

Sorry to hear you encountered that issue.

Do you have a link for us to check this table? There might be errors on the page that’s preventing the form from showing.

If you wish to share it privately, please send us a message via Contact | WP Data Access.

We’ll wait for your email!

Here’s the link to the problem page where the new row button doesn’t work:
https://thefarmerscottage.com/books/
I’ve noticed when building the app in the back-end that the new row button doesn’t work there either.

I’ve noticed that the problem table has hyperlinks stored in it. My other table doesn’t have hyperlinks stored in it and it works fine:
https://thefarmerscottage.com/alphabet/

I can give you back-end access if you need it. I just started working on this site.

Hi @cdrockey,

Thanks for the link!

Does any of your columns there have a default value set?

It does look like the error is caused by the hyperlink. Could you tell us how that is currently set up on the table?

It’d be very helpful if we can take a closer look. You can send us a message via Contact | WP Data Access to give us more information about the issue.

We’ll wait for your message. ??

• This reply was modified 3 months ago by Kim L.

Your question about default values helped me figure it out. In phpMyAdmin the field ‘link’ with Null = YES and Default = NULL did not allow the Insert button to work.

If I required the link field, Null = NO and Default = None, the Insert button would work. But I wanted the link field to be optional, so I found what would work was Null = YES and Default = ”.

Getting the empty quotes, ”, into phpMyAdmin was goofy, so I ran the sql:

ALTER TABLE cdr_books
ALTER link SET DEFAULT ”;

Then I went into WP Data Access ALTER section or “Data Designer” for the database and clicked “Reconcile”.

At this point I’m good with it working. If you still want to take a look from the wp-admin back-end, just let me know. I could let you in for a few days. I’ll use your contact form for that.

Thanks!

Hi @cdrockey,

We’re glad that’s sorted out!

We won’t need to take a look if it’s all working now on your end. ??

Thanks again for the update and feel free to contact us again if you have new questions. ??