Magento

ogray - 21 May 2010 07:21 AM

Try this queries:

DELETE cpop.* FROM catalog_product_option_price AS cpop
INNER JOIN catalog_product_option AS cpo
ON cpo.option_id = cpop.option_id
WHERE
cpo.type = 'checkbox' OR
cpo.type = 'radio' OR
cpo.type = 'drop_down';

DELETE cpotp.* FROM catalog_product_option_type_price AS cpotp
INNER JOIN catalog_product_option_type_value AS cpotv
ON cpotv.option_type_id = cpotp.option_type_id
INNER JOIN catalog_product_option AS cpo
ON cpotv.option_id = cpo.option_id
WHERE
cpo.type <> 'checkbox' AND
cpo.type <> 'radio' AND
cpo.type <> 'drop_down';

But don’t forget to BACKUP before executing!

After all day to find the solution response saved my life. Thanks for your input

its easy to fix, check this:

http://learntipsandtricks.com/blog/92/114/magento-index-management-Cannot-initialize-the-indexer-process

I’m not entirely sure if teh 2 are related but i’m getting a 500 internal server error after running this

DELETE cpop.* FROM catalog_product_option_price AS cpop
INNER JOIN catalog_product_option AS cpo
ON cpo.option_id = cpop.option_id
WHERE
cpo.type = ‘checkbox’ OR
cpo.type = ‘radio’ OR
cpo.type = ‘drop_down’;

DELETE cpotp.* FROM catalog_product_option_type_price AS cpotp
INNER JOIN catalog_product_option_type_value AS cpotv
ON cpotv.option_type_id = cpotp.option_type_id
INNER JOIN catalog_product_option AS cpo
ON cpotv.option_id = cpo.option_id
WHERE
cpo.type <> ‘checkbox’ AND
cpo.type <> ‘radio’ AND
cpo.type <> ‘drop_down’;

Can anyone guide me in fixing this? I have a live site throwing an error and I need to fix this asap

Thanks

Hi Jason,

I don’t know if you ever solved it but here is the answer for the future.

The error “server 500” is a know issue.

This has to do with file permissions.

Resetting file permissions Magento

or

.htacces file in your root folder and/or Media folder.

Cheers,

Steve

I just bookmarked it. I am a regular visitor of your website I will share It with my friends .Thanks.
---------------------------------
<a href="http://www.friv2345.com/">friv 2</a>
<a href="http://www.cubefieldflash.com/">cubefield</a>
<a href="http://www.bubbleshootergames.biz/">bubble shooter</a>
<a href="http://www.freegamesonline247.com/">free games online</a>
<a href="http://www.friv2345.com/">friv 3</a>
<a href="http://www.friv2345.com/">friv 4</a>
<a href="http://www.friv2345.com/">friv 5</a>

friv 2
cubefield
bubble shooter
free games online
friv 3
friv 4
friv 5

Hmm,

Bubbleshooter… please stop spamming…

adolmedia - 02 June 2010 07:49 AM

Hi everyone,

For peoples facing problem with Catalog product fulltext search re-indexing with error message

“Some problem with reindexing process.” or “Can’t initialize indexer process”,

please find below the fix.

Create a file called “search-reindex.php” inside your magento root folder and put the following code.

<?php
require_once 'app/Mage.php';
umask( 0 );
Mage :: app( "default" );
Mage::log("Started Rebuilding Search Index At: " . date("d/m/y h:i:s"));
$sql = "truncate catalogsearch_fulltext;";
$mysqli = Mage::getSingleton('core/resource')->getConnection('core_write');
$mysqli->query($sql);
$process = Mage::getModel('index/process')->load(7);
$process->reindexAll();
Mage::log("Finished Rebuilding Search Index At: " . date("d/m/y h:i:s"));

Then run this script by visiting www.yourdomain.com/search-reindex.php in your browser.

That’s it. It will now work like a charm.

Regards,
Rahman - AdolMedia

Hi,

it works not by me, should it helt also at Magento 1.6.1?

ogray - 21 May 2010 07:21 AM

Try this queries:

DELETE cpop.* FROM catalog_product_option_price AS cpop
INNER JOIN catalog_product_option AS cpo
ON cpo.option_id = cpop.option_id
WHERE
cpo.type = 'checkbox' OR
cpo.type = 'radio' OR
cpo.type = 'drop_down';

DELETE cpotp.* FROM catalog_product_option_type_price AS cpotp
INNER JOIN catalog_product_option_type_value AS cpotv
ON cpotv.option_type_id = cpotp.option_type_id
INNER JOIN catalog_product_option AS cpo
ON cpotv.option_id = cpo.option_id
WHERE
cpo.type <> 'checkbox' AND
cpo.type <> 'radio' AND
cpo.type <> 'drop_down';

But don’t forget to BACKUP before executing!

What was strange was that even if you set the index mode to manual, it reindexes all of them after saving a product leading to the error. (from stack trace)

I can’t believe this worked after 4 hours of trying everything. I tried:
1. deleting var/locks
2. deleting inside all folders in var
3. repairing the two tables in the query above

I’m more surprized since when I ran a select instead of the delete for the above queries, I got zero rows. So I searched for more ways. Finally I came back and ran the delete. THE QUERY DELETED NO ROWS!! And yet when I go back to magento admin, I find the second index in a “reindex required” state instead of the “processing” state it was stuck in. Reindex and done! Works like magic. Only thing I still don’t know what was wrong.
Thanks