view don't work on newly transferred database and cannot replace them

Avatar
  • Answered
You completed my transfer yet none of the data is showing on my website. I thought I had it figured out. The tables trasnsferred fine, but all of the views which drive all the data from my previous website referenced the old database ssfhl4_ssfhl. The new db with you is ssfhlc5_ssfhl, so logical if I update the database reference it should work, but it does not. when I try to do a create or replace query it gives me an error say it is not a view.
Can you help?
Avatar
Scott
Hello ssfhlc5,

Sorry to hear about your View issue. SQL Views need SQL Root access in order to run. Unfortunately this means that they are not possible on shared servers. They are certainly possible on VPS and Dedicated servers, however.

Kindest Regards,
Scott M