srober Posted February 1, 2008 Share Posted February 1, 2008 1054 - Unknown column 's.public_flag' in 'where clause' select count(*) as total from orders o, orders_status s where o.customers_id = '314' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1' [TEP STOP] this happends when the customer goes to his/her account page. Link to comment Share on other sites More sharing options...
srober Posted February 1, 2008 Author Share Posted February 1, 2008 1054 - Unknown column 's.public_flag' in 'where clause' select count(*) as total from orders o, orders_status s where o.customers_id = '314' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1' [TEP STOP] this happends when the customer goes to his/her account page. Hello OSCommerce comunity :-" Link to comment Share on other sites More sharing options...
Guest Posted February 1, 2008 Share Posted February 1, 2008 Hello OSCommerce comunity :-" Hello. Try Google, it is a search engine. It is quicker fo you to search for the specifics of your sitauation than for me to ask questions. Put in oscommerce 1054 - Unknown column 's.public_flag' in 'where clause' select count It is probably something that has not been updated. Link to comment Share on other sites More sharing options...
gomikeyp Posted February 3, 2008 Share Posted February 3, 2008 Googling it brings it back to this thread haha Link to comment Share on other sites More sharing options...
srober Posted February 4, 2008 Author Share Posted February 4, 2008 Yea as if I didnt use search engines before I posted. Obviously I could not find a answer or I would not of posted to begin with. If you looked at my join date you would notice Im not some impatient newb that just downloaded oscommerce and got stuck in the first 5min............. Thanks though. Link to comment Share on other sites More sharing options...
Mav666 Posted February 4, 2008 Share Posted February 4, 2008 ummm, I don't think the field public_flag is standard, using any contribs? Do you have a field called public_flag in the table order_status? If not, it would indeed be an unknown column ... :thumbsup: Even at a Mensa convention someone is the dumbest person in the room. Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted February 4, 2008 Share Posted February 4, 2008 Same answer as in http://www.oscommerce.com/forums/index.php?sho...=290468&hl= No solution there but once those steps followed the problem is identified. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
gomikeyp Posted February 5, 2008 Share Posted February 5, 2008 I just ran these SQL queries and fixed the problem! Thanks so much! ;) alter table banners add index idx_banners_group (banners_group); alter table banners_history add index idx_banners_history_banners_id (banners_id); alter table currencies add index idx_currencies_code (code); alter table customers add index idx_customers_email_address (customers_email_address); alter table customers_basket add index idx_customers_basket_customers_id (customers_id); alter table customers_basket_attributes add index idx_customers_basket_att_customers_id (customers_id); alter table orders add index idx_orders_customers_id (customers_id); alter table orders_products add index idx_orders_products_orders_id (orders_id); alter table orders_products add index idx_orders_products_products_id (products_id); alter table orders_status_history add index idx_orders_status_history_orders_id (orders_id); alter table orders_products_attributes add index idx_orders_products_att_orders_id (orders_id); alter table orders_products_download add index idx_orders_products_download_orders_id (orders_id); alter table products add index idx_products_model (products_model); alter table products_attributes add index idx_products_attributes_products_id (products_id); alter table reviews add index idx_reviews_products_id (products_id); alter table reviews add index idx_reviews_customers_id (customers_id); alter table specials add index idx_specials_products_id (products_id); alter table zones add index idx_zones_to_geo_zones_country_id (zone_country_id); alter table orders_status add public_flag int DEFAULT '1'; alter table orders_status add downloads_flag int DEFAULT '0'; alter table orders modify payment_method varchar(255) NOT NULL; alter table whos_online modify last_page_url text NOT NULL; Link to comment Share on other sites More sharing options...
Andyman1 Posted March 4, 2008 Share Posted March 4, 2008 I just ran these SQL queries and fixed the problem! Thanks so much! ;) alter table banners add index idx_banners_group (banners_group); alter table banners_history add index idx_banners_history_banners_id (banners_id); alter table currencies add index idx_currencies_code (code); alter table customers add index idx_customers_email_address (customers_email_address); alter table customers_basket add index idx_customers_basket_customers_id (customers_id); alter table customers_basket_attributes add index idx_customers_basket_att_customers_id (customers_id); alter table orders add index idx_orders_customers_id (customers_id); alter table orders_products add index idx_orders_products_orders_id (orders_id); alter table orders_products add index idx_orders_products_products_id (products_id); alter table orders_status_history add index idx_orders_status_history_orders_id (orders_id); alter table orders_products_attributes add index idx_orders_products_att_orders_id (orders_id); alter table orders_products_download add index idx_orders_products_download_orders_id (orders_id); alter table products add index idx_products_model (products_model); alter table products_attributes add index idx_products_attributes_products_id (products_id); alter table reviews add index idx_reviews_products_id (products_id); alter table reviews add index idx_reviews_customers_id (customers_id); alter table specials add index idx_specials_products_id (products_id); alter table zones add index idx_zones_to_geo_zones_country_id (zone_country_id); alter table orders_status add public_flag int DEFAULT '1'; alter table orders_status add downloads_flag int DEFAULT '0'; alter table orders modify payment_method varchar(255) NOT NULL; alter table whos_online modify last_page_url text NOT NULL; This won't erase any current tables right? Link to comment Share on other sites More sharing options...
medalta Posted October 26, 2010 Share Posted October 26, 2010 I just encountered the same problem and ran this and it worked like a dream Thanks Link to comment Share on other sites More sharing options...
Getting Smarter Slowly Posted October 27, 2010 Share Posted October 27, 2010 Yea as if I didnt use search engines before I posted. Obviously I could not find a answer or I would not of posted to begin with. If you looked at my join date you would notice Im not some impatient newb that just downloaded oscommerce and got stuck in the first 5min............. Thanks though. . Whew! So that's how some people look at us, huh? Wow! I never got that feeling - directly that is! You're never too old to learn. Even an old fart like myself loves learn and be creative. ?>if (empty($coffee)) {$coffee=new coffee();}<? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.