Zen Cart Logo
Forums / Addon Shipping Modules / MZMT MultiGeoZone MultiTable Shipping [Support Thread]

MZMT MultiGeoZone MultiTable Shipping [Support Thread]

Views: 103,329

Results 141 to 160 of 246
6 Mar 2007, 5:22 PM
#141
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

MZMT MultiGeoZone MultiTable Shipping [Support Thread]

i guess i have to try to reinstall the whole zencart and see if it works... it is a lot of work to add inn all the data again... but a man got to do what a man got to do... :lamo:

6 Mar 2007, 7:23 PM
#142
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

The each() error reported in query_factory is only a symptom of something being requested incorrectly somewhere else in the code. And, without writing a ton of debug code to find out what query is bringing back bad data etc, it's incredibly difficult to track down those particular problems. As such there's no "quick" solution ... hence the lack of responses to your posts.

I'm not so sure you need to re-install the whole cart. You probably have just put a new file in the wrong place or have some unexpected blanks in your settings for the module.

I haven't used the module myself, so cannot comment on it much ... but I've observed that many use it without problems.

Rather than re-installing and losing customization work and data, perhaps installing a fresh copy of Zen Cart in another folder would suffice? then re-apply the mod to that install. make sure it works. Then start comparing differences between working and busted sites ...and resolve issues that way.

7 Mar 2007, 7:46 PM
#143
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

I have installed other modules.
Zone Rates
Group Pricing Per Item
swedish language

mabe it is a conflikt with some of the modules... ill try and remove them if i figre out how... :cool:

7 Mar 2007, 9:43 PM
#144
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

I dont know what happened. But it seems like it is working perfectly now...

There is a God :cool:

10 Mar 2007, 12:17 AM
#145
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

Same problem here...
i made 46 Geo zones and 1 table for each geo zone.

10 Mar 2007, 11:26 AM
#146
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

I have 49 Geo Zone and 1 table or each zone.
When i order something from an adress in Geo Zone 1, 2 and 3 everything works fine, but when i order something from an adress from 4 and up it wont work.
This is the error i get when i order from an adress in Geo Zone 5:

[B]Warning[/B]: constant() [function.constant[/URL]]:  Couldn't find constant MODULE_SHIPPING_MZMT_GEOZONE_5_TEXT_TITLE in  [B]/home/purityfa/public_html/ehandel/includes/modules/shipping/mzmt.php[/B] on  line [B]67[/B]

[B]Warning[/B]: constant() [function.constant]: Couldn't find constant  MODULE_SHIPPING_MZMT_GEOZONE_5_TABLE_1_TEXT_WAY in  [B]/home/purityfa/public_html/ehandel/includes/modules/shipping/mzmt.php[/B] on  line [B]125[/B]

[B]Warning[/B]: constant() [function.constant]: Couldn't find constant  MODULE_SHIPPING_MZMT_GEOZONE_5_ICON in  [B]/home/purityfa/public_html/ehandel/includes/modules/shipping/mzmt.php[/B] on  line [B]134[/B]
     
