Input Form Not Inserting Data

Hi rdeigsler

What is your website address so I might take a look.

After you input a testimonial and it says it was sent, if you go to the Edit Testimonial Panel, it is not there? It should be there but not approved, unless you have turned on auto approval.

Hi Kevin,

Thanks for replying so quickly.

https://www.introflights.com/?page_id=242

That is correct, after I input a testimonial and it says it was sent, if you go to the Edit Testimonial Panel, it is not there. I look in the database and the record is not there either.

One thing I am noticing when I view source code of page is that the form tag has a method but no action (<form method=”POST”>). I am assuming this is fine as it is just posting back to itself?

That is correct.

You can try adding action=”#” to the form tag and see if that works, but I think something else is going on.

Sent you a test testimonial.

What browser are you using?

I am getting the email notification for your testimonial but no records in database.

I have tried with IE11, Firefox 26, and Chrome 31.

I just double checked the testbed and everything is working.

I see a line between Name and Email on my screen. Is that supposed to be there?

Have you changed any code?

I haven’t changed any code. I get the line on Firefox and Chrome but not with IE 11.

If you look at page source you can see there is only a break tag between them.

<label class="katb_input_label1">Name *</label><input type="text" maxlength="100" name="tb_author" value="" /><br/><label class="katb_input_label1">Email *</label><input type="text" maxlength="100" name="tb_email" value="" />

It may be because the Windows Sever is more strict with SQL insert than Apache Servers, I’ve had a similar problem before.

The admin form updates all 11 elements of the table where as the visitor form only updates 10 elements, because visitors do not up load photo urls’s.

If you are willing to try a test fix I can send you a new katb_functions.php file. Contact me through e-mail (contact page of kevinsspace.ca) if you are interested in trying a fix.

If the fix works I will release a update.

Sounds good, email sent.

Voila!, Works perfect!

Thanks for all your help.

And I want to thank you for your well commented code. The majority of developers fall short in this area of which I am also guilty.

Kudos to a well written app!

Problem resolved.