Community Forums

by **cmgharris** » Fri Jun 24, 2011 12:30 pm

I've just installed 1.5.0.5, and run eyeweb's script to clear the demo data.
Some tables in the script don't exist, and it looks to me as if there are other tabels that could be cleared out.
Is this because the script was appropriate for a previous version?
Can anyone provide a correct list of tables to clear for 1.5.0.5?

TIA
Chris

by **Qphoria** » Fri Jun 24, 2011 4:06 pm

elaineben wrote:1046 - No database selected

In phpmyadmin you have to select a database first

by **Qphoria** » Fri Jun 24, 2011 4:07 pm

This script and mod are for 1.4.x ONLY

by **poshook** » Wed Jul 06, 2011 6:02 pm

cmgharris wrote:I've just installed 1.5.0.5, and run eyeweb's script to clear the demo data.
Some tables in the script don't exist, and it looks to me as if there are other tabels that could be cleared out.
Is this because the script was appropriate for a previous version?
Can anyone provide a correct list of tables to clear for 1.5.0.5?

TIA
Chris

+1

I would prefer optional download of clean installation without any DEMO items directly on opencart.com

by **Bantamanic** » Thu Jul 07, 2011 2:10 pm

cmgharris wrote:I've just installed 1.5.0.5, and run eyeweb's script to clear the demo data.
Some tables in the script don't exist, and it looks to me as if there are other tabels that could be cleared out.
Is this because the script was appropriate for a previous version?
Can anyone provide a correct list of tables to clear for 1.5.0.5?

TIA
Chris

Ditto, I'd like a clean install for 1.5x!

by **Bantamanic** » Thu Jul 07, 2011 5:39 pm

RE: clean install for 1.5x

Not having much luck deleting table data post install. Even when I think I've removed everything, I can't get the product_id to reset to 1. So, I tried tinkering with the opencart.sql file pre-install and removed several of the insert commands and managed to get a clean install with the product_id set to 1. See attached file - It's a bit of a hack, but I hope it helps some people out.

Instructions
1. Save file to /install directory
2. Rename file to opencart.sql
3. Run install

Nick

by **DaniellY** » Wed Sep 28, 2011 10:04 am

Instructions
1. Save file to /install directory
2. Rename file to opencart.sql
3. Run install
Didn't work fine for me, actually, are there any other view on the issue?

by **harmonymusic** » Sat Feb 11, 2012 4:35 pm

Does it work with oc 1.5.1.3 ? thanks.

by **Qphoria** » Sat Feb 11, 2012 4:57 pm

No.. a different one will be needed for 1.5.x
I'll try to find a moment to create one

by **maya** » Thu May 24, 2012 12:52 pm

Hello,
I am trying to find out how to install v1.5.3 without sample data but no luck.
Can you please help me with this?
Thank you

by **garuda** » Mon Jun 25, 2012 3:23 pm

Here's an updated list of sql commands I used to purge all demo data after a fresh install of 1.5.3.1 :
(don't forget to replace "oc_" with your table prefix)

Code: Select all: TRUNCATE oc_address; TRUNCATE oc_category; TRUNCATE oc_category_description; TRUNCATE oc_category_to_store; TRUNCATE oc_coupon; TRUNCATE oc_customer; TRUNCATE oc_download; TRUNCATE oc_download_description; TRUNCATE oc_manufacturer; TRUNCATE oc_manufacturer_to_store; TRUNCATE oc_product; TRUNCATE oc_product_description; TRUNCATE oc_product_discount; TRUNCATE oc_product_image; TRUNCATE oc_product_option; TRUNCATE oc_product_option_value; TRUNCATE oc_product_related; TRUNCATE oc_product_special; TRUNCATE oc_product_to_download; TRUNCATE oc_product_to_store; TRUNCATE oc_review; TRUNCATE oc_store; TRUNCATE oc_order; TRUNCATE oc_order_download; TRUNCATE oc_order_history; TRUNCATE oc_order_option; TRUNCATE oc_order_product; TRUNCATE oc_order_total; TRUNCATE oc_product_to_category; TRUNCATE oc_coupon_product; TRUNCATE oc_attribute; TRUNCATE oc_attribute_description; TRUNCATE oc_attribute_group; TRUNCATE oc_attribute_group_description; TRUNCATE oc_banner; TRUNCATE oc_banner_image; TRUNCATE oc_banner_image_description; TRUNCATE oc_customer_group; TRUNCATE oc_customer_group_description; TRUNCATE oc_geo_zone; TRUNCATE oc_product_attribute; TRUNCATE oc_product_option_value; TRUNCATE oc_product_reward; TRUNCATE oc_product_tag; TRUNCATE oc_tax_rate; TRUNCATE oc_tax_rate_to_customer_group; TRUNCATE oc_tax_rule; TRUNCATE oc_url_alias; TRUNCATE oc_voucher_theme; TRUNCATE oc_voucher_theme_description; TRUNCATE oc_zone_to_geo_zone;

by **OSWorX** » Mon Jun 25, 2012 4:10 pm

garuda wrote:Here's an updated list of sql commands I used to purge all demo data after a fresh install of 1.5.3.1 :
(don't forget to replace "oc_" with your table prefix)

Better do use a TRUNCATE .. otherwise the IDs are continued.

by **i2Paq** » Mon Sep 03, 2012 4:14 pm

Any update to use with 1.5.4.x?

Edit: Found

Code: Select all: TRUNCATE attribute; TRUNCATE attribute_description; TRUNCATE attribute_group; TRUNCATE attribute_group_description; TRUNCATE category; TRUNCATE category_description; TRUNCATE category_to_store; TRUNCATE manufacturer; TRUNCATE manufacturer_to_store; TRUNCATE product; TRUNCATE product_attribute; TRUNCATE product_description; TRUNCATE product_discount; TRUNCATE product_image; TRUNCATE product_option; TRUNCATE product_option_value; TRUNCATE product_related; TRUNCATE product_reward; TRUNCATE product_special; TRUNCATE product_tag; TRUNCATE product_to_category; TRUNCATE product_to_store; TRUNCATE url_alias;

by **deanodv8** » Fri Oct 05, 2012 4:35 pm

Can you please tell me if this still works??? I am using Opencart 1.5.1.3 ??

I have just built a site and have been testing the payment system prior to going fully live. I want to wipe out all the Report data for Sales, Products etc so that it's all on the level when we start trading...

Will this work????

Thanks

by **helgvor_stoll** » Wed Mar 20, 2013 5:19 pm

Hi,

I cleaned the opencart.sql file to prevent the data insertion (No data in database => nothing to delete lol). I attache my sql file for people who are interested.

Helgvor.