Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

account error


srober

Recommended Posts

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

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

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

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

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

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

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

  • 4 weeks later...
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

  • 2 years later...

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...