Jump to content

spitznas

Members
  • Content count

    7
  • Joined

  • Last visited

  1. spitznas

    One Page Checkout Support

    I was having this issue and figured out that the required jQuery libraries were conflicting with prototype & scriptaculous which I was using for lightbox. If you're using lightbox or any other javascript libraries, don't load them on checkout.php. I just excluded lightbox.js from the header for checkout.php and the error went away...now I just have to fix some other errors :P
  2. spitznas

    BAXGlobal Shipping Module

    Thanks for all your help :D I'll have to contact my hosting company and ask about adjusting the timeout on php/mysql.
  3. spitznas

    BAXGlobal Shipping Module

    Actually, this would be the modified query: tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model, products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, products_price, products_price1, products_price2, products_price3, products_price4, products_price5, products_price6, products_price7, products_price8, products_price9, products_price10, products_price11, products_price1_qty, products_price2_qty, products_price3_qty, products_price4_qty, products_price5_qty, products_price6_qty, products_price7_qty, products_price8_qty, products_price9_qty, products_price10_qty, products_price11_qty, products_qty_blocks, products_date_added, products_date_available, products_weight, products_length, products_width, products_height, products_status, products_tax_class_id, manufacturers_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_image_med']) . "', '" . tep_db_input($product['products_image_lrg']) . "', '" . tep_db_input($product['products_image_sm_1']) . "', '" . tep_db_input($product['products_image_xl_1']) . "', '" . tep_db_input($product['products_image_sm_2']) . "', '" . tep_db_input($product['products_image_xl_2']) . "', '" . tep_db_input($product['products_image_sm_3']) . "', '" . tep_db_input($product['products_image_xl_3']) . "', '" . tep_db_input($product['products_image_sm_4']) . "', '" . tep_db_input($product['products_image_xl_4']) . "', '" . tep_db_input($product['products_image_sm_5']) . "', '" . tep_db_input($product['products_image_xl_5']) . "', '" . tep_db_input($product['products_image_sm_6']) . "', '" . tep_db_input($product['products_image_xl_6']) . "', '" . tep_db_input($product['products_price']) . "', '" . tep_db_input($product['products_price1']) . "', '" . tep_db_input($product['products_price2']) . "', '" . tep_db_input($product['products_price3']) . "', '" . tep_db_input($product['products_price4']) . "', '" . tep_db_input($product['products_price5']) . "', '" . tep_db_input($product['products_price6']) . "', '" . tep_db_input($product['products_price7']) . "', '" . tep_db_input($product['products_price8']) . "', '" . tep_db_input($product['products_price9']) . "', '" . tep_db_input($product['products_price10']) . "', '" . tep_db_input($product['products_price11']) . "', '" . tep_db_input($product['products_price1_qty']) . "', '" . tep_db_input($product['products_price2_qty']) . "', '" . tep_db_input($product['products_price3_qty']) . "', '" . tep_db_input($product['products_price4_qty']) . "', '" . tep_db_input($product['products_price5_qty']) . "', '" . tep_db_input($product['products_price6_qty']) . "', '" . tep_db_input($product['products_price7_qty']) . "', '" . tep_db_input($product['products_price8_qty']) . "', '" . tep_db_input($product['products_price9_qty']) . "', '" . tep_db_input($product['products_price10_qty']) . "', '" . tep_db_input($product['products_price11_qty']) . "', '" . tep_db_input($product['products_qty_blocks']) . "', now(), '" . tep_db_input($product['products_date_available']) . "', '" . tep_db_input($product['products_weight']) . "','" . tep_db_input($product['products_length']) . "', '" . tep_db_input($product['products_width']) . "', '" . tep_db_input($product['products_height']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')"); ;)
  4. spitznas

    BAXGlobal Shipping Module

    I've got a whole bunch of add-ons installed so here is my product query: $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, p.products_price, p.products_weight, p.products_height, p.products_width, p.products_length, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); Does everything look alright there? Also, I didn't even think about it but I am chugging along on a 56k connection while my broadband is getting installed, however, the bax module works on other sites. I guess they might not be running such a huge query though haha.
  5. spitznas

    BAXGlobal Shipping Module

    So do you think I have everything on my end setup correctly? Basically, does it seem like the query is getting passed correctly? I'm trying to isolate the error to my end or server side. Thanks so much for your help!
  6. spitznas

    BAXGlobal Shipping Module

    I'm attempting to get this contrib working but keep getting the following error upon entering checkout_shipping.php: 2013 - Lost connection to MySQL server during query select configuration_id, configuration_title, configuration_value from configuration where configuration_key = 'PAYMENT_CC_CRYPT_PATH' [TEP STOP] I checked the error log and got this: DATE AND TIME: 2006-05-22 18:52:37 BAX URL: https://secure.baxglobal.com/xmlRateQuote/w...StringRateQuote BAX REQUEST: <BAXRateQuoteRequest> <RateQuoteRequest> <Login> <UserId>baxdemo</UserId> <Password>gobax!</Password> </Login> <RateQuoteType></RateQuoteType> <PaymentTerms>DOMESTIC</PaymentTerms> <ShipDate>2006-05-23</ShipDate> <OriginZipCode></OriginZipCode> <DeliveryInformation> <DestinationZipCode>18013</DestinationZipCode> </DeliveryInformation> <PackageInformation> <TotalPieces>1</TotalPieces> <ShipmentWeight>100</ShipmentWeight> <WeightUnitOfMeasure>POUNDS</WeightUnitOfMeasure> <DeclaredValue>100</DeclaredValue> <Dimensions> <DimensionUnitOfMeasure>INCHES</DimensionUnitOfMeasure> <Packages> <PackageDimensions> <Pieces>1</Pieces> <Length>100</Length> <Width>100</Width> <Height>100</Height> </PackageDimensions> </Packages> </Dimensions> </PackageInformation> <SaveRateQuote> <ServiceLevel1>Yes</ServiceLevel1> <ServiceLevel2>Yes</ServiceLevel2> <ServiceLevel3>Yes</ServiceLevel3> <ServiceLevel4>Yes</ServiceLevel4> <ServiceLevel5>Yes</ServiceLevel5> <ServiceLevel6>Yes</ServiceLevel6> <ServiceLevel7>Yes</ServiceLevel7> <ServiceLevel8>Yes</ServiceLevel8> </SaveRateQuote> </RateQuoteRequest> </BAXRateQuoteRequest> Error from cURL: Error [28]: connect() timed out! BAX RESPONSE: Any ideas? Thanks!
  7. I'm attempting to use the Authorize.net + gpg module because no other authorize.net modules have worked. This has proven to be the most successful so far :P I wanted the Authorize.net Consolidated 1.7 contrib but for some reason it is not hosted in oscommerce's contributions database anymore. Being as though this is built on that contribution, I figured it should work. I am not interested in the gpg functionality. After clicking "Confirm Order", I get the following error: 2013 - Lost connection to MySQL server during query delete from orders where orders_id = '8' [TEP STOP] Is the problem server related? I am using godaddy hosting and noticed a couple of people reporting problems with them and MySQL functionality. I really need to get this site working! If anyone can help me out, it would be greatly appreciated.
×