I upgraded to the latest version of this module and am still getting this error.

* user warning: Table 'churchxx_drupal2.addresses_user' doesn't exist query: INSERT INTO addresses_user (eid, aname, street, additional, city, province, country, postal_code, is_primary) VALUES (1, '', '', '', '', '', '', '', 0) in /home/churchxx/public_html/includes/common.inc on line 3425.
* user warning: Table 'churchxx_drupal2.addresses_user' doesn't exist query: SELECT * FROM addresses_user WHERE eid = 1 ORDER BY is_primary DESC in /home/churchxx/public_html/sites/all/modules/addresses/addresses_user/addresses_user.inc on line 40.

Comments

brmassa’s picture

brmassa commented
Status: Active » Postponed (maintainer needs more info)

ted,

i just installed the module in a fresh site without problems. I need to know how i can replicate your problem.

Anyway, I guess uninstalling and then reinstalling the module will fix it.

regards,

massa

ctmiller’s picture

ctmiller commented

What do you mean by uninstall. I deleted it reuploaded and ran drupals update function and I am still getting the same error messages.

ctmiller’s picture

ctmiller commented

* user warning: Table 'churchxx_drupal2.addresses_user' doesn't exist query: UPDATE addresses_user SET is_primary = 0 WHERE is_primary = 1 AND eid = 1 in /home/churchxx/public_html/sites/all/modules/addresses/addresses_user/addresses_user.inc on line 74.
* user warning: Table 'churchxx_drupal2.addresses_user' doesn't exist query: INSERT INTO addresses_user (eid, aname, street, additional, city, province, country, postal_code, is_primary, phone, fax) VALUES (1, 'Home', '2821 South Lake Drive', '', 'Prestonsburg', 'KY', 'us', '41653', 1, '606-886-3628', '') in /home/churchxx/public_html/includes/common.inc on line 3425.
* user warning: Table 'churchxx_drupal2.addresses_user' doesn't exist query: SELECT * FROM addresses_user WHERE eid = 1 ORDER BY is_primary DESC in /home/churchxx/public_html/sites/all/modules/addresses/addresses_user/addresses_user.inc on line 40.

Is their a database not being created that needs manually created. If I knew the data structure I could try creating the database manually to see if that fixes it.

gopagoninarsing’s picture

gopagoninarsing commented

Hi,

When u enable addresses module it will creates addresses_user table. Disable addresses module and enable it again.

Looking at the above errors it seems like that tables are not created.

Enable the module and check whether the table addresses_user is created in your database.

ctmiller’s picture

ctmiller commented

Have done that multiple times. There is an addresses table in the drupal mysql database but no table addresses_user.

I would love to get this bugger working before I open the registration form up for users. Is there a table structure for the addresses_user database that I could implement it manually.

ctmiller’s picture

ctmiller commented

Got this working. I deleted it again. I tried the dev version again and this time it worked.

codycraven’s picture

codycraven commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

I know this bug report is very old but...

Sometimes Drupal modules will fail to create tables during an install. This rarely ever happens, but it does happen and from what I can tell is not the fault of the module.

For future reference if you have a module that does not create the table(s) that it was supposed to during install you need to do the following:

  1. Disable the module
  2. Uninstall the module
    To uninstall a module you need to click the Uninstall module tab on the modules page which takes you to admin/build/modules/uninstall.
    Uninstalling the module will attempt to remove the tables that should have been created and on your next install will allow the tables to be created.
  3. Reinstall the module by enabling it