```I did change the number of **Geo Zone** before i installed the module in admin module shipping.

This is the table i use in **Geo Zone 5: **

1:77,4:80,6:97,11:106,16:130,40:137,60:152,80:169,100:182,150:247,200:296,250:343,300:393,350:438,400:484,450:529,500:570,550:614,600:660,650:705,700:745,750:792,800:836,850:879,900:922,950:961,1000:1006


I have not set a table for all 49 **Geo Zone's** yet, but i dont belive that will give this error.
10 Mar 2007, 6:30 PM
#147
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

I tryed to reduce the Geo Zones to 10. Reinstalled the module and entered the table to all zones. No luck. Still gives the same error.

Is this a bug or shall i keep tring to get this to work?

Wuld love a hint on what to do to fix this... :cool:

11 Mar 2007, 6:52 PM
#148
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

This is how my mzmt.php file is:

<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce                                       |
// +----------------------------------------------------------------------+
// | Copyright (c) 2004 Josh Dechant                                      |
// |                                                                      |
// | Portions Copyright (c) 2004 The zen-cart developers                  |
// |                                                                      |
// | http://www.zen-cart.com/index.php                                    |
// |                                                                      |
// | Portions Copyright (c) 2003 osCommerce                               |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license,       |
// | that is bundled with this package in the file LICENSE, and is        |
// | available through the world-wide-web at the following url:           |
// | http://www.zen-cart.com/license/2_0.txt.                             |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to       |
// | [email protected] so we can mail you a copy immediately.          |
// +----------------------------------------------------------------------+
// $Id: mzmt.php,v 1.101 2004-10-31 Josh Dechant Exp $
//

  class mzmt {
    var $code, $title, $description, $icon, $enabled, $num_zones, $num_tables, $delivery_geozone, $order_total;
  
    function mzmt() {
      global $order;

      $this->code = 'mzmt';
      $this->title = MODULE_SHIPPING_MZMT_TEXT_TITLE;
      $this->description = MODULE_SHIPPING_MZMT_TEXT_DESCRIPTION;
      $this->sort_order = MODULE_SHIPPING_MZMT_SORT_ORDER;
      $this->tax_class = MODULE_SHIPPING_MZMT_TAX_CLASS;
      $this->tax_basis = MODULE_SHIPPING_MZMT_TAX_BASIS;

      $this->num_geozones = MODULE_SHIPPING_MZMT_NUMBER_GEOZONES;
      $this->num_tables = MODULE_SHIPPING_MZMT_NUMBER_TABLES;

      // disable only when entire cart is free shipping
      if (zen_get_shipping_enabled($this->code)) {
        $this->enabled = ((MODULE_SHIPPING_MZMT_STATUS == 'True') ? true : false);
      }

      if ($this->enabled == true) {
        $this->enabled = false;
        for ($n=1; $n<=$this->num_geozones; $n++) {
          if ( ((int)constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $n . '_ID') > 0) && ((int)constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $n . '_ID') == $this->getGeoZoneID($order->delivery['country']['id'], $order->delivery['zone_id'])) ) {
            $this->enabled = true;
            $this->delivery_geozone = $n;
            break;
          } elseif ( ((int)constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $n . '_ID') == 0) && ($n == (int)$this->num_geozones) ) {
            $this->enabled = true;
            $this->delivery_geozone = $n;
            break;
          }
        }
      }
    }

// class methods
    function quote($method = '') {
      global $order, $shipping_weight, $shipping_num_boxes, $template;

      $this->quotes = array('id' => $this->code,
                            'module' => constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $this->delivery_geozone . '_TEXT_TITLE'),
                            'methods' => array());

      $geozone_mode = $this->determineTableMethod(constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $this->delivery_geozone . '_MODE'));  
      
      if ($method) {
        $j = substr($method, 5);

        $shipping = $this->determineShipping(split("[:,]" , constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $this->delivery_geozone . '_TABLE_' . $j)));

        if ($geozone_mode == 'weight') {
          $shipping = $shipping * $shipping_num_boxes;
          // show boxes if weight
          switch (SHIPPING_BOX_WEIGHT_DISPLAY) {
            case (0):
              $show_box_weight = '';
              break;
            case (1):
              $show_box_weight = ' (' . $shipping_num_boxes . ' ' . TEXT_SHIPPING_BOXES . ')';
              break;
            case (2):
              $show_box_weight = ' (' . number_format($shipping_weight,2) . TEXT_SHIPPING_WEIGHT . ')';
              break;
            default:
              $show_box_weight = ' (' . $shipping_num_boxes . ' x ' . number_format($shipping_weight,2) . TEXT_SHIPPING_WEIGHT . ')';
              break;
          }
        }
        
        $this->quotes['methods'][] = array('id' => 'table' . $j,
                                           'title' => constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $this->delivery_geozone . '_TABLE_' . $j . '_TEXT_WAY') . $show_box_weight,
                                           'cost' => $shipping + constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $this->delivery_geozone . '_HANDLING'));
      } else {
        for ($j=1; $j<=$this->num_tables; $j++) {
          if (!zen_not_null(constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $this->delivery_geozone . '_TABLE_' . $j))) continue;

          $shipping = $this->determineShipping(split("[:,]" , constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $this->delivery_geozone . '_TABLE_' . $j)));

          if ($geozone_mode == 'weight') {
            $shipping = $shipping * $shipping_num_boxes;
            // show boxes if weight
            switch (SHIPPING_BOX_WEIGHT_DISPLAY) {
              case (0):
                $show_box_weight = '';
                break;
              case (1):
                $show_box_weight = ' (' . $shipping_num_boxes . ' ' . TEXT_SHIPPING_BOXES . ')';
                break;
              case (2):
                $show_box_weight = ' (' . number_format($shipping_weight,2) . TEXT_SHIPPING_WEIGHT . ')';
                break;
              default:
                $show_box_weight = ' (' . $shipping_num_boxes . ' x ' . number_format($shipping_weight,2) . TEXT_SHIPPING_WEIGHT . ')';
                break;
            }
          }

          $this->quotes['methods'][] = array('id' => 'table' . $j,
                                             'title' => constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $this->delivery_geozone . '_TABLE_' . $j . '_TEXT_WAY') . $show_box_weight,
                                             'cost' => $shipping + constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $this->delivery_geozone . '_HANDLING'));
        }
      }

      if ($this->tax_class > 0) {
        $this->quotes['tax'] = zen_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
      }

      if (zen_not_null(constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $this->delivery_geozone . '_ICON'))) $this->quotes['icon'] = zen_image($template->get_template_dir(constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $this->delivery_geozone . '_ICON'), DIR_WS_TEMPLATE, $current_page_base,'images/icons'). '/' . constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $this->delivery_geozone . '_ICON'), $this->title);

      return $this->quotes;
    }  

    function check() {
      global $db;

      if (!isset($this->_check)) {
        $check_query = $db->Execute("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_MZMT_STATUS'");
        $this->_check = $check_query->RecordCount();
      }
      return $this->_check;
    }

    function install() {
      global $db;

      $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable MultiRegion MultiTable Method', 'MODULE_SHIPPING_MZMT_STATUS', 'True', 'Do you want to offer multi-region multi-table rate shipping?', '6', '0', 'zen_cfg_select_option(array(\'True\', \'False\'), ', now())");
      $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Tax Class', 'MODULE_SHIPPING_MZMT_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', '6', '0', 'zen_get_tax_class_title', 'zen_cfg_pull_down_tax_classes(', now())");
      $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Tax Basis', 'MODULE_SHIPPING_MZMT_TAX_BASIS', 'Shipping', 'On what basis is Shipping Tax calculated. Options are<br />Shipping - Based on customers Shipping Address<br />Billing Based on customers Billing address<br />Store - Based on Store address if Billing/Shipping Zone equals Store zone', '6', '0', 'zen_cfg_select_option(array(\'Shipping\', \'Billing\', \'Store\'), ', now())");
      $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_SHIPPING_MZMT_SORT_ORDER', '0', 'Sort order of display.', '6', '0', now())");

      for ($n=1; $n<=$this->num_geozones; $n++) {
        $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('<hr />Geo Zone $n', 'MODULE_SHIPPING_MZMT_GEOZONE_{$n}_ID', '', 'Enable this for the following geo zone.', '6', '0', 'zen_get_zone_class_title', '_cfg_pull_down_geozones(', now())");
        $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Geo Zone $n Table Method', 'MODULE_SHIPPING_MZMT_GEOZONE_{$n}_MODE', 'weight', 'The shipping cost is based on the total weight, total price, or total count of the items ordered.', '6', '0', 'zen_cfg_select_option(array(\'weight\', \'price\', \'count\'), ', now())");
        
        for ($j=1; $j<=$this->num_tables; $j++) {
          $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Geo Zone $n Shipping Table $j', 'MODULE_SHIPPING_MZMT_GEOZONE_{$n}_TABLE_{$j}', '', 'Shipping table $j for this geo zone', '6', '0', now())");
        }

        $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Geo Zone $n Handling Fee', 'MODULE_SHIPPING_MZMT_GEOZONE_{$n}_HANDLING', '0', 'Handling Fee for this shipping geo zone', '6', '0', now())");
      }
    }

    function remove() {
      global $db;

      $db->Execute("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
    }

    function keys() {
      $keys = array('MODULE_SHIPPING_MZMT_STATUS', 'MODULE_SHIPPING_MZMT_TAX_CLASS', 'MODULE_SHIPPING_MZMT_TAX_BASIS', 'MODULE_SHIPPING_MZMT_SORT_ORDER');

      for ($n=1; $n<=$this->num_geozones; $n++) {
        $keys[] = 'MODULE_SHIPPING_MZMT_GEOZONE_' . $n . '_ID';
        $keys[] = 'MODULE_SHIPPING_MZMT_GEOZONE_' . $n . '_MODE';
        $keys[] = 'MODULE_SHIPPING_MZMT_GEOZONE_' . $n . '_HANDLING';

        for ($j=1; $j<=$this->num_tables; $j++) {
          $keys[] = 'MODULE_SHIPPING_MZMT_GEOZONE_' . $n . '_TABLE_' . $j;
        }
      }

      return $keys;
    }

    function determineTableMethod($geozone_mode) {
      global $total_count, $shipping_weight;

      switch ($geozone_mode) {
        case 'price':
          if (method_exists($_SESSION['cart'], 'free_shipping_prices')) {
            $this->order_total = $_SESSION['cart']->show_total() - $_SESSION['cart']->free_shipping_prices();
          } else {
            $this->order_total = $_SESSION['cart']->show_total();
          }
          break;

        case 'count':
          if (method_exists($_SESSION['cart'], 'free_shipping_items')) {
            $this->order_total = $total_count - $_SESSION['cart']->free_shipping_items();
          } else {
            $this->order_total = $total_count;
          }
          break;

        case 'weight':
          $this->order_total = $shipping_weight;
          break;
      }

      return $geozone_mode;    
    }

    function determineShipping($table_cost) {
      for ($i=0, $n=sizeof($table_cost); $i<$n; $i+=2) {
        if ($this->order_total >= $table_cost[$i]) {
          $shipping_factor = $table_cost[$i+1];
        }
      }

      if (substr_count($shipping_factor, '%') > 0) {
        $shipping = ((($this->order_total*10)/10)*((str_replace('%', '', $shipping_factor))/100));
      } else {
        $shipping = str_replace('$', '', $shipping_factor);
      }
      
      return $shipping;
    }

    function getGeoZoneID($country_id, $zone_id) {
      global $db;

      // First, check for a Geo Zone that explicity includes the country & specific zone (useful for splitting countries with zones up)
      $zone = $db->Execute("select gz.geo_zone_id from " . TABLE_GEO_ZONES . " gz left join " . TABLE_ZONES_TO_GEO_ZONES . " ztgz on (gz.geo_zone_id = ztgz.geo_zone_id) where ztgz.zone_country_id = '" . (int)$country_id . "' and ztgz.zone_id = '" . (int)$zone_id . "' and LOWER(gz.geo_zone_name) like 'shp%'");

      if ($zone->RecordCount() > 0) {
        return $zone->fields['geo_zone_id'];
      } else {
        // No luck…  Now check for a Geo Zone for the country and "All Zones" of the country.
        $zone = $db->Execute("select gz.geo_zone_id from " . TABLE_GEO_ZONES . " gz left join " . TABLE_ZONES_TO_GEO_ZONES . " ztgz on (gz.geo_zone_id = ztgz.geo_zone_id) where ztgz.zone_country_id = '" . (int)$country_id . "' and (ztgz.zone_id = '0' or ztgz.zone_id is NULL) and LOWER(gz.geo_zone_name) like 'shp%'");

        if ($zone->RecordCount() > 0) {
          return $zone->fields['geo_zone_id'];
        } else {
          return false;
        }
      }
    }

  }

  function _cfg_pull_down_geozones($zone_class_id, $key = '') {
    global $db;

    $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');

    $zone_class_array = array(array('id' => '0', 'text' => 'Rest of the World'));
    $zone_class = $db->Execute("select geo_zone_id, geo_zone_name from " . TABLE_GEO_ZONES . " where LOWER(geo_zone_name) like 'shp%' order by geo_zone_name");

    while (!$zone_class->EOF) {
      $zone_class_array[] = array('id' => $zone_class->fields['geo_zone_id'],
                                  'text' => $zone_class->fields['geo_zone_name']);
      $zone_class->MoveNext();
    }

    return zen_draw_pull_down_menu($name, $zone_class_array, $zone_class_id);
  }
?>
```I have now set Geo zone to 50 with one table each...
I dont understand much php, but it seems that when i sett the Geo zone to a number that is Higher than 3, it still acts like it is only 3 Geo Zones. 

