Jump to content
Sign in to follow this  
jojotaz

Need Some Help On A Shipping Module

Recommended Posts

Howdy~

I am using the Delivery Date contrib. But I was wondering on why when the user is to confirm order at the last step, the page says "1054 - Unknown column 'shipdate' in 'field list'". I have used the files and replaced them from the fresh install but still have that problem. Can someone please help me. I am not sure if I had done all of the insttuctions for the install, if I did not do all of them, can someone please let me know what I need to do.

 

Thanks

Share this post


Link to post
Share on other sites

did you run the sql ?

 

 

Run this sql on your database

 

ALTER TABLE `orders` ADD `shipdate` VARCHAR( 10 ) NOT NULL ;

Share this post


Link to post
Share on other sites
did you run the sql ?

Run this sql on your database

 

ALTER TABLE `orders` ADD `shipdate` VARCHAR( 10 ) NOT NULL ;

 

Howdy~

Sorry for such a dumb questions, but I am a newbie at this. How do you do that?

 

Thanks

Share this post


Link to post
Share on other sites

Well it can be done thru a script or theu phpMyAdmin.

 

 

Satish


Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Share this post


Link to post
Share on other sites

Howdy~

Can you help me out in getting this done one way or the other? This is the very first time I ever have worked with a database.

 

Thanks

Share this post


Link to post
Share on other sites
Howdy~

I am lost on what I am suppose to do in that thread.

 

Thanks

yea unfortunately the images are gone. They use to show how to use that tool from your host's cpanel. Do an internet search on "phpmyadmin tutorial". You need it to run the sql query mentioned earlier.

Share this post


Link to post
Share on other sites

Howdy~

I got into phpmyadmin, but not sure what to do at this point in time. Any help?

 

Thanks

Share this post


Link to post
Share on other sites

Howdy~

I have gotton into the phpmyaddmin but not sure how to "ALTER TABLE `orders` ADD `shipdate` VARCHAR( 10 ) NOT NULL ;" at this point. Any Help?

 

Thanks

Share this post


Link to post
Share on other sites
Howdy~

I have gotton into the phpmyaddmin but not sure how to "ALTER TABLE `orders` ADD `shipdate` VARCHAR( 10 ) NOT NULL ;" at this point. Any Help?

 

Thanks

Once you select the correct database for your store, there should be an "SQL" tab at the top. Click it, then paste the query in the window, then hit go and it will change the table.

Share this post


Link to post
Share on other sites

Howdy~

Now I have one more question, now that it works. I know that you can set it up to have a delivery date up to six days from the date that the order is placed. But I was wondering if there was any way to make the date at ten days ahead instead of the six?

 

Thanks

Share this post


Link to post
Share on other sites
Howdy~

Now I have one more question, now that it works. I know that you can set it up to have a delivery date up to six days from the date that the order is placed. But I was wondering if there was any way to make the date at ten days ahead instead of the six?

 

Thanks

 

There is something in the code, probably the PHP, that sets that limit. You need to find where and change it.


Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Share this post


Link to post
Share on other sites
There is something in the code, probably the PHP, that sets that limit. You need to find where and change it.

 

Howdy djmonkey1~

I have no idea what I am even looking for. Any help would be great.

 

Thanks

Share this post


Link to post
Share on other sites
Howdy djmonkey1~

I have no idea what I am even looking for. Any help would be great.

 

Thanks

 

In includes/classes/shipsched.php there is the function EarliestArrival:

	function EarliestArrival(){

	$current_day=date('w');

	$current_time=date('G'); //any time of the hour will be considered past the hour

	$prev_day=($current_day!=0) ? $current_day-1 : 6;

	$target=($current_time>=$this->schedule[$current_day]['start_time']) ? $this->schedule[$current_day]['target_day'] : $this->schedule[$prev_day]['target_day'];

	$days_needed=($current_day<=$target) ? $target-$current_day : (7-$current_day)+$target;

	$this->earliest_date=mktime(0,0,0,date('m'),date('d')+$days_needed,date('Y'));

}

 

I've never used this contribution before but that's where I would start looking.


Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Share this post


Link to post
Share on other sites

it has that thru admin configuration.

 

Satish


Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×