Magento – Magento remove table prefix

There is quite big probability that your payment method is processing payment wrongly.

Magento Order Save Process is quite simple:

• Prepares all data that should be transfered from quote item to order item, including prices and product information, afterwards it doesn't invoke price retrieval.
• Invoke before order submit events checkout_type_onepage_save_order and sales_model_service_quote_submit_before
  • Mage_CatalogInventory_Model_Stock::registerProductsSale() is invoked at this event observer
• Start DB transaction
• Invoke $order->place() method that processes the payment by calling $paymentMethod->authorize(), $paymentMethod->capture() or $paymentMethod->initialize() depends on its logic.
• Invoke $order->save() method that saves processed order to DB tables sales_flat_order_*.
• Commit DB transaction (At this step DB releases lock on inventory table)

So as you see, it couldn't be possible, that payment method charges money before the inventory lock and read of product prices or product info.

It is only possible in case if payment method is implemented in such a way, that it performs loading of products itself with prices, after the API call for charging operation is performed.

Hope this will help you in debugging your issue.

As for reindexing, it should be safe, if you don't have this issue with payment method. Since read operation that depend on locks are performed before money gets charged.

Maybe it's a little bit late, but for anyone who is searching for the correct answer here it is

Mage::getSingleton('core/resource')->getTableName('customer_entity');

It will returns "yourtableprefix_customer_entity"