When i order something from Geozone 4 and up i get the same error. The errormessage change the number ekual to the zone. 
this is from Geozone4: 

[B]Warning[/B]: constant() [[URL="http://viskarent.com/ehandel/function.constant"]function.constant[/URL]]: Couldn't find constant MODULE_SHIPPING_MZMT_GEOZONE_4_TEXT_TITLE in [B]/home/purityfa/public_html/ehandel/includes/modules/shipping/mzmt.php[/B] on line [B]67[/B]

[B]Warning[/B]: constant() [[URL="http://viskarent.com/ehandel/function.constant"]function.constant[/URL]]: Couldn't find constant MODULE_SHIPPING_MZMT_GEOZONE_4_TABLE_1_TEXT_WAY in [B]/home/purityfa/public_html/ehandel/includes/modules/shipping/mzmt.php[/B] on line [B]125[/B]

[B]Warning[/B]: constant() [[URL="http://viskarent.com/ehandel/function.constant"]function.constant[/URL]]: Couldn't find constant MODULE_SHIPPING_MZMT_GEOZONE_4_ICON in [B]/home/purityfa/public_html/ehandel/includes/modules/shipping/mzmt.php[/B] on line [B]134[/B]

11 Mar 2007, 7:21 PM
#149
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

i figured it out...

