Kryptronic Software Support Forum

antsevo · 08-01-2008 14:38:51

Currently in the CRON this can only have a minimum period of 1 year, I need to be able to set this to either 3 or 2 months, as all our orders are stored elsewhere.

I am getting a little worried again of the amount of orders that have built up over the last 4 - 6 months, and don't want the same thing to happen with the mysql server again as it did last time, by getting too large and throwing up all sorts of errors.

So either I need to have a setting to change it to this length to keep orders, or a mysql statement should suffice, to clear everything out older that 3months.

Any ideas?

antsevo · 08-01-2008 14:48:54

Can I just clone a similar setting in: khxc_selectcustom

and clone the khxc.cron.years.0
the same as khxc.cron.months.3 obviously updating the selectid and id

I have just done this, and won't really know if it will work until the next time it runs the process, but I want to make sure that it won't do anything silly to the program

Dave · 08-01-2008 15:16:13

Raw DB statements to be executed one at a time:

Code:

INSERT into `khxc_selectcustom` VALUES ('khxc.cron.years.5', 'khxc', 'khxc.cron.years', '90 days (3 months)', '7776000', '6');
INSERT into `khxc_selectcustom` VALUES ('khxc.cron.years.6', 'khxc', 'khxc.cron.years', '180 days (6 months)', '15552000', '7');
INSERT into `khxc_selectcustom` VALUES ('khxc.cron.years.7', 'khxc', 'khxc.cron.years', '270 days (9 months)', '23328000', '8');

That will add options for 3 months, 6 months and 9 months to the selection list (at the end).

antsevo · 08-01-2008 15:30:42

Thanks Dave, then that is correct what I have done.

Thanks for giving that info to me....

Dave · 08-01-2008 15:45:50

Looks like it Your post about what you did came in while I was composing mine.

antsevo · 08-01-2008 15:49:24

Sorry, i just had a flash about how it could be done....

picstart · 05-01-2009 02:36:40

how do i modifiy the raw db statemmnets below to also show a one month setting, does this also apply to the users that have not used their accoumnts for a while?

Dave · 05-01-2009 05:49:43

To add a one month option for orders in addition to the others shown above (this will put it at the end of the list).:

Code:

INSERT into `khxc_selectcustom` VALUES ('khxc.cron.years.8', 'khxc', 'khxc.cron.years', '31 days (1 month)', '267840', '9');

For unused accounts I'd think seriously about not going below a year for unused accounts but the command above will also add a 31 day option for storing orders (both cron settings use the same selection list).

picstart · 05-01-2009 06:39:08

Hi Dave,
ok will leave unused accounts, is there an easy way to remove the pending / cancelled orders except doing them one by one as we have a large number of these that never got deleted

Dave · 05-01-2009 06:52:10

Only by deleting them through the admin interface. There are 2 tables in the picture and you can't simply delete things from the orders table and ignore their 1 to n mates in the orderitems table.

Kryptronic Software Support Forum

#1 08-01-2008 14:38:51

Online Order Storage Time - How can this be changed to say 3 months

#2 08-01-2008 14:48:54

Re: Online Order Storage Time - How can this be changed to say 3 months

#3 08-01-2008 15:16:13

Re: Online Order Storage Time - How can this be changed to say 3 months

Code:

#4 08-01-2008 15:30:42

Re: Online Order Storage Time - How can this be changed to say 3 months

#5 08-01-2008 15:45:50

Re: Online Order Storage Time - How can this be changed to say 3 months

#6 08-01-2008 15:49:24

Re: Online Order Storage Time - How can this be changed to say 3 months

#7 05-01-2009 02:36:40

Re: Online Order Storage Time - How can this be changed to say 3 months

#8 05-01-2009 05:49:43

Re: Online Order Storage Time - How can this be changed to say 3 months

Code:

#9 05-01-2009 06:39:08

Re: Online Order Storage Time - How can this be changed to say 3 months

#10 05-01-2009 06:52:10

Re: Online Order Storage Time - How can this be changed to say 3 months

Board footer