VirtueMart Forum

VirtueMart 1.1.x [ Old version - no longer supported ] => Shipping VM 1.1 => UPS VM 1 => Topic started by: cinr11 on February 11, 2010, 03:39:51 AM

Title: UPS module not working
Post by: cinr11 on February 11, 2010, 03:39:51 AM
I set the debug to see why the ups module is not working. anyone know what this is. Not seeing anything come back for shipping? Only thing I have is white page with the shopping cart saying "Please select a shipping rate" with nothing else..
I tried to configure the ups module again but this time when I click on it it directs me to the administration virtue mart.

Debug: Starting Shipping module: standard_shipping
Debug: The Shipping Module 'standard_shipping' couldn't
find a Shipping Rate that matches the current Checkout configuration:
Weight: 1
Country: USA
ZIP: 11791


Debug: Starting Shipping module: ups
Title: Re: UPS module not working
Post by: lowmips on February 11, 2010, 21:22:25 PM
You are getting an error, but your error_reporting settings are too low.  turn your error settings up a notch in order to see the error.  you can try upping this in joomla, if that doesn't work, try your php.ini.
Title: Re: UPS module not working
Post by: cinr11 on February 11, 2010, 21:55:21 PM
ok I did what you told me and this is what I got: I do get a white screen with a checkout that says" please select a shipping rate" but that all I get. I don't get rates from UPS. Any idea? I did add the access key that was provided to me from ups and added it in the UpS module. I also checked off Ups module. anything else am missing?
Profile Information
Application afterLoad: 0.000 seconds, 0.22 MB
Application afterInitialise: 0.092 seconds, 3.59 MB
Application afterRoute: 0.104 seconds, 3.98 MB
Application afterDispatch: 0.244 seconds, 8.32 MB
Application afterRender: 0.339 seconds, 9.01 MB
Memory Usage
9484392
48 queries logged

   1.
      SELECT *
        FROM jos_session
        WHERE session_id = 'u3l9slq51414v2s9iuimuquno6'
   2.
      DELETE
        FROM jos_session
        WHERE ( time < '1265917427' )
   3.
      SELECT *
        FROM jos_session
        WHERE session_id = 'u3l9slq51414v2s9iuimuquno6'
   4.
      UPDATE `jos_session`
        SET `time`='1265921027',`userid`='63',`usertype`='Registered',`username`='cinr11',`gid`='18',`guest`='0',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:37;s:19:\"session.timer.start\";i:1265918995;s:18:\"session.timer.last\";i:1265920960;s:17:\"session.timer.now\";i:1265921013;s:22:\"session.client.browser\";s:114:\"Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7 GTB6 (.NET CLR 3.5.30729)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:2:\"63\";s:4:\"name\";s:12:\"Cynthia cali\";s:8:\"username\";s:6:\"cinr11\";s:5:\"email\";s:16:\"cinr11@yahoo.com\";s:8:\"password\";s:65:\"371b95c33120836266c0a6ba2fd73507:abnE5ew6QqFDnt2anes49HindwZeAvht\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"Registered\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:3:\"gid\";s:2:\"18\";s:12:\"registerDate\";s:19:\"2010-02-02 01:49:18\";s:13:\"lastvisitDate\";s:19:\"2010-02-11 14:56:14\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:1:\"\n\";s:3:\"aid\";i:1;s:5:\"guest\";i:0;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:70:\"/var/www/html/clients/joomla15/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}VMCHECK|s:2:\"OK\";auth|a:13:{s:11:\"show_prices\";i:1;s:7:\"user_id\";s:2:\"63\";s:8:\"username\";s:6:\"cinr11\";s:5:\"perms\";s:7:\"shopper\";s:10:\"first_name\";s:7:\"Cynthia\";s:9:\"last_name\";s:4:\"cali\";s:7:\"country\";s:3:\"USA\";s:3:\"zip\";s:5:\"11791\";s:16:\"shopper_group_id\";s:1:\"6\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"0\";s:21:\"default_shopper_group\";s:1:\"0\";s:22:\"is_registered_customer\";b:1;}savedcart|a:1:{s:3:\"idx\";i:0;}cart|a:2:{i:0;a:5:{s:8:\"quantity\";i:1;s:10:\"product_id\";s:2:\"33\";s:9:\"parent_id\";i:33;s:11:\"category_id\";i:10;s:11:\"description\";s:0:\"\";}s:3:\"idx\";i:1;}recent|a:2:{s:3:\"idx\";i:1;i:0;a:2:{s:10:\"product_id\";i:33;s:11:\"category_id\";i:10;}}ps_vendor_id|s:1:\"1\";minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"USD\";userstate|a:3:{s:10:\"product_id\";i:0;s:24:\"viewlistlimitshop.browse\";s:2:\"15\";s:21:\"view6browselimitstart\";i:5;}last_page|s:14:\"checkout.index\";last_browse_parameters|a:7:{s:11:\"category_id\";s:2:\"10\";s:15:\"manufacturer_id\";i:0;s:7:\"keyword\";b:0;s:8:\"keyword1\";s:0:\"\";s:8:\"keyword2\";s:0:\"\";s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}product_sess|a:11:{i:23;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1265920528;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:28;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1265920528;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;s:7:\"flypage\";s:11:\"flypage.tpl\";}i:32;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1265920528;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:29;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1265920528;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;s:7:\"flypage\";s:11:\"flypage.tpl\";}i:31;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1265920846;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;s:7:\"flypage\";s:11:\"flypage.tpl\";}i:30;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1265920528;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;s:7:\"flypage\";s:11:\"flypage.tpl\";}i:39;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1265919019;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:33;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1265921013;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;s:7:\"flypage\";s:11:\"flypage.tpl\";}i:34;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1265920728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;s:7:\"flypage\";s:11:\"flypage.tpl\";}i:27;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1265920728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:24;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1265920728;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}vmUseGreyBox|s:1:\"1\";vmCartDirection|s:1:\"0\";'
        WHERE session_id='u3l9slq51414v2s9iuimuquno6'
   5.
      SELECT *
        FROM jos_components
        WHERE parent = 0
   6.
      SELECT folder AS type, element AS name, params
        FROM jos_plugins
        WHERE published >= 1
        AND access <= 1
        ORDER BY ordering
   7.
      SELECT m.*, c.`option` AS component
        FROM jos_menu AS m
        LEFT JOIN jos_components AS c
        ON m.componentid = c.id
        WHERE m.published = 1
        ORDER BY m.sublevel, m.parent, m.ordering
   8.
      SELECT template
        FROM jos_templates_menu
        WHERE client_id = 0
        AND (menuid = 0 OR menuid = 1)
        ORDER BY menuid DESC
        LIMIT 0, 1
   9.
      SELECT group_id,group_name,group_level
        FROM `jos_vm_auth_group`
        ORDER BY group_level
  10.
      SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                 
        FROM `jos_vm_shopper_group`,`jos_vm_shopper_vendor_xref`
        WHERE jos_vm_shopper_vendor_xref.user_id='63'
        AND jos_vm_shopper_group.shopper_group_id=jos_vm_shopper_vendor_xref.shopper_group_id
  11.
      SELECT COUNT(user_id) AS num_rows
        FROM `jos_vm_user_info`, `jos_users`
                                     
        WHERE `id`=`user_id`
                                     
        AND jos_vm_user_info.user_id='63'
                                     
        AND jos_vm_user_info.address_type='BT'
  12.
      SELECT perms,first_name,last_name,country,zip
        FROM jos_vm_user_info
        WHERE user_id='63'
  13.
      SELECT `vendor_id`
        FROM `jos_vm_auth_user_vendor`
        WHERE `user_id` =63
  14.
      SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                              vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                              vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                              vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                     
        FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                     
        LEFT JOIN jos_vm_state s
        ON (v.vendor_state=s.state_2_code
        AND s.country_id=c.country_id)
                                     
        WHERE `v`.`vendor_id`=1
                                     
        AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  15.
      SELECT module_perms
        FROM jos_vm_module
        WHERE module_name='checkout'
  16.
      SELECT id
        FROM jos_menu
        WHERE link='index.php?option=com_virtuemart'
        AND published=1
  17.
      SELECT product_id, `jos_vm_product`.*
        FROM `jos_vm_product`
        WHERE `product_id`=33
  18.
      SELECT shopper_group_id,shopper_group_discount
        FROM jos_vm_shopper_group
        WHERE vendor_id='1'
        AND `default`='1'
  19.
      SELECT `product_price`, `product_price_id`, `product_currency`
        FROM `jos_vm_product_price`
        WHERE product_id=33
        AND shopper_group_id=6   
        AND (('1' >= price_quantity_start
        AND '1' <= price_quantity_end)
                                      OR (price_quantity_end='0') OR ('1' > price_quantity_end))
        ORDER BY price_quantity_end DESC
  20.
      SELECT state, country
        FROM jos_vm_user_info
        WHERE user_id='63'
  21.
      SELECT tax_rate
        FROM jos_vm_tax_rate
        WHERE tax_country='USA'
        AND (tax_state='NY' OR tax_state=' NY ' OR tax_state='-')
  22.
      SELECT id
        FROM jos_menu
        WHERE link='index.php?option=com_virtuemart'
        AND params LIKE '%product_id=33%'
        AND published=1
  23.
      SELECT id
        FROM jos_menu
        WHERE link='index.php?option=com_virtuemart'
        AND params LIKE '%category_id=10%'
        AND published=1
  24.
      SELECT product_parent_id
        FROM jos_vm_product
        WHERE product_id=33
  25.
      SELECT product_sku,product_parent_id,product_weight,product_weight_uom
        FROM jos_vm_product
        WHERE product_id='33'
  26.
      SELECT state, country
        FROM jos_vm_user_info
        WHERE user_id='63'
  27.
      SELECT tax_rate
        FROM jos_vm_tax_rate
        WHERE tax_country='USA'
        AND (tax_state='NY' OR tax_state=' NY ' OR tax_state='-')
  28.
      SELECT user_info_id
        FROM jos_vm_user_info
        WHERE user_id = '63'
        AND address_type = 'BT'
  29.
      SELECT state, country
        FROM jos_vm_user_info
        WHERE user_id='63'
  30.
      SELECT tax_rate
        FROM jos_vm_tax_rate
        WHERE tax_country='USA'
        AND (tax_state='NY' OR tax_state=' NY ' OR tax_state='-')
  31.
      SELECT state, country
        FROM jos_vm_user_info
        WHERE user_info_id='3685c4debe690876683f2c59796673ca'
  32.
      SELECT *
        FROM jos_vm_tax_rate
        WHERE tax_country='USA'
        AND (tax_state='NY' OR tax_state=' NY ')
  33.
      SELECT COUNT(user_id) AS num_rows
        FROM `jos_vm_user_info`, `jos_users`
                                     
        WHERE `id`=`user_id`
                                     
        AND jos_vm_user_info.user_id='63'
                                     
        AND jos_vm_user_info.address_type='BT'
  34.
      SELECT *
        FROM jos_vm_user_info i
        INNER JOIN jos_vm_country c
        ON (i.country=c.country_3_code OR i.country=c.country_2_code)
        LEFT JOIN jos_vm_state s
        ON (i.state=s.state_2_code
        AND s.country_id=c.country_id)
        WHERE user_id='63'
        AND address_type='BT'
  35.
      SELECT id
        FROM jos_menu
        WHERE link='index.php?option=com_virtuemart'
        AND params LIKE '%page=account.billing%'
        AND published=1
  36.
      SELECT *
        FROM jos_vm_user_info
        WHERE user_id=63
        AND address_type='BT'
  37.
      SELECT *
        FROM jos_vm_user_info i
        INNER JOIN jos_vm_country c
        ON (i.country=c.country_3_code)
        LEFT JOIN jos_vm_state s
        ON (i.state=s.state_2_code
        AND s.country_id=c.country_id)
        WHERE user_id =63
        AND address_type = 'ST'
        ORDER BY address_type_name, mdate DESC
  38.
      SELECT id
        FROM jos_menu
        WHERE link='index.php?option=com_virtuemart'
        AND params LIKE '%page=account.shipto%'
        AND published=1
  39.
      SELECT id, title, module, position, content, showtitle, control, params
        FROM jos_modules AS m
        LEFT JOIN jos_modules_menu AS mm
        ON mm.moduleid = m.id
        WHERE m.published = 1
        AND m.access <= 1
        AND m.client_id = 0
        AND ( mm.menuid = 1 OR mm.menuid = 0 )
        ORDER BY position, ordering
  40.
      SELECT state, country
        FROM jos_vm_user_info
        WHERE user_id='63'
  41.
      SELECT tax_rate
        FROM jos_vm_tax_rate
        WHERE tax_country='USA'
        AND (tax_state='NY' OR tax_state=' NY ' OR tax_state='-')
  42.
      SELECT state, country
        FROM jos_vm_user_info
        WHERE user_id='63'
  43.
      SELECT tax_rate
        FROM jos_vm_tax_rate
        WHERE tax_country='USA'
        AND (tax_state='NY' OR tax_state=' NY ' OR tax_state='-')
  44.
      SELECT id
        FROM jos_menu
        WHERE link='index.php?option=com_virtuemart'
        AND params LIKE '%product_id=33%'
        AND published=1
  45.
      SELECT id
        FROM jos_menu
        WHERE link='index.php?option=com_virtuemart'
        AND params LIKE '%category_id=10%'
        AND published=1
  46.
      SELECT product_parent_id
        FROM jos_vm_product
        WHERE product_id=33
  47.
      SELECT id
        FROM jos_menu
        WHERE link='index.php?option=com_virtuemart'
        AND params LIKE '%page=shop.cart%'
        AND published=1
  48.
      SELECT id
        FROM jos_menu
        WHERE link='index.php?option=com_virtuemart'
        AND params LIKE '%page=shop.cart%'
        AND published=1

