OK, so I have rebuilt the pages I needed to build with DataAssist and it is working to a degree. I have used the same template (unedited) that the PowerCMS Builder uses to ensure that I am not getting any security assist issues in displaying protected pages.
The problems I was having with MySQL was that the include files such as DB connections were being placed after recordsets just before the head of the html. This meant the the recordset was trying to call info from a database before it knew where to look for the database. Simply moving all connections files to the top of the code has stopped MySQL errors, but I still have some issues.
My problems now are as follows:
1. Pages created by DataAssist are not redirecting on insert or update to the correct place when it is test locally. The URL is changing from:
etc
to this
etc
or
etc
It's sort of creating the path twice or changing the path from a webserver address to a disk directory address, however, this isn't an issue on the live server! It works fine there.
2. The admin_cms style sheets on my local computer are displaying correctly, but on the remote server, the style sheets are broken, it's as though I have disabled styles in my browser. This means I can't edit anything that is on the home page of the admin section. This is the third time I have uploaded the site now, so it can't be missing a style surely... can it?
What do you want me to do? Do you want me to zip the whole site up for you?
Thanks.
Mat