cabachona Posted November 29, 2008 Share Posted November 29, 2008 Help please. I know this is somewhere in this forum, I have seen it before, however do you think I can find it? Can someone please direct me to the solution, or else help me out a bit. I cannot find what the problem is as I am sure that I tested my new data base when it was uploaded to a new server. It was a clean installation and I just uploaded the database with clients, inventory and pics were uploaded via ftp. I have had no orders, now I think I know why! 1054 - Unknown column 's.public_flag' in 'where clause' select count(*) as total from orders o, orders_status s where o.customers_id = '3' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1' [TEP STOP] This message appears when my clients go to log in. They can register with no problems, though cannot re-log in. What do I do here please. Any othe 1054 messages I have found in these forums have to do with inventory. Looking forward to hearing from someone. Thanks :( worried. Unconditional Love Makes The World Turn. When we stop and smell the flowers, we can all live instead of merely existing. We spend too much time infront of computers daily and not enough time in wonderment and awe at what we can achieve in life. creating these beasts is both a blessing and a curse! Believe in yourself as though no one else will and you will find that The World will begin to believe in You Too! Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted November 29, 2008 Share Posted November 29, 2008 site:www.oscommerce.com/forums "select count(*) as total from orders o, orders_status s where o.customers_id" Seems to give the solution 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...
cabachona Posted December 3, 2008 Author Share Posted December 3, 2008 site:www.oscommerce.com/forums "select count(*) as total from orders o, orders_status s where o.customers_id" Seems to give the solution Please forgive my apparent ignorance but - :huh: ? Could you please speak in english? what does "www.oscommerce.com/forums" have to do with this? I thought I was already in the forums. Can you give me any clue as to where to put this line? that is what file? I open up my file manager and I see a "sea of files" all could do something if I only knew! Thanks so much for your help Unconditional Love Makes The World Turn. When we stop and smell the flowers, we can all live instead of merely existing. We spend too much time infront of computers daily and not enough time in wonderment and awe at what we can achieve in life. creating these beasts is both a blessing and a curse! Believe in yourself as though no one else will and you will find that The World will begin to believe in You Too! Link to comment Share on other sites More sharing options...
germ Posted December 3, 2008 Share Posted December 3, 2008 Go to google, copy/paste that into the box, and click "Search"... If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there > Link to comment Share on other sites More sharing options...
FIMBLE Posted December 3, 2008 Share Posted December 3, 2008 Hiya, Try to run this in your phpmyadmin alter table orders_status add public_flag int DEFAULT '1'; IF you are not sure Log into your WEB SITE control panel, then look for SQL, you should see a link for phpmyadmin click on it and a new windoe should appear, from the left hand menu select your database (might be in a drop down box) once your database loads in the main window, you will see a menu across the top. one of these is called SQL click on this, a box will appear in this paste the code above, then click the GO button on the bottom right Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
cabachona Posted December 4, 2008 Author Share Posted December 4, 2008 Hiya, Try to run this in your phpmyadmin alter table orders_status add public_flag int DEFAULT '1'; IF you are not sure Log into your WEB SITE control panel, then look for SQL, you should see a link for phpmyadmin click on it and a new windoe should appear, from the left hand menu select your database (might be in a drop down box) once your database loads in the main window, you will see a menu across the top. one of these is called SQL click on this, a box will appear in this paste the code above, then click the GO button on the bottom right Nic Thank you so much Nic for your great helpful advice. I followed everything to the letter and this was by far the easier solution to use! Greatly appreciated! Thank you! Thank you! As I consider myself still to be a rank beginner with OsCommerce, I am really GRATEFUL for any help I get. I installed this version as a fresh install. (After I had tried to do an update once and failed dismally, I decided this was by far the easier solution to use) So I looked at the other two solutions which mentioned that I should have changed some coding somewhere, I had no real idea where to do this. I like this SQL solution you gave me! Ta very muchly! :rolleyes: Now everything is cool and I may get some orders now! B) Unconditional Love Makes The World Turn. When we stop and smell the flowers, we can all live instead of merely existing. We spend too much time infront of computers daily and not enough time in wonderment and awe at what we can achieve in life. creating these beasts is both a blessing and a curse! Believe in yourself as though no one else will and you will find that The World will begin to believe in You Too! Link to comment Share on other sites More sharing options...
cabachona Posted December 4, 2008 Author Share Posted December 4, 2008 Go to google, copy/paste that into the box, and click "Search"... This worked, though I still felt I was in the dark and Nic's solution below looked much easier! However thanks for the hint. I didn't know this method would work so well. I will use it more in future! Cheers :rolleyes: Unconditional Love Makes The World Turn. When we stop and smell the flowers, we can all live instead of merely existing. We spend too much time infront of computers daily and not enough time in wonderment and awe at what we can achieve in life. creating these beasts is both a blessing and a curse! Believe in yourself as though no one else will and you will find that The World will begin to believe in You Too! Link to comment Share on other sites More sharing options...
FIMBLE Posted December 4, 2008 Share Posted December 4, 2008 Glad to help :-) Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.