MySQL Error 1146 Help.

Discussion in 'MySQL' started by jasonxxx102, May 20, 2011.

0
  1. #1
    So, I was transferring an SQL database to another website today and I did everything the way I should have but the site keeps giving me a weird error.

    Database error: Invalid SQL: SELECT id FROM stats WHERE date='20/05/11'
MySQL Error: 1146 (Table 'webestat_site.stats' doesn't exist)
Session halted.
    Code (markup):
    It is telling me the table doesn't exist but I checked in the SQL database and the table is there.

    If anybody could help me that would be great.
     
    jasonxxx102, May 20, 2011 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Are you querying the correct database? You may need to switch databases if stats is not in the webestat_site database.
     
    jestep, May 20, 2011 IP
  3. darbetim

    darbetim Member

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #3
    you have to create table :)
     
    darbetim, Jun 11, 2011 IP
  4. sophiehills1

    sophiehills1 Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Hi friend ,

    Please refresh your data base and if it will be not working then please create again that DB.
     
    sophiehills1, Jun 14, 2011 IP