Professional Web Applications Themes

#12029 [Com]: "--with-apxs" can cause the error "MySQL: Unable to save result set in" - PHP Development

ID: 12029 Comment by: sietzepost at streetwisedd dot nl Reported By: root at byone dot com Status: Bogus Bug Type: MySQL related Operating System: Linux PHP Version: 4.0.6 and 4.1.0RC3 New Comment: I have the same problem. The strange thing is, I have PHP Version 4.3.3, compiled by gentoo portage. It worked fone for a couple of days, and now, out of the blue, is generates these same errors. I have plenty of dispace however, and have had plenty all the time. Does anyone have another solution? Previous Comments: ------------------------------------------------------------------------ [2003-04-01 03:24:30] nick at nickjoyce dot com I had the ...

  1. #1

    Default #12029 [Com]: "--with-apxs" can cause the error "MySQL: Unable to save result set in"

    ID: 12029
    Comment by: sietzepost at streetwisedd dot nl
    Reported By: root at byone dot com
    Status: Bogus
    Bug Type: MySQL related
    Operating System: Linux
    PHP Version: 4.0.6 and 4.1.0RC3
    New Comment:

    I have the same problem. The strange thing is, I have PHP Version
    4.3.3, compiled by gentoo portage. It worked fone for a couple of days,
    and now, out of the blue, is generates these same errors. I have plenty
    of dispace however, and have had plenty all the time. Does anyone have
    another solution?


    Previous Comments:
    ------------------------------------------------------------------------

    [2003-04-01 03:24:30] nick at nickjoyce dot com

    I had the same problem but found that mysql did not have enough disk
    space to alter its files. Altering the quota fixed the problem.

    ------------------------------------------------------------------------

    [2002-07-09 10:24:03] levi at tamisoft dot com

    I found the same problem with:
    mysql 3.23.51
    php 4.1.2 later 4.2.1
    roxen

    I found a possible way to resolv it.
    Use like this:

    $query="INSERT INTO test.test SET str=\"a test\"";
    mysql_query($query);
    if (mysql_error()) {echo "Some error occured!";exit();}

    And this way you won't get the warning.
    The only thing is that you cannot use the returned value itself
    directly, you have to use mysql_error() to see if everything went ok.

    PLZ let me know if it's not ok. It is working for me fine.

    ------------------------------------------------------------------------

    [2002-01-23 10:48:20] [email]mrobinsophp.net[/email]

    Apache is installed with mod_log_mysql and mod_auth-mysql,
    and php is installed with the built-in clients.

    [url]http://www.php.net/manual/en/faq.databases.php#AEN73271[/url]

    Please reopen with a url to a phpinfo() call if problem
    persists.

    ------------------------------------------------------------------------

    [2002-01-23 09:29:40] [email]mrobinsophp.net[/email]

    [email]ramieduix.com[/email], can you post a page with phpinfo() on
    it somewhere so I can have a look please.

    I've never had any problems with mysql and pgsql
    co-existing with php.

    ------------------------------------------------------------------------

    [2002-01-23 04:48:46] rami at eduix dot com

    I'm pretty sure these unable to save result set are due to pgsql and
    mysql co-existence in self-compiled php. Our service worked well
    without problems for 8 months with only mysql compiled in, but php
    started complaining this immediately when we compiled the pgsql in
    also. So this looks like a true bug allright.

    ------------------------------------------------------------------------

    The remainder of the comments for this report are too long. To view
    the rest of the comments, please view the bug report online at
    [url]http://bugs.php.net/12029[/url]

    --
    Edit this bug report at [url]http://bugs.php.net/?id=12029&edit=1[/url]
    sietzepost at streetwisedd dot nl Guest

  2. #2

    Default #12029 [Com]: "--with-apxs" can cause the error "MySQL: Unable to save result set in"

    ID: 12029
    Comment by: sietzepost at streetwisedd dot nl
    Reported By: root at byone dot com
    Status: Bogus
    Bug Type: MySQL related
    Operating System: Linux
    PHP Version: 4.0.6 and 4.1.0RC3
    New Comment:

    Please read Bug #16906, wich is a follow up. The problem is not
    PHP-related, but a MySQL table/key corruption. Running myisamchk should
    resolve it.


    Previous Comments:
    ------------------------------------------------------------------------

    [2003-10-03 04:27:38] sietzepost at streetwisedd dot nl

    I have the same problem. The strange thing is, I have PHP Version
    4.3.3, compiled by gentoo portage. It worked fone for a couple of days,
    and now, out of the blue, is generates these same errors. I have plenty
    of dispace however, and have had plenty all the time. Does anyone have
    another solution?

    ------------------------------------------------------------------------

    [2003-04-01 03:24:30] nick at nickjoyce dot com

    I had the same problem but found that mysql did not have enough disk
    space to alter its files. Altering the quota fixed the problem.

    ------------------------------------------------------------------------

    [2002-07-09 10:24:03] levi at tamisoft dot com

    I found the same problem with:
    mysql 3.23.51
    php 4.1.2 later 4.2.1
    roxen

    I found a possible way to resolv it.
    Use like this:

    $query="INSERT INTO test.test SET str=\"a test\"";
    mysql_query($query);
    if (mysql_error()) {echo "Some error occured!";exit();}

    And this way you won't get the warning.
    The only thing is that you cannot use the returned value itself
    directly, you have to use mysql_error() to see if everything went ok.

    PLZ let me know if it's not ok. It is working for me fine.

    ------------------------------------------------------------------------

    [2002-01-23 10:48:20] [email]mrobinsophp.net[/email]

    Apache is installed with mod_log_mysql and mod_auth-mysql,
    and php is installed with the built-in clients.

    [url]http://www.php.net/manual/en/faq.databases.php#AEN73271[/url]

    Please reopen with a url to a phpinfo() call if problem
    persists.

    ------------------------------------------------------------------------

    [2002-01-23 09:29:40] [email]mrobinsophp.net[/email]

    [email]ramieduix.com[/email], can you post a page with phpinfo() on
    it somewhere so I can have a look please.

    I've never had any problems with mysql and pgsql
    co-existing with php.

    ------------------------------------------------------------------------

    The remainder of the comments for this report are too long. To view
    the rest of the comments, please view the bug report online at
    [url]http://bugs.php.net/12029[/url]

    --
    Edit this bug report at [url]http://bugs.php.net/?id=12029&edit=1[/url]
    sietzepost at streetwisedd dot nl Guest

Similar Threads

  1. Replies: 1
    Last Post: April 24th, 01:27 PM
  2. #26162 [NEW]: $a="0abcdefg";if ($a==0) echo "OK"; result is "OK" ?!
    By zhuminglun at yahoo dot com dot cn in forum PHP Development
    Replies: 0
    Last Post: November 7th, 12:04 PM
  3. Replies: 0
    Last Post: November 7th, 11:45 AM
  4. #26022 [NEW]: Unable compile "dns.c", unable to link "libphp4.so"
    By dieter at fiebelkorn dot net in forum PHP Development
    Replies: 0
    Last Post: October 28th, 10:21 PM
  5. "save", "selective color" menu go too slow. Please help!
    By bmjun20 in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 1
    Last Post: August 12th, 08:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139