I dont know if it is a bug or that the module is not that userfriendly, but when the users change the Geo Zone number, it is not changing the mzmt.php language file. This must be done manualy.

this is the default variables:

define('MODULE_SHIPPING_MZMT_GEOZONE_1_TEXT_TITLE', 'United Parcel Service (UPS)');
define('MODULE_SHIPPING_MZMT_GEOZONE_1_ICON', 'shipping_ups.gif');
define('MODULE_SHIPPING_MZMT_GEOZONE_1_TABLE_1_TEXT_WAY', 'Ground');
define('MODULE_SHIPPING_MZMT_GEOZONE_1_TABLE_2_TEXT_WAY', 'Second Day');
define('MODULE_SHIPPING_MZMT_GEOZONE_1_TABLE_3_TEXT_WAY', 'Next Day');

define('MODULE_SHIPPING_MZMT_GEOZONE_2_TEXT_TITLE', '');
define('MODULE_SHIPPING_MZMT_GEOZONE_2_ICON', '');
define('MODULE_SHIPPING_MZMT_GEOZONE_2_TABLE_1_TEXT_WAY', '');
define('MODULE_SHIPPING_MZMT_GEOZONE_2_TABLE_2_TEXT_WAY', '');
define('MODULE_SHIPPING_MZMT_GEOZONE_2_TABLE_3_TEXT_WAY', '');

