Professional Web Applications Themes

Problem after an upgrade to php 5.0.1 and Apache 1.3.31 - PHP Development

Hello, I have upgraded, on linux redhat 8, to Apache 1.3.31 and PHP 5.0.1. I think all was good but, POST method on Form did not work, and create of mysql db wouldn't work ( with mysql_create_db() I have the error "Call to undefined function : mysql_create_db()"). I think I have doing something wrong when I was installing PHP, so I have rebuild it with a minimal configuration (just mysql, apxs, and config-file-path ). Nothing appens ... same problem as above. I decided to go back to my old PHP (4.3.2) and Apache (1.3.29) ... always same problem (and I've ...

  1. #1

    Default Problem after an upgrade to php 5.0.1 and Apache 1.3.31

    Hello,

    I have upgraded, on linux redhat 8, to Apache 1.3.31 and PHP 5.0.1.
    I think all was good but, POST method on Form did not work, and create of
    mysql db wouldn't work ( with mysql_create_db() I have the error "Call to
    undefined function : mysql_create_db()").

    I think I have doing something wrong when I was installing PHP, so I have
    rebuild it with a minimal configuration (just mysql, apxs, and
    config-file-path ).
    Nothing appens ... same problem as above.

    I decided to go back to my old PHP (4.3.2) and Apache (1.3.29) ... always
    same problem (and I've tested with all my config option or just basic config
    option).

    I need to use mysql_create_db() (yes I know it's depreciated), and of course
    I need to use the post method in my form.

    I've try to not specify my mysql dir when I do "./configure --with-mysql",
    but I need to specify on configure of PHP where mysql is ( so I use
    ../configure --with-mysql=/opt/mysql ).

    All other query between php and mysql seem to work fine ( and PHPMyAdmin
    works fine ! ).

    Anyone have an idea ? I fond nothing on google ...

    Please, need help ... really !


    NothingHere Guest

  2. #2

    Default Re: Problem after an upgrade to php 5.0.1 and Apache 1.3.31


    "NothingHere" <nothing_hhotmail.com> schreef in bericht
    news:ci4lli$ff8$1news-reader3.wanadoo.fr...
    > Hello,
    >
    > I have upgraded, on linux redhat 8, to Apache 1.3.31 and PHP 5.0.1.
    > I think all was good but, POST method on Form did not work, and create of
    > mysql db wouldn't work ( with mysql_create_db() I have the error "Call to
    > undefined function : mysql_create_db()").
    >
    > I think I have doing something wrong when I was installing PHP, so I have
    > rebuild it with a minimal configuration (just mysql, apxs, and
    > config-file-path ).
    > Nothing appens ... same problem as above.
    >
    > I decided to go back to my old PHP (4.3.2) and Apache (1.3.29) ... always
    > same problem (and I've tested with all my config option or just basic
    config
    > option).
    >
    > I need to use mysql_create_db() (yes I know it's depreciated), and of
    course
    > I need to use the post method in my form.
    >
    > I've try to not specify my mysql dir when I do "./configure --with-mysql",
    > but I need to specify on configure of PHP where mysql is ( so I use
    > ./configure --with-mysql=/opt/mysql ).
    >
    > All other query between php and mysql seem to work fine ( and PHPMyAdmin
    > works fine ! ).
    So php and mysql are working fine...So the config from apache is ok an
    dphi.ini seems to be fine to...
    > Anyone have an idea ? I fond nothing on google ...
    >
    > Please, need help ... really !
    >
    >
    Try next script:
    <?php
    // you need to replace server, username and paswword with your own data
    $link = mysql_connect("server", "username", "password")
    or exit("Can not make an connection: " . mysql_error());
    if (mysql_create_db("my_db")) {
    print ("Database successfully created\n");
    } else {
    printf ("Error with creation of database: %s\n", mysql_error());
    }
    ?>

    What does the script do? Errors or warnings...

    Polaris.


    Polaris Guest

  3. #3

    Default Re: Problem after an upgrade to php 5.0.1 and Apache 1.3.31


    "Polaris" <ask4polarishotmail.com> a écrit dans le message de
    news:4145e250$0$62352$5fc3050dreader2.news.tiscal i.nl...
    >
    > >
    > Try next script:
    > <?php
    > // you need to replace server, username and paswword with your own
    data
    > $link = mysql_connect("server", "username", "password")
    > or exit("Can not make an connection: " . mysql_error());
    > if (mysql_create_db("my_db")) {
    > print ("Database successfully created\n");
    > } else {
    > printf ("Error with creation of database: %s\n", mysql_error());
    > }
    > ?>
    >
    > What does the script do? Errors or warnings...
    >
    > Polaris.
    I found, for the first problem, that register_global where Off, not On
    (sorry that was a stupid mistake ;) ) but now it's work !

    --

    For the problem of "mysql_create_db()" I've try your script, and replace
    username & password with root ones.
    Thats what I have :
    Fatal error: Call to undefined function mysql_create_db() in
    /var/www/polaristest.php on line 5

    Thats help you on something ? ... not me ... :(


    Thanks for help ...

    - Nothing


    NothingHere Guest

  4. #4

    Default Re: Problem after an upgrade to php 5.0.1 and Apache 1.3.31


    "NothingHere" <nothing_hhotmail.com> schreef in bericht
    news:ci56oo$rfg$1news-reader5.wanadoo.fr...
    >
    > "Polaris" <ask4polarishotmail.com> a écrit dans le message de
    > news:4145e250$0$62352$5fc3050dreader2.news.tiscal i.nl...
    > >
    > > >
    > > Try next script:
    > > <?php
    > > // you need to replace server, username and paswword with your own
    > data
    > > $link = mysql_connect("server", "username", "password")
    > > or exit("Can not make an connection: " . mysql_error());
    > > if (mysql_create_db("my_db")) {
    > > print ("Database successfully created\n");
    > > } else {
    > > printf ("Error with creation of database: %s\n", mysql_error());
    > > }
    > > ?>
    > >
    > > What does the script do? Errors or warnings...
    > >
    > > Polaris.
    >
    > I found, for the first problem, that register_global where Off, not On
    > (sorry that was a stupid mistake ;) ) but now it's work !
    >
    > --
    >
    > For the problem of "mysql_create_db()" I've try your script, and replace
    > username & password with root ones.
    > Thats what I have :
    > Fatal error: Call to undefined function mysql_create_db() in
    > /var/www/polaristest.php on line 5
    >
    > Thats help you on something ? ... not me ... :(
    >
    >
    > Thanks for help ...
    >
    > - Nothing
    >
    >
    replace this line: if (mysql_create_db("my_db")) {
    with: if (mysql_query("CREATE DATABASE my_db")) {

    What does it do now? Errors /warnings...
    I'm not giving up so fast ;-)


    Polaris Guest

  5. #5

    Default Re: Problem after an upgrade to php 5.0.1 and Apache 1.3.31

    On Tue, 14 Sep 2004 00:25:35 +0200, NothingHere wrote:
    > I found, for the first problem, that register_global where Off, not On
    > (sorry that was a stupid mistake ;) ) but now it's work !
    register_global is dangerous as it could overwrite any variables used by
    your script! remember that register_globals creates variables for _all_
    parameters passed in, not just the ones you were expecting.
    > For the problem of "mysql_create_db()" I've try your script, and replace
    > username & password with root ones.
    > Thats what I have :
    > Fatal error: Call to undefined function mysql_create_db() in
    > /var/www/polaristest.php on line 5
    >
    > Thats help you on something ? ... not me ... :(
    It tells me that PHP 5 does not include MySQL support by default (some
    licensing issue). You need to recompile, telling configure where your
    MySQL install root is:
    configure --with-mysql=/usr

    HTH,
    La'ie Techie

    Lāʻie Techie Guest

  6. #6

    Default Re: Problem after an upgrade to php 5.0.1 and Apache 1.3.31


    "Polaris" <ask4polarishotmail.com> a écrit dans le message de
    news:41462145$0$62374$5fc3050dreader2.news.tiscal i.nl...
    > >
    > replace this line: if (mysql_create_db("my_db")) {
    > with: if (mysql_query("CREATE DATABASE my_db")) {
    >
    > What does it do now? Errors /warnings...
    > I'm not giving up so fast ;-)
    >
    >
    That's works ... I have that :
    " Database successfully created "
    And I check in phpmyadmin : "my_db" exist ...

    I don't want to change all my script with this line ... so, how can I get
    mysql_create_db to works ?
    It's stop working since I have upgraded to php 5.0.1 ... before with php
    4.3.2 it's works fine ...

    .... Thanks for help ;)


    NothingHere Guest

  7. #7

    Default Re: Problem after an upgrade to php 5.0.1 and Apache 1.3.31


    "La?ie Techie" <laiewin_remove_get_nospam_solutions.com> a écrit dans le
    message de news:1095139809.xoBANyWg+FPZCtRVpTgK3Ateranews...
    > On Tue, 14 Sep 2004 00:25:35 +0200, NothingHere wrote:
    >
    > > I found, for the first problem, that register_global where Off, not On
    > > (sorry that was a stupid mistake ;) ) but now it's work !
    >
    > register_global is dangerous as it could overwrite any variables used by
    > your script! remember that register_globals creates variables for _all_
    > parameters passed in, not just the ones you were expecting.
    >
    Thanks, I would check that ...
    > > For the problem of "mysql_create_db()" I've try your script, and replace
    > > username & password with root ones.
    > > Thats what I have :
    > > Fatal error: Call to undefined function mysql_create_db() in
    > > /var/www/polaristest.php on line 5
    > >
    > > Thats help you on something ? ... not me ... :(
    >
    > It tells me that PHP 5 does not include MySQL support by default (some
    > licensing issue). You need to recompile, telling configure where your
    > MySQL install root is:
    > configure --with-mysql=/usr
    >
    > HTH,
    > La'ie Techie
    >
    Here is my configure options I've used :
    './configure' '--with-apxs=/opt/apache/bin/apxs' '--with-mysql=/opt/mysql'
    '--with-config-file-path=/etc'
    As you can see, it's compiled with mysql.
    Another think :
    There is no "mysql.so" on my computer, and I installed php & apache from
    source, not from rpm.
    PHP 4.3.2 works fine with "mysql_create_db", and I see there is no line in
    php.ini 4.3.2 about mysql.so , so I think I don't need it ...
    "mysql_create_db" don't work since I've upgraded from PHP 4.3.2 to PHP 5.0.1
    ....

    Hopes since you know that you can help me ... ;)
    Thanks for all ...

    - Nothing



    NothingHere Guest

  8. #8

    Default Re: Problem after an upgrade to php 5.0.1 and Apache 1.3.31


    I notice here [url]http://www.php.net/mysql_create_db[/url] that there is a
    warning:

    "This function will not be available if the MySQL extension was built
    against a MySQL 4.x client library."
    Does that apply to you?

    ---
    Steve

    Steve Guest

Similar Threads

  1. mx 7 upgrade problem with cfx tag
    By bwdutton in forum Coldfusion Server Administration
    Replies: 0
    Last Post: May 17th, 06:05 PM
  2. Problem with CF 7 Upgrade
    By ChuckBoulineau in forum Coldfusion Server Administration
    Replies: 4
    Last Post: May 17th, 02:23 PM
  3. Replies: 2
    Last Post: July 27th, 05:29 PM
  4. [PHP] PHP Upgrade Problem
    By Tassos T in forum PHP Development
    Replies: 0
    Last Post: July 25th, 07:12 AM
  5. Replies: 2
    Last Post: July 17th, 07:27 AM

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