Cannot add or view address in a new installation.
ctmiller - January 27, 2009 - 22:15
| Project: | Addresses |
| Version: | 6.x-1.05 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Jump to:
Description
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.

#1
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
#2
What do you mean by uninstall. I deleted it reuploaded and ran drupals update function and I am still getting the same error messages.
#3
* 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.
#4
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.
#5
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.
#6
Got this working. I deleted it again. I tried the dev version again and this time it worked.