DBerror 1146 driving me crazy

[MarcKoetsier]

Hello,

I have a number of Virtuemart websites without problems. But this one is driving me nuts for the past week. I even have performed a completely clean install. When I try to place an item in the shopping cart or try to login, the following error occurs:
DB functie is mislukt met het volgende foutnummer 1146
Table 'db66689_XXX.XXX_vm_product' doesn't exist SQL=SELECT p.product_name, p.product_s_desc FROM XXX_vm_product p LEFT JOIN XXX_vm_product_category_xref pc ON pc.product_id = p.product_id LEFT JOIN XXX_vm_category c ON c.category_id = pc.category_id WHERE p.product_publish='Y' AND category_publish = 'Y' LIMIT 0,100
SQL =

SELECT p.product_name, p.product_s_desc FROM #__vm_product p LEFT JOIN #__vm_product_category_xref pc ON pc.product_id = p.product_id LEFT JOIN #__vm_category c ON c.category_id = pc.category_id WHERE p.product_publish='Y' AND category_publish = 'Y' LIMIT 0,100

Some of my own conclusions already:
- All other pages work fine, product are displayed, pricing is correct etc.
- From the SQL error: All my tables have the full 'virtuemart' in their name, and not 'vm'.
- The table "XX_product" doesn't even exist, I do have a "products" table.
- I tried copying my products table to make sure it matches the name... No result.
- I can login in (but the message appears) and when I log out I get a hard 500 error.

Does anyone have any clues?