Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

Pages: 1

 

#1 07-29-2009 13:46:07

121NetDesign
Member
From: Surrey, UK
Registered: 05-10-2007
Posts: 427

Easy way to remove pre-installed Demo Store Data from CCP7 install

Hi Guys

There is a wiki on how to remove the 'Demo Store Data' in CCP6

Has anyone come up with a similar way to remove the 'Demo Store Data' in a similar way for CCP7?

Is there a way to install CCP7 without the demo store data being installed? Similar to a Joomla install?

As always, thanks in advance!

Last edited by 121NetDesign (07-29-2009 13:46:59)

Tommy Lee

Offline

 

#2 07-29-2009 14:21:02

Dave
Member
Registered: 07-05-2003
Posts: 11233

Re: Easy way to remove pre-installed Demo Store Data from CCP7 install

Same commands just change ccp0 to ecom in the commands.

Offline

 

#3 07-29-2009 14:53:29

dh783
Member
From: Avondale, Arizona
Registered: 04-06-2005
Posts: 6233
Website

Re: Easy way to remove pre-installed Demo Store Data from CCP7 install

For future issues if you remove the install directory from the Ecom_DemoStore they will not get re-installed in future database update/install , that is as long as it doesn't get put back.

John

Offline

 

#4 07-30-2009 02:52:56

121NetDesign
Member
From: Surrey, UK
Registered: 05-10-2007
Posts: 427

Re: Easy way to remove pre-installed Demo Store Data from CCP7 install

Thanks guys, I have made it easier for others wishing to remove the demo store data by posting a modified version of the CCP6 Wiki:

Edit by Dave: The entry for doing this was already in the Wiki .  Sorry about that and thanks for posting the commands also.

Home > System > Database > Raw Database Admin > SQL Statement:Submit a Raw SQL Statement

Execute these statements one at a time:

Code:

DELETE FROM ecom_prod WHERE id='DESKTOP1001' OR id='DESKTOP1002' OR id='DESKTOP1003' OR id='DESKTOP1004' OR id='HDD1005' OR id='HDD1006' OR id='HDD1007' OR id='MONITOR1008' OR id='MONITOR1009' OR id='BUILD1001'

DELETE FROM ecom_cat WHERE id='BuildYourOwn' OR id='PCs' OR id='DeskPCs' OR id='GamePCs' OR id='HDD' OR id='scsiHDD' OR id='pcmciaHDD' OR id='eideHDD' OR id='MONITOR'

DELETE FROM ecom_prodoptions WHERE id='pc_sechdd' OR id='build_cpu' OR id='build_hdd' OR id='build_memory' OR id='build_cdrom' OR id='build_soundcard' OR id='build_videocard' OR id='build_specins'

DELETE FROM ecom_prodoptionsel WHERE id='pc_sechdd.none' OR id='build_cpu.1.0' OR id='build_cpu.900' OR id='build_cpu.1.2' OR id='build_cpu.1.4' OR id='build_cpu.1.6' OR id='build_hdd.10' OR id='build_hdd.20' OR id='build_hdd.40' OR id='build_hdd.80' OR id='pc_sechdd.20' OR id='pc_sechdd.40' OR id='pc_sechdd.80' OR id='build_memory.128' OR id='build_memory.64' OR id='build_memory.256' OR id='build_memory.512' OR id='build_cdrom.24cd' OR id='build_cdrom.16cd' OR id='build_cdrom.48cd' OR id='build_cdrom.6rw' OR id='build_cdrom.24rw' OR id='build_cdrom.12dvd' OR id='build_cdrom.24dvd' OR id='build_soundcard.32' OR id='build_soundcard.16' OR id='build_soundcard.64' OR id='build_videocard.16' OR id='build_videocard.8' OR id='build_videocard.32agp' OR id='build_videocard.32pci'

Last edited by Dave (07-30-2009 03:46:08)

Tommy Lee

Offline

 

 

Pages: 1

Board footer