Site maintenance: Tuesday 17 Nov, from 10:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / Installing on a Linux/Unix Server / Fresh install missing table

Fresh install missing table

Locked

Started by boinkt22 on 16 Dec 2006, 6:14 PM · Views: 1,627

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
16 Dec 2006, 6:14 PM
#1
boinkt22 avatar

boinkt22

New Zenner

Join Date:
Dec 2006
Posts:
1
Plugin Contributions:
0

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
in:
[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.

17 Dec 2006, 1:58 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

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

Zen-Venom Get Bitten