Admin page results form shows 'no results found'

After inserting a new product into the Db using the 'insert' page, a search shows 'no results found', though the record is in the Db. I've tried duplicating another record, with new primary key, but same result.

Also, adding the new product also adds Db records to my 'testimonials' page, though I didn't add any testimonial data.

I don't see how the product insert page could insert into the testimonials... there is no reference to the testimonials table on that page at all from what I can see.

It also appears there is no redirect, so when I do the insert it just stays on the insert page. Maybe I'm looking at the wrong page?

Your test created a new record in the Db as it should. A site search finds that record.

When I search from /admin/prod_search.php, it redirects to /admin/prod_results.php correctly, but displays 'No Results Found'.

Your test also created a new record in the Testimonials Db, but oddly, duplicated an existing record to create the new record (giving it a new primary key).

Is your insert record using a view or a table? I see you are working on the page since I'm getting a duplicate key error on the page now.

Please clarify view or table question. I'm using the pages created using form builder.

Why is the insert record giving a primary key error? Shouldn't it be creating a new PK each time?

A new primary key value will be created if you have it set to be an autonumber column and you aren't setting a value during the insert. Make sure your primary key column doesn't have a default value and that it is set to use an autonumber instead.

The primary key issue has been fixed: needed to set Db ID default value to '0' and make sure Auto Increment was checked.

However, the admin search page still returns 'no results found', though the record is in the Db.

Also, the checkbox and upload form elements on the 'insert' form don't work. A site search shows a result of 'this record has been removed', with no values in the 'Size' dropdown menu, and the file uploads don't show up on the remote server.

You were using INNER JOIN in your SQL statement, which won't return a result if the joined tables don't have a matching value. I changed it to use a LEFT JOIN instead so that I could see the result. It appears the issue is that the prodtype table doesn't have the ID from the product table listed in it and that is why the result wasn't showing.

When inserting a new product, only the prod table is changed.

Two other tables, prodtype and prodsize, should change based on checkbox selections. Both these tables use foreign keys.

Also, when the pencil is clicked, several products (including newly added ones) don't have values in any of the fields.

It appears the insert isn't adding to the other necessary tables. Empty fields would imply bad binding values in the insert server behavior.

Look at the insert page as the source of the issues since it appears there is nothing wrong with the search and results once the correct corresponding rows are inserted into the joined tables.