Coupon Code Drama

[rebecca3t]

Hi,
I was just trying to move a category around on our actinic catalog and i get this message:
"Remove the Coupon Code Information from SetupInfo table. contained an unexpected object."
The section then disappeared and I don't currently have any coupon on the site. Can someone please tell me where the setup info table is located?

thanks

[george]

Don't move any more sections or they will be lost also. I had this problem too, and seems to be cured by compacting the databases.

[rebecca3t]

Hi,
how do you compact the databases?

[george]

Click on Housekeeping (at the top), then second option down.

Remember that the section you moved will be lost for good. Were you building on a lot of new products or something?

[rebecca3t]

Hi
yes we do have up to a thousand products on our website shop. www.handembroideryshop.co.uk
We sell mainly mlitary badges for different regiments; caps, collar, etc. Its mammouth and gets bigger everyday.
this incident is very bizzare. never seen this happen before. i have tried the compact database thing and thankfully its worked! i was actually not looking forward to telling my manager what has happened.

thank you very much for your help :-)

[rebecca3t]

Goerge,
something a little off point here but i went to your website and tried adding a product to my shopping basket. it went back to the page i was at previous but it did say "No items in cart". i tried it again with the same result but the items were there when i went to the checkout

[Kermy]

Same here, George, no items in cart. You been messing around with that script again?

[pinbrook]

Rebecca3t - it is worth remebering to regularly compact the DB (daily, or weekly) this will help with the integrity of the DB

and of course regular daily snapshots for backup purposes

[george]

Same here, George, no items in cart. You been messing around with that script again?

Oooooh I may have to investigate, thanks for pointing that out peeps.


Along with correcting MacEdonia.

[george]

Same here, George, no items in cart. You been messing around with that script again?

Hmmmm. Interesting that. I had to do a bit of swapping round of pcs lately and ended up making this one the `main` one, instead of its former glory as one of the `other ones`. (Remember we're using multi-user).

Anyway, it looks like importing the snapshot from the `original pc` did not overwrite the Cart.pm, or the ActinicOrder.pm on this pc, meaning that the default Actinic files were used. The actinicextras.js and the templates were modded as they should have been.