473,729 Members | 2,177 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 2876

"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
4450
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, but they all show up empty (with or without javascript active). Where did I go wrong? Where do I...
1
2994
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
6449
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
1613
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 is not) An exception occurred during the Install phase. System.ComponentModel.Win32Exception:...
5
3370
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 installed (really just unzipped and placed some files according to the directions) PHPMyAdmin; did...
2
1676
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 field in config.default.php in my actual config.inc.php and whether or not the program will know to...
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 MultiViews AllowOverride None Order allow,deny
2
2923
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. I have downloaded the ZIP file for the english installation off the official website and extracted...
3
4007
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 advance. With Regards, Robindra Singha New Delhi - 65 India
0
8913
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8761
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9426
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9200
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8144
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6722
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4525
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4795
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2677
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.