[Old] Royal Mail Modules

[Pixxi]

You can edit each of the module files (ie. includes/modules/shipping/ ...).

Around line 176 in each of the module files you should see something like:

            $shipping_method = MODULE_SHIPPING_RM1STPACKET_TEXT_WAY . ' : ' . $sw_text . ' ' . MODULE_SHIPPING_RM1STPACKET_TEXT_UNITS; 

'$sw_text' holds the numerical weight, and the constant after it holds the 'kgs'

Remove the last part of that line so it looks like:

            $shipping_method = MODULE_SHIPPING_RM1STPACKET_TEXT_WAY; 

You may also need to remove the text 'Weight' from the 'MODULE_SHIPPING_name of module_TEXT_WAY' defines in each of the respective language files (ie. in includes/languages/english/modules/shipping/ ...)

[cotswold]

Many thanks Pixxi for your swift and helpful response. I would like to thanks all who have assisted in the production of this excellent module.

[theflyingbeard]

Hi,

I am new here and am slowly learning about Zen Cart. I have just installed big_royalmail_v2.11 while reading this thread and have experianced some of the issues that have appeared in these posts and resolved them by continuing to read on. I have not yet seen a resolution to posts #211 and #254/5
I have established that the problem seems to be with the two international signed for modules. each seems to work independantly but they dont work together.
If there is a resolution I would be interested to hear it, but I'm sure I can manage if there is no resolution. What concerns me more is that someone has rocked the boat.

***we do not solicit on the forums***
Last edited by Kim : 26th January 2007 at 04:10 PM.

Who is this Kim and why has she/he upset Philip? Obviously this kim has not read this thread fully or she/he would have recognised a hard working, straight forward, honest programer with greater personal worries than fixing bugs in a great creation and correcting newbie errors for no personal gain.

The last post from Philip on this thread that I can see was January 28th #271:

Righty ho, so I am imagining the donate button up there then ? so it's okay for me to write modules for zen cart, it's okay for me to correct your rather serious ######## up with session storing in the database that's leading to hundreds of erroneous errors on any installation since 1.3.5, but it's not okay for me to suggest that I should be renumerated for my work ? instead you can ask for money and then remove my post. Okay then how about this, would anyone like to DONATE large sums of money to me then ?

I quit

If Philip has truly quit then it's a sad loss to this community and Kim needs the boot .

If you should read this philip, Thanks for a great mod, may your health improve and I wish you peace of mind.

TFB

[Pixxi]

Did you see the post a few above yours (#279)?

I have (while testing) installed *all* of the modules together on a 1.3.7 shop and not had any errors. If what Philip's posted the solution to is not the cause of yours, perhaps your error is different?

What exactly are you having problems with, and what errors are you getting?

[FunkySlings]

Did you see the post a few above yours (#279)?

I have (while testing) installed *all* of the modules together on a 1.3.7 shop and not had any errors. If what Philip's posted the solution to is not the cause of yours, perhaps your error is different?

What exactly are you having problems with, and what errors are you getting?

Thats good to hear Pixxi - we have installed all the modules on a 1.3.7 shop and DO get the errors, as several others are reporting - post #279 hasnt fixed the error in terms of the mySQL code being run on the database for the db_cache table.

Are you running file based sessions? We don't really want to switch from db sessions to file based if it can be avoided.

[Pixxi]

Are you running file based sessions?

Sessions in the db, cache as file-based.

What exactly are you having problems with, and what errors are you getting?

If you install all the modules on a stock zencart demo store, do you get the same problem?

[theflyingbeard]

Did you see the post a few above yours (#279)?

I have (while testing) installed *all* of the modules together on a 1.3.7 shop and not had any errors. If what Philip's posted the solution to is not the cause of yours, perhaps your error is different?

What exactly are you having problems with, and what errors are you getting?

Hi Pixxi,

Yes thanks I did see the post #279 and yes I am using db sessions however I only have 5 shipping modules installed. 6 when both RM International signed for modules are installed.

With only 5 modules installed compared to the 23 modules included in 'Big RM' I did not imagine that a 6th module could possibly take me over the 65k limit. Also as I have no way of knowing how much info is being stored in the sessions and I do not get anything like "error: check your sql syntax where EXPECTED_SORT_ORDER", so I discounted that as the solution.

I dont really understand databases, php or sessions, but, with further experimentation I have found that I can install both RM International signed for modules on their own and they work. I can then install further modules 1 at a time and with various combinations of modules I am able to install between 5 and 7 modules before it all goes ######## up. So I guess it must be the session size after all.

I have included the error message I get below. Switching off a module fixes the error so I guess I need to change to file based sessions or try the suggested sql query. Unfortunately I do not know how to do either so I may have to reinstall from scratch and choose files instead of db for sessions.

Then again unless there is an easy way of sorting this I may just use 4 or 5 of the modules for everything .

Regards TFB



Warning: Variable passed to each() is not an array or object in /home/sites/newmoontrading.co.uk/public_html/includes/classes/db/mysql/query_factory.php on line 114
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/sites/newmoontrading.co.uk/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/sites/newmoontrading.co.uk/public_html/includes/functions/sessions.php on line 102
Warning: Cannot modify header information - headers already sent by (output started at /home/sites/newmoontrading.co.uk/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/sites/newmoontrading.co.uk/public_html/includes/init_includes/init_templates.php on line 78

ZC 1.3.5
big_royalmail_v2.11
db sessions

[Pixxi]

You can run the SQL via PHPMyAdmin (there should be a copy on your server) or you can edit the db_cache table directly and change the field type from 'blob' to 'mediumblob'.

Alternatively, to test if the 'blob' field is the cause of your problem, you can change to file-based sessions by finding this line in both your includes/configure.php and admin/includes/configure.php:

 define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage 

and change it to:

 define('STORE_SESSIONS', ''); // use 'db' for best support, or '' for file-based storage 

Also check that you have the right path in admin->configuration->sessions->sessions directory:

eg (your server may differ):

home/your_server_account/public_html/cache

(no trailing slash)

[theflyingbeard]

Took the easy route by switching to file sessions to test before I risk messing about with the db but it doesnt appear to have resolved the problem....

changed includes/configure.php and admin/includes/configure.php as you suggested and checked the sessions path which is:

/home/sites/newmoontrading.co.uk/public_html/cache

still get the same error message at the top of the page as last posted, no difference at all. So maybe it's not the blob thing?

I also get an error message in the body of the page if I click 'Home' (with db and with file sessions):

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUC' at line 7
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20070312 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]


I dont know if that sheds more light on the subject or adds to the mystery.....

TFB

[eddie0uk]

Hi,

I am wondering if someone else has installed the Royal Mail Modules and uses Paypal Express Checkout. (Royal Mail 2.11, Paypal Express with latest patches of March 3rd, Zen-Cart 1.3.7).

My problem is that when returning from Paypal the user is presented with the shipping options page even if I switch on the option of skipping this page and selecting the cheapest option in the Paypal Express Checkout module. A quick look at the Paypal module suggests that if it is not possible to determine the correct shipping option then it returns to the shipping options page.

However if together with the Royal Mail shipping modules I activate e.g. the flat rate (or the zone rates), then in return from Paypal I get the correct final page with all the summary but the shipping option is then flat rate, even if it is more expensive than the royal mail ones.

All this suggests me that for some reason the paypal express module is not able to get info about shipping costs from these royal mail modules while it does correctly from the ones installed with the default zen-cart (I have tried flat rate and zones).

Any help appreciated, thanks

Ed.