Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008
    Posts
    5
    Plugin Contributions
    0

    Default Help about error 1146 Table.. SQL database Help

    I am not sure how this happened but I got this Error all of a sudden, maybe one of you guys have been through this before. I really would like for someone to give me some help. I have this error on my page,

    1146 Table 'Mysite_zc1.TABLE_MUSIC_GENRE' doesn't exist
    in:
    [select music_genre_id, music_genre_name from TABLE_MUSIC_GENRE order by music_genre_name]

    I tried asking my webhosting company for help, but they said that they can't help e with those things. Is it cuz I picked a bad hosting company? do hosting companies usually offer tech help? Maybe I should switch to a new hosting company.

    I think what I need to solve this problem is to upload the database table of Table_music_genre .. If this is the problem can someone offer me a fresh install of this database table? My zencart install is very fresh with few mods.

    I also have all the files for install of Zencart, and I see that thy have a folder with "install" and SQL databases. Maybe one fo you guys can tell me which file to upload to my database to fix this.
    any help would be very appreciated.

    thank you.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: Help about error 1146 Table.. SQL database Help

    Try re-uploading your /includes/extra_datafiles/music_type_database_names.php file ... it must be missing or damaged.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Feb 2008
    Posts
    5
    Plugin Contributions
    0

    Default Re: Help about error 1146 Table.. SQL database Help

    WOW, you are the Man.. It worked like a charm.. thank you a Million.

 

 

Similar Threads

  1. v139h SQL Error 1146 Table TABLE_CUSTOMERS_ADMIN_NOTES doesn't exist
    By utefan in forum General Questions
    Replies: 4
    Last Post: 3 Mar 2016, 07:45 PM
  2. MYSQL error #1146 table doesn't exist - help!
    By TheKenster in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 20 Jan 2012, 01:48 PM
  3. Replies: 4
    Last Post: 15 Oct 2010, 07:18 AM
  4. Help with new install 1146 Table error
    By valnoren in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 29 Apr 2008, 08:30 PM
  5. Help! 1146 Table doesn't exist?
    By sberriemb in forum General Questions
    Replies: 5
    Last Post: 6 Jun 2007, 08:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg