Missing DB files in MySQL on VB 4.1.3 (HELP PLEASE)

Discussion in 'Databases' started by lacaliboy, Jul 30, 2011.

  1. #1
    I have a forum community running on VB 4.1.3 that was upgraded about 1-2 months ago from another VB4 version. about 3-4 weeks ago I started getting several emails with database errors. Within the weeks I started noticing several other database error emails with more than one database errors saying that they are missing or corrupt. I tried the "Repair function" with no results. I was hoping someone with experience could help me salvage my forum.

    Here are a few of the errors below:

    When trying to check my Private Messages I get this error:
    MySQL Error : Table 'ftastrea_newvb.contenttype' doesn't exist
    Error Number : 1146


    When trying to post I get this error:
    MySQL Error : Table 'ftastrea_newvb.tag' doesn't exist
    Error Number : 1146


    When I click on a user and then click on "Find all started threads" I get this error:
    MySQL Error : Table 'ftastrea_newvb.searchlog' doesn't exist
    Error Number : 1146


    These are just a few that I have found, but im sure there are more.

    Please help.
    Thanks
     
    lacaliboy, Jul 30, 2011 IP
  2. iliveforyou

    iliveforyou Active Member

    Messages:
    207
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #2
    1. it's possible to write wrong table name(check the table name, maybe you it's an syntax mistake when you call the table name).
    2. it's possible that the table doesn't exist(check the table if exist, if not then create the table).
    3. check connection to database
     
    iliveforyou, Aug 2, 2011 IP