Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

UNABLE TO ADD NEW Categories


atlantis

Recommended Posts

WHEN I TRY TO ADD A NEW CATEGORIE I GET THE BELOW ERROR, IT ONLY HAPPENS IF YOU ADD A NEW CATEGORIE, HOWEVER IF YOU ADD A NEW PRODUCT ITS FINE, COULD DO WITH SOME HELP WITH THIS

 

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

 

insert into categories (sort_order, categories_status, parent_id, date_added) values ('', '', '0', now())

Link to comment
Share on other sites

  • 2 months later...

Hi Atlantis,

 

Thx - I couldn't reinstall here but I worked out a fix:

 

Create a new field in the categories table, making sure it is set up for the following:

 

field: categories_status

type: tinyint(4)

Null: Yes

Default: NULL

 

And this solved it. Thanks for sending the reply so fast though.

 

See you on the next problem ;)

 

Best,

 

Kino

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...