TRUNCATE DB

[blr044]

Working with a fresh install of RC2a. Installed some security and set it up the way I want it to be. Then enter this bit of code into phpMyAdmin to clean out products and so on:

 

DELETE FROM `address_book`; 
DELETE FROM `banners`; 
DELETE FROM `banners_history`; 
DELETE FROM `categories`; 
DELETE FROM `categories_description`; 
DELETE FROM `counter`; 
DELETE FROM `customers`; 
DELETE FROM `customers_basket`; 
DELETE FROM `customers_info`; 
DELETE FROM `manufacturers`; 
DELETE FROM `manufacturers_info`; 
DELETE FROM `orders`; 
DELETE FROM `orders_products`; 
DELETE FROM `orders_status_history`; 
DELETE FROM `orders_total`; 
DELETE FROM `products`; 
DELETE FROM `products_attributes`; 
DELETE FROM `products_attributes_download`; 
DELETE FROM `products_description`; 
DELETE FROM `products_notifications`; 
DELETE FROM `products_options`; 
DELETE FROM `products_options_values`; 
DELETE FROM `products_options_values_to_products_options`; 
DELETE FROM `products_to_categories`; 
DELETE FROM `reviews`; 
DELETE FROM `reviews_description`; 
DELETE FROM `sessions`; 
DELETE FROM `specials`; 
DELETE FROM `whos_online`; 

ALTER TABLE banners AUTO_INCREMENT = 1; 
ALTER TABLE banners_history AUTO_INCREMENT = 1; 
ALTER TABLE categories AUTO_INCREMENT = 1; 
ALTER TABLE customers AUTO_INCREMENT = 1; 
ALTER TABLE customers_basket AUTO_INCREMENT = 1; 
ALTER TABLE customers_basket_attributes AUTO_INCREMENT = 1; 
ALTER TABLE manufacturers AUTO_INCREMENT = 1; 
ALTER TABLE manufacturers_info AUTO_INCREMENT = 1; 
ALTER TABLE orders AUTO_INCREMENT = 1; 
ALTER TABLE orders_products AUTO_INCREMENT = 1; 
ALTER TABLE orders_status_history AUTO_INCREMENT = 1; 
ALTER TABLE orders_total AUTO_INCREMENT = 1; 
ALTER TABLE products AUTO_INCREMENT = 1; 
ALTER TABLE products_attributes AUTO_INCREMENT = 1; 
ALTER TABLE products_description AUTO_INCREMENT = 1; 
ALTER TABLE products_options_values_to_products_options AUTO_INCREMENT = 1; 
ALTER TABLE reviews AUTO_INCREMENT = 1; 
ALTER TABLE specials AUTO_INCREMENT = 1;

 

I found this in a post dated back in 2003. After that I enter 9 categories only without any products to check site to see if all is ok. 2 of the 9 categories point back to what was there originally; the second and the seventh category. What I am saying, clicking on these two categories, and viewing the source code this is what I see:

 

<title>Hardware - Graphics Cards - Printers - Monitors - Speakers - Keyboards - Mice - Memory - Cdrom Drives</title>

<meta name="description" content="Hardware, Graphics Cards, Printers, Monitors, Speakers, Keyboards, Mice, Memory, CDROM Drives.">

<meta name="keywords" content="hardware,graphics,cards,printers,monitors,speakers,keyboards,mice,memory,cdrom">

 

So why if clearing out the database of said products and categories, only two of them not what they should be?

 

Puzzled :-"

[♥geoffreywalton]

Do you have a metatags contribution installed?

 

Have you cleared down these tables?

 

Have you thought of using truncate rater than delete?

 

G

[blr044]

Do you have a metatags contribution installed?

 

Have you cleared down these tables?

 

Have you thought of using truncate rater than delete?

 

G

 

I have KissMT Dynamic Meta Tags installed. I have this and did use it. But I noticed there were a few I had to manually empty the tables. I am going back to phpMyAdmin and use trauncate aand see what happens.

