v1.3.9h - Admin Shipping Module - can't see to edit the modules

[Elemi]

Hi all
I've recently upgraded to 1.3.9h, have used the All Business Template, and the add-ons are NZ Bank Direct, Contest and Reward Points which were loaded over the last 2 weeks. I have not made any changes to my shipping options. Everything is running fine except I cannot go in and edit my shipping costs and there is a price increase as of 1st August.

For payments I use bankdeposit (for manual PayPal invoices), dirbanknz and moneyorder.

I'm not sure how to attach an admin screen shot (upload files didn't upload), however the columns showing in my shipping admin are:
Modules - Sort Order - Action with no extra column on the right allowing me to edit any of the modules.

I've tried searching through the forums, but I'm guessing I'm using different terminology as nothing has come up.

Is it related to a template, or some piece of code I need to adjust and if so, where?

Thanking you in advance
Tania :-)

[schoolboy]

If the function was there BEFORE the upgrade, then it's possible your upgrade was not done properly.

The template and payment modules should not affect this, and as shipping module files are loaded into the CATALOG area (no files go into admin folders), you should not have to worry about anything in your admin folders/files.

What shipping modules are involved here? are they "standard" mods, or are you using custom shipping modules?

As you are unable to "edit" them, you won't be able to "clip" the pricing variables associated with them, using ZC admin console, but you CAN get this out of the database. So make a BACKUP of the database as your first line of defence. The shipping variables are housed in the CONFIGURATION table, and there are ways to "extract" them from a SQL "dump" of your dbase. If you can get that dbase backup onto your local machine (as a TXT file), then it's possible to extract those variables. You could also try (via phpMyAdmin) to export the data as a csv, or even a excel file.

When you have your dbase backup, you could try RE-FTP the shipping modules files again, and see if this corrects the problem. It is possible that you may need to REMOVE them first, then INSTALL them again.

The REMOVE will also take all the variables out of the dbase - but as you now have a dbase backup from which they can be extracted, when you INSTALL them again, you can use copy and paste to put the variables back in.

Much will depend on WHAT shipping modules you use, so tell us what they are and we may have further advice.

[Elemi]

My shipping modules are Delivery, Flat, MZMT and Store Pickup

And I have absolutely no idea how to use mysql or phpmyadmin.

[schoolboy]

Delivery, MZMT

are custom modules. You will need the original module files.

[schoolboy]

It's 25 to 1 am here in the UK so I won't be around for the next 12 hours...

[Elemi]

Delivery, MZMT

are custom modules. You will need the original module files.

I have removed the Delivery and MZMT files (delivery was inactive, MZMT has never been efficient with calculating postage costs for international orders). No change to my admin layout.

[Elemi]

Okay - I have just gone through the flat.php modules and found this:

On my server

function remove() {
global $db;
$db->Execute("delete from " . TABLE_CONFIGURATION . " where configuration_key like 'MODULE\_SHIPPING\_FLAT\_%'");
}

My files I copied over from 1.2.7 have this coding:

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

Could this be the issue, and if so, which way should I code it?

TYIA
:-)

[DrByte]

http://www.zen-cart.com/content.php?124-blank-page

[Elemi]

No idea what I did, or how I fixed it, as all I've done this morning is read through the cache (Thanks Doc) looking for a starting point and deleted all references to the mzmt.php file and it's now working... strange.

Back to my earlier question about the two lines, should I update my flat files to the newer text or just leave them alone as everything is now working?

:-)

[DrByte]

As for "the 2 lines", if you're using v1.3.9h, then you should use the v1.3.9h version of the file.