Why can't you place links to other sites on iPage?

Click Here To View All Answers...

First off, Why can't you place links to other sites on iPage? Many thanks for any response. 2nd question I got is.. 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'.


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.


Comments (5)

I'm stumped. I'm not so sure what is the right answer to your question. I'll do some investigation and get back to you if I got an anything. You should email the people at iPage as they probably could answer your iPage question..

Comment #1

Please forgive my apparent ignorance but -.


Could you please speak in english? what does "" 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..

Comment #2

Go to google, copy/paste that into the box, and click "Search".....

Comment #3


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 iPage 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.


Comment #4

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!.

Now everything is cool and I may get some orders now!..

Comment #5

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!.


Comment #6

This question was taken from a support group/message board and re-posted here so others can learn from it.