Thread: Mzmt Sql

Page 1 of 8 123 ... LastLast
Results 1 to 10 of 72
  1. #1
    Join Date
    Oct 2005
    Posts
    44
    Plugin Contributions
    0

    Default

    I'm trying to execute the zone sql statements for my MZMT. I have the basic MZMT files copied over and the module is installed.

    I am receiving errors when running the US geo zone sql.

    When I run the script through zencart admin/tools/Install SQL patches I receive the following error: 1064 You have an error in your SQL syntax near 'geo_zones` VALUES ('', 'Shp: United States: 48', 'United States: Continental 48' at line 1

    Merlinpa1969 advised that I should run the scripts through phpMyAdmin, this did not work either.

    I then received this error: #1146 - Table geo_zones doesn't exist

    I looked through my tables and I have a zen_geo_zones table, but not a geo_zones table.

    Is there something I need to change in the script or is there something I forgot to do?

    The only thing I can think of is in the setup instructions it states that the pre defined zones are set up with "shp" at the beginning of the filename.

    I'm just not sure.

  2. #2
    Join Date
    Oct 2005
    Posts
    4
    Plugin Contributions
    0

    Default

    Table geo_zones doesn't exist - that is correct because you used the default prefix of zen_ - the sql was designed for use through the admin section which automagically appends zen_

    Open the SQL in your fav editor and alter the table name to zen_geo_zones and run through phpMyAdmin - that should run the query ok

  3. #3
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: MZMT SQL error

    rather that trying to use phpmyadmin to insert use the sql updater in the zen cart admin under tools

    the bterry_
    is the database name

    the zen_ is the table name

    you are recieving this error in phpmyadmin because of the db prefix
    zen cart sql updater will add this prefix for you

  4. #4
    Join Date
    Jul 2005
    Posts
    11
    Plugin Contributions
    0

    Default Re: MZMT SQL error

    It worked! Thank you so much! :)

  5. #5
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: MZMT SQL error

    quite welcome,

  6. #6
    Join Date
    Jan 2006
    Posts
    45
    Plugin Contributions
    0

    Default MZMT default radio button selection

    Hi all,

    I use MZMT shipping module. I am just wondering how does it select the default radio button. For instance, I use 2 tables for each state. One table is for regular post and the other table for registered post. Obviously, registered postage is a bit more expensive than the regular. In my checkout, I display registered post first, then regular post below that. The regular post is selected (checked) by default. I would like to have registered post selected by default. How do I achieve this? I guess mzmt is set up to select the cheaper option by default. I went through mzmt source code but couldnt quite find the solution. Please let me know if any of you are aware of this. Thanks a lot!

    Ben

  7. #7
    Join Date
    Nov 2003
    Posts
    783
    Plugin Contributions
    2

    Default Re: MZMT default radio button selection

    Quote Originally Posted by chillout_buddha
    I guess mzmt is set up to select the cheaper option by default.
    No it does not. Zen Cart selects the cheapest option by default.

  8. #8
    Join Date
    Apr 2006
    Posts
    44
    Plugin Contributions
    0

    Default MZMT Only Shows Handling Fee

    Hi,
    I just installed MZMt and configured it with the pre-built GeoZones. (I created my own GeoZone for Canada).

    Configured my tables for price (not weight) as follows:

    62.99:6.50,99.99:8.50,199.99:12,299.99:15,300:20

    My problem is that when I ship to a Canadian address the shipping method only shows the handling fee of $7.00 and not the rest of the rate for the price of the order. If I delete the handling fee, the shipping charge is $0.00.

    Next, if I select a US address, it charges $0.00 and the shipping estimator in the cart shows:
    United Parcel Service (UPS) (Ground) $0.00
    I don't have the UPS module installed.

    My last issue, is that i need a way to have an expedited shipping charge, but I'm not using a specific module (fedex/usps/ups), I had it set up using table rate with an additional charge of $12.00 (prior to installing MZMT).

    Anyone offer some help please?

    The site is at:
    http://staging.mindmint.s402.sureserver.com/
    --
    Brad Schwartz <baschwar at baschwar dot com>
    http://www.baschwar.com/

  9. #9
    Join Date
    Nov 2003
    Posts
    783
    Plugin Contributions
    2

    Default Re: MZMT Only Shows Handling Fee

    Quote Originally Posted by baschwar
    My problem is that when I ship to a Canadian address the shipping method only shows the handling fee of $7.00 and not the rest of the rate for the price of the order. If I delete the handling fee, the shipping charge is $0.00.
    According to your table, I must order at least $62.99 to be charged for shipping.

    Quote Originally Posted by baschwar
    I don't have the UPS module installed.
    The name of the shipping method comes from the language file.

    Quote Originally Posted by baschwar
    My last issue, is that i need a way to have an expedited shipping charge
    Use multiple tables for multiple shipping methods. In the current version, it is best to think of each table as a shipping method (to a specific destination).

  10. #10
    Join Date
    Apr 2006
    Posts
    44
    Plugin Contributions
    0

    Default Re: MZMT Only Shows Handling Fee

    Hi,

    Thanks... those were all my issues. I misunderstood in the FAQ the >= vs. <=, my own fault.

    And, I edited the mzmt.php file and everything seems good now.

    Thanks,

    Brad
    --
    Brad Schwartz <baschwar at baschwar dot com>
    http://www.baschwar.com/

 

 
Page 1 of 8 123 ... LastLast

Similar Threads

  1. MZMT SQL error
    By iron_chick in forum Addon Payment Modules
    Replies: 70
    Last Post: 29 May 2010, 08:41 AM
  2. MZMT problem
    By cadfc in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 30 Mar 2010, 04:02 PM
  3. mzmt
    By msdave in forum Addon Shipping Modules
    Replies: 9
    Last Post: 24 Dec 2007, 01:19 PM
  4. Export SQL table for mzmt zones for Australia
    By alan57m in forum Addon Shipping Modules
    Replies: 0
    Last Post: 7 Dec 2007, 03:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR