chrometweaks.org

Need help with Apache, iPage and routers?

Click Here To View All Answers...


First of all Need help with Apache, iPage and routers? Hoping for any response. Another question... I hope somebody can help me out there!.

My iPage site is encountering a problem once an order is confirmed..

The error reads, on a new, white & blank page (apart from message at the top):.

1054 - Unknown column 'orders_status_id' in 'field list'.

Insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('7', '1', now(), '1', '').

[TEP STOP].

Any help at all in this would be much appreciated...

Comments (78)

I would like to know the answer too. Anyone here know what is the right answer. I'll do some poking around and get back to you if I find an anything. You should email the people at iPage as they probably can answer it..

Comment #1

Thanks very much for quick reply, the unfortunate thing is that I am a complete novice at all this & am not sure what exactly I need to do..

I.e wouldn't really know what I should be looking for, or where for that matter..

Any further help would be great!..

Comment #2

Who can access your database - is it you or is it your host?.

You need to be able to access your table structures - done via phpmyadmin..

This post has been edited by.

Yesudo.com.

: 10 February 2004, 19:07..

Comment #3

Cheers guys, thanks for the replies. As I said, I am new to this but trying to get to grips with everything as fast as possible!!.

I now know where you mean, what exactly should I now do in phpMyAdmin ? .

I appreciate your patience!!..

Comment #4

Choose your store database on the left - this will show all the tables within your database on the left..

Then choose the...........sorry, forgotten which table we are looking at - ahh the orders_status_history table and on the right you will get a list of the fields/columns within that table..

Check that the field/column 'orders_status_id' exists..

This error message, suggests that it doesn't..

1054 - Unknown column 'orders_status_id' in 'field list'.

Insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('7', '1', now(), '1', '').

[TEP STOP].

If it doesn't you need to add it. check first if it needs to be added let us know and we can talk you through it - just want to make sure I am not barking up the wrong tree...

Comment #5

Found it, & yes, it needs to be added!!.

Any help on this would be great, you've really helped so far!!..

Comment #6

There should be an option to add a new field(At End Of Table).

Choose this then enter.

In Field enter - orders_status_id.

In Type enter - int.

In Length enter - 5.

In Null enter - not null..

Comment #7

I hope somebody can help me out there!.

My iPage site is encountering a problem once an order is confirmed..

The error reads, on a new, white & blank page (apart from message at the top):.

1054 - Unknown column 'orders_status_id' in 'field list'.

Insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('7', '1', now(), '1', '').

[TEP STOP].

Any help at all in this would be much appreciated...

Comment #8

Doesn't appear this - orders_status_id - appears in the orders_status_history table..

You may want to check the columns in that table..

This post has been edited by.

Yesudo.com.

: 10 February 2004, 17:13..

Comment #9


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