Local/City Delivery

[starynightskyz]

Today I loaded the Local Delivery 3.0 I was getting an error, and to be honest , the zones were mind bogling and I had no clue how to set it up for Canada.

 

So I loaded City Delivery Mod and it too has an error,

 

I had to of missed a step somewhere... I've fumbled with what little I know all day to try to fix it, and nothing.

I searched for exact spelling in the files downloaded and tried to upload some sql commands, they would not load properly.

 

Can someone please point me in the right direction?

 

Here's what I see in the admin

 

Here's what I get in the cart

 

Kindest Regards,

Tanx

Nancy :D

[♥geoffreywalton]

Nancy

 

If you didn't do every step in the installation then it aint going to work. What was the problem when you tried to run the sql?

 

1) Go to your ISPs admin area for your site.

 

2) Click on the icon for Database administration or Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites. If you can’t find this, please consult your ISP's help desk.

 

3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box.

 

4) Click on "SQL" on the navigation bar.

 

5) Enter/paste your SQL in the textbox provided or, if you have a file containing the sql commands, click on Import and follow the on screen prompts.

 

6) For both methods click "Go"..

 

7) If all goes well, your SQL query will run successfully

 

For another explanation see:-

 

http://www.oscommerce.com/forums/index.php?sho...dmin+mysql+code

 

Or for a contribution to allow you to run SQL Script from Admin

 

http://www.oscommerce.com/community/contributions,4567

 

Cheers!

[starynightskyz]

Thanx Geoffrey!

 

I think I might be in trouble. If it really is an SQL problem, I don't think the contribution files are complete,

 

and here's why.

 

For the City Delivery, It did not come with sql commands. It only says it's created based on Local Delivery versions 1.2 - with updates for 1.6

This folder doesn't come with SQL commands So I can only assume I would of had to installed them first from One of those two versions.

 

For Local Delivery Mod, I started with the latest "complete" package. Version 3.0 This only came with an SQL update from

Update Local Delivery v1.61 toLocal Delivery v1.7 The 3.0 update txt said it didn't require updates.

 

it was this I tried to add to the SQL , through my php admin

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES
('', 'Sort Order', 'MODULE_SHIPPING_DLY_SORT_ORDER', '10', 'Sort order of display.', 6, 16, NULL, NULL, NULL, NULL),
('', 'rue du magasin', 'MODULE_SHIPPING_DLY_ADRESSE', '5 rue Saint Louis', 'Rue du magasin', 6, 17, NULL, NULL, NULL, NULL),
('', 'CP', 'MODULE_SHIPPING_DLY_CP', '62200', 'Code postal magasin', 6, 18, NULL, NULL, NULL, NULL),
('', 'Ville', 'MODULE_SHIPPING_DLY_VILLE', 'Boulogne sur mer', 'Ville magasin', 6, 19, NULL, NULL, NULL, NULL),
('', 'Pays', 'MODULE_SHIPPING_DLY_PAYS', 'FRANCE', 'Pays du magasin', 6, 20, NULL, NULL, NULL, NULL);

 

However, both mods have differnt tages ( i guess youd call them ) one has DLYC the other DLY3

 

Is that the problem? with the SQL?

 

 

Nancy :D

[germ]

There is an "install function" in the code that writes the config to the DB but it never gets called (that I can tell).

 

	  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Maximum Local Delivery Distance', 'MODULE_SHIPPING_DLY3_MAX_LOCAL_DISTANCE', '12 Km', 'What is the Maximum Local delivery distance which you will travel to deliver orders. [ ie. 12 Km ]', '6', '10', now())");

(A snippet).

 

As a temp workaround you could add something like this to your config file:

 

define('MODULE_SHIPPING_DLY3_MAX_LOCAL_DISTANCE', '12 Km');

And Nancy, you need to breathe more or move farther south....

:o

 

Looking a little blue around the gills girl!

;)

 

:lol: