SQL Error

Discussion in 'Free Hosting' started by lupuslun, Feb 17, 2018.

  1. lupuslun

    lupuslun New Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    SQL Error:
    1146 - Table 'lupuslun_198674LusIn.mybbdatacache' doesn't exist
    Query:
    SELECT title,cache FROM mybbdatacache

    ____

    $config['database']['type'] = 'mysql';
    $config['database']['database'] = 'lupuslun_*********';
    $config['database']['table_prefix'] = 'mybb_';

    $config['database']['hostname'] = 'localhost';

    ____

    What am I doing wrong?
     
  2. sobakix2

    sobakix2 New Member

    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    mysql module is quite obsolete and likely turned off in your php version. use 'mysqli' or 'pdo' instead
     
  3. lupuslun

    lupuslun New Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Switched to mysqli and still nothing?
     
  4. sobakix2

    sobakix2 New Member

    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    then i guess it's a valid error message and you indeed have that table missing. one solution is to recreate the entire repository in a separate database or at least with different table prefix and then recreate the missing table using the DDL you can pull from the new table. that's in case you already have data that you want to keep. if it's a brand new repository - just delete it and recreate from scratch

    also google is your best friend: https://community.mybb.com/thread-113427.html
     

Share This Page