...indexing via GUI fails and status is "processing"...?

> cd index
> php -f indexer.php -- --reindex catalog_url

...gives error messages that should help.

see database for possible indexing identifiers:
mysql> use magento;
mysql> select * from index_process;


magento version:
1.6.1.0

date:
Thu Dec 8 01:12:43 CET 2011

sources:
http://rackspeed.de/forum/magento-faq-backend/there-a-problem-with-reindexing-process-582

...magento needs InnoDB mysql storage engine... ?

http://dev.mysql.com/doc/refman/5.5/en/innodb-storage-engine.html

...magento says 'Internal Server Error', logfile says: DirectoryIndex not allowed here ...?

DirectoryIndex set in magento/.htaccess
edit httpd.conf, set "AllowOverride All" (individual options do not change behaviour)


magento version:
any

date:
Fri Dec 2 03:39:57 CET 2011

...how to update/upgrade mysql database directory after mysql server update?

use command 'mysql_upgrade' from shell


magento version:
any

date:
Fri Dec 2 03:39:57 CET 2011

...how to enable magento error output?

Go to errors/local.xml.sample
and copy local.xml.sample to local.xml


magento version:
1.6.1.0

date:
Fri Dec 2 03:39:57 CET 2011

sources:
http://www.magentocommerce.com/boards/viewthread/84053/

... categories not showing up / products (not) showing up in some places?

1. categories must be subcategories of some (e.g. "Default") category
(-> Catalog -> Manage Categories)
2. parent category must be set as "Root Category" for store
(-> System -> Manage Stores -> [Store Name])


magento version:
1.6.1.0

date:
Mon Dec 12 15:21:10 CET 2011

sources:
http://www.aschroder.com/2009/03/top-3-solutions-when-your-magento-categories-are-not-displaying/