Linked Questions

7
votes
3answers
1k views

magento url rewrite prevent -1 or -2

I have a category created which contains url key as - "sofa" and url generated is "sofa.html". URL rewrites system record generated as follows : ID Path : category/5 Request path : sofa.html Target ...
3
votes
3answers
27k views

Can I Delete The Thousands Of URL Rewrites?

I am wanting to add redirects from old site URL to new site URLs however when I go into URL Rewrite Management there are over 8,000 records there already. Can I delete these? Most of them are in the ...
2
votes
3answers
3k views

What are reasons for a Magento database become huge?

I am not sure if I am allowed to ask this here but I have a curiosity. Is it normal that a Magento with 800 orders to have 600mb? Also there are only 20 products (12 configurable, 3 bundles)
5
votes
2answers
15k views

Understanding Catalog URL Rewrite Indexer [duplicate]

I've truncated the core_url_rewrite table with about 5000000 records. After that I run the Catalog URL Rewrite Indexer which created 1782612 records. Then I run it again and the table had 2251930 ...
0
votes
2answers
941 views

Delete Magento 1.9 Core URL Rewrites

I need to delete/truncate the Magento 1.9 core URL rewrites which are older than 3 months of core_url_rewrite table in Database. What's the exact SQL query to achieve this?
4
votes
1answer
4k views

Lock wait timeout exceeded

Quite often we get the following error in Magento when we try to make a change to one of our Categories. SQLSTATE[HY000] [1205] Lock wait timeout exceeded; try restarting transaction, query was: ...
2
votes
1answer
2k views

core_url_rewrite table

When I change the position of products in a category, then the whole webshop will have database problems. When I debugged the problem, I saw that the table core_url_rewrite was the problem. This table ...
2
votes
1answer
2k views

Core Url Rewrite bug in Magento 1.8?

I remember there was a bug in Magento 1.7 and EE 1.12 which generated URL writes each time a category was saved. We noticed this when clients started seeing millions of URL rewrites. There was a patch ...
1
vote
1answer
247 views

Magento 1.9.3 re-indexing page and URL Issue

Every time Magento 1.9.3 re-indexing page and URL automatically increases every time when I run re-indexing, URL Rewrite Management increases ??? even product or fix
1
vote
1answer
900 views

`core_url_rewrite` Table optimization [duplicate]

I think core_url_rewrite is built in the wrong way: why it contains records for not visible products ( all simple associated to the configurable for example ) why it contains records for every ...
1
vote
1answer
460 views

after everyday my database backup size increasing 2mb/day

When I live my magento store site the database size was 2.xx MB after one week when i take my database backup its size increase up-to 8.xx MB and browsing speed also reduced please any one tell me ...
1
vote
1answer
1k views

Magento product url not working after magento upgrade from 1.5 to 1.8 [duplicate]

I have upgraded magento from 1.5 to 1.8, everything is working fine apart from custom URL. Custom product URL is not working even after reindexing everything. is there any way we make old custom URL ...
0
votes
1answer
32 views

Core URL re-write table - delete URL entries for deleted products

We are on Magento Version 1.9.3.7 and have been using Magento for a few years now. When we moved our site to the live site from the development site, we deleted all the development products but looks ...
0
votes
1answer
762 views

core_url_rewrite is too big [duplicate]

I have an issue with my Magento's database (Magento 1): in few days, doing several times the reindexing process, the table 'core_url_rewrite' weighs about 10 GB and the server stops to work. Then, ...
0
votes
1answer
161 views

After re-indexing it gives me 505 error

After re-indexing the Magento 1.9.1 It freezes for some time and Gives 505 error as shown in below snapshot. I contacted server administrator they say its Magento problem server is working ...

15 30 50 per page