My virtuemart will show Error 1054 while I click confirm purchase. When I check the virtuemart backend. I can't see any orders.
This is the screen shot
I've tried joomla installer database update, virtuemart install and update database. I can give out admin username and password if needed.
Hmmm, it says that a table column is missing. In VitueMart tools is a database updater, which should solve that. But you say, you used that one already? Actually it should be always executed updating vm.
Sometimes it happens that a field (column) must become smaller, to be able to add another field. Sometimes it happens that people have another sequence of their columsn, which most time completly unimportant. But maybe the updater fails, because it tries first to add a new column, or increase coloumn varchar size, but there is no room created for it already.
Check your tables starting with "order" and compare the values withe install.sql of the vm component https://dev.virtuemart.net/projects/virtuemart/repository/entry/trunk/virtuemart/administrator/components/com_virtuemart/install/install.sql