Jump to content

lglapion

Members
  • Content count

    42
  • Joined

  • Last visited

  1. I have some questions about install. There is a reviews.txt with a sentence of code, but no explanation to a newbie of what to do with it: ALTER TABLE `reviews` ADD `approved` TINYINT(3) UNSIGNED DEFAULT "0"; UPDATE `reviews` SET `approved` = '1'; 1) There are two folders: ADMIN and CATALOG -My admin folder is inside my catalog. Does it matter? 2) After installing files I don't see a change in admin and I receive this error in my right column on my site: 1054 - Unknown column 'r.approved' in 'where clause' select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' and r.approved = '1' order by r.reviews_id desc limit 10 [TEP STOP] And this error after clicking on tiny arrow in the read reviews box: Read What Others Are Saying 1054 - Unknown column 'r.approved' in 'where clause' select count(*) as total from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '1' and rd.languages_id = '1' and r.approved = '1' [TEP STOP] Thank you for reading!
  2. lglapion

    "Complete Reviews System"

    i have the same question. i thought it was a simple as downloading files- but it didn't work for me...
  3. What am I missing? Thanks!!! // BOF Separate Pricing Per Customer v4.1, Hide products and categories from groups if(!tep_session_is_registered('sppc_customer_group_id')) { $customer_group_id = '0'; } else { $customer_group_id = $sppc_customer_group_id; } global $hide_product; // is determined in product_info.php // on other pages we'll check it with a query if (!isset($hide_product) && isset($HTTP_GET_VARS['products_id'])) { $hide_product = tep_get_hide_status_single($customer_group_id, (int)$HTTP_GET_VARS['products_id']); } else { $hide_product = false; } if (isset($HTTP_GET_VARS['products_id']) && $hide_product == false) include(DIR_WS_BOXES . 'manufacturer_info.php'); if (tep_session_is_registered('customer_id')) include(DIR_WS_BOXES . 'order_history.php'); if (isset($HTTP_GET_VARS['products_id'])) { if (tep_session_is_registered('customer_id')) { $check_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . (int)$customer_id . "' and global_product_notifications = '1'"); $check = tep_db_fetch_array($check_query); if ($check['count'] > 0) { include(DIR_WS_BOXES . 'best_sellers.php'); } else { (($hide_product == false )? include(DIR_WS_BOXES . 'product_notifications.php') : ''); } } else { (($hide_product == false)? include(DIR_WS_BOXES . 'product_notifications.php') : ''); } } else { include(DIR_WS_BOXES . 'best_sellers.php'); } if (isset($HTTP_GET_VARS['products_id'])) { if (basename($PHP_SELF) != FILENAME_TELL_A_FRIEND && $hide_product == false) { include(DIR_WS_BOXES . 'tell_a_friend.php'); } // end if (basename($PHP_SELF) != FILENAME_TELL_A_FRIEND && $hide_product == false) } else { include(DIR_WS_BOXES . 'specials.php'); } // end if (isset($HTTP_GET_VARS['products_id'])) if ($hide_product == false) { require(DIR_WS_BOXES . 'reviews.php'); } // EOF Separate Pricing Per Customer v4.1, Hide products and categories from groups if (substr(basename($PHP_SELF), 0, 8) != 'checkout') { //include(DIR_WS_BOXES . 'languages.php'); //include(DIR_WS_BOXES . 'currencies.php'); } ?> <tr><td><img src="images/creditcards.gif" width="197" height="75" border="0"> <?php ?>
  4. lglapion

    UPS Ground Only

    tHIS ALSO WORKED GREAT FOR ME AND WAS SO SIMPLE- THANKS!
  5. ps: Are there any snapshots available for this contribution? It would be great to see what it looks like on a website and on OSC admin panel... Thanks!
  6. Hi all! I am wondering if anyone is using this contribution with SPPC? If so, anything I should know- like which to install first? Thanks!- Lisa
  7. sorry- i somehow posted this in wrong spot- remove me if possible!!! -lisa
  8. lglapion

    Seperate Pricing Per Customer v3.5

    (I posted this in wrong spot earlier, sorry) Hello there! Getting ready to have SPPC installed for its retail/ wholesale benefits. I am now realizing that I can enter all the pretty colors of one product that I want into OSC- but each color won't have it's own inventory without some additional configgin'. Can anyone point me in the right direction of a modification that works with SPPC? (& which to install first) Thanks!!! - Lisa
  9. Hello there! Getting ready to have SPPC installed for its retail/ wholsale benefits. I am now realizing that I can enter all the pretty colors of one product that I want into OSC- but each color won't have it's own inventory without some additional configgin'. Can anyone point me in the right direction of a modification that works with SPPC? (& which to install first) Thanks!!!
  10. Hi- my question is simple! I need to install SPPC (which I learned about after doing color & text changes, image uploading, etc to my shop cart). I see that the easiest/fastest way to install is with MySql- which is how I would like to do it- if you have not installed other contributions at all. I have not installed any other contributions. Still I wonder, by installing in this fashion will I lose the design aspect of the site? Of course I am backing it up. But can someone please look at what I have done with my cart and just give me heads up? here it is: www.eshesleepsets.com/shop
  11. Hi! I recently installed OSC. I love it and these forums are very helpful. I have been reading the contributions for SPPC. I have a couple questions: 1. Will it affect current personalized visual settings (colors, images, text, all the work I have done) at all? 2. Will I have to reload my retail products/ prices, etc. Or will it transfer thru.....or something... 3. I am wondering what is the most recent FULL package? Would that be v.4.1.5?(v4.1.4 is the last one that actually says "full package".) I do get that I may have to use a bug fix here or there. 4. I gather with SPPC the pricing is affected but can still be seen by a retailer, thus the creation of Hide Products from Groups for SPPC (which leads me to: is HPCG v.2.0.1 the full package too?) Thanks!
  12. lglapion

    [contribution] "osC_GiftWrap_v1.0"

    I just wanted to show you some love coming up with this option for future newbies like me! I appreciate you! :thumbsup:
×