Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

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!

Posted

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.

Posted (edited)

Steffani,

 

Try reloading your english.php file into the admin/includes/languages/ directory

 

 

 

Chris

Edited by DunWeb
Posted

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>

Posted

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

Posted (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 by steffanih
Posted

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.

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.

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...