define('MODULE_SHIPPING_MZMT_GEOZONE_3_TEXT_TITLE', '');
define('MODULE_SHIPPING_MZMT_GEOZONE_3_ICON', '');
define('MODULE_SHIPPING_MZMT_GEOZONE_3_TABLE_1_TEXT_WAY', '');
define('MODULE_SHIPPING_MZMT_GEOZONE_3_TABLE_2_TEXT_WAY', '');
define('MODULE_SHIPPING_MZMT_GEOZONE_3_TABLE_3_TEXT_WAY', '');
```Here is only  the 3 default Geozones defined. I figured out that i must add the codes to each Geozone manualy... 

I must say that i am a bit proud over myself that i actually found this out of my own... :smartass: 
There is no instructions in the readme file or anywhere else in the forums about this that i have found... but wait... now it is... :cool:
11 Mar 2007, 7:49 PM
#150
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

okey... now i got this new error suddenly:

[B]Warning[/B]:  Variable passed to each() is not an array or object in [B]/home/purityfa/public_html/ehandel/includes/classes/db/mysql/query_factory.php[/B] on line [B]114[/B]

[B]Warning[/B]:  session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/purityfa/public_html/ehandel/includes/classes/db/mysql/query_factory.php:114) in [B]/home/purityfa/public_html/ehandel/includes/functions/sessions.php[/B] on line [B]108[/B]

[B]Warning[/B]: Cannot modify header information - headers already sent by (output started at /home/purityfa/public_html/ehandel/includes/classes/db/mysql/query_factory.php:114) in [B]/home/purityfa/public_html/ehandel/includes/init_includes/init_templates.php[/B] on line [B]78[/B]
```Starting to get frustrated.... :cool:
11 Mar 2007, 8:11 PM
#151
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

