Enable & Disable Categories

[Karole]

Hi,

I just installed (or attempted to install) this contribution. I failed miserably it seems. I went to the site and this is what the main page says:

 

1054 - Unknown column 'c.categories_status' in 'where clause'

 

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

 

[TEP STOP]

 

AND

The admin section says this when I click on the categories:

 

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]

 

I am VERY limited in my knowledge of all of this, I can follow instructions though.

 

Any help would be appreciated.

 

~:~ Karole

[RazorSharp]

Karole:

 

Have you added categories_status to your database? It can not find that field.

 

YOU MUST HAVE FORGOT THIS STEP IN THE README FILE

 

Installation:

 

Copy each of the files included to their appropriate locations, then Run

the following SQL statement:

 

ALTER TABLE categories ADD categories_status TINYINT(1) UNSIGNED DEFAULT "1" NOT NULL;

 

 

Hope this helps.

 

RazorSharp

[Karole]

Thank you, thank you, thank you.

Apparently I can NOT follow directions very well. That was it, I didn't put in the db information.

I suppose this is how we learn, by our mistakes. :)

 

~:~ Karole

[loxly]

Yes, it is how we ALL learn and KEEP learning.

 

Now go grap another mod and try to install it... quick before you get scared off!!!!

[Druide]

Yes, it is how we ALL learn and KEEP learning.

 

Now go grap another mod and try to install it... quick before you get scared off!!!!

 

oh my....

 

 

we dont want that to happen to ANY member/guest

 

It's way to much fun when you solved 'another error' from your store, that will keep you updating it :)

[loxly]

LOL, it's like falling off a horse, you have to get right back on or you might not......

 

We love challenges though, that's why we are here right?

 

And I guess I can't spell either.... you all know I meant GRAB right??????

 

8)

[Karole]

Thank you all for the encouragement.

 

I am going to be tackeling a few more contributions....so I am sure you will be hearing from me :D

 

~:~ Karole

[jonathanprice2001]

How do you run this statement?

 

ALTER TABLE categories ADD categories_status TINYINT(1) UNSIGNED DEFAULT "1" NOT NULL;

 

 

Thanks,

Jonathan

[sdowns]

After installing Disable/Enable Categories I have the same error:

1054 - Unknown column 'p.products_image_med' in 'field list'

.

This error message is only shown on the bottom of the Categories pages where the New Products infobox* should be.

 

 

It must be related to this: when I imported enable_disable_categories.sql, I got the following error from phpMyAdmin:

#1060 - Duplicate column name 'categories_status

.

:rolleyes: Any ideas what is causing the error?

 

* In my case its the Featured Products v1.6.3 infobox.

[♥geoffreywalton]

The duplicate message means when you tried to run the sql, the field categories_status already exists, so if you are running it again you would expect to get this message.

 

The unknown column message means either the field has not been created or it could be you are installing a contribution written for mysql4 on a server running mysql5.

 

Open enable_disable_categories.sql and see it refers to this field otherwise post again.

 

G

[sdowns]

After installing Disable/Enable Categories I have the same error:

1054 - Unknown column 'p.products_image_med' in 'field list'

.

This error message is only shown on the bottom of the Categories pages where the New Products infobox* should be.

 

 

It must be related to this: when I imported enable_disable_categories.sql, I got the following error from phpMyAdmin:

#1060 - Duplicate column name 'categories_status

.

:rolleyes: Any ideas what is causing the sql error?

* In my case its the Featured Products v1.6.3 infobox.

:blush: Turns out it was caused by index.php in Featured Products v1.6.3.