Announcement

Collapse
No announcement yet.

Db error on install

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Db error on install

    Ive received this error.. i know its my fault..something i didnt do right..but any ideas?

    Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\Program Files\Apache Group\Apache2\htdocs\includes\db_mysql.php on line 333

    Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\Program Files\Apache Group\Apache2\htdocs\includes\db_mysql.php on line 334

  • #2
    newbie with same problem

    hi,

    while trying to upgrade from 2.3.2, i got this running the upgrade scipt:
    Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /data/members/free/tripod/nl/v/v/t/vvttestforum/htdocs/forum/includes/db_mysql.php on line 333

    Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /data/members/free/tripod/nl/v/v/t/vvttestforum/htdocs/forum/includes/db_mysql.php on line 334

    Echec ! Errors :
    Error checking Quota:
    Error initializing quota:
    Checking mail quota:

    I suppose it is the same problem?

    kind regards

    ps:
    phpinfo results

    PHP4u Version 3.0
    Based on PHP-4.3.2


    And now for something completely different ... Yeah, ladies and gents, it works now !! ;o)

    System Debian GNU/Linux - Bi PIII 1Ghz - 1 Gb RAM - Kernel 2.4.x
    Build Date Jun 30 2003 14:16:33
    Configure Command './configure' '--with-jpeg-dir=/usr' '--with-png-dir=/usr' '--with-zlib=/usr' '--with-bz2=/usr' '--with-tiff-dir=/usr' '--with-zip=/usr/local' '--with-gd=/usr' '--with-ttf=/usr/include/freetype2/freetype' '--with-freetype-dir=/usr' '--with-mhash=/usr/local/' '--with-dom=/usr' '--with-ming=/usr' '--without-pear' '--enable-gd-native-ttf' '--enable-calendar' '--enable-bcmath' '--enable-safe-mode' '--enable-memory-limit' '--enable-trans-sid' '--disable-posix' '--disable-sockets' '--with-mysql=/usr/' '--enable-force-cgi-redirect' '--with-clibpdf' '--with-gettext' '--with-mcrypt=/usr/' '--with-mcal-dir=/usr/' '--enable-mbstring' '--enable-mbregex' '--with-iconv'
    Server API CGI
    Registered PHP Streams php, http, ftp, compress.bzip2, compress.zlib

    This program makes use of the Zend Scripting Language Engine:
    Zend Engine v1.3.0, Copyright (c) 1998-2003 Zend Technologies with Zend Optimizer v2.1.0, Copyright (c) 1998-2003, by Zend Technologies


    PHP Credits

    Configuration
    PHP Core
    Directive Local Value Master Value
    allow_call_time_pass_reference On On
    allow_url_fopen Off Off
    always_populate_raw_post_data Off Off
    arg_separator.input & &
    arg_separator.output & &
    asp_tags Off Off
    auto_append_file /data/apache/php/mmp_lib/append.php /data/apache/php/mmp_lib/append.php
    auto_prepend_file /data/apache/php/mmp_lib/prepend.php /data/apache/php/mmp_lib/prepend.php
    browscap no value no value
    default_charset no value no value
    default_mimetype text/html text/html
    define_syslog_variables Off Off
    disable_classes no value no value
    disable_functions highlight_file,diskfreespace, exec, passthru, system, popen, fsockopen, pfsockpen, show_source, php_uname, ini_get, ini_alter, ini_restore, ini_set, getrusage, mysql_list_dbs, get_current_user, set_time_limit, getmyuid, getmypid, dl, leak, listen, chown, chmod, chgrp, realpath, tmpfile, link highlight_file,diskfreespace, exec, passthru, system, popen, fsockopen, pfsockpen, show_source, php_uname, ini_get, ini_alter, ini_restore, ini_set, getrusage, mysql_list_dbs, get_current_user, set_time_limit, getmyuid, getmypid, dl, leak, listen, chown, chmod, chgrp, realpath, tmpfile, link
    display_errors On On
    display_startup_errors On On
    doc_root no value no value
    docref_ext no value no value
    docref_root no value no value
    enable_dl Off Off
    error_append_string no value no value
    error_log no value no value
    error_prepend_string no value no value
    error_reporting 2037 2037
    expose_php On On
    extension_dir ./ ./
    file_uploads On On
    gpc_order GPC GPC
    highlight.bg #FFFFFF #FFFFFF
    highlight.comment #FF8000 #FF8000
    highlight.default #0000BB #0000BB
    highlight.html #000000 #000000
    highlight.keyword #007700 #007700
    highlight.string #DD0000 #DD0000
    html_errors On On
    ignore_repeated_errors Off Off
    ignore_repeated_source Off Off
    ignore_user_abort Off Off
    implicit_flush Off Off
    include_path .:/data/apache/php/mmp_lib .:/data/apache/php/mmp_lib
    log_errors Off Off
    log_errors_max_len 1024 1024
    magic_quotes_gpc On On
    magic_quotes_runtime Off Off
    magic_quotes_sybase Off Off
    max_execution_time 10 10
    max_input_time -1 -1
    memory_limit 8388608 8388608
    open_basedir no value no value
    output_buffering no value no value
    output_handler no value no value
    post_max_size 512000 512000
    precision 14 14
    register_argc_argv On On
    register_globals On On
    report_memleaks On On
    safe_mode On On
    safe_mode_exec_dir /data/apache/php/safe_exec /data/apache/php/safe_exec
    safe_mode_gid Off Off
    safe_mode_include_dir /data/apache/php/mmp_lib /data/apache/php/mmp_lib
    sendmail_from no value no value
    sendmail_path /usr/sbin/sendmail /usr/sbin/sendmail
    serialize_precision 100 100
    short_open_tag On On
    SMTP localhost localhost
    smtp_port 25 25
    sql.safe_mode Off Off
    track_errors Off Off
    unserialize_callback_func no value no value
    upload_max_filesize 200000 200000
    upload_tmp_dir /tmp /tmp
    user_dir no value no value
    variables_order EGPCS EGPCS
    xmlrpc_error_number 0 0
    xmlrpc_errors Off Off
    y2k_compliance Off Off

    Zend Optimizer
    Optimization Pass 1 enabled
    Optimization Pass 2 enabled
    Optimization Pass 3 enabled
    Optimization Pass 9 disabled
    Optimization Pass 10 disabled
    Zend Loader enabled
    License Path no value

    bcmath
    BCMath support enabled

    bz2
    BZip2 Support Enabled
    BZip2 Version 1.0.2, 30-Dec-2001

    calendar
    Calendar support enabled

    ctype
    ctype functions enabled

    domxml
    DOM/XML enabled
    DOM/XML API Version 20020815
    libxml Version 20424
    HTML Support enabled
    XPath Support enabled
    XPointer Support enabled

    gd
    GD Support enabled
    GD Version 2.0 or higher
    FreeType Support enabled
    FreeType Linkage with freetype
    JPG Support enabled
    PNG Support enabled
    WBMP Support enabled

    gettext
    GetText Support enabled

    iconv
    iconv support enabled
    iconv implementation glibc
    iconv library version 2.2.5

    Directive Local Value Master Value
    iconv.input_encoding ISO-8859-1 ISO-8859-1
    iconv.internal_encoding ISO-8859-1 ISO-8859-1
    iconv.output_encoding ISO-8859-1 ISO-8859-1

    mbstring
    Multibyte Support enabled
    Japanese support enabled
    Multibyte (japanese) regex support enabled

    mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

    Directive Local Value Master Value
    mbstring.detect_order no value no value
    mbstring.encoding_translation Off Off
    mbstring.func_overload 0 0
    mbstring.http_input pass pass
    mbstring.http_output pass pass
    mbstring.internal_encoding none none
    mbstring.language neutral neutral
    mbstring.substitute_character no value no value

    mcrypt
    mcrypt support enabled
    version >= 2.4.x
    Supported ciphers cast-128 cast-128 gost gost rijndael-128 rijndael-128 twofish twofish arcfour arcfour cast-256 cast-256 loki97 loki97 rijndael-192 rijndael-192 saferplus saferplus wake wake blowfish-compat blowfish-compat des des panama panama rijndael-256 rijndael-256 serpent serpent xtea xtea blowfish blowfish enigma enigma rc2 rc2 tripledes tripledes
    Supported modes cbc cfb ctr ecb ncfb nofb ofb stream

    Directive Local Value Master Value
    mcrypt.algorithms_dir no value no value
    mcrypt.modes_dir no value no value

    mhash
    MHASH support Enabled
    MHASH API Version 20020524

    ming
    Ming SWF output library enabled
    Version 0.3a

    mysql
    MySQL Support enabled
    Active Persistent Links 0
    Active Links 0
    Client API version 3.23.52
    MYSQL_MODULE_TYPE external
    MYSQL_SOCKET /var/run/mysqld/mysqld.sock
    MYSQL_INCLUDE -I/usr//include/mysql
    MYSQL_LIBS -L/usr//lib -lmysqlclient

    Directive Local Value Master Value
    mysql.allow_persistent Off Off
    mysql.connect_timeout -1 -1
    mysql.default_host no value no value
    mysql.default_password no value no value
    mysql.default_port no value no value
    mysql.default_socket no value no value
    mysql.default_user no value no value
    mysql.max_links 3 3
    mysql.max_persistent 0 0
    mysql.trace_mode Off Off

    overload
    User-Space Object Overloading Support enabled

    pcre
    PCRE (Perl Compatible Regular Expressions) Support enabled
    PCRE Library Version 3.92 11-Sep-2002

    session
    Session Support enabled
    Registered save handlers files user

    Directive Local Value Master Value
    session.auto_start Off Off
    session.bug_compat_42 On On
    session.bug_compat_warn On On
    session.cache_expire 180 180
    session.cache_limiter nocache nocache
    session.cookie_domain no value no value
    session.cookie_lifetime 3600 3600
    session.cookie_path no value no value
    session.cookie_secure Off Off
    session.entropy_file /dev/urandom /dev/urandom
    session.entropy_length 16 16
    session.gc_divisor 100 100
    session.gc_maxlifetime 1200 1200
    session.gc_probability 0 0
    session.name PHPSESSID PHPSESSID
    session.referer_check no value no value
    session.save_handler files files
    session.save_path /data/session /data/session
    session.serialize_handler php php
    session.use_cookies On On
    session.use_only_cookies Off Off
    session.use_trans_sid Off Off

    standard
    Regex Library Bundled library enabled
    Dynamic Library Support enabled
    Path to sendmail /usr/sbin/sendmail

    Directive Local Value Master Value
    assert.active 1 1
    assert.bail no value no value
    assert.callback 0 0
    assert.quiet_eval 1 1
    assert.warning 1 1
    auto_detect_line_endings 0 0
    default_socket_timeout 60 60
    safe_mode_allowed_env_vars PHP_ PHP_
    safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
    url_rewriter.tags a=href,area=href,frame=src,form=,fieldset= a=href,area=href,frame=src,form=,fieldset=
    user_agent no value no value

    tokenizer
    Tokenizer Support enabled

    xml
    XML Support active
    XML Namespace Support active
    EXPAT Version 1.95.2

    zip
    Zip support enabled

    zlib
    ZLib Support enabled
    Compiled Version 1.1.4
    Linked Version 1.1.4

    Directive Local Value Master Value
    zlib.output_compression Off Off
    zlib.output_compression_level -1 -1
    zlib.output_handler no value no value

    Additional Modules
    Module Name

    PHP License
    This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE
    This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
    If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact [email protected]




    eric delaeter
    Last edited by eric delaeter; Sun 5 Oct '03, 12:44am.

    Comment


    • #3
      I'm having the same types of errors.

      I've tried to delete my database and start over but that has just made things worse as it didn't delete enough to create a new database.

      I'm really stuck now and have tried bith versions 2.3.2 and 3.0.0 b7 and am about to scream as I have just paid £50 for something that I cannot use unless I move web hosts and I've not long ago taken a 12 month pay in advance contract with my host.

      Please please please someone help me.
      Kerry-Anne :)

      Twitter Blog

      www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

      Comment


      • #4
        the connection info your providing is incorrect.

        It can't connect to the MySQL server hence the error.
        Scott MacVicar

        My Blog | Twitter

        Comment


        • #5
          So what can I do about it?

          I'm new to having a forum and don't know very much about the setting up etc of everything.

          I can't afford to move hosts again either
          Kerry-Anne :)

          Twitter Blog

          www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

          Comment


          • #6
            ask your host for help, they will be able to advise you better.

            Every system varies and you may even have to request your host to setup a mysql account for you.

            Unless you have Cpanel / Plesk / Ensim and in that case you can do it yourself.
            Scott MacVicar

            My Blog | Twitter

            Comment


            • #7
              I had a mySQL account for my old IPB board but I killed the board off at weekend so decided to go vB and now I am regretting it.

              I have contacted my host but they take about 3 days to reply from experience.

              I don't know what else to do.
              Kerry-Anne :)

              Twitter Blog

              www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

              Comment


              • #8
                does the database still exist?

                If so just delete all the tables and us the connection data for that.

                Do you have any sort of control panel for hosting?
                Scott MacVicar

                My Blog | Twitter

                Comment


                • #9
                  I've deleted all the tables and data but the base seems to still exist.

                  I have a control panel but don't know what I am doing on it.

                  I tried to install after deleting all the tables and it wont do it.
                  Kerry-Anne :)

                  Twitter Blog

                  www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

                  Comment


                  • #10
                    just take the details you used for IPB and put them in to the vBulletin config.php.

                    This means same
                    username
                    password
                    database name

                    the database will still exist without tables.
                    Scott MacVicar

                    My Blog | Twitter

                    Comment


                    • #11
                      That is what I did to start with though
                      Kerry-Anne :)

                      Twitter Blog

                      www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

                      Comment


                      • #12
                        ok when an error appears, right click on the page and select view source.

                        Then copy the entire message there, it provides more data.
                        Scott MacVicar

                        My Blog | Twitter

                        Comment


                        • #13
                          PHP Code:
                           <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "[url="http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd"]http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd[/url]">
                          <!-- saved from url=(0060)[url]http://www.peterska2.co.uk/forums/install/install.php?step=2[/url] -->
                          <HTML><HEAD><TITLE>vBulletin 3 Install Script Step 2Connect to the database</TITLE>
                          <
                          META http-equiv=Content-Type content="text/html; charset=ISO-8859-1"><LINK 
                          href
                          ="vBulletin 3 Install Script Step 2) Connect to the database_files/controlpanel.css" 
                          rel=stylesheet>
                          <
                          STYLE type=text/css>#all {
                           
                          MARGIN10px
                          }
                          #all P {
                           
                          FONT-SIZE11pxFONT-FAMILYverdanaarialhelveticasans-serif
                          }
                          #all TD {
                           
                          FONT-SIZE11pxFONT-FAMILYverdanaarialhelveticasans-serif
                          }
                          #all LI {
                           
                          FONT-SIZE11pxFONT-FAMILYverdanaarialhelveticasans-serif
                          }
                          #all DIV {
                           
                          FONT-SIZE11pxFONT-FAMILYverdanaarialhelveticasans-serif
                          }
                          </
                          STYLE>

                          <
                          META content="MSHTML 6.00.2800.1226" name=GENERATOR></HEAD>
                          <
                          BODY style="MARGIN: 0px">
                          <
                          TABLE class=navbody 
                          style
                          ="BORDER-RIGHT: 2px outset; BORDER-TOP: 2px outset; BORDER-LEFT: 2px outset; BORDER-BOTTOM: 2px outset" 
                          cellSpacing=0 cellPadding=4 width="100%" border=0>
                            <
                          TBODY>
                            <
                          TR>
                              <
                          TD width=160><IMG title="vBulletin 3 ©2003 Jelsoft Enterprises Ltd." 
                                
                          alt="" src=""></TD>
                              <
                          TD style="PADDING-LEFT: 100px"><B>vBulletin 3 Install 
                                Script
                          </B><BR>(Please be patient as some parts may take some 
                                time
                          )<BR><BR><B style="FONT-SIZE: 10pt">Step 2Connect to the 
                                database
                          </B> (Step 2 of 13)</TD></TR></TBODY></TABLE>
                          <
                          DIV id=all>
                          <
                          P style="FONT-SIZE: 10pt"><B><U>Step 2Connect to the 
                          database
                          </U></B></P><BR><B>Parse error</B>: parse error in 
                          <B>/home/www/peterka2/forums/includes/config.php</Bon line <B>42</B><BR>
                          <
                          P>Attempting to attach to database</P><BR><B>Warning</B>: mysql_error(): 
                          supplied argument is not a valid MySQL-Link resource in 
                          <B>/home/www/peterka2/forums/includes/db_mysql.php</Bon line 
                          <B>333</B><BR><BR><B>Warning</B>: mysql_errno(): supplied argument is not a 
                          valid MySQL
                          -Link resource in 
                          <B>/home/www/peterka2/forums/includes/db_mysql.php</Bon line 
                          <B>334</B><BR><BR><B>Warning</B>: mysql_errno(): supplied argument is not a 
                          valid MySQL
                          -Link resource in 
                          <B>/home/www/peterka2/forums/includes/db_mysql.php</Bon line <B>133</B><BR>
                          <
                          P><FONT color=red size=+1><B>The database has failed to connect because you do 
                          not have permission to connect to the serverPlease confirm the values entered 
                          in the 
                          'includes/config.php' file.</B></FONT></P></DIV>
                          <
                          FORM name=nextStep action=install.php method=get><INPUT type=hidden value=
                          name
                          =step
                          <
                          TABLE class=navbody 
                          style
                          ="BORDER-RIGHT: 2px outset; PADDING-RIGHT: 4px; BORDER-TOP: 2px outset; PADDING-LEFT: 4px; PADDING-BOTTOM: 4px; BORDER-LEFT: 2px outset; PADDING-TOP: 4px; BORDER-BOTTOM: 2px outset" 
                          cellSpacing=0 cellPadding=4 width="100%" border=0>
                            <
                          TBODY>
                            <
                          TR align=middle>
                              <
                          TD>vBulletin ©2000-2003 Jelsoft Enterprises Ltd.</TD>
                              <
                          TD></TD></TR></TBODY></TABLE></FORM>
                          <
                          DIV></DIV><!-- START CONTROL PANEL FOOTER -->
                          <
                          P align=center><class=copyright href="[url="http://www.vbulletin.com/"]http://www.vbulletin.com/[/url]" 
                          target=_blank></A></P>
                          <
                          DIV></DIV></BODY></HTML
                          Kerry-Anne :)

                          Twitter Blog

                          www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

                          Comment


                          • #14
                            ok you have a parse error.

                            Something is wrong in config.php

                            missing quote or semi-colon at the end of a string.

                            If you can't seem to find it mail the config.php to [email protected] and i'll adjust it and mail it back.

                            Though i'll be going offline in about 5 minutes.
                            Scott MacVicar

                            My Blog | Twitter

                            Comment


                            • #15
                              mail sent
                              Kerry-Anne :)

                              Twitter Blog

                              www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...
                              X