Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

steffanih

Pioneers
 View Profile  See their activity

  • Posts

    97

  • Joined

  • Last visited

 Content Type 

Everything posted by steffanih

  1. steffanih
    Hello, I am restoring a site after an SSL certificate was added to our site and there are many database syntax errors I am fishing through to get my database back up. This is the one I am having a hard time finding a resolution for: This is the portion of my code: drop table if exists ps_customized_data; create table ps_customized_data ( id_customization int(10) unsigned not null , type tinyint(1) not null , index int(3) not null , value varchar(255) not null , PRIMARY KEY (id_customization, type, index) ); and this is the error message I receive when running the backup: 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 'int(3) not null , value varchar(255) not null , PRIMARY KEY (id_customizat' at line 4
  2. steffanih
    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.
  3. steffanih
    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?
  4. steffanih
    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 I am receiving an error when I go to catalog/index.php Thanks in advance Steff
  5. steffanih
    Nevermind, it was a couple lines of code in that area causing the problem. U rule.
  6. steffanih
    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>
  7. steffanih
    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.
  8. steffanih
    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!
  9. steffanih
    Hi there, I've recently added this module into my shopping cart and it appears to be working, and shows in the shipping selections. When click on the continue button, it appears to refresh instead of moving to the next shipping step. What should I do? Thanks Steff
×
×
  • Create New...