Its the same error i got before i got the Geozone error. One step forward, 2 steps back...

http://www.zen-cart.com/forum/showthread.php?t=60106

Continue will follow in other thread...

11 Mar 2007, 8:15 PM
#152
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

Error is back again. God, why have you forsaken me ?

13 Mar 2007, 5:05 PM
#153
netwiser avatar

netwiser

New Zenner

Join Date:
Aug 2006
Posts:
49
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

I have installed the shipping module and imported the database
however in Step 3 of the install it says Setup Pre-configuration from Admin -> Configuration -> MultiGeoZone MultiTable Shipping ..

I have 2 MultiGeoZone MultiTable Shipping entries under Admin -> Configuration ->

And both appear to have nothing under them to configure ...

I will be happy to give proper access to anyone that may know what I have mucked up :-)

Thanks,

Bob
:lamo:

14 Mar 2007, 2:55 PM
#154
dreamscape avatar

dreamscape

Totally Zenned

Join Date:
Nov 2003
Posts:
721
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

dantien:

There is no instructions in the readme file or anywhere else

It says so right in Section 3 of the README if you bother to read it. :sleepy:

14 Mar 2007, 7:43 PM
#155
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

I apologize for writing that.

After reading the section 3 now again i understand what it meant. I did read it but did not understand what it meant until now... :blush:

Peace

15 Mar 2007, 10:55 PM
#156
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

Status report:

Tryed to do what DrByte sugested and made a second zencart and try to figure out if there is something different. But did not find out what whas wrong. I gave up and started to do bild a new cart with all data. It did go a bit faster this tome tho.

The new cart works perfect with the MZMT module so far and i am very happy about that. Now i can get on with my life. :cool:

Peace

16 Mar 2007, 5:12 PM
#157
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

Well...

The MZMT module worked perfectly to when i added a table in zone 16. All tables from to 1 to 15 works. And the funny thing is that if i clear the table 15 and ad it in zone 16 it works fine.

