Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Gil_e_n

Pioneers
  • Posts

    571
  • Joined

  • Last visited

Posts posted by Gil_e_n

  1. I apologize, it looks like the problem was that I had forgotten something I needed to do to integrate it with another contribution. I have (well, bits and pieces of) fast easy checkout installed, and it requires that you unregister the individual payment variables at the top of checkout_confirmation. I had done so for various other payment modules, but apparently not for po_number. It's fixed now, as far as I can tell.

  2. And. Now it's started working again. Now that I commented out all the if-else statements in po.php because our system handles that differently, anyway.

     

    But now, when the po number is stored in the session, it doesn't disappear, and you can't override it. For example, I make an order, and enter 123 as the order number. I then go and make another order. I try to enter 456. It goes through okay, I think. Until I get to checkout_confirmation.php, and the po number is displayed as 123. It can't change until that session is deleted.

  3. I've had this installed for a while now, and just discovered a problem. For me, it doesn't work when I have taxes enabled. The purchase order number doesn't go through, and I get this error: Credit Account Error! Please enter your purchase order number.

     

    I also have chemo's MS3 Tax Class contribution installed to improve performance. I have a sneaking suspicion that the problem stems from some sort of conflict between the two.

     

    Has anyone else had this problem and fixed it? I've been poking through the code, but I'm not seeing where the problem's coming from yet.

  4. Hi. I just installed this and am getting this error:

    Warning: ftp_put(): php_connect_nonb() failed: Connection timed out (110) in /home/public_html/admin/froogle.php on line 349
    
    Warning: ftp_put(): Type set to I. in /home/public_html/admin/froogle.php on line 349
    uploads.google.com: FTP upload has failed!

    I feel I should point out that I only have 35 products in the file I'm trying to send, making the timing out more confusing. Does anyone know why this would be happening?

  5. The way I'm handling shipping is after a certain weight, the only shipping module that appears is a "We'll contact you after the order with your shipping charges" module. I've coded it so that this module only shows up if the shipping weight is over that amount, and I've tested the other modules and gotten them to display only when the shipping weight is under or equal to that amount. But it won't work in the UPS XML module.

     

    I added this code, underneath the if (($this->enabled == true) && ((int)MODULE_SHIPPING_UPSXML_RATES_ZONE > 0)) { blah blah blah} statement:

    //Only use module if total order weight under SHIPPING_FREIGHT_WEIGHT
      if ( $this->enabled == true ) {
    	$check_flag = false;
    	if ($shipping_weight <= SHIPPING_FREIGHT_WEIGHT) {
    		$check_flag = true;
    	}
    
    	if ($check_flag == false) {
    	  $this->enabled = false;
    	}
    
      }
    //End only use module if total order weight under SHIPPING_FREIGHT_WEIGHT

    In order to have $shipping weight have a value at this point, I added this code to classes/shipping.php within the shipping function

    global $language, $PHP_SELF, $total_weight, $shipping_weight;
    
    	$shipping_weight = $total_weight;
    
    	if (SHIPPING_BOX_WEIGHT >= $shipping_weight*SHIPPING_BOX_PADDING/100) {
    	  $shipping_weight = $shipping_weight+SHIPPING_BOX_WEIGHT;
    	} else {
    	  $shipping_weight = $shipping_weight + ($shipping_weight*SHIPPING_BOX_PADDING/100);
    	}

     

    What really is baffling me here is that this worked on several other modules that I've tested. Can anyone think of any reason why this would work on other modules, but not on UPS XML?

  6. Hello. I've been installing SPPC and I can't get the advanced_search_result.php page to work correctly. I keep getting this error:

     

    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 'and ((pd.products_name like '%crane%' or p.products_model like '%crane%' or m.ma' at line 1

     

    select count(distinct p.products_id) as total from ((products p) left join manufacturers m using(manufacturers_id), products_description pd) left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c and ((pd.products_name like '%crane%' or p.products_model like '%crane%' or m.manufacturers_name like '%crane%' or pd.products_description like '%crane%') )

     

    [TEP STOP]

     

    I've already tried both the newest update of SPPC and the solution stated here, and I still can't get it to work. Can anyone tell me what I'm doing wrong?

  7. I've been attempting to fix this. My first instinct was that the error was in index.php, since it only breaks in the category listing and in the product listing. I tried comparing my index.php to the one included in the contribution, and making quadruply sure that I installed it correctly. As far as I could tell, I had. Then I just dropped in the included index.php file, and see if that fixed the problem. The problem remained.

     

    I then wondered if it might be the product_listing page, but extensive comparison with the included product_listing page didn't work. Nor did dropping it into my shop.

     

    I'm guessing the error's elsewhere then. Any advice as to where I might look, or what the errors my stem from would be appreciated.

  8. Hi. I just installed this contribution, and I'm having some problems. When I attempt to go to a category listing page, I get this error:

    1054 - Unknown column 'p.products_id' in 'on clause'
    
    select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '52'
    
    [TEP STOP]

     

    I double-checked that I'd run the included sql statements correctly, but they are appearing correctly in phpmyadmin, so I'm not sure what's up here.

  9. I just installed this contribution, and it seemed to work fine at first. But then I tried creating a new address in checkout_shipping_address.php, and I got this error:

     

    1062 - Duplicate entry '0' for key 1

     

    insert into address_book (customers_id, entry_firstname, entry_lastname, entry_street_address, entry_postcode, entry_city, entry_country_id, entry_company, entry_zone_id, entry_state) values ('3', 'Tester', 'Testing', 'lsjkgpoui', '65498', 'Acampo', '223', '', '12', '')

     

    [TEP STOP]

     

    It looks to me like it's just entering the state I enter as the zone_id, and not as the entry state. I'm looking at the checkout_shipping address page, and I'm not quite sure how to fix it. I have fast easy checkout installed, and there's some code there that could be screwing it up, but I already ran my copy of the page through winmerge against the included demo files, and removed the code pertaining to fast easy checkout, but that didn't fix it.

     

    Any help would be appreciated.

  10. I have this contribution installed (and it works perfectly, thank you.) Now, what I'm attempting to do is make it so that when price is zero, it displays an alternate price I've input into a new field in the database if that alternate price exists. Sadly, I cannot get this to work on the product listing page. (I did, however, get it to work on the product_info page). If someone could point me a direction in how to do this, I would greatly appreciate it.

  11. If anyone has any advice on what to about the errors, it would be welcome. I just wiped my database of the reports subtable in the admin_files table, and redid it with all four reports that I'm attempting to display. It is currently displaying the default three, but not the fourth contribution that I installed. In administrator -> file access -> reports -> store files, it is displaying all four links that I am attempting to display, but it also shows that error. When I start clicking around on the four links, it stops displaying the error until I try clicking on store files again.

     

    Please help. This is driving me nuts.

  12. Well, I just went to File Access -> Reports ->Store files (I believe that's what you meant? Thank you, I hadn't realized that lead anywhere), and I have this error:

     

    Warning: dir(/htdocs/catalog/admin/): failed to open dir: Invalid argument in J:\XAMPP\xampp\htdocs\catalog\admin\admin_files.php on line 235

     

    Fatal error: Call to a member function on a non-object in J:\XAMPP\xampp\htdocs\catalog\admin\admin_files.php on line 237

     

    Those lines are:

    235: $dir = dir(DIR_FS_ADMIN);

     

    237: while ($file = $dir->read()) {

     

    ...I'm still confused, but farther along than before I believe, so thank you.

  13. Okay, I'm desperately trying to add entries to the boxes, and it is utterly failing to work. I have added

    tep_admin_files_boxes(FILENAME_STATS_ORDERLIST, BOX_REPORTS_ORDERLIST) .

    to the reports.php in admin/includes/boxes. I have added

    insert into admin_files (admin_files_id, admin_files_name, admin_files_is_boxes, admin_files_to_boxes, admin_groups_id) values ('43', 'orderlist.php', '0', '8', '1,2');

    to the sql database that I imported into my database. I am utterly failing in making this work. I did, however, manage to make my header tags controller box appear, but failed to create an easypopulate box and make it appear. Can someone explain to me, in small, easy-to-understand words, exactly how to add more links to the boxes on the left with this contribution?

  14. I just installed this, and am having problems. One is that "Allow categories description" shows up three times in the admin. The other is that, while going to the categories and editing the description in the admin like the directions say, nothing appears on my category page.

     

    I had the header tags contribution installed, and this is probably part of the problem, since I was pretty much guessing at how to install it. Does anyone have any suggestions on how to fix it? I'm considering just restoring the basic version of osc for the conflicting pages and installing it on that, but I'd prefer to avoid that.

×
×
  • Create New...