Jump to content

Two Pillars

  • Content count

  • Joined

  • Last visited

Posts posted by Two Pillars

  1. Tried to figure this one out by myself and have had no luck. After I initially installed 2.04 and had issues (see previous post in this forum) I replaced the three files with the 2.06 version files. Now, under Shipping Modules, I see the currently installed modules, but when I click the Install Module button, it does not display any available modules. There is a number 6 in parentheses on the Install Module button, so I know they're there. It for some reason is not displaying the modules currently available. I've checked several times with file comparison tools that the edits made to the admin/modules.php file are correct and they appear fine. What else could be causing this?


    ***Nevermind...found the problem exactly 5 minutes after the original post. Typical. Had to do with an old version file of Fedex web services in the Shipping folder.

  2. Ran into two issues during and after installation on a store I updated to


    1) In admin/modules.php there two MZMT code additions/changes, ok, no problem. These two were taken care of using a file compare tool. There was a third change from my original admin/modules.php file below the two MZMT and was commented as // usps_codes and had one line of code following it. It did not show in my modules file. Is this part of this addon or something from a separate addon?


    2) Once the three files included were uploaded (1 in admin, 2 in includes), I proceeded to follow the instructions in the Configuration section of the manual. No problem until Section 3.2 on Page 11 following the "Update" bullet. I added three Geo Zones and 3 Tables/Geo Zone and clicked save. Clicked Edit and it gave me 33 empty field entry boxes below the Update checkbox. All with no text, just the boxes. No pull down menus either. Any ideas what has happened?

  3. Fixed the "Remove" trash can icon out on the right side of the screen by changing this line in stylesheet.css

    #checkoutPage div.cartRow6 {position:absolute;right:0;width:75px;text-align:center;}

    to this

    #checkoutPage div.cartRow6 {float:left;width:75px;text-align:center;}


    Works in Chrome, not tested in any other browser.


    Still have no idea why the Subtotal and Total are showing $0.00 however...any help me figure this one out???

  4. Ok, I have simple checkout and guest checkout installed. They work fine with fix by MiCR0 to actually show the shipping and billing address instead of a "," but... still have the "trash" icon out on of the box, although I think I can isolate this and fix it myself.


    The real problem is that BOTH the Sub-Total and Total show $0.00, no matter if the Update button is refreshed or the browser is refreshed. Any ideas on how to fix this issue? This appears in both Chrome and IE8.

  5. Anyone ever figure this out???? My subcategories aren't showing either... only items listed in categories show. I have a sneaking suspicion that if I moved the items in the categories into subcategories, such that all items were in subcategories, it would work fine.

    Nope, just moved the items directly in the categories into new subcategories and no dice. Now it says there are no products to show! So now I guess I'll pick through the query to see what I can find...

  6. here are the quety that don't show products in subcategories.


    $print_catalog_query_raw = "select distinct p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, cd.categories_name, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id=p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id=c.categories_id left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on c.parent_id='0' and c.categories_id=cd.categories_id left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . $languages_id . "' and cd.language_id = '" . $languages_id . "' order by cd.categories_name, c.parent_id, c.sort_order, c.categories_id, pd.products_name";


    Anyone ever figure this out???? My subcategories aren't showing either... only items listed in categories show. I have a sneaking suspicion that if I moved the items in the categories into subcategories, such that all items were in subcategories, it would work fine.

  7. Thanks for the fix Morgan! The only problem I'm having is when running the sql in your fix I get the following error:


    #1060 - Duplicate column name 'attribute_sort'


    I'm still learning... What is the fix for this? Or has it already been inserted in the mysql statement?


    The problem I'm having is there is after installing attribute_sort 1.2a I still have no option to sort the attributes through the ajax attribute manager. Argh. It would be so cool if I could get this working! Any help appreciated!


    I'm having the same problem...Getting this on the item edit page where the normal attribute box is,


    1060 - Duplicate column name 'product_option_sort'


    ALTER TABLE products_options ADD COLUMN product_option_sort INT UNSIGNED NOT NULL DEFAULT '0'


    [TEP STOP]


    Have 2.8.2 installed with the 1.2a attribute sort contribution installed prior to 2.8.2. I change the "false" to "true" in the admin/attributeManager/classes/attributeManagerConfig.class.php line as instructed in the installation instructions. Anyone help me figure this one out?