473,327 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Prob in phpMyAdmin on IIS installation on Windows XP

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
4 2843

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

"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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Pierre Jelenc | last post by:
I have installed Apache, PHP, and MySQL running locally, on localhost. I now am trying to install phpMyAdmin, but I'm running into a problem: when I run http://localhost/phpMyAdmin/index.php (with...
1
by: Richard White | last post by:
Hi, I've got a localhost (ie. my PC) installation of Apache MySQL WinXP-Pro and I'm trying to get the MySQL administration program {phpMyAdmin} to run.
7
by: SCS | last post by:
Running PHP 4.5.7 PHPMyAdmin 2.5.7-pl1 IIS 6 I am thrying to get phpmyadmin to work, but whenever I click a link or try to browse a database I get a 404 error, because the PmaAbsoluteUri...
2
by: J | last post by:
hi, I'm having a problem installing a service created in vb.net 2003 on a windows 2000 server. I have installed the service on a few XP machines with out any problems...but the 2 servers (win...
5
by: NewbieSupreme | last post by:
I installed Apache 2.0.58, tested it, got the "working" page. Installed MySQL 5.0.22, and didn't really see how to test that, but there is a mysql process running in the task manager. Ran through...
2
by: Marcus | last post by:
Hello, I am trying to install phpMyAdmin 2.8.2 and have a question about config.inc.php. Is it necessary to include all of the $cfg fields in config.default.php, or is it ok to just have...
3
by: Susanne | last post by:
I have a server with my own domain and have created some users under htdocs/users/. I have installed phpMyAdmin under htdocs/. Everything works, but I can't open phpMyAdmin. I have made an alias in...
2
by: miraan | last post by:
Hi, I have just installed Apache, PHP5, and WinMySQLAdmin 1.4 on brand new Windows XP, I have configured everything properly (I followed instructions from a book, so I know everything is right), I...
3
by: robin1983 | last post by:
Dear All, I have problem in phpmyadmin (WAMP). I already worked in phpmyadmin, then I installed Mysql 5.1 in my system. After installation of mysql, separately, its not allowing to access the...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.