Prob in phpMyAdmin on IIS installation on Windows XP

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • JimC
    #1

    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





    Tags: None
    • JimC
      #2
      Re: Prob in phpMyAdmin on IIS installation on Windows XP


      "JimC" <jimc@cross-comp.com> wrote in message
      news:8d10c.3933 $ko4.472@newssv r27.news.prodig y.com...[color=blue]
      > 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.[/color]

      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


        Comment

        • Five Cats
          #3
          Re: Prob in phpMyAdmin on IIS installation on Windows XP

          In message <OQq0c.4359$_Y1 .3335@newssvr27 .news.prodigy.c om>, JimC
          <jimc@cross-comp.com> writes[color=blue]
          >
          >"JimC" <jimc@cross-comp.com> wrote in message
          >news:8d10c.393 3$ko4.472@newss vr27.news.prodi gy.com...[color=green]
          >> 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.[/color]
          >
          >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?[/color]

          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

            Comment

            • JimC
              #4
              Re: Prob in phpMyAdmin on IIS installation on Windows XP


              "Five Cats" <cats_spam@[127.0.0.1]> wrote in message
              news:KWjqCXAQmk QAFw7E@[127.0.0.1]...[color=blue]
              > In message <OQq0c.4359$_Y1 .3335@newssvr27 .news.prodigy.c om>, JimC
              > <jimc@cross-comp.com> writes[color=green]
              > >
              > >"JimC" <jimc@cross-comp.com> wrote in message
              > >news:8d10c.393 3$ko4.472@newss vr27.news.prodi gy.com...[color=darkred]
              > >> 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.[/color]
              > >
              > >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?[/color]
              >
              > 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.[/color]

              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









                Comment

                • Five Cats
                  #5
                  Re: Prob in phpMyAdmin on IIS installation on Windows XP

                  In message <bEt0c.31963$_r 3.25547@newssvr 25.news.prodigy .com>, JimC
                  <jimc@cross-comp.com> writes[color=blue]
                  >[/color]
                  <snip>[color=blue]
                  >
                  >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.
                  >[/color]

                  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

                    Comment

                    Previous template Next
                    Working...