By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,971 Members | 907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,971 IT Pros & Developers. It's quick & easy.

Prob in phpMyAdmin on IIS installation on Windows XP

P: n/a
I have PHP installed on a Windows XP platform using IIS as
server. When updating a MySQL database field set to MEDIUMTEXT
in phpMyAdmin, the transaction seems to fail if the text contains
more than a few hundred characters.

The update is actually made successfully, but afterwards, the server
cannot locate the phpMyAdmin page as requested by the client
browser. I get a "Page cannot be found" error. Clicking
on Update from the browser clears the problem.

Anyone know what's causing the problem? Potential sources
of the problem could be with the driver for MySQL, with the IIS
settings, or with the phpMyAdmin settings. I suspect IIS.

Jim

Jul 17 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a

"JimC" <ji**@cross-comp.com> wrote in message
news:8d****************@newssvr27.news.prodigy.com ...
I have PHP installed on a Windows XP platform using IIS as
server. When updating a MySQL database field set to MEDIUMTEXT
in phpMyAdmin, the transaction seems to fail if the text contains
more than a few hundred characters.

The update is actually made successfully, but afterwards, the server
cannot locate the phpMyAdmin page as requested by the client
browser. I get a "Page cannot be found" error. Clicking
on Update from the browser clears the problem.

Anyone know what's causing the problem? Potential sources
of the problem could be with the driver for MySQL, with the IIS
settings, or with the phpMyAdmin settings. I suspect IIS.


Still having problems with this. As I update my local MySQL database,
it brings the system practically to a halt. It is probably not PHP-
related, but does anyone recognize the problem?

Jim
Jul 17 '05 #2

P: n/a
In message <OQ*****************@newssvr27.news.prodigy.com> , JimC
<ji**@cross-comp.com> writes

"JimC" <ji**@cross-comp.com> wrote in message
news:8d****************@newssvr27.news.prodigy.co m...
I have PHP installed on a Windows XP platform using IIS as
server. When updating a MySQL database field set to MEDIUMTEXT
in phpMyAdmin, the transaction seems to fail if the text contains
more than a few hundred characters.

The update is actually made successfully, but afterwards, the server
cannot locate the phpMyAdmin page as requested by the client
browser. I get a "Page cannot be found" error. Clicking
on Update from the browser clears the problem.

Anyone know what's causing the problem? Potential sources
of the problem could be with the driver for MySQL, with the IIS
settings, or with the phpMyAdmin settings. I suspect IIS.


Still having problems with this. As I update my local MySQL database,
it brings the system practically to a halt. It is probably not PHP-
related, but does anyone recognize the problem?


What happens if you run the same SQL directly? I bet it freezes then as
well, and if it does this suggests there is a problem in MySQL not
anywhere else.

--
Five Cats
Email to: cats_spam at uk2 dot net
Jul 17 '05 #3

P: n/a

"Five Cats" <ca*******@[127.0.0.1]> wrote in message
news:KW**************@[127.0.0.1]...
In message <OQ*****************@newssvr27.news.prodigy.com> , JimC
<ji**@cross-comp.com> writes

"JimC" <ji**@cross-comp.com> wrote in message
news:8d****************@newssvr27.news.prodigy.co m...
I have PHP installed on a Windows XP platform using IIS as
server. When updating a MySQL database field set to MEDIUMTEXT
in phpMyAdmin, the transaction seems to fail if the text contains
more than a few hundred characters.

The update is actually made successfully, but afterwards, the server
cannot locate the phpMyAdmin page as requested by the client
browser. I get a "Page cannot be found" error. Clicking
on Update from the browser clears the problem.

Anyone know what's causing the problem? Potential sources
of the problem could be with the driver for MySQL, with the IIS
settings, or with the phpMyAdmin settings. I suspect IIS.


Still having problems with this. As I update my local MySQL database,
it brings the system practically to a halt. It is probably not PHP-
related, but does anyone recognize the problem?


What happens if you run the same SQL directly? I bet it freezes then as
well, and if it does this suggests there is a problem in MySQL not
anywhere else.


Let me clarify. I can read and write from a MySQL database in normal
time using PHP calls in my own program , and a benchmark test I run now
and then performs as expected. I could beat it down further by using
C language calls. I've played this game before.

But updating through phpMyAdmin to a page served by IIS is what runs
slowly. It almost hangs on a single transaction, which is bizarre since
it's going through the same driver that my PHP applcation script uses.
Of course it's not exactly the same, i.e., the phpMyAdmin doesn't operate in
exactly the same environment as my PHP application. But I sort of
suspect that's where the problem lies.

--
Anyway, if anyone has nothing else to do, take the California quiz, another
PHP app, at http://cross-comp.com/pages/webdesig.../califquiz.php

Jim



Jul 17 '05 #4

P: n/a
In message <bE*******************@newssvr25.news.prodigy.com> , JimC
<ji**@cross-comp.com> writes
<snip>
Let me clarify. I can read and write from a MySQL database in normal
time using PHP calls in my own program , and a benchmark test I run now
and then performs as expected. I could beat it down further by using
C language calls. I've played this game before.

But updating through phpMyAdmin to a page served by IIS is what runs
slowly. It almost hangs on a single transaction, which is bizarre since
it's going through the same driver that my PHP applcation script uses.
Of course it's not exactly the same, i.e., the phpMyAdmin doesn't operate in
exactly the same environment as my PHP application. But I sort of
suspect that's where the problem lies.


I had something similar to this using PHPMyAdmin with Netscape. With IE
there was no problem.

However I doubt this is the cause of your problem!
--
Five Cats
Email to: cats_spam at uk2 dot net
Jul 17 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.