Categories & products alphabet sorting not work.

[papaavola]

J! 2.5.6  VM 2.08c

This is old problem but it's still exists.

After setting some category or product sort order manually, it's impossible to use alphabet sort order because there is no way to make dublicate sort order ID:s manually.
I hope that developers use little time and fix problems with these sort orders. I think here is many other users that like to use Virtuemart but also like to use Alphabet sort orders with it.

At moment, only way set categories or products back to alphabet order is use PhpMyAdmin and set all sort order id:s to 1.

Thanks for all developers for this great component, make it more shiny and fix this

[lysov]

I have a similar problem in VM BE (208c). When I click on the ID column to sort products according IDs, I get this message:
vmdebug checkValidOrderingField:VirtueMartModelProduct programmer choosed invalid ordering virtuemart_product_id, use product_name

[South Africa]

I have a similar problem. When I sort the published column, I get the following error message:-

vmError: exeSortSearchListQuery Incorrect key file for table '/tmp/#sql_4931_0.MYI'; try to repair it SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `joomla_virtuemart_products_en_gb` as l JOIN `joomla_virtuemart_products` AS p using (`virtuemart_product_id`)group by p.`virtuemart_product_id` ORDER BY published DESC LIMIT 40, 10

[PRO]

I have a similar problem. When I sort the published column, I get the following error message:-

vmError: exeSortSearchListQuery Incorrect key file for table '/tmp/#sql_4931_0.MYI'; try to repair it SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `joomla_virtuemart_products_en_gb` as l JOIN `joomla_virtuemart_products` AS p using (`virtuemart_product_id`)group by p.`virtuemart_product_id` ORDER BY published DESC LIMIT 40, 10

^^^ try the "install or update tables" in tools

[lorartemis]

vmError: exeSortSearchListQuery Incorrect key file for table '/tmp/#sql_7ec3_0.MYI'; try to repair it SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `p5asl_virtuemart_products_en_gb` as l JOIN `p5asl_virtuemart_products` AS p using (`virtuemart_product_id`)group by p.`virtuemart_product_id` ORDER BY p.`created_on` DESC LIMIT 10, 10

is the error I'm getting, I tried the fix you mentioned, just in case by no joy :-)

[PRO]

have you tried to "repair" "optimize" the database?

[lorartemis]

I did yes thanks.    I still can't see the products in VM.  I can see them in the database with phpmyadmin so I know the data is there.  I've also managed to edit some of the records before they 'disappeared' which is even more confusing.