Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2005
    Posts
    52
    Plugin Contributions
    0

    Default Corrupted Customer Table?

    After a fresh intall of Zen Cart and a new template from Template Monster, I attempted to import my old customer table with the help of my Web host. Between the two of us, we apparently have damaged the table. Here is the error message from the admin:

    1054 Unknown column 'customers_info_source_id' in 'field list'
    in:
    [select customers_info_source_id from billedm_customers_info where customers_info_id = '1']
    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."


    "ID# Last Name
    Asc Desc First Name
    Asc Desc Company
    Asc Desc Account Created
    Asc Desc Referred By
    Asc Desc Last Login
    Asc Desc Pricing Group
    Asc Desc Authorized
    Asc Desc Action "

    The information is intact. When I click on the "Asc" line anywhere (with no apparent link) the details for my single customer appears.

    Running a "short" SQL dump that came with the template makes not change. Running the "full" SQL dump replaces my products AND does not change the error.

    I suspect this error is derived from renaming a table since I now have a total of 278 table which appears to be about 3X as many as I need. I have tables with no prefixes ... tables with "zen_" prefixes ... tables with "billedm_" prefixes which, I think, are the correct ones.

    Can the customers table(s) be individually repaired? Everything else appears to be working OK.
    Bill Edmunds

    [email protected]
    Ocean Park Photography
    www.billedmunds.com

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

    Default Re: Corrupted Customer Table?

    Did you have an add-on?

    customers_info_source_id doesn't belong to a clean Zen Cart ...
    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: v1.5.5]
    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
    Dec 2005
    Posts
    52
    Plugin Contributions
    0

    Default Re: Corrupted Customer Table?

    No add-ons that would affect customers but I thougt the tables were different in the template installation.

    However my old install (still working at http://www.billedmunds.com/buy) list two sets of tables that look the same as the fresh install. After a cursory look inside the old and new tables appear identical

    #1 set old
    customers
    customers_basket
    customers_basket_attributes
    customers_info
    customers_wishlist

    #2 set old
    zen_customers
    zen_customers_basket
    zen_customers_basket_attributes
    zen_customers_info
    zen_customers_wishlist

    My tables in the new install are:

    #1 set new
    billedm_customers
    billedm_customers_basket
    billedm_customers_basket_attributes
    billedm_customers_info
    billedm_customers_wishlist

    #2 set new
    customers
    customers_basket
    customers_basket_attributes
    customers_info
    customers_wishlist


    #3 set new
    zen_customers
    zen_customers_basket
    zen_customers_basket_attributes
    zen_customers_info
    zen_customers_wishlist
    Bill Edmunds

    [email protected]
    Ocean Park Photography
    www.billedmunds.com

  4. #4
    Join Date
    Dec 2005
    Posts
    52
    Plugin Contributions
    0

    Default Re: Corrupted Customer Table?

    Hmmmm...on second thought, I seem to remember trying an extension that allowed a customer to input a "where did you hear about ...." feature. Too bad there isn't a list of add-ons like Fireox. I'll try to track that add-on.
    Bill Edmunds

    [email protected]
    Ocean Park Photography
    www.billedmunds.com

  5. #5
    Join Date
    Dec 2005
    Posts
    52
    Plugin Contributions
    0

    Default Re: Corrupted Customer Table?

    Good eye.

    You're right Ajeh. I installed "How Did You Hear About Us Version 1.3.6_beta" and a MySQL dump file

    "This contrib creates a drop-down box populated by admin entered
    (Admin->Extra->Referral) referral sources that prompts the customer where they
    found out about the site. Admin can also make this required or not
    (Admin->Configuration->Customer Details). Also includes ability to control
    whether or not an "Other" appears in the dropdown and if so, displays an
    additional text input box (Admin->Configuration->My Store).

    Information is then stored in customers_info table for reports and data mining.
    Reports are displayed in Admin->Extra->Referral Sources. If you double click on `Other` a list of all the write in sources from customers will appear with the
    dates that they were entered."

    Navigating to the aforementioned Extras --> Referral Sources produces the same error:

    "1054 Unknown column 'ci.customers_info_source_id' in 'field list'
    in:
    [select count(ci.customers_info_source_id) as no_referrals, s.sources_name, s.sources_id from billedm_customers_info ci LEFT JOIN billedm_sources s ON s.sources_id = ci.customers_info_source_id group by s.sources_id order by ci.customers_info_source_id DESC]
    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."

    Is it possible to remove or has dump file on the permanently chaged the tables? Should I attempt a re-install although (now) I see the warning " This version is only compatible with ZenCart Version 1.3.6"?
    Bill Edmunds

    [email protected]
    Ocean Park Photography
    www.billedmunds.com

  6. #6
    Join Date
    Dec 2005
    Posts
    52
    Plugin Contributions
    0

    Default Re: Corrupted Customer Table?

    I found an ugly fix but a fix nonetheless.

    I re-installed the add-on. I ran the patch through PHP Admin when it refused to update through Zen Cart Tools.

    I got a new error message under Admin -- >Customers -- "...error in line 1048 of admin/customers.php.

    //rmh referral start
    $source_query = "select customers_info_source_id from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . $customers->fields['customers_id'] . "'";
    $source = $db->Execute($source_query);

    -----> $entry_referral = zen_get_sources_name($source->fields <-----

    ['customers_info_source_id'], $customers->fields['customers_id']);
    //rmh referral end

    I commented out the whole section and now I see my only customer and I am able to add new ones.

    And yes, I have learned to back up now before applying MySQL patches.
    Bill Edmunds

    [email protected]
    Ocean Park Photography
    www.billedmunds.com

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

    Default Re: Corrupted Customer Table?

    Go to the Tools ... Developer's Tool Kit ...

    In the bottom input box, enter:
    customers_info_source_id

    Select Catalog/Admin from the dropdown and click Search ...

    And see what files come up with that referenced ...
    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: v1.5.5]
    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!

 

 

Similar Threads

  1. Replies: 1
    Last Post: 31 Oct 2014, 11:48 PM
  2. v139h Customer Data Corrupted after server error
    By mshultise in forum General Questions
    Replies: 9
    Last Post: 25 Jun 2013, 09:51 PM
  3. re: customers dbase table corrupted. How can I create new one
    By anthonytjm in forum General Questions
    Replies: 0
    Last Post: 2 Aug 2010, 03:19 PM
  4. customer table
    By DarkAngel in forum General Questions
    Replies: 4
    Last Post: 26 Apr 2010, 03:21 AM
  5. Corrupted Stuck Orders table?
    By lucidlee in forum Managing Customers and Orders
    Replies: 1
    Last Post: 27 Dec 2008, 12:05 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR