Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    2
    Plugin Contributions
    0

    Default 1034 Incorrect key file for table 'zen_customers'; try to repair it

    Quote Originally Posted by kobra View Post
    Using a backup depends upon the date and if the table existed then

    Do you have or did you have any customers?

    If not, this table can be re-created as an empty table

    If you had customers you will need to find a backup somewhere to restore them
    Can someone tell me how to do this. I dropped my zen_customer table in db 4. Tried restoring so many times I'm dizzy from db 2. Myphpadmin always says the restored back up of db 2 into db 2 but it says it is a empty db when the restore is complete. I was trying to copy zen_customer from db 2 to new db 4 and I dropped the table (gone poof), In my many attempts to fix as I said now have an empty db 2. db 4 is there is myphpadmin and it looks like all the tables and data are there except the zen_customer.

    Since the original db is empty, can I just recreate an empty table to make the cart work. If so HOW?

    I have been trying to get this cart up and going for 10 days. I have made things go from:

    1034 Incorrect key file for table 'zen_customers'; try to repair it in: [select count(*)

    to

    1062 Duplicate entry '1' for key 'PRIMARY' in: [insert into zen_customers_info

    to where I am now with no zen_customer table

    1146 Table 'zc4.zen_customers' doesn't exist
    in: [select count(*) as count from zen_customers]

    I just started out helping a friend upgrade their cart and now I have shut down their store for 10 days. I wouldn't be lying saying I have cried and stay up night after night trying to find the fix.


    I have backups from cpanel going back to 7/10
    a fanstatico back up of the store for db 2
    and individual exports of db 2 from cpanel (those are the ones I keep trying to restore and the phpadmin says they are empty after it restores.

    Any help or guidance would be appreciated.

    What version of Zen Cart are you using? should be 1.3.9 now both versions 2 and 4

    Has your site been upgraded? When? From what version(s)? 10 days ago # 2 went from 1.3.7 to 1.3.8, 2 was working accept for 1038 error, made a clean install creating # 4 got error 1062 when trying to register customer

    What addons have you installed? When? not sure

    In what ways is your site customized or different from a brand new uncustomized install? It uses apple_zen template

    If you're encountering display/layout problems, post your site URL* so it can be seen in action. Layout looks great in #4.... #2 is really bad.

    If you're encountering problems that could be related to your server or hosting company, include the name of your hosting company (not their URL). I am the host for my friend.

    HAVE YOU LOOKED IN THE FAQ AREA for answers to your question? (ie: a search for your error message or what you want to edit/change, etc) Yes, I have tried every thing I can find to try.

    Have you searched the FORUM for your error message or for answers to the question you're asking? Yes

    WHEN did the problem "start"? How does that compare with other events of your hosting company, changes you've made to your site files/addons, or your admin settings, etc? 12 days ago I did cpanel and mysql updates, 11 days ago I did apache update and php to 5.3

    If this is your first store, have you tested all aspects of transactions before going live? My friend does have two other stores which have the original error, I have not touched those yet. They only have the patch applied and have the 1034 error if you log in to the admin or if someone tries to register.

  2. #2
    Join Date
    Jul 2011
    Posts
    2
    Plugin Contributions
    0

    Default Re: 1034 Incorrect key file for table 'zen_customers'; try to repair it

    nevermind

  3. #3
    Join Date
    Jan 2004
    Posts
    60,443
    Blog Entries
    4
    Plugin Contributions
    51

    Default Re: 1034 Incorrect key file for table 'zen_customers'; try to repair it

    Glad you found a solution by repairing your database table.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donations always welcome: www.zen-cart.com/donate

    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.



 

 

Similar Threads

  1. "1034 Incorrect key file for table 'zen_customers'; try to repair it
    By albert7 in forum Upgrading from 1.3.x to 1.3.9
    Replies: 3
    Last Post: 31 Aug 2011, 07:26 PM
  2. 1034 Incorrect key file for table 'customers';
    By AmazingGraze in forum General Questions
    Replies: 1
    Last Post: 27 Jan 2011, 01:58 AM
  3. ** BIG PROBLEM! ** 1034 Incorrect key file for table
    By RobertKramers in forum General Questions
    Replies: 5
    Last Post: 28 Mar 2009, 12:00 PM
  4. 1034 Incorrect key file for table - after upgrading MySQL
    By macat in forum General Questions
    Replies: 2
    Last Post: 30 Jan 2009, 10:38 PM

Bookmarks

Posting Permissions

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