If I login as admin, all is fine. However if I log in as a user, then it redirects to the old test site (development server used to get the site running). I have checked siteurl and home values are correct in the database. I am also using paid membership pro plugin. I searched the database and found 740 entries of the old URL :(
Can anyone advise as to the best way forward without breaking the live site?