Fresh install missing table
In testing a fresh install of a 1.3.6 store. I got this message:
1146 Table 'olym1960_zencart.address_book' doesn't exist
[select count(*) as total from customers c left join customers_info ci on c.customers_id= ci.customers_info_id left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id ]
I checked the DB and, yes, that table is missing.
Is there a sql summary of the DB structure somewhere so I could manually add the table?
If that is missing, is there way to check that all tables were installed properly? Otherwise, the store itself seems to be operating without any other problems.
Re: Fresh install missing table
In the Zen Cart distribution files you can find in the zc_install folder this file: mysql_zencart.sql that contains the base DB tables...
Searching this file I do not see any table named "olym1960_zencart.address_book"
You could manually use phpmyadmin and drop all the tables from the DB and reload(import) this file again and you should be correct after this but some base info will have to be reentered from the admin or just find the stray table and see where it cam from.
Can always begin over on a new install also
By RobWUK in forum Upgrading from 1.3.x to 1.3.9
Last Post: 27 Sep 2006, 12:35 AM
By JuxiZoza in forum Setting Up Categories, Products, Attributes
Last Post: 23 Mar 2006, 05:16 AM
Content and Graphics Copyright (c) 2003 - 2013 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC