Post by cmgharris » Fri Jun 24, 2011 8: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

Newbie

Posts

Joined
Fri Jun 24, 2011 8:23 pm

Post by Qphoria » Sat Jun 25, 2011 12:06 am

elaineben wrote:1046 - No database selected
In phpmyadmin you have to select a database first

OpenCart 2.0.x Mod Update Info

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Qphoria » Sat Jun 25, 2011 12:07 am

This script and mod are for 1.4.x ONLY

OpenCart 2.0.x Mod Update Info

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by poshook » Thu Jul 07, 2011 2:02 am

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 :choke:

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

http://youtu.be/rzRkqO6nIV8


Newbie

Posts

Joined
Sun Jun 27, 2010 3:19 am

Post by Bantamanic » Thu Jul 07, 2011 10: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!

Newbie

Posts

Joined
Thu Jul 07, 2011 10:02 pm

Post by Bantamanic » Fri Jul 08, 2011 1:39 am

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

;D
Nick

Newbie

Posts

Joined
Thu Jul 07, 2011 10:02 pm

Post by DaniellY » Wed Sep 28, 2011 6:04 pm

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?

Newbie

Posts

Joined
Thu Sep 08, 2011 4:45 pm

Post by harmonymusic » Sun Feb 12, 2012 12:35 am

Does it work with oc 1.5.1.3 ? thanks.

Newbie

Posts

Joined
Sat Feb 11, 2012 1:29 am

Post by Qphoria » Sun Feb 12, 2012 12:57 am

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

OpenCart 2.0.x Mod Update Info

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by maya » Thu May 24, 2012 8: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

User avatar
Newbie

Posts

Joined
Sat Feb 18, 2012 1:46 am
Location - London

Post by garuda » Mon Jun 25, 2012 11: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;
Last edited by garuda on Tue Jun 26, 2012 3:20 am, edited 2 times in total.

Newbie

Posts

Joined
Wed Apr 25, 2012 10:40 am

Post by OSWorX » Tue Jun 26, 2012 12:10 am

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.

Image


User avatar
Newbie

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by i2Paq » Tue Sep 04, 2012 12:14 am

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;

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

UPGRADE to 2.x: Contemplate before thou begins!

Our FREE search: Find your answer FAST!.

BUGs?: Known BUGS for All OC Versions.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by deanodv8 » Sat Oct 06, 2012 12:35 am

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

Newbie

Posts

Joined
Sat Oct 06, 2012 12:31 am

Post by helgvor_stoll » Thu Mar 21, 2013 1:19 am

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.

User avatar
Newbie

Posts

Joined
Thu Mar 07, 2013 12:53 am
Location - Strasbourg (France)

Post by helgvor_stoll » Thu Mar 21, 2013 1:20 am

I forgot. It's the file for the 1.5.5.1 release

User avatar
Newbie

Posts

Joined
Thu Mar 07, 2013 12:53 am
Location - Strasbourg (France)

Post by rdvapors » Sat Jun 01, 2013 11:35 am

How about deleting the sample data base, I have two of everything, one with out the prefix and one with

for example

With: oc_XXXX

Without: XXX

Can I delete the oc_XXX tables?

Newbie

Posts

Joined
Thu Dec 13, 2012 11:29 pm

Post by Sakunne » Thu Jun 06, 2013 4:50 am

There is a basic rule considering database integrity:
- when you delete data in the table whith primary key: id_zzz
- you should delete all data which tables using this key

For example if you deleted:
- table `oc_product`
you should also delete data from:
-- table `oc_product_attribute`
-- table `oc_product_description`
-- for table `oc_product_discount`
-- table `oc_product_image`
-- table `oc_product_option`
-- table `oc_product_option_value`
-- table `oc_product_related`
-- table `oc_product_reward`
-- table `oc_product_special`
-- table `oc_product_to_category`
-- table `oc_product_to_store`

... and so on

User avatar
Newbie

Posts

Joined
Thu Jun 06, 2013 4:40 am
Location - Tallinn, Estonia

Post by miguelal » Wed Jul 24, 2013 6:07 am

helgvor_stoll wrote:I forgot. It's the file for the 1.5.5.1 release
No it isn't.

For it to be for the 1.5.5.1 release at least the following tables are missing in your script:
oc_product_profile
oc_profile
oc_profile_description
oc_order_recurring
oc_order_recurring_transaction

Please find attached a script where I have removed all data related to:
Attributes
Banners
Categories
Manufacturers
Products
Voucher Themes

Installation Instructions:
1) unzip contents to "install" folder within your opencart folder (replacing original opencart.sql file)
2) follow the normal install procedure through your browser

Attachments


Newbie

Posts

Joined
Wed Jul 24, 2013 5:32 am

Post by punchi » Tue Dec 30, 2014 7:21 am

Any update for the 2.X? thanks!

Newbie

Posts

Joined
Fri Mar 12, 2010 5:29 am
Who is online

Users browsing this forum: No registered users and 8 guests