close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Admin page results form shows 'no results found'

Thread began 1/25/2018 5:00 pm by tmcbinc99963 | Last modified 4/17/2018 12:41 pm by Ray Borduin | 292 views | 9 replies |

tmcbinc99963

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.

Sign in to reply to this post

Ray BorduinWebAssist

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?

Sign in to reply to this post

tmcbinc99963

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).

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

tmcbinc99963

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?

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

tmcbinc99963

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

tmcbinc99963

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...