Hi Rashida,
I have now reverted my live site to use SPPB 4.0.11 and the problem with the various tables have gone away and it seems to be functioning correctly again. I still wish to be able to install V5 as there is some functionality in it that I want to use so I still want to be able to overcome the problems shown with V5.
Before doing the changes on the live site, I went through the following stages on the test site (.com)
- Uninstalled V5
- Re-installed V4 - fixed the problem, which was enough to give me the confidence to apply the steps to Live.
- Attempted to reinstall V5 - got a duplicate table error, so the update failed.
- Uninstalled V4
- Reinstalled V5 - installed correctly but the problem with the fron-end display returned.
So, the test site now has V5 on it and I will leave it like that for now so you can investigate what may be the root cause of the problem (and test) whether there is anyway for me to be able to run V5 succesfully and what I need to do to enable me to use V5 in future.
Since this does not seem to be a common problem I assume that there must be something about some of these pages that must be causing the issue or some corruption in the way some of the database tables are being changed in the move from V4 to V5. My understanding of the database tables is insufficient for me to figure out if this is the problem and what I may need to do to fix it.
As I say, I still want to make use of V5 andf if I need to make some changes to my existing pages to achieve this the I will do so - but need to know what the problem is before I can have confidence that V5 is a sensible move forward.