Guest Posted August 30, 2010 Posted August 30, 2010 Hi I have just installed the add on "Prices for Logged in users, and when I go to delete or edit a customer I get the following. Is someone able to tell me what I need to do to fix it. 1054 - Unknown column 'a.entry_street_address_2' in 'field list' select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_street_address_2, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id, c.member_level from customers c left join address_book a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '2' [TEP STOP] I suspect it may have something to do with the following Database -------- You will have to add an extra field to the customers table of the data base ALTER TABLE `customers` ADD `member_level` INT(5) DEFAULT '0' NOT NULL; Can someone tell me please how I add the extra field. Many thanks Kind regards Grandpa
MrPhil Posted August 31, 2010 Posted August 31, 2010 You installed some add-on but forgot to add the new field "entry_street_address_2" to table "address_book". Go back and find the instructions. They'll either tell you to run some sort of "update" script, or will give manual instructions similar to the "ALTER TABLE..." instructions you're asking about. As for running those instructions, go into phpMyAdmin (a tool your hosting service should have provided) and select your database. Select the SQL tab and type in the "ALTER TABLE..." instructions exactly as given. Note that the "backtick" character ` is usually to the left of the "1" key on many keyboards. phpMyAdmin also includes buttons to add/modify fields, but if you don't have any idea how to pick apart the ALTER TABLE instruction to know what information to fill in, it's better to do it manually.
Guest Posted August 31, 2010 Posted August 31, 2010 You installed some add-on but forgot to add the new field "entry_street_address_2" to table "address_book". Go back and find the instructions. They'll either tell you to run some sort of "update" script, or will give manual instructions similar to the "ALTER TABLE..." instructions you're asking about. As for running those instructions, go into phpMyAdmin (a tool your hosting service should have provided) and select your database. Select the SQL tab and type in the "ALTER TABLE..." instructions exactly as given. Note that the "backtick" character ` is usually to the left of the "1" key on many keyboards. phpMyAdmin also includes buttons to add/modify fields, but if you don't have any idea how to pick apart the ALTER TABLE instruction to know what information to fill in, it's better to do it manually. Hi Many thanks for your help. I think I must be blind and done something (or not done) but I can't find where Ive gone wrong.So I'm going to start all over again and see what happens. Again many thanks Kind regards Grandpa
Recommended Posts
Archived
This topic is now archived and is closed to further replies.