MISSING FILES FOR SEARCH ON WEB SITE PLEASE HELP !

[webstarter]

Hi there can anyone tell me what php files need to be where for the qucik find area on my web site as I'm am sure I am missing a file or maybe there is one in the wrong place as when my customers search for an item they get this come up on the page

 

Products meeting the search criteria

 

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

 

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and c.categories_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%kkk%' or p.products_model like '%kkk%' or m.manufacturers_name like '%kkk%') )

 

[TEP STOP]

 

 

Please help thank you I will be very greatful

[ozcsys]

Hi there can anyone tell me what php files need to be where for the qucik find area on my web site as I'm am sure I am missing a file or maybe there is one in the wrong place as when my customers search for an item they get this come up on the page

 

Products meeting the search criteria

 

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

 

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and c.categories_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%kkk%' or p.products_model like '%kkk%' or m.manufacturers_name like '%kkk%') )

 

[TEP STOP]

 

 

Please help thank you I will be very greatful

 

 

 

I do not believe that there is a status field in the categories table in a default install of osC. My guess is that you have installed a contribution without running the sql files or command that was included

[webstarter]

I do not believe that there is a status field in the categories table in a default install of osC. My guess is that you have installed a contribution without running the sql files or command that was included

 

Please could you surgest what I should do as I'm new to all this ? Thank You

[webstarter]

I do not believe that there is a status field in the categories table in a default install of osC. My guess is that you have installed a contribution without running the sql files or command that was included

 

 

I do not believe that there is a status field in the categories table ? What does this mean please I'am a new user does this mean I would need to add a php file somewhere or is it missing a line ? Thank You

[ozcsys]

I do not believe that there is a status field in the categories table ? What does this mean please I'am a new user does this mean I would need to add a php file somewhere or is it missing a line ? Thank You

 

 

What it means is that your file is querying the database for the following field

 

'c.categories_status'

 

and it is not in your database. Since this field does not exist in a default install of osC then it must have been added to the file later one problably when you (or someone) installed a contribution. When the changes were made to the files during the install of the contribution you ( or someone) should have also made the needed changes to the database. You need to look at the files that came with the contribution and look for the sql files or commands and run them via phpmyadmin.

[webstarter]

What it means is that your file is querying the database for the following field

 

'c.categories_status'

 

and it is not in your database. Since this field does not exist in a default install of osC then it must have been added to the file later one problably when you (or someone) installed a contribution. When the changes were made to the files during the install of the contribution you ( or someone) should have also made the needed changes to the database. You need to look at the files that came with the contribution and look for the sql files or commands and run them via phpmyadmin.

 

Thank you very much for your help it is all now back to normal and working again.

 

The modifaction I was trying out was this one is it just as simple as adding php over another or is it a bit more involved. ? ( enable_disable_categories_1.6.1.2 ) Is there any advice I need to know for this mod or is it quite simple I really wanted just to be able to turn on and off the catogrie areas like in the products area with the green light and red light is there any simpler way as this one I downloaded seams to have a few more extras after it ?.

 

:blink:

[ozcsys]

Thank you very much for your help it is all now back to normal and working again.

 

The modifaction I was trying out was this one is it just as simple as adding php over another or is it a bit more involved. ? ( enable_disable_categories_1.6.1.2 ) Is there any advice I need to know for this mod or is it quite simple I really wanted just to be able to turn on and off the catogrie areas like in the products area with the green light and red light is there any simpler way as this one I downloaded seams to have a few more extras after it ?.

 

:blink:

 

 

You need to find the sql file or commands and then run them using phpmyadmin (found in your hosting control panel. )

 

Basically you skipped part of the install process and you need to complete it.

[webstarter]

You need to find the sql file or commands and then run them using phpmyadmin (found in your hosting control panel. )

 

Basically you skipped part of the install process and you need to complete it.

 

As you can see I'am a new user so would you be able to tell me where exactley I can find this phpmyadmin (found in your hosting control panel. ) ? And once I have got there what actions need to be taken out after thank you very much what does it actualy do ?

:blink:

[webstarter]

You need to find the sql file or commands and then run them using phpmyadmin (found in your hosting control panel. )

 

Basically you skipped part of the install process and you need to complete it.

 

As you can see I'am a new user so would you be able to tell me where exactley I can find this phpmyadmin (found in your hosting control panel. ) ? And once I have got there what actions need to be taken out after thank you very much what does it actualy do ?

:blink:

[webstarter]

You need to find the sql file or commands and then run them using phpmyadmin (found in your hosting control panel. )

 

Basically you skipped part of the install process and you need to complete it.

 

Hi there what area of these do I find it in and also what do I need to do once I get there ? Please could you explain what it will acctualy do sorry to be such a pain. Thank You

 

Configuration

Configuration

My Store, Logging, Cache

 

Modules

Modules

Payment, Shipping

Catalog

Catalog

Contents, Manufacturers

 

Locations / Taxes

Locations / Taxes

Countries, Tax Zones

Customers

Customers

Customers, Orders, Birthdays

 

Localization

Localization

Currencies, Languages

Reports

Reports

Products, Orders

 

Tools

Tools

Backup, Banners, Files

:blink: