steffanih Posted July 13, 2010 Posted July 13, 2010 I have SPPC up and working beautifully for a company that also needs to hide products with wholesale pricing from retail customers. So I installed Simply Hide and I am experiencing a few problems/conflicts and would appreciate some assistance: 1: My admin is showing some strange things with the headers, please see the screenshot of the issue > http://img339.imageshack.us/img339/6427/issue1.jpg 2: I am no longer getting an input area for specified customer groups, which is an SPPC feature. When I visit my site as a wholesale customer, I am still seeing the correct wholesale pricing, but I am unable to input the information when I add new products. Please let me know if any code is necessary to help me out on this and I will post. I think if I can get these two issues worked out, I can troubleshoot the error codes from there, thanks! Quote
Guest Posted July 13, 2010 Posted July 13, 2010 Steffani, If you have SPPC installed, you should be using this contribution: http://addons.oscommerce.com/info/3059 Chris steffanih 1 Quote
steffanih Posted July 14, 2010 Author Posted July 14, 2010 Who knows how long I would have been fiddling with this trying to make it work? Thank you for saving me a huge amount of time and energy. I'm still getting the errors on my admin (see photo link) and not sure which file is causing the issue. I thought maybe it was application_top.php, but I'm not seeing anything unusual. Quote
Guest Posted July 14, 2010 Posted July 14, 2010 (edited) Steffani, Try reloading your english.php file into the admin/includes/languages/ directory Chris Edited July 14, 2010 by DunWeb steffanih 1 Quote
steffanih Posted July 14, 2010 Author Posted July 14, 2010 Amazing! One last little issue that I haven't been able to find any information on to fix it. I receive this error message when clicking logoff: Fatal error: Call to undefined function tep_set_hidden_products() in D:\Hosting\*******\****\*****\catalog\logoff.php on line 37 My code looks like this( line 37 being the second to the last line, right before the <HEAD> tag): <?php /* $Id: logoff.php 1739 2007-12-20 00:52:16Z hpdl $ adapted for Separate Pricing Per Customer v4.2 2005/05/16 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'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_LOGOFF); $breadcrumb->add(NAVBAR_TITLE); tep_session_unregister('customer_id'); tep_session_unregister('customer_default_address_id'); tep_session_unregister('customer_first_name'); // BOF Separate Pricing Per Customer tep_session_unregister('sppc_customer_group_id'); tep_session_unregister('sppc_customer_group_show_tax'); tep_session_unregister('sppc_customer_group_tax_exempt'); if (tep_session_is_registered('sppc_customer_specific_taxes_exempt')) { tep_session_unregister('sppc_customer_specific_taxes_exempt'); } // EOF Separate Pricing Per Customer tep_session_unregister('customer_country_id'); tep_session_unregister('customer_zone_id'); tep_session_unregister('comments'); $cart->reset(); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> Quote
steffanih Posted July 14, 2010 Author Posted July 14, 2010 Nevermind, it was a couple lines of code in that area causing the problem. U rule. Quote
steffanih Posted July 15, 2010 Author Posted July 15, 2010 One more issue that has come up. Can you please help? I needed to hide the wholesale products from general retail customers so I found the info on a contribute called hidden products 2.0.3 fix, that another forum post said would resolve the problem. After making the changes to my catalog/includes/modules/new_products.php ***** in /catalog/includes/modules/new_products.php ***** ***** FIND ***** $info_box_contents[] = array('text' => TABLE_HEADING_NEW_PRODUCTS; ***** REPLACE WITH ***** // $info_box_contents[] = array('text' => TABLE_HEADING_NEW_PRODUCTS; ***** FIND ***** if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { ***** ADD BELOW ***** $info_box_contents[] = array('text' => TABLE_HEADING_NEW_PRODUCTS); ***** FIND ***** $col ++; if ($col > 2) { $col = 0; $row ++; } } // end for ($x = 0; $x < $no_of_new_products; $x++) } // end if (($no_of_new_products = tep_db_num_rows($new_products_query)) > 0) // EOF Separate Pricing Per Customer new contentBox($info_box_contents); ?> <!-- new_products_eof //--> ***** REPLACE WITH ***** $col ++; if ($col > 2) { $col = 0; $row ++; } } // end for ($x = 0; $x < $no_of_new_products; $x++) } // end if (($no_of_new_products = tep_db_num_rows($new_products_query)) > 0) else { $info_box_contents = array(); $info_box_contents[0] = array('params' => 'class="productListing-odd"'); $info_box_contents[0][] = array('params' => 'class="productListing-data"', 'text' => ""); } // EOF Separate Pricing Per Customer new contentBox($info_box_contents); ?> <!-- new_products_eof //--> I am receiving an error when I go to catalog/index.php Parse error: syntax error, unexpected $end in D:\Hosting\5663011\html\sneekee\catalog\includes\modules\new_products.php on line 129 Thanks in advance Steff Quote
steffanih Posted July 19, 2010 Author Posted July 19, 2010 (edited) I'm having an SQL database issue now with SHP. I try to restore a previous backup thinking if I go back through and start from scratch adding on SHP, I will resolve the last issue. When I try to restore, I get this error: 1067 - Invalid default value for 'timestamp' create table hidden_products ( hidden_products_id int(11) not null auto_increment, customers_id int(11) not null , products_id int(11) default '0' not null , categories_id int(11) default '0' not null , unixtime int(11) default '0' not null , timestamp timestamp default 'CURRENT_TIMESTAMP' not null , PRIMARY KEY (hidden_products_id), KEY customers_id (customers_id) ) [TEP STOP] I read through some forums and have substituted NOW() for CURRENT_TIMESTAMP and still receive the same error message., I also ran the query in the the install file and I still receive this error. We are running MYSQL 5.019. Any ideas? Edited July 19, 2010 by steffanih Quote
steffanih Posted July 19, 2010 Author Posted July 19, 2010 I decided to reinstall OS commerce and then run my backup. ll of these errors began when we had an SSL certificate issued for the site. It seems like there are some version differences or something. I've been going through and adjusting syntax errors to my backup file, and as a newb...it's getting a little frustrating. I'm starting a new thread for the syntax error I am unable to sort out myself. Thanks again for your help, eventually, I'll get this site back on go. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.