Somewhere between a Drupal 6.4 >>> to >>> 6.6 update and addresses module v6.x-1.0-alpha2 >>> to >>> addresses6.x-1.0-alpha3:

user warning: Table 'd60517276.addresses_user' doesn't exist query: SELECT * FROM addresses_user WHERE eid = 1 ORDER BY is_primary DESC in /mnt/w0906/d10/s42/b02de952/www/sitenamexyz.ca/sites/all/modules/addresses/addresses_user/addresses_user.inc on line 37.

When I do an installation of addresses6.x-1.0-alpha3 with options on a test site, I can see a difference in table names between two database tables currently based on Drupal 6.6.

  • addresses_user is TABLE name on test site with NO error message and fresh module install (addresses6.x-1.0-alpha3)
  • addresses is TABLE name on active site with ERROR (also has additional field of atype)

    • Looking at a backup files from 15+ days ago (when addresses/users seemed to be working fine) I see that the TABLE name of addresses existed. addresses_user.installfiles show difference of:

    $schema['addresses'] = array(
    to
    $schema['addresses_users'] = array

    Can I simply disable the module, drop the table and reactivate module to get a new/good >addresses_user TABLE?

    How else should i approach this issue?

    Comments

    brmassa’s picture

    brmassa commented
    Status: Active » Fixed

    Charles,

    sorry about this bug. You can fix it simply by renaming the the table to addresses_users.

    regards,

    massa

    AntiNSA’s picture

    AntiNSA commented

    Rename it where I cant even find the table in my-sql

    rcharles’s picture

    rcharles commented

    Thank you. Worked like a charm.

    NecroHill’s picture

    NecroHill commented

    which table we have to rename?

    Status: Fixed » Closed (fixed)

    Automatically closed -- issue fixed for two weeks with no activity.