[♥bruyndoncx]

perhaps some cached data ?

[blr044]

Just finished using TRUNCATE 'products'; and etc, but still a few point to RC2a original as before. But the others, meta tags does match actual category name.

 

May look here.

 

I can not add my products to my store because of this issue.

[blr044]

perhaps some cached data ?

 

I did clear cache in browser.

[♥bruyndoncx]

in your configuration section, there is section for caching, perhaps you have categories data cached ?

Turn off caching and see what happens.

Cache files are usually in your temp directory, removing them would also do the trick..

[blr044]

Looking in admin -> tools -> cache controls, are listed three cache blocks:

Categories Box

Manufacturers Box

Also Purchased Module

 

and no files exist for none of them. /cgi-bin/tmp/ is empty.

[♥bruyndoncx]

I also have a section in admin->configuration->cache

 

to enable/disable cache globally. nothing there either ?

[blr044]

Yes, cache setting is set at false

[♥bruyndoncx]

do you have a tep_meta_tags table or something like that ?

[blr044]

I have nothing in table that come close to meta tags and etc. I did check the cache table and this is what I see there. I did a print screen an the image is below.

 

[♥bruyndoncx]

so you have SEO urls with caching, if you empty that table, you should be fine, or refresh/reset it's cache or something if you have that option in your admin

[♥bruyndoncx]

BTW, if your site is at the above domain, you should your html, the first couple of tables have glaring html errors

 

first table tag not closed,

 

next table align=""center" doubled double quote ... if you still follow me ... :rolleyes:

[blr044]

Sorry, but this is getting to be a pain in the ! Cleared cache table and then TRUNCATED all tables - customers, products, orders and categories. Nothing changed, still the same.

[blr044]

BTW, if your site is at the above domain, you should your html, the first couple of tables have glaring html errors

 

first table tag not closed,

 

next table align=""center" doubled double quote ... if you still follow me ... :rolleyes:

php isn't my thing but am somewhat knowledgeable with html and css. I did look at the view source code and seen the double quote in front of center and corrected that. While checking header.php, did not see any open, or at least not noted, any open <table> tags.

[♥bruyndoncx]

this is getting really funny ...

 

i'm here up late at night, learning about KISS MT and finetuning it so I can finally get my latest test version onto the production site. You think, who cares ...

 

The standard settings for KISS MT on the home page generate this

<title>My Great Product Range - Full Range of Wiggets - Buy from Greatdiscounts4u</title>

<meta name="description" content="My Great Product Range, Full Range of Wiggets.">

<meta name="keywords" content="great,product,range,full,wiggets">

 

and KISS MT also has its own caching mechanism, and configuration section.

You should be able to reset the cache, haven't tried this myself, but if it does what it says, it should solve it :D

 

as for the html error, it is missing the closing > at the end of the first line

<body>
<!-- header //-->
<table width="800" cellspacing="0" cellpadding="0" align="center"
  <tr>
     <td class="outline">

<!-- Begin Table -->

[blr044]

Thanks, I corrected the missing ( > ). In /includes/modules/kiss_tags/includes/init.php, tried setting the cache to true, but it did not solve issue. Will work on this a little longer, and no solution, since I have fresh installed store with no products added and no contributions except Security Pro and KissMT, I might start over without KissMT. Just to see if that is my problem.

 

<_<

[♥bruyndoncx]

in catalog/includes/modules/kissmt/cache are the cache files

so you can just delete them

 

during testing, population of your database, it is better to set the cache off, otherwise you won't see the most recent results, as this thread painfully proofs

[blr044]

Thanks Carine for your help. I cleared DB and cache file and started all over. I added 9 categories and a few products. Even deleted a few and added few others. Meta tags is correct and even phpMyAdmin looks fine. The little tip of setting admin -> configuration -> cache to false during this procedure, was very helpful. So made a not of this for future reference.

 

Have a great evening.

 

:D