close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

I am getting an invalid email/please complete field when I have an email entered on my registration page.

Thread began 6/28/2019 2:02 pm by jo271221 | Last modified 7/04/2019 10:46 am by Ray Borduin | 21 views | 3 replies |

jo271221

I am getting an invalid email/please complete field when I have an email entered on my registration page.

I have attached the page and FTP info. This is an old site and it was working, I am not sure when it quit.

Sign in to reply to this post

Ray BorduinWebAssist

What email address are you using? I entered mine and it seems to take it.

Sign in to reply to this post

jo271221

My email however my email (in pm) is already associated with a registered user so maybe we are requiring unique?

Also shortly after I published this page (which I believe we were using in the past and I took it down for a while so that new users could not register) we started having server issues. This is what was reported:
, I noticed that the server is getting out of RAM memory due to MySQL connections.
I saw some big queries that could be stuck in the process. I attached the file slow-queries.log with the slowest queries.


Typically this behavior has one of two causes:
- A query acquired a lock and never releases it
- You're running an unindexed query (especially where JOINs are involved)

As we saw in the slow-queries.log file, we have slowest select's and that's locking the MySQL connections.
The query 1 have "Time: 24647" that's around 7 hours. Then the queries get the state "Waiting for table level lock"

I do not see any joins on this page however I did notice an extra body tag and deleted that and attached both copies. I have also attached a couple update pages that DO have join statements on them.

For now I am replacing the files in question with temporary pages to see if they notice a difference on the server load.

I have not been paying much attention to this site and someone requested to be listed in the directory so I put the new member page back out there and now all of these issues - ? Thank you!

Attached Files
directory_update.php
directory_update_interest_hobbies_sportsBAK.php
memberships-new-add.php
memberships-new-addBAK.php
Sign in to reply to this post

Ray BorduinWebAssist

It is probably a really inefficient query on a page that is hanging it up. The way to debug this is to go to PHPMyAdmin and run the query "SHOW PROCESSLIST".

https://dev.mysql.com/doc/refman/5.5/en/show-processlist.html

That will show you the query or queries that are hung up and then you can know what query you need to optimize. Sometimes you can just add indexes or re-write the queries on the page to make them run more quickly to solve the problem.

Sign in to reply to this post

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