mergedplot Posted April 20, 2003 Share Posted April 20, 2003 1054 - Unknown column 'comments' in 'field list' select customers_name, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, comments, fedex_track_num, ups_track_num, usps_track_num, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '4' Any help would be great. I'm not sure why I'm getting this error. Thanks, Matt Link to comment Share on other sites More sharing options...
erisen Posted April 20, 2003 Share Posted April 20, 2003 Hello Mate, I have the 2.2 MS1 installed and in my orders table there is no comments field: # # Table structure for table `orders` # CREATE TABLE orders ( orders_id int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', customers_name varchar(64) NOT NULL default '', customers_company varchar(32) default NULL, customers_street_address varchar(64) NOT NULL default '', customers_suburb varchar(32) default NULL, customers_city varchar(32) NOT NULL default '', customers_postcode varchar(10) NOT NULL default '', customers_state varchar(32) default NULL, customers_country varchar(32) NOT NULL default '', customers_telephone varchar(32) NOT NULL default '', customers_email_address varchar(96) NOT NULL default '', customers_address_format_id int(5) NOT NULL default '0', delivery_name varchar(64) NOT NULL default '', delivery_company varchar(32) default NULL, delivery_street_address varchar(64) NOT NULL default '', delivery_suburb varchar(32) default NULL, delivery_city varchar(32) NOT NULL default '', delivery_postcode varchar(10) NOT NULL default '', delivery_state varchar(32) default NULL, delivery_country varchar(32) NOT NULL default '', delivery_address_format_id int(5) NOT NULL default '0', billing_name varchar(64) NOT NULL default '', billing_company varchar(32) default NULL, billing_street_address varchar(64) NOT NULL default '', billing_suburb varchar(32) default NULL, billing_city varchar(32) NOT NULL default '', billing_postcode varchar(10) NOT NULL default '', billing_state varchar(32) default NULL, billing_country varchar(32) NOT NULL default '', billing_address_format_id int(5) NOT NULL default '0', payment_method varchar(32) NOT NULL default '', cc_type varchar(20) default NULL, cc_owner varchar(64) default NULL, cc_number varchar(32) default NULL, cc_expires varchar(4) default NULL, last_modified datetime default NULL, date_purchased datetime default NULL, orders_status int(5) NOT NULL default '0', orders_date_finished datetime default NULL, currency char(3) default NULL, currency_value decimal(14,6) default NULL, PRIMARY KEY (orders_id) ) TYPE=MyISAM; What are you referring to as "comments?" GALATASARAY RULES! ultrAslan - ultrAslan - ultrAslan Link to comment Share on other sites More sharing options...
mergedplot Posted April 20, 2003 Author Share Posted April 20, 2003 I didn't add any comment feature in there... I don't know how it got in there. I uploaded the /admin/orders.php and /admin/includes/language/english/orders.php files again (new from the ZIP file) and it still gives me that error. -Matt Link to comment Share on other sites More sharing options...
mergedplot Posted April 20, 2003 Author Share Posted April 20, 2003 I have replaced nearly every file I can think of that would have something to do with the order making... I've replaced them with the ones from the latest zip... But it's still showing this "fedex_tracking" and comments and such... How on earth do I get this back working??? What file is used to write and make the order, that would create a spot for "comments" and what not?? Thanks, Matt Link to comment Share on other sites More sharing options...
erisen Posted April 20, 2003 Share Posted April 20, 2003 Hello again, I have checked the latest code release, there is not a column called comments in the orders table. Also in your SQL, you have all these columns that are not in the orders table. Are you doing a fresh install? An upgrade? GALATASARAY RULES! ultrAslan - ultrAslan - ultrAslan Link to comment Share on other sites More sharing options...
Druide Posted April 20, 2003 Share Posted April 20, 2003 Matt you made a mistake with installing a contribution, its clear that your query is NOT from a fresh osC install. fedex_track_num etc... are not available in any query referring the latest snapshot, so you need to check your latest added contribution install info / readme again Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
mergedplot Posted April 20, 2003 Author Share Posted April 20, 2003 Thanks guys. Spent some time on it last night, found out it was indeed that tracking thing I installed (but since uninstalled) but must have left a file in there. I think it was one of the order.php files in the function dir... Anyway, all set now. Thanks, Matt Link to comment Share on other sites More sharing options...
mergedplot Posted April 20, 2003 Author Share Posted April 20, 2003 Which begs the question, is there a UPS/FedEx/USPS tracking mod that works with the latest MS1? Thanks, Matt Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.