Accidentally dropped categories_image field from database

[Guest]

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

[Guest]

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.

[Guest]

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 :)