I also get the error if i add table 15 in both zone 15 and zone 16. So it seems like the max tables in the Geozones is 15 even if i add 50 Geozones. :cry:

Here is my shipping tables from 1 to 17:

Zone 1 Shipping Table
1:77,4:80,6:97,11:106,16:130,60:137,80:143,100:155,150:201,200:242,250:280,300:321,350:361,400:399,450:435,500:468,550:507,600:545,650:584,700:614,750:655,800:690,850:728,900:763,950:795,1000:833

Zone 2 Shipping Table
1:77,4:80,6:97,11:106,16:130,40:137,60:152,80:169,100:182,150:224,200:268,250:310,300:352,350:394,400:435,450:474,500:513,550:554,600:594,650:636,700:672,750:712,800:750,850:792,900:831,950:865,1000:906

Zone 3 Shipping Table
1:77,4:80,6:97,11:106,16:130,40:137,60:152,80:169,100:182,150:228,200:275,250:320,300:362,350:406,400:447,450:492,500:527,550:570,600:611,650:654,700:691,750:732,800:774,850:813,900:852,950:890,1000:933

Zone 4 Shipping Table
1:77,4:80,6:97,11:106,16:130,40:137,60:152,80:169,100:182,150:236,200:282,250:328,300:372,350:415,400:460,450:503,500:544,550:588,600:628,650:672,700:709,750:751,800:794,850:836,900:876,950:914,1000:959

Zone 5 Shipping Table
1:77,4:80,6:97,11:106,16:130,40:137,60:152,80:169,100:182,150:247,200:296,250:343,300:393,350:438,400:484,450:529,500:570,550:614,600:660,650:705,700:745,750:792,800:836,850:879,900:922,950:961,1000:1006

Zone 6 Shipping Table
1:77,4:80,6:97,11:106,16:130,40:152,60:172,70:193,90:212,150:256,200:307,250:357,300:403,350:451,400:498,450:544,500:585,550:635,600:677,650:723,700:767,750:812,800:856,850:902,900:945,950:984,1000:1030

Zone 7 Shipping Table
1:77,4:80,6:97,11:106,16:130,30:137,40:152,60:172,70:193,90:212,150:265,200:315,250:364,300:411,350:460,400:509,450:558,500:599,550:648,600:694,650:741,700:786,750:832,800:878,850:924,900:966,950:1010,1000:1059

Zone 8 Shipping Table
1:77,4:80,6:97,11:106,16:130,30:137,40:152,60:172,70:193,90:212,150:270,200:323,250:372,300:424,350:471,400:521,450:568,500:613,550:664,600:710,650:756,700:803,750:850,800:897,850:946,900:991,950:1030,1000:1083

Zone 9 Shipping Table
1:77,4:80,6:97,11:106,16:130,30:137,40:152,60:172,70:193,90:212,150:275,200:330,250:384,300:431,350:484,400:531,450:584,500:630,550:677,600:728,650:777,700:824,750:869,800:918,850:968,900:1011,950:1059,1000:1107

Zone 10 Shipping Table
1:77,4:80,6:97,11:106,16:130,30:137,40:152,60:172,70:193,90:212,150:280,200:338,250:392,300:444,350:497,400:547,450:596,500:641,550:695,600:744,650:794,700:838,750:890,800:940,850:989,900:1034,950:1080,1000:1132

Zone 11 Shipping Table
1:77,4:80,6:97,11:106,16:130,20:137,30:148,40:166,60:189,70:220,90:239,150:294,200:356,250:410,300:462,350:517,400:570,450:622,500:673,550:724,600:778,650:831,700:878,750:931,800:978,850:1033,900:1080,950:1129,1000:1180

Zone 12 Shipping Table
1:77,4:80,6:97,11:106,16:130,20:138,30:148,40:166,60:189,70:220,90:239,150:303,200:362,250:417,300:471,350:529,400:581,450:637,500:686,550:741,600:794,650:846,700:897,750:950,800:1001,850:1055,900:1103,950:1153,1000:1204

