However, it put all the tables into the "Master" table. So, we went into SQL and changed the settings on the Yaf database to allow full privledges. Okay - all good, I'm now able to get into the Yaf database that I imported from the old hosting service. BUT...
The same error I was/AM having with the live forums is now occurring on the new installation of the yaf forums on my local host! I can register as a new user with no problem, but when I try to login again as that user I get the error: "The user name or password entered is incorrect. Please try again." And I absolutely can NOT get signed in!
So I opened up the Yaf SQL database, and checked the Yaf_Prov_Membership table - my new user registration does show up in that table. Then I checked the Yaf_Users Table, and lo and behold it IS there and I see that the IsApproved field in both tables is currently set to 0 - so I have to manually set them to 1 - so all is good, except that I should be able to log in as the administrator and do the approval through the Admin page on the forums, instead of in the SQL database.
So what's the problem you say? Well...I get the SAME "The user name or password entered is incorrect. Please try again." error when I try to log in to the upgraded forums as the admin! Um - help!? Please???
I'll post on the other thread regarding the upgrade - there are STILL numerous problems going on here with the database and I am pretty much at a loss as to why/how these problems have occurred, when I have NOT changed the code. It makes no sense!