Jump to content

cdamianou

Members
  • Content count

    236
  • Joined

  • Last visited

Everything posted by cdamianou

  1. cdamianou

    Bundled products

    Im ryng to egt this contribution to work, but no luck. I try to add and confirm bundled products, but i get the following error. 1054 - Unknown column 'products_bundle' in 'field list' insert into products_description (products_name, products_bundle, products_description, products_url, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_id, language_id) values ('testing', 'e', 'ddfdsf', '', '', '', '', '328', '1') [TEP STOP] Can anyone help Thanks
  2. cdamianou

    Bundled products

    Thanks Steve I pressume i just us ethe following in the query box, and it should delete everything for bundled Products? DELETE FROM products_bundles Then i just run the sql file again, hopefully it will work ok? Thanks Costas
  3. cdamianou

    Bundled products

    Sorry Steve Can you explain how to do this. You are probably sayng, oh my God, this Guy is useless. Sorry mate. Im still learning SQL basics. I can add queries etc, but delete items, well, maybe with your help on this, i will learn something else about SQL. Thanks in advance
  4. cdamianou

    Bundled products

    Anyone?
  5. cdamianou

    Bundled products

    Ive changed Product Bundles in database to 'tinyint' but i get the following error Error SQL-query : ALTER TABLE `products_bundles` CHANGE `bundle_id` `bundle_id` TINYINT( 6 ) DEFAULT '0' NOT NULL MySQL said: #1062 - Duplicate entry '127-11' for key 1 Any ideas?
  6. cdamianou

    Bundled products

    Ive added the following ALTER TABLE `yourdatabasenamehere`.`products` ADD `products_bundle` TINYTEXT NOT NULL But i get this message after the query MySQL said: #1060 - Duplicate column name 'products_bundle'
  7. cdamianou

    Bundled products

    How do i add this, or whats the Query. My egnorance is showing again
  8. cdamianou

    Bundled products

    Can anyone help? Thanks
  9. cdamianou

    Bundled products

    Hi can someone help me please. I have ionstalled this mod, but i am getting the following error. 1054 - Unknown column 'products_bundle' in 'field list' insert into products_description (products_name, products_bundle, products_description, products_url, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_id, language_id) values ('test', 'e', 'hkjh', '', '', '', '', '325', '1') [TEP STOP] I cant figure out the problem. My Catalogue.php file is as follows
  10. cdamianou

    Bundled products

    Hi Is their anyone willing to atempt this instelation for me? Of course you will be rewarded. Thanks in advance
  11. cdamianou

    print_catalog v1.1

    Can someone please help me. I have installed version 3, evrything works apart from the acending and descending pics dont show. Here is the link http://www.worldmagicshop.co.uk/catalog_pr...with_images.php I checked the instellation, everything is fine. I dont understand this. Please help.
  12. cdamianou

    Customer Rewards/ Point System

    I have installed a contribution that does something similar, its called Cutomer Loyalty scheme
  13. cdamianou

    Shop By price

    Hi I installed the shop by price contributioon and works perfectly, however when you click on one of the price options the list of products dosnt show the descriptions of the products. Can anyone help. Thanks
  14. cdamianou

    Bundled products

    Update to my querys. Its the following i do not understand 1) add 'products_bundle' => '', after $parameters = array('products_name' => '', (line 358) 2) insert "p.products_bundle," into the SQL query one line below this one (LINE 377) if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) { so the whole line shoud be: $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_bundle from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); 3) add if (isset($pInfo->products_bundle) && $pInfo->products_bundle == "yes") { // this product is a bundle so get contents data $bundle_query = tep_db_query("SELECT products_bundles.subproduct_id, products_bundles.subproduct_qty, products_description.products_name FROM products_description INNER JOIN products_bundles ON products_bundles.subproduct_id=products_description.products_id WHERE products_bundles.bundle_id = " . $pInfo->products_id . " and language_id = '" . (int)$languages_id . "'"); while ($bundle_contents = tep_db_fetch_array($bundle_query)) { $bundle_array[] = array('id' => $bundle_contents['subproduct_id'], 'qty' => $bundle_contents['subproduct_qty'], 'name' => $bundle_contents['products_name']); } } ten lines lower than the above SQL query, just after the closing curly bracket "}" and before the code section starting with $manufacturers_array = array(array('id' => '', 'text' => '')); 4) add ", p.products_bundle" after p.manufacturers_id into the query on line 72, so the whole line is as follows: $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_bundle from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); 5) STEP 4 : create a table to store the bundle information. Run this SQL in your phpMyAdmin to add the table automatically. *************************************************************** CREATE TABLE `products_bundles` (`bundle_id` SMALLINT NOT NULL, `subproduct_id` SMALLINT NOT NULL, `subproduct_qty` TINYINT NOT NULL , PRIMARY KEY (`bundle_id`, `subproduct_id`)) Sorry if this is allot Thanks In Advance
  15. cdamianou

    Bundled products

    So far so good however i have encountered a confusion at the following part that says add 'products_bundle' => '', after $parameters = array('products_name' => '', (line 358) Dont understand this part. Thanks
  16. cdamianou

    Bundled products

    Hi Sorry if i have got this wrong. I pressume i run the 2 above as 2 seperate SQL queries? Thanks
  17. cdamianou

    Bundled products

    I have access to PHPmy Admin, but not shure exactly how to acomplish that pasrt of the install. everything else looks straight forward. Thanks Costas
  18. cdamianou

    Bundled products

    I am having trouble understanding the install of this mod. I am not a very advance oscommecer/ I was wondering if their was anyone that was willing to help with the install. Thanks Costas
  19. cdamianou

    LiveSupport v1.2c Always Says Already OPen?

    I cant seem to locate the latest 1.3Version. Anyone got a link? Thanks
  20. cdamianou

    LiveSupport v1.2c Always Says Already OPen?

    Same problema as well. When i activate Live support, it says that a user is waiting to talk to me. Its a name i was using a while ago, and my system crashed, and for some reason, that username is alsways connected when i activate live support.
  21. Thats only helpfull if you have weight on your products. If you dont and you whant to do it by price then that whont work.
  22. I have been tryng for the past few months to fins a solution, and still havent found anything. Shurely their is someone out their that can help.
  23. cdamianou

    Worldpay support III

    I believe Worlpay accepts payment by Switch, however when someone goes to checkout and to the worldpay transaction page the only option available is mastercard, visa and visa delta. Can someone expolain how to set worldpay up in order to accept switch. Thanks In Advance
  24. cdamianou

    Worldpay support III

    I have installed the worldpay 4.0 v 1.4 module, followed the instrunction. Ive got up to where i have to go to admin and click the Green Button to activate, but i get the following error Warning: call_user_func() expects first argument, 'tep_get_order_status_name', to be a valid callback in /homepages/37/d71334475/htdocs/store/admin/includes/functions/general.php on line 1253 Can someone help please. Thanks
  25. cdamianou

    [Contribution] Dynamic MoPics v2.2

    Sorry, i didnt realise.
×