Zone 13 Shipping Table
1:77,4:80,6:97,11:106,16:130,20:138,30:148,40:166,60:189,70:220,90:239,150:308,200:371,250:428,300:484,350:541,400:595,450:652,500:700,550:756,600:812,650:863,700:914,750:969,800:1021,850:1076,900:1128,950:1178,1000:1230

Zone 14 Shipping Table
1:77,4:80,6:97,11:106,16:130,20:138,30:148,40:166,60:189,70:220,90:239,150:312,200:376,250:431,300:493,350:550,400:604,450:660,500:712,550:772,600:826,650:881,700:932,750:987,800:1042,850:1096,900:1147,950:1201,1000:1253

Zone 15 Shipping Table
1:77,4:80,6:97,11:106,16:130,20:138,30:148,40:166,60:189,70:220,90:239,150:315,200:379,250:438,300:498,350:558,400:613,450:672,500:724,550:786,600:840,650:897,700:951,750:1005,800:1062,850:1119,900:1171,950:1225,1000:1279

Zone 16 Shipping Table
1:77,4:80,6:97,11:106,16:130,20:138,30:148,40:166,60:189,70:220,90:239,150:317,200:381,250:445,300:503,350:563,400:622,450:684,500:735,550:797,600:855,650:910,700:968,750:1024,800:1083,850:1138,900:1193,950:1247,1000:1306

Zone 17 Shipping Table
1:77,4:80,6:97,11:106,16:130,20:138,30:148,40:166,60:189,70:220,90:239,150:323,200:392,250:454,300:517,350:580,400:641,450:701,500:759,550:824,600:884,650:945,700:1001,750:1062,800:1121,850:1183,900:1235,950:1294,1000:1356
```Is there something i can do to add more that 15 tables in the Geozone without getting this error? : 

[B]Warning[/B]: Variable passed to each() is not an array or object in [B]/home/purityfa/public_html/produkter/includes/classes/db/mysql/query_factory.php[/B] on line [B]114[/B]

[B]Warning[/B]: session_start() [[URL="http://viskarent.com/produkter/function.session-start"]function.session-start[/URL]]: Cannot send session cache limiter - headers already sent (output started at /home/purityfa/public_html/produkter/includes/classes/db/mysql/query_factory.php:114) in [B]/home/purityfa/public_html/produkter/includes/functions/sessions.php[/B] on line [B]108[/B]

[B]Warning[/B]: Cannot modify header information - headers already sent by (output started at /home/purityfa/public_html/produkter/includes/classes/db/mysql/query_factory.php:114) in [B]/home/purityfa/public_html/produkter/includes/init_includes/init_templates.php[/B] on line [B]78[/B]

17 Mar 2007, 11:45 AM
#158
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

It seems to me that the tables have a limit of some sort. When i shorten all the tables i am able to add more tables in zone 16 and abow.

I cant shorten the tables to complete all Geozones, so this is a big problem for me...

17 Mar 2007, 8:10 PM
#159
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

Another strange thing that i just discovered is that when i only have the 15 zones and the module is ok, I also get this error when i install another shipping module that is on the list in shipping module.

The shop is useless if i cant add a complete set of 39 Geozones. And hopefully one other shipping module like Zone Rates.

I wonder if i am writing so everyone understand.

What shuld i do ?

I got a lot of pressure on me to get this shop running, and i realy didnt think that this shipping module wuld stop me as it have done now in 2 weeks.

Please help...

17 Mar 2007, 9:17 PM
#160
dantien avatar

dantien

New Zenner

Join Date:
Dec 2006
Posts:
31
Plugin Contributions:
0

Re: MZMT MultiGeoZone MultiTable Shipping [Support Thread]

Does it have something to do with this?

"Lastly, there is a limit of 255 characters on each of the Zone Shipping Tables and Zone Countries. This can be changed in the database to suit your needs."