Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2006
    Location
    UK
    Posts
    306
    Plugin Contributions
    1

    Default Customer error, possibly database related ?

    I have suddenly gained the following error, I have no idea why it occured and have done nothing other than decide to checck on a few customers ... and this is the error I get ... with no customer listing showing.

    Code:
    1030 Got error 127 from storage engine
    in:
    [select count(*) as total from zen_customers c left join zen_customers_info ci on c.customers_id= ci.customers_info_id left join zen_address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id ]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
    Thanks for any help

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Customer error, possibly database related ?

    Sounds like you may have had a MySQL database crash ...

    Try running the Repair on the database table ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Feb 2006
    Location
    UK
    Posts
    306
    Plugin Contributions
    1

    Default Re: Customer error, possibly database related ?

    Quote Originally Posted by Ajeh View Post
    Sounds like you may have had a MySQL database crash ...

    Try running the Repair on the database table ...

    Thanks for the advice Linda, it has now developed further and there is no site there and no admin there either, I guess I need to log into the database itself to do this repair that you mention?

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Customer error, possibly database related ?

    It does sound like you need to repair the database via phpMyAdmin ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Feb 2006
    Location
    UK
    Posts
    306
    Plugin Contributions
    1

    Default Re: Customer error, possibly database related ?

    Thanks Ajeh, I mentioned it to my hosts, and they fixed whatever it was, they didn't tell me what the problem was, but they fixed it so all is now well again, thanks for pointing me in the right direction, and responding promptly and accurately as ever, I appreciate your efforts.

 

 

Similar Threads

  1. customer uploads not related to purchases
    By g_force in forum Templates, Stylesheets, Page Layout
    Replies: 7
    Last Post: 6 Feb 2010, 10:31 PM
  2. Database Query Related
    By callingrohit in forum General Questions
    Replies: 1
    Last Post: 28 Sep 2008, 08:56 PM
  3. Questions related to database tables
    By superprg in forum General Questions
    Replies: 25
    Last Post: 15 Aug 2006, 10:31 PM

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