Jump to content

katiallo

Members
  • Content count

    64
  • Joined

  • Last visited

Everything posted by katiallo

  1. katiallo

    Official PayPal IPN Support Thread

    Hello all, I've installed PayPal IPN v2.3.4 I went to test it and I got the following message 'Paypal does not allow your country of residence to ship to the country you wish to' how can I correct this? Thank you
  2. Shipping and handling charges are not added to the total. Can someone please help me to correct this problem? Thanks in advance
  3. katiallo

    Seperate Pricing Per Customer v3.5

    Thank you JanZ for all your help :) :) Everything is now working
  4. katiallo

    Seperate Pricing Per Customer v3.5

    Thank you JanZ I'm very new to this and I tried to change the query but I'm getting errors. Is it possible to help me? here is my allproducts query: $listing_sql = "select p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id $where order by pd.products_name"; and print_catalog $print_catalog_query_raw = "select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, cd.categories_name, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id=p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id=c.categories_id left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on c.parent_id='0' and c.categories_id=cd.categories_id left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by cd.categories_name, c.parent_id, c.sort_order, c.categories_id, pd.products_name"; I'm very thankfull for the contribution and help you provided.
  5. katiallo

    Seperate Pricing Per Customer v3.5

    Janz, I got these contributions finaly working but I do have a small problem. Products are visible on 'Printable Catalog' and "View all Products' how can I correct that? Thank you again
  6. katiallo

    Seperate Pricing Per Customer v3.5

    Hello, I have a small problem. I also have 'all products' contribution installled and all products there are visible even if I hide from groups. Is there code to use in this situation? Thank you
  7. katiallo

    RSS News

    How come only one is working? and ofcource the one I don't realy want....lol http://www.indulgefashion.com.au/indulge_news.xml http://www.fashionarticles.org/fashion/rss/Lingerie/136 http://www.reprint-content.com/rss/Lingerie/178 www.blushlingerie.co.uk/blog/?feed=rss2 only this one is working for me http://fashion-era.com/footer/rss.xml why is that?
  8. katiallo

    RSS News

    Ok Jack found one that works....I guess was nothing wrong with contribution. Thank you
  9. katiallo

    RSS News

    I did Jack. I'm still getting the error,
  10. katiallo

    RSS News

    I have this contribution installed for some time now. Suddently it doesn't dispay and I'm getting this error: XML error: SYSTEM or PUBLIC, the URI is missing at line 2 thank you all for your help.
  11. katiallo

    Seperate Pricing Per Customer v3.5

    These lines are the same as in my file.
  12. katiallo

    Seperate Pricing Per Customer v3.5

    Hi I'm sorry of being a bother. I have a few problems with this contribution and I need help to fix them. 1. When logged in all products are visible even if I hide them from a group. 2. When I go to login I don't get a choice of groups or enything like that. 3. I have so far 2 groups when I tried to add another I got this message at login: Warning: implode() [function.implode]: Bad arguments. in /home/xxxxxx/public_html/includes/functions/general.php on line 1339 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 select p.products_id, find_in_set('1', products_hide_from_groups) as hide_or_not, find_in_set('1', categories_hide_from_groups) as in_hidden_category from products p left join products_to_categories p2c using(products_id) left join categories c using(categories_id) where p.products_id in () 4. I cannot edit in admin under configuration/customer details 'Default Customer Group and Visitor Pricing Group': I have this error: Fatal error: Call to undefined function tep_cfg_pull_down_cg_list() in /home/xxxxxx/public_html/admin/configuration.php(125) : eval()'d code on line 1 Warning: call_user_func(tep_cfg_get_customer_group) [function.call-user-func]: First argument is expected to be a valid callback in /home/xxxxxx/public_html/admin/includes/functions/general.php on line 1315 5. In admin catalog/products when at editing that page still looks funny. Its like two pages in one. "categories/products and edit in one page". Thanks to JanZ some errors before where fixed. Fields in database are: customers_group_id smallint(5) unsigned customers_group_name varchar(32) customers_group_show_tax enum('1','0') customers_group_tax_exempt enum('0','1') group_payment_allowed varchar(255) group_shipment_allowed varchar(255) PRIMARY customers_group_id entry_company_tax_id varchar(32) YES
  13. katiallo

    Seperate Pricing Per Customer v3.5

    I also realized that I cannot edit under configuration/customer details 'Default Customer Group and Visitor Pricing Group': I have this error: Fatal error: Call to undefined function tep_cfg_pull_down_cg_list() in /home/xxxxxx/public_html/admin/configuration.php(125) : eval()'d code on line 1 Warning: call_user_func(tep_cfg_get_customer_group) [function.call-user-func]: First argument is expected to be a valid callback in /home/xxxxxx/public_html/admin/includes/functions/general.php on line 1315
  14. katiallo

    Seperate Pricing Per Customer v3.5

    Fields in database are: customers_group_id smallint(5) unsigned customers_group_name varchar(32) customers_group_show_tax enum('1','0') customers_group_tax_exempt enum('0','1') group_payment_allowed varchar(255) group_shipment_allowed varchar(255) PRIMARY customers_group_id entry_company_tax_id varchar(32) YES
  15. katiallo

    Seperate Pricing Per Customer v3.5

    Thank you for the help. Everything seems to work now. I still have the warning under customers but its workable. Under catalog/categories editing page still looks king of funny to me: (Catalog/categories on my editing page (no idea if it supposes to look like that) at the bottom of everything has the catalog/categories page and the following error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxxxx/public_html/admin/includes/functions/database.php on line 99) but still workable. Again thank you
  16. katiallo

    Seperate Pricing Per Customer v3.5

    Hello; I installed separate_price_415 and hide_products_and_categories_v201. I'm getting some errors and was wondering if anyone can help. First I got an SQL error: FAILED! - ALTER TABLE customers ADD customers_group_id smallint UNSIGNED NOT NULL default '0', ADD customers_group_ra enum('0','1') NOT NULL, ADD customers_payment_allowed varchar(255) NOT NULL default '', ADD customers_shipment_allowed varchar(255) NOT NULL default '' . I can't loggin the continue button is missing. . I can't create an account, I'm getting an error: 1054 - Unknown column 'customers_group_ra' in 'field list' . On admin side in customers I get this error: 1054 - Unknown column 'c.customers_group_ra' in 'field list' select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_group_id, c.customers_group_ra, a.entry_country_id, a.entry_company, cg.customers_group_name from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join customers_groups cg on c.customers_group_id = cg.customers_group_id order by c.customers_id DESC limit 0, 5 . On admin side in Configuration/customers/details this warning: Warning: call_user_func(tep_cfg_get_customer_group) [function.call-user-func]: First argument is expected to be a valid callback in /home/xxxxxx/public_html/admin/includes/functions/general.php on line 1315 . Catalog/categories on my editing page (no idea if it supposes to look like that) at the bottom of everything has the catalog/categories page and the following error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxxxx/public_html/admin/includes/functions/database.php on line 99 Thank you all. GREAT CONTRIBUTION
  17. katiallo

    Seperate Pricing Per Customer v3.5

    My site is live and I have hard time correcting this problem: 1146 - Table 'hotling3_ecom.TABLE_PRODUCTS_GROUPS' doesn't exist select customers_group_price from TABLE_PRODUCTS_GROUPS where products_id = '330' and customers_group_id = '0' [TEP STOP] The table exists in my database. Can someone help me with this?
  18. katiallo

    Seperate Pricing Per Customer v3.5

    I just installed your contribution. When I'm clicking on a product I get the following: 1146 - Table 'hotling3_ecom.TABLE_PRODUCTS_GROUPS' doesn't exist select customers_group_price from TABLE_PRODUCTS_GROUPS where products_id = '330' and customers_group_id = '0' [TEP STOP] can you please help me to correct it? Thank you
  19. Thank you Jack for all your help .....all working now this is a great contribution Thank you j
  20. changed the line to just the name instead of www.xxxxxx.net and still getting an error when clicking sumbit a link
  21. line 46 47 define('EMAIL_SUBJECT', 'Welcome to ' . www.xxxxxx.net . ' link exchange.');
  22. Ooops ok I got it. But when I click submit I get the following error Parse error: syntax error, unexpected T_STRING in /home/hotling3/public_html/includes/languages/english/links_submit.php on line 46
  23. I'm going to sound silly Jack but how do I do that. Sorry, but I'm new.
  24. Sorry here is the whole SQL error: Server: localhost Error There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem ERROR: Unknown Punctuation String @ 1 STR: <? SQL: <?php /* $Id: links_setup.php,v 1.00 2003/10/02 Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); SQL query: MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?php require('includes/application_top.php')' at line 1 [ Back ] and here is the first lines from links_setup.php <?php /* $Id: links_setup.php,v 1.00 2003/10/02 Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php');
×