Results 1 to 8 of 8

Thread: mysql 4.1 and my forum

  1. #1
    Member
    Join Date
    Feb 2003
    Posts
    13

    Angry mysql 4.1 and my forum

    after i upgrade mysql to 4.1 my forum not workad i got this error

    There seems to have been a problem with the Forums database.
    Please try again by clicking the Refresh button in your web browser.

    An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

    We apologise for any inconvenience

  2. #2
    Member
    Join Date
    Jan 2004
    Location
    Roswell, GA
    Posts
    363

    Default

    Make sure you have the box checked that says Use old style (4.0) passwords with mySQL 4.1+ in Tweak Settings
    Number1Host.net
    Shared, Reseller, and Dedicated Hosting
    Server Setup, Management, and Security
    The Web's Number 1 Host - Number1Host.net

  3. #3
    Member
    Join Date
    Mar 2006
    Posts
    379

    Default

    does your forum compatible with the MySQL 4.1 due to the query syntax between MySQL 4.0 and MySQL 4.1 ? there are some major changes on the MySQL 4.0 to MySQL 4.1, do you have a backup copy of your database before it is being upgraded?
    Tweakservers | Professional Server Setup & Security Hardening
    Authorised SmarterTools Reseller, SSL Certificate & PRTG Network Monitor

  4. #4
    Member celliott's Avatar
    Join Date
    Jan 2006
    Location
    United Kingdom
    Posts
    460

    Default

    Open up my.cnf and add the following:

    [mysqld]
    old-passwords.

    I found that the old password feature in cPanel didnt work for me. If there appears to be no connectivity, reset the database password and update your forum configuration file.

  5. #5
    Member
    Join Date
    Feb 2003
    Posts
    13

    Default

    Quote Originally Posted by tweakservers
    does your forum compatible with the MySQL 4.1 due to the query syntax between MySQL 4.0 and MySQL 4.1 ? there are some major changes on the MySQL 4.0 to MySQL 4.1, do you have a backup copy of your database before it is being upgraded?
    do i need to copmile apache wit new mysql?
    yes i have back up

  6. #6
    Member
    Join Date
    Feb 2003
    Posts
    13

    Default

    Quote Originally Posted by celliott
    Open up my.cnf and add the following:

    [mysqld]
    old-passwords.

    I found that the old password feature in cPanel didnt work for me. If there appears to be no connectivity, reset the database password and update your forum configuration file.
    when i put
    [mysqld]
    old mysql password

    mysql didn't start

  7. #7
    Member
    Join Date
    Feb 2003
    Posts
    13

    Default

    Quote Originally Posted by cooldude7273
    Make sure you have the box checked that says Use old style (4.0) passwords with mySQL 4.1+ in Tweak Settings
    yes it is checked

  8. #8
    Member casey's Avatar
    Join Date
    Jan 2003
    Location
    If there is trouble, it will find me
    Posts
    2,336

    Default

    Quote Originally Posted by kahlid123
    do i need to copmile apache wit new mysql?
    yes i have back up
    Yes, you do. It explicitely states that in WHM.

Similar Threads

  1. Forum
    By jonib77 in forum New User Questions
    Replies: 3
    Last Post: 12-12-2005, 11:43 AM
  2. [OT] New forum
    By Radio_Head in forum cPanel & WHM Discussions
    Replies: 7
    Last Post: 02-19-2003, 06:04 PM
  3. mysql, installing forum ERROR
    By iwebmaster in forum cPanel & WHM Discussions
    Replies: 0
    Last Post: 12-30-2002, 06:27 PM