Problems with the "Customer Account Number" contri

[EricPrice]

This is a brand new install with the catalog files and admin directory in the root of the site. I have been trying to get the Customer Account Number contribution by Nick Hemsley working, without any success. After working through the install directions I got the following error.

 

1054 - Unknown column 'a.entry_acct' in 'field list'

 

select c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_acct, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_zone_id, a.entry_state, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter from customers c, address_book a where c.customers_id = '2' and a.customers_id = c.customers_id and a.address_book_id = '1'

 

or something similar depending on what Im doing at the time. The URL at the top is http://shop.irwj.com/account.php (you wont be able to access this site)

 

I found all the instances where the instructions ask me to insert and / or find and replace files, except for two. The instructions indicated that I should insert this

 

define('ACCOUNT_ACCT', 'true');

 

into the application_top.php file of the admin and catalog directories, but the other define ('ACCOUNT_????,'true'); that are used as waymarkers arent located in that file or any other that I could find in the snapshot. I think this is supposed to turn the contribution on and off, but Im not sure.

 

Anyone know what I might have missed or miscopied here? It seems like a relatively straight-forward addin (one of the reasons I started with it in fact)

 

Eric Price

[EricPrice]

Nevermind, Im an idiot. I ran my sql commands against a different db.

 

Doh!

[Druide]

i know exactly what you mean, about 3.5 years ago i transferd some of my projects to a dedicated host but kept everything there for some time and guess what it was not updating everything on the new host because of my lack of adjusting ALL config files.

(bad coding)

 

I love it when a ball starts to roll down the hill... it will not stop till it gets stuck...