Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Accidentally dropped categories_image field from database


Guest

Recommended Posts

Can anyone out there that knows SQL please help me!

 

When trying to get rid of category images, I just accidentally dropped the categories_image field from the database.

 

Now I'm getting this error:

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

 

select cd.categories_name, c.categories_image from categories c, categories_description cd where c.categories_id = '21' and cd.categories_id = '21' and cd.language_id = '1'

 

[TEP STOP]

 

on the pages that should have the category image: http://www.chiclingerie.com.au/store/index.php?cPath=21

 

What can I do to get the field back?

 

I am sweating here at the moment.

 

Any help would be much appreciated!!

 

Ta,

Leah

Link to comment
Share on other sites

use the phpmyadmin tool and edit the categories table. Add the categories_image column as varchar(64) default null. However you will have to re-assign an image for each category afterwards.

Link to comment
Share on other sites

use the phpmyadmin tool and edit the categories table. Add the categories_image column as varchar(64) default null. However you will have to re-assign an image for each category afterwards.

 

Thank you so much Mark! I have done this now. Luckily I didn't have any images in there!

 

Cheers,

Leah :)

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...