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.
Bookmarks