Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Kelkoo Adon Please Help


Esmir

Recommended Posts

Hi

Wen installed Kelkoo feture i get folowing error

 

Kategori Produkt Status Action

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

 

select p.products_id, p.products_compare_status, p.products_quantity, p.products_price, p.products_tax_class_id, pd.products_name, cd.categories_name from products p, products_description pd, products_to_categories p2c, categories c, categories_description cd WHERE p.products_id = pd.products_id AND (cd.categories_id = c.parent_id OR (c.parent_id = 0 AND cd.categories_id = c.categories_id)) AND p.products_id = p2c.products_id AND c.categories_id = p2c.categories_id AND p.products_status = 1 AND p.products_price <> 0 AND pd.language_id = '4' AND cd.language_id = '4' AND pd.products_name like '%%' group by p.products_id, cd.categories_id order by cd.categories_name, pd.products_name

 

I think it is becouse i ignored the first 2 steps in the instalation since i dont get it

i have no clue what to do in those 2 steps

 

-----------------------------------------------------------------------------------------

#1# ADD fields for status and delivery cost in the table products :

-----------------------------------------------------------------------------------------

ALTER TABLE `products` ADD `products_compare_status` TINYINT( 1 ) DEFAULT '1' NOT NULL ;

ALTER TABLE `products` ADD `products_compare_expedition` VARCHAR( 20 ) ;

 

 

-----------------------------------------------------------------------------------------

#2# inser in the table configuration definition for default delivery cost

-----------------------------------------------------------------------------------------

INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('delivery cost for KELKOO', 'EXPEDITION_PRICE', 'no charge', 'Tip default delivery cost :<br>ex: "free over 50" (max 20 characteres)', 7, 99, now(), now(), NULL, NULL);

 

Please help me cleare this out

 

Sincerely

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...