cdrockey

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!

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.

Nevermind! I figured out it was Jetpack Boost. To fix the problem I turned off the setting to

Defer Non-Essential JavaScript

Run non-essential JavaScript after the page has loaded so that styles and images can load more quickly. Read more on web.dev.