471,066 Members | 1,481 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

database hangs in MyPHPAdmin/can't login to web site

I cannot log into our web site. I have a test web site and a real
site. On Friday I could log in and today Monday I cannot log in. I
have 2 databases In PHPMyAdmin, the real database and and a test
database site which used to be mirrors. Someone else did upgrade
work on the real site which I must troubleshoot because they are
gone.

Symptoms:I can select in myPHPadmin the test database but when I try
to switch in PHPMyAdmin from the test database to the real database
the myPHPAdmin tool hangs. At that point I cannot get back to either
of the other two databases.

As I mentioned none of the users can log in to the real web site/
database. When they do it just keeps loading.
(I am and have always used Mozilla). When I clear all the cookies/
sessions from mozilla I can go back to the login page otherwise it
just keeps loading. That is when I clear all cookies at least I can
go back to the login page. I still can't log in but it stops
everything from hanging.

The only idea I have right now is compare the real web site login page
to the test one line by line. I don't get any error messages. I just
can't log in. I would assume nothing has changed in the login page
and there is some process error?

It is a hosted database and I thought maybe the problem was with them
except they tested it and can't find a problem.

Why would selecting the real database hang in myPhpAdmin??? This
happens whether or not I try to log in to our site in the browser. So
since the real database is hanging in phpAdmin can I assume something
is wrong with that database and it is not the login page? What could
be wrong with the database itself? How can I troubleshoot it?

thanks,
Jun 27 '08 #1
2 2497
JRough wrote:
I cannot log into our web site. I have a test web site and a real
site. On Friday I could log in and today Monday I cannot log in. I
have 2 databases In PHPMyAdmin, the real database and and a test
database site which used to be mirrors. Someone else did upgrade
work on the real site which I must troubleshoot because they are
gone.

Symptoms:I can select in myPHPadmin the test database but when I try
to switch in PHPMyAdmin from the test database to the real database
the myPHPAdmin tool hangs. At that point I cannot get back to either
of the other two databases.

As I mentioned none of the users can log in to the real web site/
database. When they do it just keeps loading.
(I am and have always used Mozilla). When I clear all the cookies/
sessions from mozilla I can go back to the login page otherwise it
just keeps loading. That is when I clear all cookies at least I can
go back to the login page. I still can't log in but it stops
everything from hanging.

The only idea I have right now is compare the real web site login page
to the test one line by line. I don't get any error messages. I just
can't log in. I would assume nothing has changed in the login page
and there is some process error?

It is a hosted database and I thought maybe the problem was with them
except they tested it and can't find a problem.

Why would selecting the real database hang in myPhpAdmin??? This
happens whether or not I try to log in to our site in the browser. So
since the real database is hanging in phpAdmin can I assume something
is wrong with that database and it is not the login page? What could
be wrong with the database itself? How can I troubleshoot it?

thanks,
First of all, this isn't really a PHP question - it's a database question.

As to why it's hanging - you need to find out what was done over the
weekend. Then if you're still having problems, try comp.databases.mysql
with the information you got from your host.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Jun 27 '08 #2
On Jun 9, 2:39 pm, Jerry Stuckle <jstuck...@attglobal.netwrote:
JRough wrote:
I cannot log into our web site. I have a test web site and a real
site. On Friday I could log in and today Monday I cannot log in. I
have 2 databases In PHPMyAdmin, the real database and and a test
database site which used to be mirrors. Someone else did upgrade
work on the real site which I must troubleshoot because they are
gone.
Symptoms:I can select in myPHPadmin the test database but when I try
to switch in PHPMyAdmin from the test database to the real database
the myPHPAdmin tool hangs. At that point I cannot get back to either
of the other two databases.
As I mentioned none of the users can log in to the real web site/
database. When they do it just keeps loading.
(I am and have always used Mozilla). When I clear all the cookies/
sessions from mozilla I can go back to the login page otherwise it
just keeps loading. That is when I clear all cookies at least I can
go back to the login page. I still can't log in but it stops
everything from hanging.
The only idea I have right now is compare the real web site login page
to the test one line by line. I don't get any error messages. I just
can't log in. I would assume nothing has changed in the login page
and there is some process error?
It is a hosted database and I thought maybe the problem was with them
except they tested it and can't find a problem.
Why would selecting the real database hang in myPhpAdmin??? This
happens whether or not I try to log in to our site in the browser. So
since the real database is hanging in phpAdmin can I assume something
is wrong with that database and it is not the login page? What could
be wrong with the database itself? How can I troubleshoot it?
thanks,

First of all, this isn't really a PHP question - it's a database question.

As to why it's hanging - you need to find out what was done over the
weekend. Then if you're still having problems, try comp.databases.mysql
with the information you got from your host.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
You are right it is a mySQL error on the server. they haven't been
able to fix it or give me any info yet.
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by ahevans | last post: by
9 posts views Thread by Pacific Design Studios | last post: by
2 posts views Thread by harris | last post: by
reply views Thread by psb | last post: by
3 posts views Thread by BobLaughland | last post: by
reply views Thread by Mike Smith | last post: by
1 post views Thread by =?Utf-8?B?SHVzYW0=?= | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.