Magento Indexing Problem and solution

Stock Status Index process is working now. Please try run this process later. I have resolved the indexing problem. Problem was with the permission and ownership  to /public_html/var/locks directory. #chown -R owner_name:group_name directory e.g [/home/spsimpo/public_html/var]# chown -R spsimpo:spsimpo locks N.B MUST BE THE SAME OWNER AND GROUP OF /VAR Also need to chmod 777 to [...]

MySQL Indexing Sequence

The indexing should be the same sequence in the SQL used. SELECT `image_no` AS count FROM `images` WHERE `section`=’b_cars’ AND `ad_no`=’300483′ ORDER BY `image_no` DESC LIMIT 1 KEY `section` (`section`,`ad_no`,`order_no`,`image_no`) WHERE ORDER BY/GROUP BY SELECT