running wolf Posted April 23, 2005 Posted April 23, 2005 1054 - Unknown column 'purchased_without_account' in 'field list' select customers_id, purchased_without_account, customers_firstname, customers_password, customers_email_address, customers_default_address_id from customers where upper(customers_email_address) = '[email protected]' and upper(customers_firstname) = 'NNNNN' and upper(customers_lastname) = 'NNNNN' [TEP STOP] I get this error when checking out without opening an account. Otherwise everything seams to work fine. I would be grateful for some advice, thanks Quote Kristine Running Wolf
safoo Posted April 23, 2005 Posted April 23, 2005 you didn't run the sql script to create the 'purchased_without_account' column in the database. Reread the instructions and try again. Quote
running wolf Posted April 23, 2005 Author Posted April 23, 2005 thanks for the tip, but, please, how do I do this? Do I create a new table purchase_without_account? If yes, how many fields? Grateful for an answer Quote Kristine Running Wolf
Wendy James Posted April 23, 2005 Posted April 23, 2005 There should be an sql file in the zip you downloaded for that contribution. You have to put that into your database. How you do it depends on how you connect to your database. Quote Wendy James Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
running wolf Posted April 23, 2005 Author Posted April 23, 2005 thanks so much, I found the sql file and am in mysql, it says : create new table and then:fields. Quote Kristine Running Wolf
Wendy James Posted April 23, 2005 Posted April 23, 2005 You should just have to copy and paste all of the text in that file into an sql query in your myphpadmin or however you connect to your database. You do not have to manually create anything. Quote Wendy James Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
running wolf Posted April 23, 2005 Author Posted April 23, 2005 ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id;ALTER TABLE customers ADD INDEX (purchased_without_account); INSERT INTO configuration_group VALUES (40, 'Accounts', 'Configuration of Account settings', 40, 1); INSERT INTO configuration VALUES ('', 'Purchase Without Account', 'PWA_ON','true','Allow Customers to purchase without an account', 40, 1, '2003-04-08 13:07:44', '2003-04-08 12:10:51', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'); ALTER TABLE orders ADD purchased_without_account TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL; I ran this quote in customers but it still won't work Quote Kristine Running Wolf
running wolf Posted April 23, 2005 Author Posted April 23, 2005 got it, thanks so much Quote Kristine Running Wolf
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.