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)
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

brmassa - January 28, 2009 - 19:46
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

#2

ctmiller - February 17, 2009 - 00:47

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

ctmiller - February 22, 2009 - 21:10

* 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

gopagoninarsing - February 27, 2009 - 10:55

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

ctmiller - February 28, 2009 - 04:56

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

ctmiller - March 1, 2009 - 03:42

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

 
 

Drupal is a registered trademark of Dries Buytaert.