#309 ab_custom_contact_fields doesn't exist

v2.13
closed
None
5
2012-09-17
2005-09-17
azism
No

I just upgraded from version 2.12 to 2.13 (FINAL). When
I go into my Addressbook, and select Contacts, then
select any contact, I get the following:

======================

Database error: Invalid SQL: SELECT
ab_addressbooks.acl_read, ab_addressbooks.acl_write,
ab_contacts., ab_companies.address AS
work_address, ab_companies.address_no AS
work_address_no, ab_companies.zip AS work_zip,
ab_companies.city AS work_city, ab_companies.state
AS work_state, ab_companies.country AS
work_country, ab_companies.homepage,
ab_companies.bank_no, ab_companies.email AS
company_email, ab_companies.phone AS
company_phone, ab_companies.fax AS company_fax,
ab_companies.name AS company_name,
ab_companies.post_address AS work_post_address,
ab_companies.post_address_no AS
work_post_address_no, ab_companies.post_zip AS
work_post_zip, ab_companies.post_city AS
work_post_city, ab_companies.post_state AS
work_post_state, ab_companies.post_country AS
work_post_country, ab_custom_contact_fields.
FROM
ab_contacts LEFT JOIN ab_companies ON
(ab_contacts.company_id=ab_companies.id) INNER
JOIN ab_addressbooks ON
(ab_contacts.addressbook_id=ab_addressbooks.id)
LEFT JOIN ab_custom_contact_fields ON
ab_custom_contact_fields.id=ab_contacts.id WHERE
ab_contacts.id='18'
MySQL Error: 1146
(Table 'admintom_go.ab_custom_contact_fields' doesn't
exist)
Session halted.

============================

I did not see this under 2.12. WHat do I need to do to
correct this problem???

Discussion

  • Logged In: YES
    user_id=733975

    Please look in
    modules/addressbook/sql/addressbook.install.sql and look for
    the queries to create the tables.

    I've no idea why there tables are missing in your database

     
  • azism
    azism
    2005-10-07

    Logged In: YES
    user_id=1230975

    I have looked through everything, and can't find such a table
    anywhere. In either the upgrade or in the old SQL backups.
    There are two variation of 'ab_custom_contact_fields' with an
    extension, such as '_sort' and '_cats'. But that all I can find,
    period.

     
  • azism
    azism
    2005-10-07

    Logged In: YES
    user_id=1230975

    Okay, I took one more shot at things. I ran the uninstall sql
    script for the addressbook. Then the install script. Then I
    restored the data. It seems okay now. Something weird must
    have happened during the upgrade, that's all I can figure.
    Everything else seems fine. Just the addressbook glitch. Go
    figure.