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
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
+1cmgharris 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
I would prefer optional download of clean installation without any DEMO items directly on opencart.com
Ditto, I'd like a clean install for 1.5x!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
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
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
Attachments
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)
(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.
Better do use a TRUNCATE .. otherwise the IDs are continued.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)
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
Any update to use with 1.5.4.x?
Edit: Found
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 _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
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
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
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.
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.
Attachments
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
- 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
No it isn't.helgvor_stoll wrote:I forgot. It's the file for the 1.5.5.1 release
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
Who is online
Users browsing this forum: No registered users and 84 guests