chrometweaks.org

Thinking of moving from iPage to fatcow?

Click Here To View All Answers...


Question I have... Thinking of moving from iPage to fatcow? Hoping for any response. Another quick question... Hi al this is all I get frommy contral Panel Categories / Products Status Action.

1054 - Unknown column 'c.categories_status' in 'field list'.

Select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name.

[TEP STOP].

Can any one help me plz.

Angel..

Comments (68)

That's a good question. I'm not sure what is the right answer. I'll do some poking around and get back to you if I bump into an useful answer. You should email the people at iPage as they probably can answer it..

Comment #1

Before you start removing stuff, you should find out how it got there. but c.categories status is apparently not a field in your database. you need to find where that query is in the code of the page you are getting the error on and remove it from there...

Comment #2

Thanks m8.

Do you now a lont about OSC I have a nother problem..

Comment #3

You need to go back through your contributions step by step, also make sure that any SQL tables which needed to be modified, you have done so. I make a checklist when making changes, as well as document within the program by DATE that I start that particular contribution. This way, I can search my whole hard drive for that particular string and every file which has that in there, I will find my lines of code added. It eliminates errors..

On another issue gottaloveit, in your signature area, where you have stated 'Some osc sites ...' this can be taken as advertising, and is against forum rules. No posting of any web address, etc is allowed in the signature area. If requesting help, a iPage domain is allowable, also in the area of talking about your store. No where else is it allowed...

Comment #4

Thank you sir for that information. I apparantly was breaking the rules. Sorry if my intentions were to share ideas with people...

Comment #5

You are more than welcome to post in the ChatterBox area, My Store and people can make comments, etc. your remark under your signature is questionable..

Comment #6

Hi al this is all I get frommy contral Panel Categories / Products Status Action.

1054 - Unknown column 'c.categories_status' in 'field list'.

Select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name.

[TEP STOP].

Can any one help me plz.

Angel..

Comment #7

Did you install any contributions? it's looking for the field "status" in your "categories" table, which isn't there by oscommerce base install...

Comment #8


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