4 legacy queries logged

   1.
      SELECT `lft`, `rgt`
        FROM `jos_core_acl_aro_groups`
        WHERE `name`='Public Frontend'
   2.
      SELECT g1.id, g1.name, COUNT(g2.name) AS level

        FROM jos_core_acl_aro_groups AS g1

        INNER JOIN jos_core_acl_aro_groups AS g2
        ON g1.lft BETWEEN g2.lft
        AND g2.rgt

        WHERE g1.lft BETWEEN 3
        AND 12

        GROUP BY g1.name

        ORDER BY g1.lft
   3.
      SELECT `lft`, `rgt`
        FROM `jos_core_acl_aro_groups`
        WHERE `name`='Public Backend'
   4.
      SELECT g1.id, g1.name, COUNT(g2.name) AS level

        FROM jos_core_acl_aro_groups AS g1

        INNER JOIN jos_core_acl_aro_groups AS g2
        ON g1.lft BETWEEN g2.lft
        AND g2.rgt

        WHERE g1.lft BETWEEN 13
        AND 20

        GROUP BY g1.name

        ORDER BY g1.lft

Language Files Loaded

    * /var/www/html/clients/joomla15/language/en-GB/en-GB.ini 1
    * /var/www/html/clients/joomla15/language/en-GB/en-GB.plg_system_debug.ini 1
    * /var/www/html/clients/joomla15/language/en-GB/en-GB.com_virtuemart.ini
    * /var/www/html/clients/joomla15/language/en-GB/en-GB.tpl_joomlatemplatekit2.1.ini
    * /var/www/html/clients/joomla15/language/en-GB/en-GB.mod_virtuemart_cart.ini
    * /var/www/html/clients/joomla15/language/en-GB/en-GB.mod_mainmenu.ini 1
    * /var/www/html/clients/joomla15/language/en-GB/en-GB.mod_search.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None
Title: Re: UPS module not working
Post by: lowmips on February 12, 2010, 04:08:00 AM
it looks like you turned on system debug mode, that's not what I was talking about. There is an error reporting setting..turn it up to the max.
global config->server->server settings->error reporting
Title: Re: UPS module not working
Post by: cinr11 on February 18, 2010, 01:07:37 AM
Working
Title: Re: UPS module not working
Post by: cte2087 on January 26, 2011, 02:09:24 AM
How did you get it to work? Did you apply the patch code after line 300 in ups.php?
Title: Re: UPS module not working
Post by: eubotas on February 19, 2011, 19:56:35 PM
I am having this same problem. With UPS and USPS. How did you get it to work?
Title: Re: UPS module not working
Post by: katalystsol on March 23, 2011, 04:43:52 AM
You might check out this post:

http://forum.virtuemart.net/index.php?topic=69466.0