Closed Thread
Results 1 to 5 of 5

Thread: MYSQL Error

  1. #1
    Chetz is offline x10Hosting Member Chetz is an unknown quantity at this point
    Join Date
    Nov 2007
    Location
    London, UK
    Posts
    44

    Unhappy MYSQL Error

    Hi,

    I have a phpBB2 site. It was all alright until the changeover and other things. (I'm on absolut).

    www.chetz92.co.uk

    Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/chetz/public_html/phpBB2/db/mysql4.php on line 330

    Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/chetz/public_html/phpBB2/db/mysql4.php on line 331
    phpBB : Critical Error

    Could not connect to the database
    This is my config file:
    <?php


    // phpBB 2.x auto-generated config file
    // Do not change anything in this file!

    $dbms = 'mysql4';

    $dbhost = 'localhost';
    $dbname = 'chetz_current';
    $dbuser = 'chetz_chetz';
    $dbpasswd = 'PASSWORD';

    $table_prefix = 'phpbb_';

    define('PHPBB_INSTALLED', true);

    ?>
    I've tried it with my backup of the database, but still the same.
    Can someone help me?
    Chetz

    Chetz92.co.uk - Flash Games Arcade

  2. #2
    TechAsh's Avatar
    TechAsh is offline Retired TechAsh is an unknown quantity at this point
    Join Date
    Oct 2007
    Location
    UK
    Posts
    5,853

    Re: MYSQL Error

    I think this bit is causing the error:
    $dbms = 'mysql4';
    The MySQL version is '5.0.45-community'.

    I would recommend upgrading to phpBB3 anyway, but if you like version 2, there may be a way to fix it. I'm not sure what you will have to change $dbms to (Maybe another user can help here), but you could try this
    $dbms = 'mysql';
    That might work (It's worth a try.)
    Useful Links:
    Terms of Service | Server News | Buy a Domain
    Free Domains: co.cc | Dot.tk -- Free File Storage: Dropbox -- Website Monitoring: Service Uptime


    My Websites:
    Earthtime Games & TechAsh's Blog

  3. #3
    Chetz is offline x10Hosting Member Chetz is an unknown quantity at this point
    Join Date
    Nov 2007
    Location
    London, UK
    Posts
    44

    Re: MYSQL Error

    Thanks TechAsh, but it doesn't seem to work.

    I've tried changing that to a number of things, but I just get a basic 'phpBB : Critical Error
    Could not connect to the database' error.

    It must be with the server or my account.
    Chetz

    Chetz92.co.uk - Flash Games Arcade

  4. #4
    Russ's Avatar
    Russ is offline Retired ***** Russ is an unknown quantity at this point
    Join Date
    Sep 2007
    Posts
    3,162

    Re: MYSQL Error

    Go into your file manager, and use code editor on /home/chetz/public_html/phpBB2/db/mysql4.php and go to line 330,331 and paste them in.. Also I am moving this to a script support forum.
    x10 Chat is now available! Live Support!

    DO NOT PRIVATE MESSAGE STAFF - WE ARE BUSY

  5. #5
    Chetz is offline x10Hosting Member Chetz is an unknown quantity at this point
    Join Date
    Nov 2007
    Location
    London, UK
    Posts
    44

    Re: MYSQL Error

    Solved on IRC with chougard

    Thanks guys
    Chetz

    Chetz92.co.uk - Flash Games Arcade

Closed Thread

Similar Threads

  1. MySql Database error on Cossacks
    By Shovon in forum Free Hosting
    Replies: 0
    Last Post: 01-24-2008, 03:14 AM
  2. Replies: 5
    Last Post: 12-29-2007, 03:25 AM
  3. MYSQL error
    By slayer2746 in forum Free Hosting
    Replies: 3
    Last Post: 12-07-2007, 01:02 PM
  4. mySQL error: Too many Connection
    By mumbhaki in forum Scripts & 3rd Party Apps
    Replies: 3
    Last Post: 11-22-2007, 02:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers