Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

mySQL error: Can't open file: 'ibf_forums.MYI'.

Discussion in 'General Discussion' started by rooftopp, May 30, 2003.

  1. rooftopp

    rooftopp Registered

    Joined:
    May 30, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    151
    I am using invision board 1.1.2 and can not acceess my forum today - I get the following error:

    mySQL query error: SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
    c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
    from ibf_forums f, ibf_categories c
    LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
    WHERE f.category=c.id
    order by c.position, f.position

    mySQL error: Can't open file: 'ibf_forums.MYI'. (errno: 145)
    mySQL error code: 1016
    Date: Friday 30th of May 2003 04:07:49 AM

    On the Invison forums staff says:

    Group: IPS Staff
    Posts: 4581
    Member No.: 2146
    Joined: 17-February 02



    QUOTE (kevin c @ Apr 9 2003, 08:13 PM)

    My ISP says it is not a cpanel problem because they are running the very latest version it is a problem with MySQL 4.0 and Invision Board. CAn someone please figure this out instead of pointing fingers. I told the same thing to my ISP.

    Rest assured no one is pointing fingers.

    We had been advised that is was due to the mySQL upgrade hosts had performed which was related to cPanel. We can only pass on information we have been told

    Can anyone help me?
     
    #1 rooftopp, May 30, 2003
  2. MichaelShanks

    MichaelShanks Well-Known Member
    PartnerNOC

    Joined:
    Aug 20, 2001
    Messages:
    104
    Likes Received:
    0
    Trophy Points:
    316
    okay tell them to

    cd /var/lib/mysql/cat_position

    and run

    myisamchk -r *.MYI

    then restart mysql

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 MichaelShanks, May 30, 2003
  3. rooftopp

    rooftopp Registered

    Joined:
    May 30, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    151
    Thank you I will forward your suggestion.
     
    #3 rooftopp, May 30, 2003
  4. Tox

    Tox Member

    Joined:
    Aug 12, 2002
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    151
    I have had this on another server recently as well and it turned out that a table was just corrupted. Was fixed with the REPAIR TABLE command.

    cPanel.net Support Ticket Number:
     
    #4 Tox, May 30, 2003
  5. rooftopp

    rooftopp Registered

    Joined:
    May 30, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    151
    Yes there is that suggestion. However, followers of same still had the error.

    cPanel.net Support Ticket Number:
     
    #5 rooftopp, May 30, 2003
  6. scriptmaster

    scriptmaster Registered

    Joined:
    Jul 13, 2003
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    151
    not a cpanel ?

    This is a problem that doesn't only affect invisionboard, my people reported same problems with phpbb , ldu , phpnuke and other software

    cPanel.net Support Ticket Number:
     
    #6 scriptmaster, Jul 28, 2003
  7. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,720
    Likes Received:
    98
    Trophy Points:
    328
    cPanel Access Level:
    Root Administrator
    I had heard that this was a problem with InvisionBoard. While I'm sure there are probably other software out there that experience this problem, I thought it was software related and not a problem with MySQL or CPanel. The only problems we have with clients are those running InvisionBoard. At any rate, I would appreciate a permanent fix for the problem.

    cPanel.net Support Ticket Number:
     
    #7 sparek-3, Jul 29, 2003
  8. scriptmaster

    scriptmaster Registered

    Joined:
    Jul 13, 2003
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    151
    Yes , Invisionboard seems quite a major problems with this but there are over 60 forums/cms programs which do get this error , it seems to only affect mostly the same table db_topics. This error only occurs on boards that are busy as far as I know , but it might happen on smaller ones.

    cPanel.net Support Ticket Number:
     
    #8 scriptmaster, Jul 29, 2003
  9. carmatec

    carmatec Member

    Joined:
    Mar 9, 2003
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    151
    Location:
    US
    The problem happens because php takes its own mysql libs (which come with the build) and does not use the actual libs present on the server. For eg, you may be running mysql 4.0.13, but upon recompiling php, check out phpinfo and you will see that the 'client API version' at the bottom will reflect mysql 3.x, it is this incompatibility that causes this problem.

    You need to recompile PHP by specifying in the configure step --with-mysql=/usr so that it picks up the 4.x libs instead. This fixes the problem.

    cPanel.net Support Ticket Number:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #9 carmatec, Jul 31, 2003
  10. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    191
    Is there a reason the cpanel build uses --with-mysql instead of --with-mysql=/usr ?

    cPanel.net Support Ticket Number:
     
    #10 casey, Jul 31, 2003
  11. LS_Drew

    LS_Drew Well-Known Member

    Joined:
    Feb 20, 2003
    Messages:
    187
    Likes Received:
    0
    Trophy Points:
    166
    Yes, if this is the case can we please change this NOW?????

    cPanel.net Support Ticket Number:
     
    #11 LS_Drew, Jul 31, 2003
  12. Creazioni

    Creazioni Well-Known Member

    Joined:
    Jan 5, 2003
    Messages:
    133
    Likes Received:
    0
    Trophy Points:
    166
    With mysql 4.0.14 situation is the same

    Have the same problem now too?

    Only solutions is configure php like up?

    downgrade mysql to 4.0.11 is a solution?
    or 3.0.x?


    THANKS

    cPanel.net Support Ticket Number:
     
    #12 Creazioni, Aug 27, 2003
  13. kcdworks

    kcdworks Well-Known Member

    Joined:
    Jul 28, 2002
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    166
    The only "solution" until Buildapache is changed to allow PHP to be built with --with-mysql=/usr is to compile php yourself with that option, and do not choose the php option when running buildapache. You will also want to complete the tweaks to my.cnf posted here: http://www.vbulletin.com/forum/showthread.php?threadid=69070

    We've done that to our install on all of our servers where users have reported error 1016, and it has solved it for us. It has NOTHING to do with downgrading MySQL, it's that the MySQL API included with php is outdated, so you have to force it to use the API included with MySQL (which you'll have to do after PHP drops MySQL support by default anyway).
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #13 kcdworks, Aug 27, 2003
  14. FWC

    FWC Well-Known Member

    Joined:
    May 13, 2002
    Messages:
    354
    Likes Received:
    0
    Trophy Points:
    316
    Location:
    Ontario, Canada
    Buildapache has had this capablity for a while now.
     
    #14 FWC, Aug 28, 2003
(You must log in or sign up to post here.)
Loading...
Similar Threads - mySQL error Can't
  1. Luis Gil

    Database error, Can't connect to local MySQL server through socket

    Luis Gil, Feb 13, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    412
    Luis Gil
    Feb 15, 2018
  2. htcmarket

    Can't get hostname for your address mysql error

    htcmarket, Feb 21, 2017, in forum: Database Discussion
    Replies:
    2
    Views:
    1,474
    cPanelMichael
    Feb 21, 2017
  3. LaLi

    mysqldump: [ERROR] unknown option '--skip-name-resolve'

    LaLi, Jul 28, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    83
    cPanelLauren
    Jul 30, 2018
  4. udee

    The system failed to drop the MySQL user error

    udee, Jul 14, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    108
    cPanelMichael
    Jul 16, 2018
  5. Sunlander

    MySQL Error in WHM Service Status Daily Process Log

    Sunlander, Jun 28, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    126
    cPanelMichael
    Jun 29, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice