473,583 Members | 2,905 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2868

"JimC" <ji**@cross-comp.com> wrote in message
news:8d******** ********@newssv r27.news.prodig y.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.c om>, JimC
<ji**@cross-comp.com> writes

"JimC" <ji**@cross-comp.com> wrote in message
news:8d******* *********@newss vr27.news.prodi gy.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?


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.c om>, JimC
<ji**@cross-comp.com> writes

"JimC" <ji**@cross-comp.com> wrote in message
news:8d******* *********@newss vr27.news.prodi gy.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?


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************ *******@newssvr 25.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
4431
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 "root", no password at this time) after customizing config.inc.php, I get a blank page. The source code shows that the expected frames are there,...
1
2982
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
6439
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 auto-detection is nor working properly. Im pretty sure it is a problem with my php.ini file, but Im not sure where to look... can someone please help
2
1602
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 2000 server sp4) I have triend have the same error (both are on diffrent domains and have framework v1.1 installed; 1 is a domain controler, the other...
5
3361
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 the PHP 5.1.4 installation directions, and that seems to work, since I can use phpinfo() and get all the information on a test php page. Then I...
2
1669
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 whichever fields I explicitly need customized, such as $cfg? I am not clear on whether there are any security risks by not explicitly stating every...
3
471
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 httpd.conf: Alias /phpMyAdmin/ "C:/Program/Apache2/htdocs/phpMyAdmin/" <Directory "C:/Program/Apache2/htdocs/phpMyAdmin"> Options Indexes...
2
2913
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 have tested a php file on localhost and it works fine, but now, I want to install phpmyadmin on my computer so I can easily play with databases, etc....
3
3996
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 phpmyadmin showing error message. kindly help me to to access the database and table that i created through wamp not through Mysql. Thank you in...
0
7811
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8159
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8314
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8185
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5689
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5366
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3811
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3836
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1416
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.